Managerial Accounting – Spring 2019 – Lab 2 , chapter 3 Excel Computer Problem* The following data refer to Miller Widget Company for the year 20 x1…

Hello

I need help with figuring out what exactly goes in the Manufacturing overhead part.

The 8 things that goes in the “Title” area.

I figured out 7 out of 8. I am not sure what’s the last thing that goes there.

  • Attachment 1
  • Attachment 2

Managerial Accounting – Spring 2019 – Lab 2 , chapter 3Excel Computer Problem*The following data refer to Miller Widget Company for the year 20 x1 .Work – in – process inventory , 12/31 / x0 ….$ 10, 100Work – in – process inventory , 12/31 / x ] ……10,000Finished – goods inventory , 12/31 / x0 ……Raw – material inventory , 12/31 / 40 …..10, 1010Raw – material inventory , 12/31 /’x ] . ……………. .. "1 1, 000Finished – goods inventory , 12 / 31 / x1 ….15, 400Purchases of raw material in 20 x1 .35, 000Indirect material used …..Indirect- labor cost incurred ..24, 000Direct- labor cost incurred ….19, 000Selling and administrative Salaries ………13, BOOInsurance on factory and Equipment ………… … . . . . .3. 600Depreciation on factory Equipment ..2, 100Property taxes on factory ..`3, 400Utilities for factory …..5,000" " "Utilities for sales and administrative offices …..2.5010Other selling and administrative expenses ….4,000Depreciation on factory building ……3, 800Depreciation on cars used by sales personnel ……….2, 200Rental For warehouse space to store raw material ………3, 100Rental of space for company president’s office . … …. ….1 , 500Applied manufacturing overhead ..58, 000Sales revenue .`205, 800Income tax expense .5, 100Hequired :1 . Prepare the Company’s schedule of cost of goods manufactured for 20×1 . Note : Input appliedoverhead before calculating over or under – applied overhead .2. Prepare the company’s schedule of cost of goods sold for 20×1 . The company closes overapplied orunderapplied overhead into Cost of Goods Sold .3. Prepare the company’s income statement for 20*’1