Fix Top of Form 2/15: Milestone submission. On Sheet 1: Table 2 should use Fixed cost per month “$3 million (instead of $10) per

Fix Top of Form

2/15: Milestone submission.
On Sheet 1:
Table 2 should use Fixed cost per month “$3 million (instead of $10) per

Click here to Order a Custom answer to this Question from our writers. It’s fast and plagiarism-free.

Top of Form

2/15: Milestone submission.

On Sheet 1:

Table 2 should use Fixed cost per month “$3 million (instead of $10) per month” because Project 2->Tab 2->Question #3 states that “The variable cost per unit is $10 and the fixed costs are $3 million per month.” Please correct the related numbers on Question 2 accordingly.

Question #2: “Marginal Contribution = Revenue – Variable Costs” is the correct formula you should use. 

Question #2: You should use the formula “Profit % = Profit / Revenue” when calculating Profit % for Total (in cell D70). Do not use ‘sum’ function at here. 

On Sheet 2:
Please do not use “Total Fixed Costs (Millions- from Tab1)” which is inaccurate statement.
For Question #1, you need to carefully read the assumptions which indicate that the Fixed Costs is allocated based on the number of boxes sold. For example, Total FC for Standard Boxes = (Volumes per year for Standard Boxes/Total Volume for both boxes) * Total FX = (108/126) * 156 =133.71. You need to correct all related calculations accordingly. 

Sheet 3:

For Question #1, Total Allocated costs (row 14) for Cost of Standard Boxes (Column H) should be the sum of the computed results in column H (=16.84). 

Your calculations for the Allocated cost per box are incorrect. For example, for Standard boxes, Allocated Cost per box = Total Allocated costs (16.84) / Number of boxes per year (108) = 0.16. Please correct your related calculations for both standard boxes and Deluxe boxes.

On Sheet 4:
For Question #1, check “Fixed Costs” and “Contribution” numbers if you revised the costs on Sheet 3. They should be consistent.
Revised other related questions caused by the above changes. 

Place your order now for a similar assignment and have exceptional work written by one of our experts, guaranteeing you an A result.

Need an Essay Written?

This sample is available to anyone. If you want a unique paper order it from one of our professional writers.

Get help with your academic paper right away

Quality & Timely Delivery

Free Editing & Plagiarism Check

Security, Privacy & Confidentiality