Filming Voyages CVP Case 1 (1)
docx
keyboard_arrow_up
School
George Brown College Canada *
*We aren’t endorsed by this school
Course
2031
Subject
Industrial Engineering
Date
Feb 20, 2024
Type
docx
Pages
1
Uploaded by LieutenantBraveryGrouse22
Case 1
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.
1.
Compute the revenue and variable costs for each film. Use this to compute the contribution margin per film. (2.5)
2.
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.5)
3.
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.5)
4.
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.5)
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help