Attached Excel Sheet
Sections:
a)
b)
c)
d)
e)
Problem 4-28 ErgoFurn, Inc. manufactures ergonomically designed computer furniture. ErgoFurn uses a job order costing sys Job No. CC723 CH291 PS812 On November 30, ErgoFurn's Raw Materials Inventory account totaled $668,000, and its Finished Goods Inven hours. The company's manufacturing overhead budget for the year totaled $4,500,000, and the company plan the company used a total of 830,000 machine hours, total manufacturing overhead amounted to $4,274,500, disposition of over / under applied overhead. ErgoFurn purchased $638,000 in raw materials in December and incurred the following costs for jobs in proces Job No. CC723 CH291 PS812 DS444 The following jobs were completed in December and transferred to the Finished Goods Inventory: Job No. CC723 CH291 DS444 (a) Calculate the total cost of each of the four jobs worked on in December. CC723 Total Cost (b) $ PS812 $ Calculate the total manufacturing cost for December. Total manufact uring cost (c) CH291 $ Calculate the cost of goods manufactured for December. Cost of goods manufact ured $ $ (d) Calculate the balance in the Work in Process Inventory account on December 31. Balance in work in process (e) $ Assume that ErgoFurn sold 15,000 computer caddies, 12,000 chairs, and 4,500 desks in December. Calculate Cost of Goods Sold for the month of December and the ending Finished Goods Inventory balance on December 31. (For computation purpose round per unit rates to 2 decimal places, e.g. 3.54. Round final answers to 0 decmial places, e.g. 45,000.) Cost of goods sold $ Finished goods inventory $ es a job order costing system. On November 30, the Work in Process Inventory consisted of the following jobs: Item Units Accumulated Cost Computer caddy 20,000 $900,000 Chair 15,000 431,000 Printer stand 25,000 250,000 $1,581,000 its Finished Goods Inventory totaled $3,456,400. ErgoFurn applies manufacturing overhead on the basis of machine 00, and the company planned to use 900,000 machine hours during the year. Through the first eleven months of the year, amounted to $4,274,500, and Cost of Goods Sold was $8,750,250. For the pursposes of this problem, ignore year-end ng costs for jobs in process that month: Materials Machine Direct Labor Issued Hours Hours 12,000 11,600 $122,400 $13,800 4,400 3,600 $43,200 $211,000 19,500 14,300 $200,500 $252,000 14,000 12,500 $138,000 Item $ Cost $155,000 ds Inventory: DS444 Direct Labor Units Computer caddy 20,000 Chair 15,000 Desk 5,000 ber 31. 4,500 desks in he ending urpose round per decmial places, wing jobs: asis of machine n months of the year, ignore year-end