Filming Voyages Inc. is a company operated by an individual in the summer as a marine life filming operation on the Great Lakes. It operates a sailing schooner with a full film crew.

Over the last few years, the company has been able to sell their films to a local public television channel for, on average $$9,000$ each. The shoot time for the films is usually $3$ sailing days. The company operates from mid$-$May until mid$-$September, with postproduction in September and October. 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, filming and$/$or marine biology 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, $$55$ per person. The daily operating expenses fuel and miscellaneous supplies average $$50$ per cruise, and the postproduction editing costs are approximately $$1,800$ per film. The company has a variety of annual expenses including postproduction facilities, maintenance, depreciation, marketing, licenses, etc., totaling approximately $$85,000.$

Required:

Prepare an Excel Workbook or Google Sheets to answer the following questions in a professional manner. Ensure that you are utilizing workbook 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.

Compute the revenue and variable costs for each film. Use this to compute the contribution margin per film. $(2\mathrm{.}5)$

Compute the number of films that 'Canadian' must sell each year to break$-$even. Use your knowledge gained in this course to show the different formulas, graphs etc for break$-$even analysis. $(2\mathrm{.}5)$

The owner expects a total return on capital and remuneration of $$125,000.$ Using the concept of 'contribution margin', cost$-$volume$-$profit, and target profit calculations, estimate how many films the owner needs to make to reach this objective. Is this a realistic expectation? Add your thoughts, proposals, and recommendations. $(2\mathrm{.}5)$

Prepare a contribution margin income statement for Filming Voyages Inc. If the owner wishes to adjust or achieve his income goal, what changes can he make? How can these changes be easily estimated and projected to show how these changes affect net income. Use your imagination, and your knowledge of cost$-$volume$-$profit analysis. Highlight your ideas by utilizing the various graphing tools in Excel. $(2\mathrm{.}5)$