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

Info icon This preview shows pages 1–7. 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.
Image of page 1

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

View Full Document Right 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
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
Image of page 3

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

View Full Document Right 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.
Image of page 4
Slow Season Busy Season Reduced Prices 40 55 55 60 60 45 10,000 10,000 8,000 25,000 30,000 25,000 75,000 105,000 90,000 35,000 45,000 25,000 25,000 40,000 35,000 288,000 396,000 297,000 232,400 315,800 268,800 $55,600 $80,200 $28,200
Image of page 5

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

View Full Document Right Arrow Icon
Result Cells Scenarios Total_Revenue Total_Expenses
Image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern