Question: please i need help with solving this homework , must be answer in excel , please also show how answers was sloved and the formulas
Graded: Learning Unit 4. Ch 10 Special Pricing Decision AJ & Company manufactures cances. Their newest product sells for $1100. The company produces and sells 3,500 units per year. Cost data follows: Variable manufacturing $650 per unit Variable selling and administrative $160 per unit Fixed manufacturing $420,000 per year Fixed selling and administrative $320,000 per year A potential deal has come up for a one-time sale of 20 units at a special price of $800 per unit Tho nalo will not negatively impact the company's regular sales activities, It will require the normal variable manufacturing costs and variablo soling and administrativo costs There is plenty of excess capacity and the deal will not impact fixed costs Create a Differential Analysis of a Special Pricing Decision showing the expected increase or decrease in operating income if this order is accepted. Based on your analysis, would you accept or reject the order? Why? You can see a sample analysis in Chapter 10. Exhibit M10-5. Pay close attention, ours is slightly different This assignment is worth 15 points overall, 9 points for proper setup, 3 points for correct final answer, 3 points for formulas When your file is ready to submit, click on "Graded: Leaming Unit 4. Ch 10 Special Pricing Decision" above. In the next scroon, attach your file. This assignment must be submitted in EXCEL with formulas in at least two cells. Review the tab here "Easy Excel Functions
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
