Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

So this question requires excel but I have no idea how to solve it, please help. A travel company Adventure Travels currently has 10 buses.

So this question requires excel but I have no idea how to solve it, please help.

A travel company Adventure Travels currently has 10 buses. There is a fixed cost of $10,000 for maintenance of the garage which houses 10 buses. The price per ticket is $40 for one trip and, at that price, demand for each trip is 50 passengers. Each bus has a capacity of 60 passengers. The travel company wants to set the price per ticket between $35 and $45. Prices will vary in whole numbers, i.e., $35, $36, etc. For every $1 increase in price, demand decreases by 2 passengers. For every $1 decrease in price, demand increases by 2 passengers per trip. Variable costs are $900 per trip. The company wants to add more buses. The total number of buses will range from at least 10 to a maximum of 20 buses. Addition of each new bus incurs an additional $1,000 on fixed cost. The garage has a maximum capacity of 20 buses. Assume one trip per bus for calculations.

1.Start with the original values. For a ticket price of $36, the maximum possible difference in profits is equal to:

A. Half of the profit made when the number of buses is 20

B. Value of profit made when the number of buses is 10

C. Difference between the profit when number of buses is 20 and profit when number of buses is 10

D. All of the above

Thank you!

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

Probability and Stochastic Processes A Friendly Introduction for Electrical and Computer Engineers

Authors: Roy D. Yates, David J. Goodman

3rd edition

1118324560, 978-1118324561

More Books

Students also viewed these Mathematics questions