Fitzroy Court costing
Project description
This is an activity on apportionment of costs, breakeven analysis and marginal cost pricing.
At the end of this activity you should be able to:-
• Apportion fixed costs to several products
• Use breakeven analysis to help to determine the effects of different prices
• Judge when apportioned fixed costs may be misleading in decisions about pricing
• Use Excel to create models and charts
please focus in;
What are we looking for?
(((To pass this assessment you MUST submit an individual Excel file containing:)))
• An apportionment of fixed costs and calculation of variable costs
• Break-even points for the upper and lower selling prices for each type of apartment per week
• Calculations of expected net profit per week for each apartment type, at the upper and lower proposed selling prices
(((To achieve a higher grade in this assessment you SHOULD:)))
• Provide an accurate apportionment of fixed costs and calculation of variable costs
• Deliver an accurate calculation of break-even points and profits
• Include clear, accurately labelled data in tabular form
• Use appropriate Excel functions
• Include recommendations as to how the cost data should be used in setting prices
To achieve a grade at the highest level you COULD:
• Lay out your work clearly in order to make your information clear
• Provide appropriate diagrams
• Use Excel to enable What If analysis
• Make recommendations that are clearly based on your analysis
ScholarMatic: Explanation & Answer
Your ready answer from a verified tutor is just a click away for as little as $14.99
Click Order Now to get 100% Original Answer Customized to your instructions!
