Question

In: Accounting

Lopez Manufacturing Company had the following account balances for the quarter ending June 30, unless otherwise...

Lopez Manufacturing Company had the following account balances for the quarter ending June 30, unless otherwise noted:

      Work-in-process inventory (April 1)                $ 149,300

      Work-in-process inventory (March 31)               181,700

      Finished goods inventory (January 1)                 550,000

      Finished goods inventory (March 31)                 513,000

      Direct materials used                                           391,000

      Indirect materials used                                          96,000

      Direct manufacturing labor                                 494,000

      Indirect manufacturing labor                               212,000

      Property taxes on manufacturing plant building   35,700

      Salespersons' company car costs                           19,000

      Depreciation of manufacturing equipment          287,200

      Depreciation of office equipment                        137,400

      Miscellaneous plant overhead                             133,100

      Plant utilities                                                        129,000

      General office expenses                                       301,000

      Marketing distribution costs                                  51,800

Required:

a.   Prepare a cost of goods manufactured schedule for the quarter.

b.   Prepare a cost of goods sold schedule for the quarter.

Solutions

Expert Solution

Lopez Manufacturing Company
Cost of goods Manufactured Schedule
Quarter ended June 30
Beginning Work In progress, april 1       149,300
Direct materials used 391,000
Direct Labour              4,94,000
Manufacturing Overhead:
Indirect materials used 96,000
Indirect Manufacturing labour 212,000
Property taxes on manufacturing plant building 35,700
Depreciation of manufacturing equipment 287,200
Miscellaneous Plant overhead 133,100
Plant utilities 129,000
Total Manufacturing costs incurred    1,778,000
Total manufacturing costs    1,927,300
Less :Ending Work In progress, March 31     -1,81,700
Cost Goods Manufactured 1,754,600
Lopez Manufacturing Company
Cost of goods Sold Schedule
Quarter ended June 30
Cost Goods Manufactured 1,754,600
Add : Beginning Finished Goods, lJanuary 1 5,50,000
Finished Goods Available for Sale 2,304,600
Less: Ending Finished Goods, March 31 (-5,13,000)
Cost of Goods Sold 1,791,600   

Related Solutions

Gaby Manufacturing Company had the following account balances for the quarter ending September 30, unless otherwise...
Gaby Manufacturing Company had the following account balances for the quarter ending September 30, unless otherwise noted: Amortization of manufacturing equipment                   $88,000 Amortization of office equipment                                      41,200 Direct manufacturing labour                                             160,000 Direct materials used                                                           126,000 Finished goods inventory (July 1)                                    180,000 Finished goods inventory (September 30)                      170,000 General office expenses                                                       101,800 Indirect manufacturing labour                                            62,000 Indirect materials used                                                         28,000 Marketing distribution costs                                                10,000 Miscellaneous plant overhead                                             45,000 Plant utilities                                                                           30,800 Property taxes on plant building                                          9,600 Property taxes on salespersons'...
Messinger Manufacturing Company had the following account balances for the quarter ending March 31, unless otherwise...
Messinger Manufacturing Company had the following account balances for the quarter ending March 31, unless otherwise noted: Work-in-process inventory (January 1) $ 140,400 Work-in-process inventory (March 31) 171,000 Finished goods inventory (January 1) 540,000 Finished goods inventory (March 31) 510,000 Direct materials used 378,000 Indirect materials used 84,000 Direct manufacturing labor 480,000 Indirect manufacturing labor 186,000 Property taxes on manufacturing plant building 28,800 Salespersons' company vehicle costs 12,000 Depreciation of manufacturing equipment 264,000 Depreciation of office equipment 123,600 Miscellaneous plant...
Messinger Manufacturing Company had the following account balances for the quarter ending March 31, unless otherwise...
Messinger Manufacturing Company had the following account balances for the quarter ending March 31, unless otherwise noted: ​Work-in-process inventory (January 1)​$140,400 ​Work-in-process inventory (March 31)​171,000 ​Finished goods inventory (January 1)​540,000 ​Finished goods inventory (March 31)​510,000 ​Direct materials used​378,000 ​Indirect materials used​84,000 ​Direct manufacturing labour​480,000 ​Indirect manufacturing labour​186,000 ​Property taxes on manufacturing plant building​28,800 ​Salespersons' company vehicle costs​12,000 ​Amortization of manufacturing equipment​264,000 ​Amortization of office equipment​123,600 ​Miscellaneous plant overhead​135,000 ​Plant utilities​92,400 ​General office expenses​305,400 ​Marketing distribution costs​30,000 Required: a.​Prepare a cost...
Messinger Manufacturing Company had the following account balances for the quarter ending March 31, unless otherwise...
Messinger Manufacturing Company had the following account balances for the quarter ending March 31, unless otherwise noted: Accounts Amount Work-in-process inventory (January 1) $ 140,400 Work-in-process inventory (March 31) 171,000 Finished goods inventory (January 1) 540,000 Finished goods inventory (March 31) 510,000 Direct materials used 378,000 Indirect materials used 84,000 Direct manufacturing labor 480,000 Indirect manufacturing labor 186,000 Property taxes on manufacturing plant building 28,800 Salespersons' company vehicle costs 12,000 Depreciation of manufacturing equipment 264,000 Depreciation of office equipment 123,600...
Montevideo Company had the following account balances for the quarter ending March 31, unless otherwise noted:...
Montevideo Company had the following account balances for the quarter ending March 31, unless otherwise noted: Work-in-process inventory (January 1) $ 140,400 Work-in-process inventory (March 31) 171,000 Finished goods inventory (January 1) 540,000 Finished goods inventory (March 31) 510,000 Direct materials used 378,000 Indirect materials used 84,000 Direct manufacturing labor 480,000 Indirect manufacturing labor 186,000 Property taxes on manufacturing plant building 28,800 Salespersons' company vehicle costs 12,000 Depreciation of manufacturing equipment 264,000 Depreciation of office equipment 123,600 Miscellaneous plant overhead...
The following is the ending balances of accounts at June 30, 2021, for Excell Company. Account...
The following is the ending balances of accounts at June 30, 2021, for Excell Company. Account Title Debits Credits Cash $ 91,000 Short-term investments 73,000 Accounts receivable (net) 288,000 Prepaid expenses (for the next 12 months) 40,000 Land 83,000 Buildings 328,000 Accumulated depreciation—buildings $ 164,000 Equipment 269,000 Accumulated depreciation—equipment 124,000 Accounts payable 177,000 Accrued liabilities 49,000 Notes payable 108,000 Mortgage payable 210,000 Common stock 140,000 Retained earnings 200,000 Totals $ 1,172,000 $ 1,172,000 Additional information: The short-term investments account includes...
The following is the ending balances of accounts at June 30, 2021, for Excell Company. Account...
The following is the ending balances of accounts at June 30, 2021, for Excell Company. Account Title Debits Credits Cash $ 91,000 Short-term investments 73,000 Accounts receivable (net) 288,000 Prepaid expenses (for the next 12 months) 40,000 Land 83,000 Buildings 328,000 Accumulated depreciation—buildings $ 164,000 Equipment 269,000 Accumulated depreciation—equipment 124,000 Accounts payable 177,000 Accrued liabilities 49,000 Notes payable 108,000 Mortgage payable 210,000 Common stock 140,000 Retained earnings 200,000 Totals $ 1,172,000 $ 1,172,000 Additional information: The short-term investments account includes...
The following is the ending balances of accounts at June 30, 2018 for Excell Company. Account...
The following is the ending balances of accounts at June 30, 2018 for Excell Company. Account Title Debits Credits Cash $ 121,000 Short-term investments 103,000 Accounts receivable 318,000 Prepaid expenses 70,000 Land 113,000 Buildings 358,000 Accumulated depreciation—buildings $ 179,000 Equipment 284,000 Accumulated depreciation—equipment 139,000 Accounts payable 192,000 Accrued expenses 64,000 Notes payable 138,000 Mortgage payable 320,000 Common stock 290,000 Retained earnings 45,000 Totals $ 1,367,000 $ 1,367,000 Additional information: The short-term investments account includes $37,000 in U.S. treasury bills purchased...
Donald’s Juice Shop had the following balances in its ledger at 30 June 2020. Account Amount...
Donald’s Juice Shop had the following balances in its ledger at 30 June 2020. Account Amount ($) Cash at Bank $48 724 Accounts Receivable $2 05 056 Inventory $2 91 200 Prepaid Insurance $15 744 Office Supplies on Hand $8 736 Furniture & Fixtures $1 06 080 Accumulated Depreciation – Furniture & Fittings $29 120 Delivery Equipment $1 24 800 Accumulated Depreciation – Delivery Equipment $49 920 Accounts Payable $72 072 Loan Payable $3 12 000 Donald, Capital $1 32...
Balance Sheet:   The following is the ending balances of accounts at June 30, 2017 for WorkBee...
Balance Sheet:   The following is the ending balances of accounts at June 30, 2017 for WorkBee Company. Account Title Debits Credits Cash 148,000 Accounts receivable 280,000 Prepaid expenses 35,000 Land 72,000 Buildings 320,000 Accumulated depreciation—buildings 160,000 Investments 265,000 Salaries Payable 120,000 Accounts payable 173,000 Deferred Revenue 45,000 Notes payable 100,000 Mortgage payable 250,000 Common stock 100,000 Retained earnings 172,000 Totals 1,120,000 1,120,000 Additional Information: 1. The accounts receivable account consists of the following: a. Amounts owed by customers $225,000 b....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT