Classic Limo, Inc., provides limousine service to Tri-Cities airport. The price of the service is fixed at a flat rate for each trip and most costs of providing service are stable for each trip. Marc Pence, the owner, budgets income by estimating two factors that fluctuate with the economy: the fuel cost associated with each trip and the number of customers who will take trips. Looking at next year, Marc develops the following estimates of contribution margin (price less variable cost of the trip, including fuel) and for the estimated number of customers. Although Marc understands that it is not strictly true, he assumes that the cost of fuel and the number of customers are independent. Contribution Margin per Ride (Price Variable Scenario cost) Excellent $ 45 Fair 40 Poor Number of Customers 5,400 3,200 2,400 15 In addition to the costs of a ride, Marc estimates that other service costs are $54,000 plus $4 for each customer (ride) in excess of 3,200 rides. Annual administrative and marketing costs are estimated to be $15,000 plus 10 percent of the contribution margin. Required: Prepare an analysis of the possible operating income for Classic Limo, Inc., similar to that in Exhibit 13.15. What is the range of possible operating incomes? Contribution Margin Number of Customers Total Contribution Margin Service Costs Marketing & Admin Operating Profit (Loss) Poor 15 Fair 40 Excellent 45 2,400 2,400 2,400 3,200 3,200 Poor 15 Fair Excellent 3,200 Poor $ 15| Fair Excellent 5,400 5,400 5,400 $ 45 Exhibit 13.15 Spreadsheet Analysis of Alternative Budgeting Scenarios Sales Quantity Cost of Goods Sold of Gross Margin Gerosion Marketing & Admin Operating Profit Revenue & Admi 225,000 225,000 225,000 $5,625,000 $6,750,000 $7,875,000 $3,712,500 $3,712,500 $3,712,500 $1,912,500 $3,037,500 $4,162,500 $1,652,250 $1,652,250 $1,652,250 $260.250 $1,385,250 $2,510,250 9 240.000 240,000 240,000 $6,000,000 $7,200,000 $8,400,000 $3,960,000 $3,960,000 $3,960,000 $2,040,000 $3,240,000 $4,440,000 $1,686,000 $1,686,000 $1,686,000 $354,000 $1,554,000 $2,754,000 10 11 12 13 260,000 260,000 260.000 $6,500,000 $7,800,000 $9,100,000 $4,290,000 $4.290.000 $4,290,000 $2,210,000 $3,510,000 $4,810,000 $1,731,000 $1,731,000 $1,731,000 $479,000 $1,779,000 $3,079,000 14 15