***PLEASE SHOW EXCEL FORMULAS (CALCULATIONS) so I may compare to my notes. Thank you!

Cane Company manufactures two products called Alpha and Beta that sell for $125 and $85, respectively. Each product uses only one type of raw material that costs $6 per pound. The company has the capacity to annually produce 101,000 units of each product. Its average cost per unit for each product at this level of activity are given below: Alpha Beta $ 30 $12 Direct materials Direct labor 21 20 Variable manufacturing overhead 8 6 11 Traceable fixed manufacturing overhead 17 19 Variable selling expenses 13 9 Common fixed expenses 16 11 Total cost per unit $ 105 $77 The company considers its traceable fixed manufacturing overhead to be avoidable, whereas its common fixed expenses are unavoidable and have been allocated to products based on sales dollars. 4. Assume that Cane expects to produce and sell 91,000 Betas during the current year. One of Cane's sales representatives has found a new customer who is willing to buy 6,000 additional Betas for a price of $40 per unit. What is the financial advantage (disadvantage) of accepting the new customer's order? 5. Assume that Cane expects to produce and sell 96,000 Alphas during the current year. One of Cane's sales representatives has found a new customer who is willing to buy 11,000 additional Alphas for a price of $84 per unit; however pursuing this opportunity will decrease Alpha sales to regular customers by 6,000 units. a. What is the financial advantage (disadvantage) of accepting the new customer's order? b. Based on your calculations above should the special order be accepted? Complete this question by entering your answers in the tabs below. Req 5A Req 5B What is the financial advantage (disadvantage) of accepting the new customer's order? 8. Assume that Cane normally produces and sells 61,000 Betas and 81,000 Alphas per year. If Cane discontinues the Beta product line, its sales representatives could increase sales of Alpha by 16,000 units. What is the financial advantage (disadvantage) of discontinuing the Beta product line? 9. Assume that Cane expects to produce and sell 81,000 Alphas during the current year. A supplier has offered to manufacture and deliver 81,000 Alphas to Cane for a price of $84 per unit. What is the financial advantage (disadvantage) of buying 81,000 units from the supplier instead of making those units? 10. Assume that Cane expects to produce and sell 51,000 Alphas during the current year. A supplier has offered to manufacture and deliver 51,000 Alphas to Cane for a price of $84 per unit. What is the financial advantage (disadvantage) of buying 51,000 units from the supplier instead of making those units? 13. Assume that Cane's customers would buy a maximum of 81,000 units of Alpha and 61,000 units of Beta. Also assume that the raw material available for production is limited to 161,000 pounds. How many units of each product should Cane produce to maximize its profits? Alpha Beta Units produced