- I Need To Solve This Using Excel 1 (40.81 KiB) Viewed 25 times
I NEED TO SOLVE THİS USİNG EXCEL
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
I NEED TO SOLVE THİS USİNG EXCEL
I NEED TO SOLVE THİS USİNG EXCEL
A greengrocer tries to determine how many kilograms of strawberries he should order for the next month. He knows that cost of the strawberry is 10 dollars/kg. The demand for the strawberry has the probability distribution shown below. Strawberries are sold for 15 dollars/kg. If the kilogram demand for strawberries for that week is less than the kilogram ordered by the grocery store, the strawberries are sold to a company that makes jam for 3 dollars/kg. This grocery store orders based 1 on historical data according to a normal distribution with a mean of 20 and a standard deviation of 2 kilograms. 2 a. Complete green shaded areas in the Excel file given below. Calculate the average profit of 20 runs. (30p) 3 b. b. Calculate the maximum profit and strawberries(kg) ordered for maximum profit (Hint: Use Vlookup function) based on the calculations in Part a. (5p) 4 5 6 7 8 9 10 11 12 Cost 10.00 $ Selling Price Disposal Price 15.00 $ 3.00 $ Strawberry(kilograr Probability Dum. Probability 15 0.5 20 0.3 22 0.2 um 13 14 Kilograms of Strawberry Random Demand Ordered Probability Kilogram of strawberries will sold to jam maker Strawberry Demand (kg) Disposal Revenue Run Costs Sales Revenue Profit 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 amico 99 10 11 12 13 14 15 16 17 18 19 20 36 37 38 Average profit Max profit kg of strawberries ordered for Max profit 39
A greengrocer tries to determine how many kilograms of strawberries he should order for the next month. He knows that cost of the strawberry is 10 dollars/kg. The demand for the strawberry has the probability distribution shown below. Strawberries are sold for 15 dollars/kg. If the kilogram demand for strawberries for that week is less than the kilogram ordered by the grocery store, the strawberries are sold to a company that makes jam for 3 dollars/kg. This grocery store orders based 1 on historical data according to a normal distribution with a mean of 20 and a standard deviation of 2 kilograms. 2 a. Complete green shaded areas in the Excel file given below. Calculate the average profit of 20 runs. (30p) 3 b. b. Calculate the maximum profit and strawberries(kg) ordered for maximum profit (Hint: Use Vlookup function) based on the calculations in Part a. (5p) 4 5 6 7 8 9 10 11 12 Cost 10.00 $ Selling Price Disposal Price 15.00 $ 3.00 $ Strawberry(kilograr Probability Dum. Probability 15 0.5 20 0.3 22 0.2 um 13 14 Kilograms of Strawberry Random Demand Ordered Probability Kilogram of strawberries will sold to jam maker Strawberry Demand (kg) Disposal Revenue Run Costs Sales Revenue Profit 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 amico 99 10 11 12 13 14 15 16 17 18 19 20 36 37 38 Average profit Max profit kg of strawberries ordered for Max profit 39