Please help solve this question (#4). Will rate thumbs up if correct. I understand that it is likely difficult to follow the screen shots. However, the question's narrative is very lengthy. Just try to focus on the data tables and information that's presented and the required questiond being asked in the table below. Thank you!

Pat Miranda, the new controller of Vault Hard Drives, Inc., has just returned from a seminar on the choice of the activity level in the predetermined overhead rate. Even though the subject did not sound exciting at first, she found that there were some important ideas presented that should get a hearing at her company. After returning from the seminar, she arranged a meeting with the production manager , J. Stevens, and the assistant production manager, Marvin Washington. Pat: 2.1 Patt Marvin 3. I ran across an idea that I wanted to check out with both of you. It's about the way we compute predetermined overhead rates. We're all ears. We compute the predetermined overhead rate by dividing the estimated total factory overhead for the coming year, which is all a fixed cost, by the estimated total units produced for the coming year. We've been doing that as long as I've been with the company And it has been done that way at every other company I've worked at, except at most places they divide by direct labor-hours. We use units because it is simpler and we basically make one product with minor variations But, there's another way to do it. Instead of basing the overhead rate on the estimated total units produced for the coming year, we could base it on the total units produced at capacity. Oh, the Marketing Department will love that. It will drop the costs on all of our products. They'll go wild over there cutting prices. That is a worry, but I wanted to talk to both of you first before going over to Marketing Aren't you always going to have a lot of unused capacity costs That's correct, but let me show you how we would handle it. Here's an example based on our budget for next year. Pat: Marvin Pati 2. Pat: Budgeted Castinated production Butted sa Capacity Selling price Variable manufacturing cost Total manufacturing overhead cost Call Fixed) Selling and administrative expenses (all fixed) Teginning inventories 81,000 units 31,000 units 100,000 units 572 per unit $17 per unit $ 1,944,000 $ 2.245.000 50 Traditional Approach to Computation of the Predetermined Overhead Rate Estimated total manufacturing overhead cost, $1,944,000 Estimated total units produced, 81,000 $24.00 per unit $ 5,832,600 Budgeted Income Statement Revenue (81,000 units * $72 per unit) Cost of goods sold: Variable manufacturing (81,000 units * $17 per unit) Manufacturing overhead applied (81,000 units X $24 per unit) Gross margin Selling and administrative expenses Net operating income $ 1,377,000 1,944,000 3,321,000 2,511,000 2,245,000 3 266,000 New Approach to Computation of the Predetermined Overhead Rate Using Capacity in the Denominator Estimated total manufacturing overhead cost at capacity, $1,944,000 Total units at capacity, 100,800 units $19.44 per unit $ 5,832,000 Budgeted Income Statement Revenue (81,008 units * $72 per unit) Cost of goods sold: Variable manufacturing (81,000 units $17 per unit) Manufacturing overhead applied (81,000 units * $19.44 per unit) Gross margin Cost of unused capacity (100,000 units - 81, eee units) * $19.44 per unit) Selling and administrative expenses Net operating income $1,377,000 1574,640 2.951 640 2.880, 360 369,360 2,245,000 $ 265,000 7. what I don't think I like the looks of that "Cost of unused capacity. If that thing shows up on the income statement, someone from headquarters is likely to come down here looking for som Whoall I don't think I like the looks of that "Cost of unused capacity." If that thing shows up on the income statement, someone from headquarters is likely to come down here looking for some people to lay off. Marvin: I'm worried about something else too. What happens when sales are not up to expectations? Can we pull the "hat trick Pati I'm sorry, I don't understand. Marvin's talking about something that happens fairly regularly. When sales are down and profits look like they are going to be lower than the president told the owners they were going to be, the president comes down here and asks us to deliver some more profits. Marvin: And we pull them out of our hat. J. Yeah, we just increase production until we get the profits we want. Pat? I still don't understand. You mean you increase sales? J. Nope, we increase production. We're the production managers, not the sales managers. Pat I get it. Because you have produced more, the sales force has more units it can sell. Nope, the marketing people don't do thing. We just build inventories and that does the trick. Required: In all of the questions below, assume that the predetermined overhead rate under the traditional method is $24 per unit, and under the new capacity-based method it is $19.44 per unit 1. Assume actual sales is 75,000 units and the actual production in units, actual selling price, actual variable manufacturing cost per unit, and actual fixed costs all equal their respective budgeted amounts. Given these assumptions: a. Compute net operating Income using the traditional income statement format. b. Compute net operating income using the new income statement format 2. Assume that actual sales is 75,000 units and the actual selling price, actual variable manufacturing cost per unit, and actual fixed costs all equal their respective budgeted amounts. Under the traditional approach, how many units would have to be produced to realize net operating income of $266,000? 3. Assume that actual sales is 75,000 units and the actual selling price, actual variable manufacturing cost per unit, and actual fixed costs all equal their respective budgeted amounts. Under the new capacity-based approach, how many units would have to be produced to realize net operating income of $266,000? Complete this question by entering your answers in the tabs below. b. Compute net operating income using the new Income statement format 2. Assume that actual sales is 75,000 units and the actual selling price, actual variable manufacturing cost per unit and actual fixed costs all equal their respective budgeted amounts. Under the traditional approach, how many units would have to be produced to realize net operating income of $266,000? 3. Assume that actual sales is 75,000 units and the actual selling price, actual variable manufacturing cost per unit, and actual fixed costs all equal thelt respective budgeted amounts. Under the new capacity based approach, how many units would have to be produced to realize net operating income of $266,000? Complete this question by entering your answers in the tabs below. Required 1A Required 1B Required 2 Required 3 Compute net operating income using the traditional Income statement format. Vault Hard Drives, Inc. Income Statement: Traditional Approach 0 Sales Cost of goods sold Variable manufacturing Manufacturing overhead applied Gross margin Selling and administrative expenses Net operating income 0 $ 0 Roonid unit, ana actual nixed costs an equal their respecuve ouageted amounts. Given these assumptions: a. Compute net operating income using the traditional income statement format. b. Compute net operating Income using the new income statement format. 2. Assume that actual sales is 75,000 units and the actual selling price, actual variable manufacturing cost per unit, and actual fixed costs all equal their respective budgeted amounts. Under the traditional approach, how many units would have to be produced to realize net operating income of $266,000? 3. Assume that actual sales is 75,000 units and the actual selling price, actual variable manufacturing cost per unit, and actual fixed costs all equal their respective budgeted amounts. Under the new capacity based approach how many units would have to be produced to realize net operating income of $266,000? Complete this question by entering your answers in the tabs below. Required 1A Required Required 2 Required 3 Compute net operating Income using the new Income statement format. Vault Hard Drives, Inc. Income Statement: New Approach Sales Cost of goods sold Variable manufacturing Manufacturing overhead applied Gross margin Other expenses Cost of unused capacity Selling and administrative expenses 0 0 unit, and actual fixed costs an equal their respective budgeted amounts. Given these assumpuons: a. Compute net operating income using the traditional income statement format. b. Compute net operating income using the new income statement format. 2. Assume that actual sales is 75.000 units and the actual selling price, actual variable manufacturing cost per unit, and actual fixed costs all equal their respective budgeted amounts. Under the traditional approach, how many units would have to be produced to realize net operating income of $266,000? 3. Assume that actual sales is 75,000 units and the actual selling price, actual variable manufacturing cost per unit and actual fixed costs all equal their respective budgeted amounts. Under the new capacity based approach, how many units would have to be produced to realize net operating Income of $266,000? Complete this question by entering your answers in the tabs below. Required 1A Required 18 Required 2 Required 3 Assume that actual sales is 75,000 units and the actual selling price, actual variable manufacturing cost per unit, and actual fixed costs all equal their respective budgeted amounts. Under the traditional approach, how many units would have to be produced to realize net operating Income of $266,000? (Do not round your intermediate calculations and round your final answers to the nearest whole dollar number.) Show less Traditional Approach units unit, ana actual fixed costs all equar their respective budgeted amounts. Given these assumptions: a. Compute net operating income using the traditional income statement format. b. Compute net operating income using the new income statement format 2. Assume that actual sales is 75,000 units and the actual selling price, actual variable manufacturing cost per unit, and actual fixed costs all equal their respective budgeted amounts. Under the traditional approach, how many units would have to be produced to realize net operating income of $266,000? 3. Assume that actual sales is 75,000 units and the actual selling price, actual variable manufacturing cost per unit, and actual fixed costs all equal their respective budgeted amounts. Under the new capacity-based approach, how many units would have to be produced to realize net operating income of $266,000? Complete this question by entering your answers in the tabs below. Required 1A Required 1B Required 2 Required 3 Assume that actual sales is 75,000 units and the actual selling price, actual variable manufacturing cost per unit, and actual fixed costs all equal their respective budgeted amounts. Under the new capacity-based approach, how many units would have to be produced to realize net operating income of $266,000? (Do not round your intermediate calculations and round your final answers to the nearest whole dollar number.) Show less Now approach units