Contribution Margin Problem Set II
|
Contribution Margin Problem Set II
Sailing Voyages Inc. is a company operated by an individual as a summer tourist attraction on the Great Lakes. It operates a sailing schooner offering day cruises for individuals and groups. Over the last few years, the average number of tourists per cruise was 30. The average charge per person for the cruise including group discounts was $100. The company operates from mid-May until mid-September. On average, the ship sails 100 days during this period.
‘The Canadian’ (the name of the schooner) requires a crew of 6, and is captained by the owner of the company. University students with extensive sailing experience have been willing to work on a per diem basis of $100. They are paid only if the ship is cruising. The ship provides non-alcoholic refreshments and a light lunch. These are acquired daily from a local delicatessen and cost, on average, $25 per person. The daily operating expenses fuel and miscellaneous supplies average $50 per cruise. The company has a variety of annual expenses including: maintenance, depreciation, marketing, licenses, etc., totaling approximately $85,000.
Required:
Prepare an Excel Workbook to answer the following questions in a professional manner. Ensure that you are utilizing Excel features (including links between spreadsheets, formulas, formatting, graphing). Please have a professional cover sheet that includes your name, student ID, Faculty Name, Course code and name, A title, Due date.
Contribution Margin Problem Set II