Question

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 $58 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 $ 6.50 9.00 2.00 8.00 $704,000 total) 2.70 4.00 ($352,000 total) $ 32.20 A number of questions relating to the production and sale of Daks follow. Each question is independent. Required: 1-a. Assume that Andretti Company has sufficient capacity to produce 118,800 Daks each year without any increase in fixed manufacturing overhead costs. The company could increase its unit sales by 35% above the present 88,000 units each year if it were willing to increase the fixed selling expenses by $110,000. What is the financial advantage (disadvantage) of investing an additional $110,000 in fixed selling expenses? 1-b. Would the additional investment be justified? 2. Assume again that Andretti Company has sufficient capacity to produce 118,800 Daks each year. A customer in a foreign market wants to purchase 30,800 Daks. If Andretti accepts this order it would have to pay import duties on the Daks of $3.70 per unit and an additional $21,560 for permits and licenses. The only selling costs that would be associated with the order would be $2.60 per unit shipping cost. What is the break-even price per unit on this order? 3. The company has 700 Daks on hand that have some irregularities and are therefore considered to be "seconds." Due to the Irregularities, it will be impossible to sell these units at the normal price through regular distribution channels. What is the unit cost figure that is relevant for setting a minimum selling price? 4. 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 25% 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 30% of their normal level during the two-month period and the fixed selling expenses would be reduced by 20% during the two-month period. a. How much total contribution margin will Andretti forgo if it closes the plant for two months? b. How much total fixed cost will the company avoid if it closes the plant for two months? c. What is the financial advantage (disadvantage) of closing the plant for the two-month period? d. Should Andretti close the plant for two months? 5. An outside manufacturer has offered to produce 88,000 Daks and ship them directly to Andretti's customers. If Andretti Company accepts this offer, the facilities that it uses to produce Daks would be idle; however, fixed manufacturing overhead costs would be reduced by 30%. Because the outside manufacturer would pay for all shipping costs, the variable selling expenses would be only two- thirds of their present amount. What is Andretti's avoidable cost per unit that it should compare to the price quoted by the outside manufacturer?

Please solve for required 1-5 in image. Provide explanation of answers. Examples using excel preferred.

Answer 1

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	6.50	A
Direct Labor	9.00	B
Variable Manufacturing overhead	2.00	C
Variable Selling Expenses	2.70	D
Total Variable cost per unit	20.20	E=A+B+C+D
Sell Price Per unit	58.00	F
Contribution Per unit	37.80	G=F-E
Number of Units	88,000.00	H
Contribution amount	3,326,400.00	I=G*H
Fixed cost
Fixed manufacturing overhead	704,000.00	J
Fixed selling expenses	352,000.00	K
Total Fixed cost	1,056,000.00	L=J+K
Net Income	2,270,400.00	M=I-L
Ans 1 a
Increase in Units	30,800.00	N=H*30%
Contribution Per unit	37.80	G
Contribution Amount	1,164,240.00	O=N*G
Extra selling expenses	110,000.00	P
Net Income	1,054,240.00	Q=O-P
Ans 1 b
The net income will increase by $ 1,054,240 so yes the additional investment is justified.
Ans 2- Foreign Market
Total Variable cost per unit	20.20	E
Less: Present Variable Selling Expenses	2.70	D
Add: Shipping costs	2.60
Add: Import Duties	3.70
Revised Variable cost per unit	23.80	R
Additional permits and licenses	21,560.00	S
Number of units	30,800.00	N
Permits and licenses cost per unit	0.70	T=S/N
Break-even price per unit	24.50	U=R+T
Ans 3- Seconds Units
Only Variable unit cost figure is relevant for setting a minimum selling price. Here as the units are seconded so Andretti may also not incur variable selling expenses. So relevant variable cost per unit will be- $ 20.20- $ 2.70= $ 17.50.
Total relevant Variable cost per unit of $ 17.50 is the relevant minimum selling price.
Ans 4 a	Plant close
Number of units	14,666.67	V=H/12*2
Contribution Per unit	37.80	G
Contribution lost	554,400.00	W=U*G
Ans 4 b
Savings in Fixed manufacturing overhead by 70%	(82,133.33)	X=J/12*2*60%
Savings in Fixed selling expenses by 20%	(11,733.33)	Y=K/12*2*20%
Total fixed cost to be avoided	(93,866.67)
Net Financial disadvantage of closing the plant	460,533.33	Z=W+X+Y
Ans 4 c	25% capacity
Number of units	3,666.67	AA=H/12*2*25%
Contribution Per unit	37.80	G
Contribution earned	138,600.00	AB=AA*G
Fixed manufacturing overhead	117,333.33	AC=J/12*2
Fixed selling expenses	58,666.67	AD=K/12*2
Net Financial advantage at 25% capacity	37,400.00	AE=AB-AC-AD
Ans 4 d
So Andretti should not close the plant for two months but operate it at 25% capacity.
Ans 5
Variable cost per unit
Direct Materials	6.50	A
Direct Labor	9.00	B
Variable Manufacturing overhead	2.00	C
Variable Selling Expenses	0.90	AF=D*1/3
Total avoidable Variable cost per unit	18.40	AG=A+B+C+AF
Fixed cost
Avoidable Fixed manufacturing overhead by 30%	(211,200.00)	AH=J*30%
Number of Units	88,000.00	H
Avoidable Fixed manufacturing overhead per unit	(2.40)	AI=AH/H
Avoidable cost per unit	16.00	AJ=AG+AI