Question: please i need help with solving this homework , must be answer in excel , please also show how answers was sloved and the formulas

please i need help with solving this homework , must be answer in excel , please also show how answers was sloved and the formulas that were used Thank you please i need help with solving this homework , must be answer

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!