Project #86068 - Exel, Business and

Joe Café Case

Understanding the effects of pricing on revenues, costs and pricing

Introduction: It is February and you have recently been hired as the manager of Joe Café. You have been asked to improve profitability…Please use Excel for all calculations.

1.     Analysis of Pricing: You manage Joe Café which sells meals at a price of \$8.50 each. The meal includes a hot dish and a beverage of your choice. The average number of meals sold per month is 21,000. The owners of  Joe Café would like to increase its sales and profits. They know that if price is lowered, they will sell more meals. So they run an experiment. Price is lowered to \$7.50 per meal in March and the number of meals sold increases to 23,000.

a.       What is the Price Elasticity of Demand?

b.      Is elasticity elastic, inelastic or neither?

c.       What does this mean and why does it matter?

d.      Will Revenues increase or decrease as a result of the price cut? By How much?

e.       Beatrice has calculated the fixed costs for the Café are \$18,000 per month and each meal costs \$4.50. Will profits go up or down as a result of the price cut? By How much?

1.     Shaun suggests that there wasn’t enough time in the experiment. He estimates that in the second month, April, the Café will sell 26,000 meals at \$7.50. Please answer the following assuming that Shaun is correct. You want to get an idea of what will happen to profits before you commit to an action. If profits go up when Shaun is correct, then you will keep the current price of \$7.50.

a.       What would be the Price Elasticity of Demand if Shaun is correct?

b.      Is elasticity elastic, inelastic or neither?

c.       What does this mean and why does it matter?

d.      Will Revenues increase or decrease as a result of the price cut at 26,000 meals? By How much?

e.       Beatrice has calculated the fixed costs for the Café are \$18,000 per month and each meal costs \$4.50. Will profits go up or down as a result of the price cut if Mt. Claire sells 26,000 meals? By How much?

1.     The owners, see that after seeing the change in profits from the price decrease in March. They go back to a price of \$8.50 and sell 21,000 meals in April. They decide that they are only willing to produce 21,000 meals at a price of \$8.50. However, if they raised price to \$9.50 per meal, they would be willing to produce 30,000 meals.

a.       Calculate the Elasticity of Supply. Is it elastic or inelastic?

b.      How many meals will Mt. Claire Café sell at \$9.5 each? Hint: you can only sell what customers will buy. Use the original the elasticity of demand calculated in 1 above.

c.       What will be the Revenue?

d.      What will be the Profit?

 Subject Mathematics Due By (Pacific Time) 10/11/2015 12:00 am
TutorRating
pallavi

Chat Now!

out of 1971 reviews
amosmm

Chat Now!

out of 766 reviews
PhyzKyd

Chat Now!

out of 1164 reviews
rajdeep77

Chat Now!

out of 721 reviews
sctys

Chat Now!

out of 1600 reviews
sharadgreen

Chat Now!

out of 770 reviews
topnotcher

Chat Now!

out of 766 reviews
XXXIAO

Chat Now!

out of 680 reviews
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy