Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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 the 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. Scenario Contribution Margin Per Ride Number of Customers (Price - Variable cost) Excellent $50 12,000 Fair $35 6,200 Poor $25 4,500 In addition to the costs of a ride, Marc estimates that other service costs are $60,000 plus $4 for each customer (ride) in excess of 6,000 rides. Annual administrative and marketing costs are estimated to be $20,000 plus 15% of the contribution margin. Required: 1) Using the above information, construct an Excel spreadsheet to prepare an analysis of the possible operating income for Classic Limo, Inc., similar to that in Exhibit 13.15 on page 558 of the textbook. You must submit this part of the assignment as an Excel file and utilize formulas for all calculations. You will be graded on the answers provided, formulas/calculations, and presentation. If you would like feedback on this part of the assignment before submitting, please email your spreadsheet to me at least 48 hours prior to the due date. 2) Write a two-page paper as if you are the accounting manager of Classic Limo, Inc. and are recommending that management use ONLY ONE of the nine calculated budgeting scenarios for planning for the upcoming year. Your selection should be based on the scenario that is MOST LOGICAL based on research rather than the one the company would prefer. The paper should focus on detailing the thought process of making the final budgeting decision. The paper must include what assumptions were made (i.e. - location of airport, economic conditions) and the full rationale behind your decision. While you have freedom to make certain assumptions to support your selection, you must use at least two outside sources with factual information to support your decision as well (i.e. - fuel prices, weather conditions, tourism statistics). There is

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Ethics Education Making Ethics Real

Authors: Alberto J. Costa, Margarida M. Pinheiro

1st Edition

1032019999, 9781032019994

More Books

Students also viewed these Accounting questions

Question

=+2 What factors would you consider in evaluating an e-CCT program?

Answered: 1 week ago

Question

What is the purpose of a costbenefit analysis?

Answered: 1 week ago