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. $10.00 |
Direct labor. 4.50 |
Variable manufacturing overhead. 2.30 |
Fixed manufacturing overhead. 5.00 ($300,000 total) |
Variable selling expenses. 1.20 |
Fixed selling expenses. 3.50 ($210,000 total) |
Total cost per unit. $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. 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 as an Excel document. 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.
Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks! |
Andretti | ||
Variable cost per unit | Note | |
Direct Materials | 10.00 | A |
Direct Labor | 4.50 | B |
Variable Manufacturing overhead | 2.30 | C |
Variable Selling Expenses | 1.20 | D |
Total Variable cost per unit | 18.00 | E=A+B+C+D |
Sell Price Per unit | 32.00 | F |
Contribution Per unit | 14.00 | G=F-E |
Number of Units | 60,000.00 | H |
Contribution amount | 840,000.00 | I=G*H |
Fixed cost | ||
Fixed manufacturing overhead | 300,000.00 | J |
Fixed selling expenses | 210,000.00 | K |
Plant close | Amount $ | |
Fixed manufacturing overhead at 60% | 30,000.00 | L=J/12*2*60% |
Fixed selling expenses at 80% | 28,000.00 | M=K/12*2*80% |
Total cost incurred if plant closed | 58,000.00 | |
30% capacity | Amount $ | |
Number of units | 3,000.00 | N=H/12*2*30% |
Contribution Per unit | 14.00 | See G |
Contribution earned | 42,000.00 | O=N*G |
Less: Fixed manufacturing overhead | 50,000.00 | P=J/12*2 |
Fixed selling expenses | 35,000.00 | Q=K/12*2 |
Net Income | (43,000.00) | R=O-P-Q |
Decrease in loss by | 15,000.00 | S=M+R |
So Andretti should not close the plant for two months but operate it at 30% capacity. |
Other factor that could possibly influence the decision are: |
The assumptions may not be correct. Company may incur costs then estimated. It will impact the decision. |
Andretti Company has a single product called a Dak. The company normally produces and sells 60,000...
Andretti Company has a single product called a Dak. The company normally produces and sells 82,000 Daks each year at a selling price of $58 per unit. The company’s unit costs at this level of activity are given below: Direct materials $ 8.50 Direct labor 10.00 Variable manufacturing overhead 2.00 Fixed manufacturing overhead 7.00 ($574,000 total) Variable selling expenses 3.70 Fixed selling expenses 3.00 ($246,000 total) Total cost per unit $ 34.20 A number of questions relating to the production...
Andretti Company has a single product called a Dak. The company normally produces and sells 88,000 Daks each year at a selling price of $56 per unit. The company’s unit costs at this level of activity are given below: Direct materials $ 9.50 Direct labor 12.00 Variable manufacturing overhead 3.10 Fixed manufacturing overhead 10.00 ($880,000 total) Variable selling expenses 3.70 Fixed selling expenses 3.50 ($308,000 total) Total cost per unit $ 41.80 A number of questions relating to the production...
Andretti Company has a single product called a Dak. The company normally produces and sells 84,000 Daks each year at a selling price of $40 per unit. The company’s unit costs at this level of activity are given below: Direct materials $ 9.50 Direct labor 10.00 Variable manufacturing overhead 3.20 Fixed manufacturing overhead 9.00 ($756,000 total) Variable selling expenses 3.70 Fixed selling expenses 4.50 ($378,000 total) Total cost per unit $ 39.90 4. Due to a strike in its supplier’s...
Andretti Company has a single product called a Dak. The company normally produces and sells 86,000 Daks each year at a selling price of $58 per unit. The company’s unit costs at this level of activity are given below: Direct materials $ 8.50 Direct labor 10.00 Variable manufacturing overhead 2.00 Fixed manufacturing overhead 10.00 ($860,000 total) Variable selling expenses 1.70 Fixed selling expenses 4.50 ($387,000 total) Total cost per unit $ 36.70 A number of questions relating to the production...
Andretti Company has a single product called a Dak. The company normally produces and sells 80,000 Daks each year at a selling price of $58 per unit. The company’s unit costs at this level of activity are given below: Direct materials $ 8.50 Direct labor 9.00 Variable manufacturing overhead 3.50 Fixed manufacturing overhead 8.00 ($640,000 total) Variable selling expenses 2.70 Fixed selling expenses 2.50 ($200,000 total) Total cost per unit $ 34.20 A number of questions relating to the production...
Andretti Company has a single product called a Dak. The company normally produces and sells 89,000 Daks each year at a selling price of $60 per unit. The company’s unit costs at this level of activity are given below: Direct materials $ 9.50 Direct labor 10.00 Variable manufacturing overhead 2.50 Fixed manufacturing overhead 4.00 ($356,000 total) Variable selling expenses 3.70 Fixed selling expenses 3.50 ($311,500 total) Total cost per unit $ 33.20 A number of questions relating to the production...
ndretti Company has a single product called a Dak. The company normally produces and sells 86,000 Daks each year at a selling price of $58 per unit. The company’s unit costs at this level of activity are given below: Direct materials $ 7.50 Direct labor 10.00 Variable manufacturing overhead 2.30 Fixed manufacturing overhead 6.00 ($516,000 total) Variable selling expenses 4.70 Fixed selling expenses 3.00 ($258,000 total) Total cost per unit $ 33.50 A number of questions relating to the production...
Andretti Company has a single product called a Dak. The company normally produces and sells 124,000 Daks each year at a selling price of $46 per unit. The company's unit costs at this level of activity are given below $ 7.50 Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Variable selling expenses Fixed selling expenses Total cost per unit 3.00 4.00 (5496,000 total) 3.79 5.50 (5682,800 total) $32.70 A number of questions relating to the production and sale...
Andretti Company has a single product called a Dak. The company normally produces and sells 86,000 Daks each year at a selling price of $58 per unit. The company’s unit costs at this level of activity are given below: Direct materials $ 9.50 Direct labor 10.00 Variable manufacturing overhead 1.80 Fixed manufacturing overhead 5.00 ($430,000 total) Variable selling expenses 3.70 Fixed selling expenses 2.50 ($215,000 total) Total cost per unit $ 32.50 A number of questions relating to the production...
Andretti Company has a single product called a Dak. The company normally produces and sells 86,000 Daks each year at a selling price of $58 per unit. The company’s unit costs at this level of activity are given below: Direct materials $ 7.50 Direct labor 10.00 Variable manufacturing overhead 2.30 Fixed manufacturing overhead 6.00 ($516,000 total) Variable selling expenses 4.70 Fixed selling expenses 3.00 ($258,000 total) Total cost per unit $ 33.50 A number of questions relating to the production...