Final Project Proposal Case Study
Blue Café
1000kg of coffee beans,
Blue plans to import 1 ton of specialty coffee beans from Ethiopia. The best flavor tasting period of specialty coffee green beans is 6 months, and it needs 1 month of transportation. It needs to be sold within 5 months, otherwise it can only be half price of ordinary coffee Sell.
1000kg – green coffee beans
50kg(5%) – loss (due to transportation, baking, other losses)
950kg – usable coffee beans
20g – the amount consumed in a cup of coffee
150 days – number of days to sell
316.67 cups – average daily sales
9$ – unit price per cup (original price)
4.5$ – discounted unit price
D~N(?=300,?^2=50^2) – the number of customers per day
3.5$ – cost per cup
-0.8 -Elastic coefficient of coffee (discount unit price can be $7, $8)
two options
- Directly estimate the total sales volume for one and a half years, refer to assignment 2.2. Then put the discounted price of 7, 8 on the analog side
- Simulate the demand for 150 days, get the total demand, deduct the total cost, and get the total profit for 150 days.
Carry out 100 simulations on total profit and total demand, and each simulation judges whether there is any surplus in stock, plus the profit of remaining beans
Change the price to $7 and $8 or change the stock quantity