Question

Classic Limo, Inc., provides limousine service to Tri-Cities airport. The price of the service is fixed at a flat rate for eaRequired: Prepare an analysis of the possible operating income for Classic Limo, Inc., similar to that in Exhibit 13.15. What

Exhibit 13.15 Spreadsheet Analysis of Alternative Budgeting Scenarios Sales Quantity Cost of Goods Sold of Gross Margin Geros

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Analysis of possible operating income of Classic Limo, Inc

Magketing opezotiug and Admin lost (outnbution Nembex Total Coutribution (ost Searice Profit of Customes Nargin Maagin 36000

Operating profit/(Loss)= Total contribution margin- service cost- Marketing and administrative costs

Possible operating income:

For 2400 rides = (-36600)+17400+28200 =$ 9000

For 3200 rides = (-25800)+62200+60600=$ 97000

For 5400 rides = (-4900)+116600+140900=$ 252600

Calculations:

1. Service Cost

$54,000 is fixed for upto 3200 rides.

For 5400 rides= (5400-3200)*4 + 54000 = 62800

2. Marketing and administrative costs

= 15000+ 10% of contribution margin

For 2400 rides

- Poor = 15000+ (36000*10%)= 18600

- Fair = 15000+ (96000*10%)= 24600

- Excellent = 15000+ (108000*10%)= 25800

For 3200 rides

- Poor = 15000+(48000*10%)= 19800

- Fair= 15000+(128000*10%)= 27800

- Excellent= 15000+(144000*10%)= 29400

For 5400 rides

- Poor= 15000+(81000*10%)= 23100

- Fair= 15000+(216000*10%)= 36600

- Excellent = 15000+(243000*10%)= 39300

Add a comment
Know the answer?
Add Answer to:
Classic Limo, Inc., provides limousine service to Tri-Cities airport. The price of the service is fixed...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Classic Limo, Inc., provides limousine service to Tri-Cities airport. The price of the service is fixed...

    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...

  • Pool Cleaning Service provides pool cleaning services to residential customers. The company has three​ employees, each...

    Pool Cleaning Service provides pool cleaning services to residential customers. The company has three​ employees, each assigned to specific customers. The company considers each​ employee's territory as a business segment. The company incurs variable costs that include the​ employees' wages, pool​ chemicals, and gas for the service vans. Fixed costs include depreciation on the service vans. Following is the income statement for the month of July: Possible reasons for the profitability of this business segment include the​ following: Felicity Pool...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT