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

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!

Q:

\f