[meteor_slideshow slideshow=”arp1″]
Fitzroy Court costing
As a newly appointed graduate management trainee you have been asked by the marketing director of Fitzroy Court to produce a short report for the board of directors including models in Excel that allow the directors to consider various pricing options.
Your report must be in excel and should make recommendations about the pricing of all three apartment types being built by the company for weekly rental. In order to make these recommendations your report will have to include:
1. As required by the directors, a note of the break-even points for the upper and lower selling prices for each type of apartment per week
2. Also as required by the directors, calculations of expected net profit per week for each apartment type, at the upper and lower proposed selling prices.
3. As suggested by Katrina, recommendations as to how the cost data should be used in setting prices.
The figures you use to support your report must be clearly presented, properly formatted and correctly described. The directors may ask you to explain your calculations. You will certainly need to use a tabular presentation for some of the data; it will probably help to make things clearer if you use diagrams and charts as well.
Fitzroy Court – Details
Universal Marketing plc are the developers of a new apartment and leisure complex called Fitzroy Court which is located in the West Country of England. The company needs to decide on a price per apartment per week for the holiday apartments which they are about to offer for rent.
The board of directors have asked that all fixed costs should be apportioned (i.e. shared out) on the basis of the total number of rooms in each apartment. Katrina Petrova, the marketing director, has some doubts about the validity of such calculations for pricing purposes; she agrees that fixed costs must of course be considered in evaluating profits, but she thinks that once you are committed to fixed costs, these should be ignored in setting prices.
The directors have carried out market research and obtained data on prices charged by competitiors for similar apartments, and wish to use this for initial modelling. They would like to establish:
1. The break-even point for each type of apartment if rented at the upper or lower ends of the price ranges.
2. The weekly profit or loss for each type of apartment.
3. Expected total annual profit or loss for the venture, assuming full occupancy.
4. Recommendations for action if their figures indicate low season losses on rental.
The directors have produced the attached information regarding costs, size of apartments and maximum occupancy to help with your calculations.
Universal Marketing PLC
Background Information – Fitzroy Court
Market Research
Studio One Bedroom Two Bedroom
Weekly price range for rental £240 – £300 £320 – £420 £350 – £480
Cost Data
Variable Costs £
Cleaning materials per room per week 0.40
Cleaning cost per room per week 10.50
Garden Maintenance per week (two bedroom flat only) 5.00
Electrical Cost per room per week (average) 3.90
Average Laundry Cost per occupant per week* 3.00
Annual Fixed Costs for the Complex £
Depreciation of Furniture & Fittings 100,000
Administration Costs 200,000
Legal and Financial Costs 15,000
Maintenance Costs – site and facilities 260,000
Gymnasium & Recreation Facilities 125,000
Other Information (needed to calculate annual depreciation of the buildings)
Life of Complex 30 years
Initial Building Cost £4,500,000
Apartment Details
• Every apartment has a kitchen and a bathroom, in addition to its other rooms.
• Studio apartments have a combined living room/bedroom;
• One bedroom apartments have a separate living room and a bedroom
• Two bedroom apartments have a living room, a separate dining room and two bedrooms.
Studio 1 Bedroom 2 Bedroom
No of apartments 6 54 10
Maximum number of occupants 2 4 6
*Regardless of the number of occupants, health and safety requirements are that all bed linen and towels, used or not, are laundered each week when an apartment has been occupied.
Notes
Some variable costs are expressed per room and apartments have more than one room; others are expressed per occupant.
Prices quoted are for “high” and “low” season. The summer season would usually cost more than autumn or winter; the last week in December would be more expensive too. It would certainly be possible to model this by looking at similar companies to see how prices are changed during each week of the year. It is possible, however that taking the mean (simple average) of the high and low season prices will approximate such modelling over a full year (in other words, you can probably assume approximately 26 weeks of high season, and 26 weeks of low season).
Good pieces of work will show most or all the following characteristics:
• Accurate apportionment of fixed costs and calculation of variable costs
• Accurate calculation of break-even points and profits
• Effective use of MS Excel
• Clear, accurately labelled data presentations
• Well argued commentary on the rationale for the proposed pricing structure
[meteor_slideshow slideshow=”arp2″]
A-Research-Paper.com is committed to deliver a custom paper/essay which is 100% original and deliver it within the deadline. Place your custom order with us and experience the different; You are guaranteed; value for your money and a premium paper which meets your expectations, 24/7 customer support and communication with your writer. Order Now
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]
