A production supervisor for Linkoln Company is comparing his budget to actuals for inventory components in...

Transcribed Image Text:

A production supervisor for Linkoln Company is comparing his budget to actuals for inventory components in May. He has asked you to prepare two documents which will be sent to the division finance officer. The first is a cost of goods manufactured statement which will require you to derive the individual components of total manufacturing costs. The second is a one-page analysis document which will highlight specific sensitivities and relative comparison points. Using the information included within the Resources tab, complete the table below for the month ended May. Year 6. For Questions 1-3, calculate the required costs identified in column A, and enter your associated response rounded to whole numbers in column B. If a response is zero, enter a zero (0). For Questions 4-8, use the drop-down menu below and enter your response in column B. A 1 Cost Item 2 1. Raw materials used 3 2. Direct labor 4 3. Overhead applied B Amount 123 Situation 123 123 4. Relative to raw materials used, raw materials purchased are: 5. Relative to cost of goods sold, cost of goods manufactured is: 6. If labor hours budgeted were 21,000 hours, cost of goods sold would be: 7. If actual labor hours were 20,200, manufacturing costs would be: 8. If ending finished goods inventory totaled 68,450, the impact on cost of goods manufactured would be: Answer Linkoln Company-Inventory Items: May Year 6 Raw Materials Components Beginning raw materials Purchased raw materials Ending raw materials WIP Components Labor hours budgeted Labor hours actual Wage rate/hour Budgeted overhead (Labor hours as cost driver) Beginning WIP Ending WIP FG Components Beginning finished goods Ending finished goods Pounds Price/lb. 1,650 $ 4.50 4,725 $ 5.00 1,470 $ 5.00 20,000 19,850 S 9.00 $ 120,000 $ 49,500 $ 41,650 $ 63,200 $ 67,450 A production supervisor for Linkoln Company is comparing his budget to actuals for inventory components in May. He has asked you to prepare two documents which will be sent to the division finance officer. The first is a cost of goods manufactured statement which will require you to derive the individual components of total manufacturing costs. The second is a one-page analysis document which will highlight specific sensitivities and relative comparison points. Using the information included within the Resources tab, complete the table below for the month ended May. Year 6. For Questions 1-3, calculate the required costs identified in column A, and enter your associated response rounded to whole numbers in column B. If a response is zero, enter a zero (0). For Questions 4-8, use the drop-down menu below and enter your response in column B. A 1 Cost Item 2 1. Raw materials used 3 2. Direct labor 4 3. Overhead applied B Amount 123 Situation 123 123 4. Relative to raw materials used, raw materials purchased are: 5. Relative to cost of goods sold, cost of goods manufactured is: 6. If labor hours budgeted were 21,000 hours, cost of goods sold would be: 7. If actual labor hours were 20,200, manufacturing costs would be: 8. If ending finished goods inventory totaled 68,450, the impact on cost of goods manufactured would be: Answer Linkoln Company-Inventory Items: May Year 6 Raw Materials Components Beginning raw materials Purchased raw materials Ending raw materials WIP Components Labor hours budgeted Labor hours actual Wage rate/hour Budgeted overhead (Labor hours as cost driver) Beginning WIP Ending WIP FG Components Beginning finished goods Ending finished goods Pounds Price/lb. 1,650 $ 4.50 4,725 $ 5.00 1,470 $ 5.00 20,000 19,850 S 9.00 $ 120,000 $ 49,500 $ 41,650 $ 63,200 $ 67,450