(PLEASE DO IN EXCEL! Thank you!)

The following cost data relate to the manufacturing activities of Scan House, LLC, Inc. during 2017:

Total actual manufacturing overhead cost incurred

(including $15,000 of indirect materials).............................. $353,000

Purchases of raw materials (both direct and indirect) ......... $250,000

Direct labor cost................................................................... $135,000

Inventories:

Raw materials, beginning ........................... $10,000

Raw materials, ending ................................ $15,000

Work in process, beginning ......................... $20,000

Work in process, ending............................... $35,000

Scan House uses a predetermined overhead rate to apply manufacturing overhead cost to production. The predetermined overhead rate for the year was $15 per machine-hour. A total of 23,000 machine-hours were recorded during 2017.

Required:

a. Compute the amount of under-applied or overapplied manufacturing overhead cost for the year. b. Assuming that any Over- or under-applied overhead is immaterial; prepare the adjusting entry to allocate the over- or under-applied overhead at the end of 2017. c. Prepare a Schedule of Cost of Goods Manufactured for the year.