Name Bus 213 Managerial Accounting Special Project #2 Due Date: Sunday, December 3, 2017 by 11:59 pm This project requires the solution to be prepared using an excel spreadsheet. Email your completed spreadsheet to me by 11:59 pm Sunday, December 3, 2017. However, if you prefer to submit a hard copy of your solution, you can submit it during our last class on Friday December 1, 2017, or drop it off in my office anytime during the day on December 1st The Scan House Company manufactures a number action figures. One of the action figures, R2-D2, is currently in production for the release of the latest Star Wars movie coming out next month The company normally produces and sells 60,000 R2-D2s each year at a selling price of $32 per unit. The company's unit costs at this level of activity are given below: 10.00 Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Variable selling expenses Fixed selling expenses Total cost per unit 4.50 2.30 5.00 ($300,000 total) 1.20 3.50 ($210,000 total) A number of questions relating to the production and sale of R2-D2 follow. Each question is independent equired (using an excel spreadsheet) 1. Assume that Scan House has sufficient capacity to produce 90,000 R2-D2s each year without any increase in fixed manufacturing overhead costs, The company could increase its unit sales by 25% above the present 60,000 units each year if it were willing to increase the fixed selling expenses by $80,000. What is the financial advantage (disadvantage) of investing an additional $80,000 in fixed selling expenses? Would the additional investment be justified? 2. Assume again that Scan House has sufficient capacity to produce 90,000 R2-D2s each year. A customer in a foreign market wants to purchase 20,000 R2-D2s. If Scan House accepts this order it would have to pay import duties on the R2-D2 of $1.70 per unit and an additional $9,000 for permits and licenses. The only selling costs that would be associated with the order would be $3.20 per unit shipping cost. What is the break-even price per unit on this order? 3. The company has 1,000 R2-D2s 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? Explain 4. Due to a strike in its supplier's plant, Scan House is unable to purchase more material for the production of R2-D2s. The strike is expected to last for two months. Scan House Company has enough material on hand to operate at 30% of normal levels for the two-month period. As an