CASE TWO :

A Special Economic Zone Authority, whose area includes a holiday resort situated on the Red Sea, operates, for 30 weeks each year, a holiday home which is left to visiting parties of children in care from other authorities. The children are accompanied by their own house mothers who supervise them throughout their holiday. From six to fifteen guests are accepted on terms of $100 per person per week. No differential exists for adults and children. Weekly costs incurred by the host authority are

Seasonal staff supervises and carry out the necessary duties at the home at a cost of $11,000 for the 30-week period. This provides staffing sufficient for six to ten guests per week but if eleven or more guests are to be accommodated; additional staff at a total cost of $200 per week are engaged for the whole of the 30-week period. Rent, including rates for the property, is $4,000 per annum and the councils recreation department, which charges a nominal fee of $1,000 per annum, maintains the garden of the home. Case Two Question: Tabulate the appropriate figures in such a way as to show the break-even point/s and to comment on your figures (Please do it on an excel or word file NOT handwritten)

Thank you so much

Food Electricity for heating and cooking Domestic (laundry, cleaning, etc...) expenses Use of minibus (Per guest) $25 $3 $5 $10