I need some help with this qualitative analysis.

I have also attched the chart refered to within the question.

ACC 216 Quantitative Analysis Assignment modified from the textbook: Andretti Company has a single product called a Dak. The company normally produces and sells 60,000 Daks each year at a selling price of $32 per unit. The company's unit costs at this level of activity are given below: Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Variable selling expenses Fixed selling expenses Total cost per unit $10.00 4.50 2.30 5.00 ($300,000 total) 1.20 3.50 ($210,000 total) $26.50 Due to a strike in its supplier's plant, Andretti Company is unable to purchase more material for the production of Daks. The strike is expected to last for two months. Andretti Company has enough material on hand to operate at 30% of normal levels for the two-month period. As an alternative, Andretti could close its plant down entirely for the two months. If the plant were closed, fixed manufacturing overhead costs would continue at 60% of their normal level during the two-month period and the fixed selling expenses would be reduced by 20% during the two month period. Required: Utilizing Excel, create a spreadsheet similar to Exhibit 12.1 on page 566 of the textbook to compare alternatives. Display your results using the total cost approach. Utilize formulas for all calculations and upload to Blackboard as an Excel document. In one page or less, analyze the data you gathered to support your decision of whether the plant should continue operating or close for the two-month period. As part of your analysis please discuss other factors that could possibly influence your decision Current Situation $200,000 Situation with New Machine $200,000 Differential Costs and Benefits $ 0 70,000 70,000 0 40,000 25,000 15,000 Sales (5,000 units $40 per unit) Variable expenses: Direct materials (5,000 units x $14 per unit) Direct labor (5,000 units $8 per unit; 5,000 units * $5 per unit) Variable overhead (5,000 units x $2 per unit) Total variable expenses Contribution margin Fixed expenses Other Rental of new machine Total fixed expenses Net operating income 10,000 120,000 80,000 10.000 105,000 95.000 62,000 62,000 3,000 65,000 $. 30.000 (3.000) 62000 $ 18,000 $12.000