
FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
Spreadsheet
Lundberg Company had the following
The trial balance of Lundberg Company is shown in its spreadsheet.
Data for adjusting the accounts are as follows:
(a) | Factory |
$3,100 |
(b) | Estimate of this year's sales that will be returned next year | 590 |
(c) | Cost of goods expected to be returned | 260 |
(d) | Interest receivable | 80 |
(e) | Interest payable | 620 |
(f) | Estimate of uncollectible accounts, based on an aging of |
2,400 |
(g) | Office supplies consumed | 2,900 |
(h) | Factory supplies consumed | 3,300 |
(i) | Factory building |
5,000 |
(j) | Factory equipment depreciation | 4,000 |
(k) | Overapplied factory overhead | 1,470 |
(l) | Provision for corporate income taxes | 6,100 |
(m) | Physical counts of the inventories agreed with the amounts in the books. |
Additional information needed to prepare the financial statements is as follows:
Beginning inventories: | |
Finished goods, January 1 | $19,000 |
Work in process, January 1 | 7,200 |
Materials inventory, January 1 | 9,500 |
Materials purchases for the year | 51,410 |
Direct labor | 60,000 |
Actual factory overhead | 90,920 |
Indirect materials charged to production | 3,300 |
Required:
1. Prepare a 6-column spreadsheet.
Enter factory overhead and cost of goods sold amounts in the order presented.
Lundberg Company End-of-Period Spreadsheet For Year Ended December 31, 20-- |
||||||||
---|---|---|---|---|---|---|---|---|
Account Title | Trial Balance | Adjustments | Adjusted Trial Balance | |||||
Debit | Credit | Debit | Credit | Debit | Credit | |||
Cash | 30,300.00 | |||||||
Government Notes | 5,000.00 | |||||||
Interest Receivable | ||||||||
Accounts Receivable | 34,000.00 | |||||||
Allow. for Doubtful Accounts | 540.00 | |||||||
Finished Goods Inventory | 24,000.00 | |||||||
Work in Process Inventory | 10,000.00 | |||||||
Materials Inventory | 8,500.00 | |||||||
Estimated Returns Inventory | 60.00 | |||||||
Office Supplies | 3,100.00 | |||||||
Factory Supplies | 3,800.00 | |||||||
Land | 100,000.00 | |||||||
Factory Building | 120,000.00 | |||||||
Accum. Depr.-Factory Build. | 10,000.00 | |||||||
Factory Equipment | 40,000.00 | |||||||
Accum. Depr.-Factory Equip. | 5,000.00 | |||||||
Accounts Payable | 13,800.00 | |||||||
Customer Refunds Payable | 110.00 | |||||||
Income Tax Payable | ||||||||
Interest Payable | ||||||||
Bonds Payable | 80,000.00 | |||||||
Capital Stock | 50,000.00 | |||||||
Paid-In Capital in Excess of Par | 30,000.00 | |||||||
93,800.00 | ||||||||
Cash Dividends | 30,000.00 | |||||||
Sales | 410,740.00 | |||||||
Sales Returns and Allowances | 6,100.00 | |||||||
Interest Revenue | 200.00 | |||||||
Factory Overhead | 78,630.00 | 89,300.00 | ||||||
Cost of Goods Sold | 190,600.00 | |||||||
Wages Expense | 70,000.00 | |||||||
Office Supplies Expense | ||||||||
Utilities Expense-Office | 4,400.00 | |||||||
Interest Expense | 7,000.00 | |||||||
Income Tax Expense | 18,000.00 | |||||||
783,490.00 | 783,490.00 | |||||||
Net Income |
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Prepare the entries that should be made in the general journal to close the revenue, cost of goods sold, expense, and other temporary accounts. On December 31, 20X1, the Income Statement columns of the worksheet for Jim’s Music Emporium contained the following information. Income Statement Columns Debit Credit Income Summary $ 38,000 $ 41,300 Sales 251,500 Sales Returns and Allowances 3,600 Sales Discounts 2,600 Interest Income 140 Purchases 133,800 Freight In 1,900 Purchases Returns and Allowances 1,700 Purchases Discounts 1,470 Rent Expense 8,200 Utilities Expense 2,870 Telephone Expense 1,480 Salaries Expense 65,500 Payroll Taxes Expense 5,210 Supplies Expense 1,640 Depreciation Expense 2,200 Interest Expense 280 Totals $ 267,280 $ 296,110 Assume further that the owner of the firm is Jim Landis and that the Jim Landis, Drawing account had a balance of $25,900 on December 31, 20X1.arrow_forwardConsider the following account starting balances and transactions involving these accounts. Use T-accounts to record the starting balances and the offsetting entries for the transactions. The starting balance of Accounts Payable is $2,800 The starting balance of Cash is $8,400 The starting balance of Debt is $3,400 The starting balance of Inventory is $4,200 1. Pay $6 owed to a supplier 2. Buy $17 worth of manufacturing supplies on credit 3. Borrow $55 from a bank What is the final amount in Debt? Note: No unit adjustments are necessary.arrow_forwardMorrison Company Balance Sheet January 1 Assets Cash $ 40,950 Raw materials Work in process Finished goods Prepaid expenses Property, plant, and equipment (net) $ 17,800 6,600 31,800 56, 200 3,350 124,000 $ 224,500 Total assets Liabilities and Stockholders' Equity Accounts payable Retained earnings $ 7,100 217,400 Total liabilities and stockholders' equity $ 224,500 During January the company completed the following transactions: a. Purchased raw materials on account, $75,200. b. Raw materials used in production, $91,500 ($80,200 was direct materials and $11,300 was indirect materials). c. Paid $202.100 of salaries and wages in cash ($108,800 was direct labor, $41,700 was indirect labor, and $51,600 was related to employees responsible for selling and administration). d. Various manufacturing overhead costs incurred (on account) to support production, $43,350. e. Depreciation recorded on property, plant, and equipment, $63,600 (70% related to manufacturing equipment and 30% related to…arrow_forward
- Need help with the following missing data. Thank You!arrow_forwardBased on the following transactions, answer the following questions. i. ii. iii. iv. V. vi. vii. Purchased inventory with a cost of $28,300 on account. Sales on account to customers totalled $54,700. Payments made to employees for wages totalled $19,600. Cash collections from customers settling their accounts totalled $49,500. Invoice received from the utility company for $6,100 is due in 30 days. Payments totalling $19,500 were made to suppliers to settle part of the balance owing to them. Received a deposit of $1,800 from a customer for goods to be delivered next month.arrow_forwardThe following selected account balances appeared on the financial statements of the Washington Company. Use these balances to answer the questions that follow. Accounts receivable, Jan. 1 $13,000 Accounts receivable, Dec. 31 9,000 Accounts payable, Jan. 1 4,000 Accounts payable, Dec. 31 7,000 Inventory, Jan. 1 10,000 Inventory, Dec. 31 15,000 Sales 56,000 Cost of goods sold 31,000 The Washington Company uses the direct method to calculate net cash flow from operating activities. Assume that all accounts payable are owed to merchandise suppliers. Cash collections from customers were Oa. $45,000 Ob. $56.000 Oc. $52,000 Od. $60,000arrow_forward
- The following income statement was prepared by an office clerk hired for July. As the accounting supervisor, you recognize that it is incorrect and prepare a corrected multi-step income statement. Demo Sales Income Statement For Month Ended July 31, 2820 Sales $562,140 37,000 18,000 $617,140 Accounts receivable Unearned sales Net sales Operating expenses: Accumulated depreciation, equipment Advertising expense Cost of goods sold Depreciation expense, equipment Insurance expense Interest expense Interest payable Jen Conway, withdrawals Office supplies Prepaid insurance Prepaid rent Rent expense Salaries payable Sales discounts $ 30, 000 14,000 394, 000 3,00e 2,500 1,700 250 14,000 9,080 14,000 25,000 5,000 175, 000 2,80e 690,250 $ 73,110 Loss DEMO SALES Income Statement For Month Ended July 31, 2020 Operating expenses:arrow_forwardAre the entries and values correct or am I missing something? (See image)arrow_forwardEXERCISE (All exercise would be saved in one record) Journalize the following transactions for the month of February 1: Sold merchandise on account for $10,000 (other income, other receivable,); Cost of Goods Sold $3,000 (Inventory, Cost of Sale) Received the utilities bill for $250.00 (accrued expense, utilities expense) Salaries for the week are $3,300 (salaries expense, wages payable) Received an invoice of $100 for advertising. Create a new customer (use your own information), Term 3%, n/15, credit limit $1,000. Prepare the Customer List Report only for your account, include a column for term conditions and credit limits. (February 5) Prepare a sales order (15 units of any product). In the Sales Order Register include a column with the name of the vendor. (February 7) The invoice from the sales order above was delivered completely (February 9) (Prepare an Invoice Register) Prepare an Income Statement (February 28) Prepare a Balance Sheet (February 28)…arrow_forward
- Nonearrow_forwardThe question is on the photo. Thanksarrow_forwardGiorgio is in the Sales by Customer Detail report. He wants to see the line items for Jones Company's transactions for the previous month in date order. How should Giorgio proceed? Select an answer: Go to Sort and then select Num. Go to Display columns by and then select Month. Go to Sort and then select Trans.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education


Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,

Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON

Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education