Case Study – Chapter 3 Muesli AG Introduction You are interested now in understanding how the application of overhead to the production campaigns (jobs) compares to actual manufacturing overhead costs at Muesli AG. A spreadsheet has been created with some key figures from the past year. You will use that spreadsheet to analyze the results and illustrate how over or under applied overhead affects cost of goods sold and company net operating income. Problem Statement: Case Details Recall from our prior analysis that manufacturing overhead is applied based on a plant-wide POHR and machine hours. These are the estimates for the year: Manufacturing Overhead (MOH) Machine Hours (MH) POHR € 3,830,000 4,800 € 797.92 per machine hour Select data regarding beginning and ending inventories, transactions during the year, and other key figures are provided. You will need to calculate the missing data in order to complete your analysis. Instructions: Use formulas and links to cells in the worksheet provided in order to answer the following questions. 1. What is the value of the work-in-process (WIP) inventory at the beginning of the year? (Hint: calculate the totals on each open production campaign in order to determine the total WIP) 2. What is the value of the WIP inventory at the end of the year? (Hint: calculate the totals on each open production campaign in order to determine the total WIP) 3. Based on the job sheets for the completed production campaigns, how much manufacturing overhead (MOH) was applied to all completed jobs during the year? 4. What is the value of raw materials used in production? 5. How much was the cost of direct labor applied to completed production campaigns? 6. What is the value of actual overhead incurred? 7. Is overhead over or under applied and if so by how much? 8. What is the value of ending raw materials inventory? 9. Calculate Cost of Goods Manufactured (COGM). 10. Calculate Cost of Goods Sold (COGS) for the Year. 11. What is the value of net operating income? 12. Close the over or under applied overhead into COGS to determine the adjusted COGS. 13. Now what is the value of net operating income? Is it higher or lower than before the adjustment? Why does this make sense? 14. Leave all your formulas as is, but change Incurred (actual) MOH to €3,000,000. What other values change? Explain. Insert formulas and cell references into the "gold" cells below. Estimates for the Year Manufacturing Overhead (MOH) Machine Hours (MH) POHR Beginning of the Year Inventory Raw materials Work-in-process Finished Goods (boxes of Muesli) Completed Job Sheet Information for the Year Direct Materials Used Direct Labor Costs Actual Machine Hours Applied Overhead [3] Transactions during the Year Raw material purchases Raw materials used in production [4] Direct labor costs [5] Incurred (actual) MOH [15] € 3,830,000 4,800 € 797.92 per machine hour € 348,800 €0 € 426,680 € 7,905,400 € 960,000 4,762 € 7,900,000 € 3,810,000 Over or Under-applied Overhead Calculation Applied Overhead Actual Overhead [6] Difference (Over or Under applied?) [7] €0 Values for the Financial Statements at the End of the Year: End of the Year Inventory Raw Materials [8] Work-in-Process Finished Goods Cost of Goods Manufactured [9] Cost of Goods Sold [10] Adjusted Cost of Goods Sold [12] €0 € 339,600 Jobs in Process at the Beginning of the Year Production "Campaigns" Q1-201219 Q2-201220 # of units (boxes) Direct materials Direct labor costs Actual machine hours Totals: [1] 16,000 € 84,800.00 € 240.00 10.0 32,000 € 60,000.00 € 80.00 2.0 € 0.00 Jobs in Process at the End of the Year Production "Campaigns" Q4-211219 Q4-211220 # of units (boxes) Direct materials Direct labor costs Actual machine hours Totals: [2] 32,000 € 169,600.00 € 960.00 24.0 32,000 € 64,200.00 € 320.00 8.0 € 0.00 Muesli AG Income Statement for the Year Sales Cost of Goods Sold Gross Margin Selling and Administrative Expenses: Administrative Salaries Advertising Maintenance on Office Equpment Office Supplies Sales Salaries Licenses and taxes Interest Expense Net Income [11, 13] € 15,224,000 € 15,224,000 € 264,000 € 144,000 € 24,000 € 12,000 € 480,000 € 432,000 € 720,000 € 2,076,000 € 13,148,000 Inventory Change in Value € 450,000 € 400,000 € 350,000 € 300,000 € 250,000 Beginning of Year € 200,000 End of Year € 150,000 € 100,000 € 50,000 €0 Raw Materials [8] Work-in-Process Finished Goods
Purchase answer to see full attachment