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.

This lab report was uploaded on 02/20/2008 for the course BIS 150 taught by Professor Jacobs during the Spring '07 term at DeVry Houston.

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