Rafting2 - Front Range Rafting Date Created: Created By:...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Front Range Rafting Date Created: 1/26/2007 Created By: Mahanaim Peterson Purpose: To perform a cost-volume-profit analysis for the Front Range Rafting company of Fort Collins, Colorado.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
25 30 35 40 45 50 55 60 65 0 50,000 100,000 150,000 200,000 250,000 300,000 350,000 400,000 Cost-Volume-Profit Revenue Expenses Customers per Day
Background image of page 2
25 30 35 40 45 50 55 60 65 0 10,000 20,000 30,000 40,000 50,000 60,000 70,000 80,000 90,000 Net Income vs. Customers per Day for Different Rafting Fees $40 $45 $50 $55 $60 $65 $70 Customers per Day Net Income
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Scenario Summary Current Values: Average Season Changing Cells: Avg._Number_of_Customers__per_d 55 50 Fee_per_Customer 45 60 Insurance 8,000 10,000 Maintenance 25,000 25,000 Salary_and_Benefits 90,000 95,000 Administrative___Advertising 25,000 35,000 Est._Taxes 35,000 35,000 Result Cells: Total_Revenue 297,000 360,000 Total_Expenses 268,800 278,000 $B$30 $28,200 $82,000 Notes: Current Values column represents values of changing cells at time Scenario Summary Report was created. Changing cells for each scenario are highlighted in gray.
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 12

Rafting2 - Front Range Rafting Date Created: Created By:...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online