Question: Part 3: Based on the data presented in the Unit VII Spreadsheet Template in Excel (Special Order tab), calculate the net increase or decrease in
Part 3: Based on the data presented in the Unit VII Spreadsheet Template in Excel (Special Order tab), calculate the net increase or decrease in profit if they take the special order.
Complete your calculations by filling in the highlighted cells, and embed a copy of the completed spreadsheet into this report. Discuss the results and comment on if you think the cookie business should take on this special order of cookies for a wedding. Business has been slow the last few months, and the offer is less than the usual selling price for the cookies.
As part of your discussion, include both quantitative (based on the numbers) and qualitative (not based on numbers) factors that would go into the decision to take on the special order.
This is a 5301- Managerial Applications of Accounting course.
| Cookie Business | |
| Number of cookies needed | 1,000 |
| Discounted price per cookie | $ 2.75 |
| Normal price per cookie | $ 3.75 |
| Cost of special printed design per cookie | $ 0.50 |
| Cost of tool needed to make the design | $ 100.00 |
| Revenue for special order | $ 2,750 |
| Costs for special order: | |
| Design cost | $ 500 |
| Tool cost | $ 100 |
| Total Variable Manufacturing Cost | $ 600 |
| Net profit | $ 2,150 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
