Please see the question and help using excel. I have started the problem using the following set up...

Any formulas you could provide would be very helpful!!

Assignment 5: Inventory Management Newspaper Boy Problem: Daily demand for a newspaper is independent and identical. Demand can be characterized as follows: Demand in Units Probability 10 0.20 20 0.20 30 0.20 40 0.20 0.20 50 Cost of the newspaper is $1. The newspaper is sold to customers for a price of $1.40. Any unsold newspapers at the end of the day have to be sold as waste, and yields a revenue of $0.25 per copy. How many newspaper must be stocked at the start of the day? Simulate for 100 days, and draw your conclusion. D E F G H | J K L M N O P Q R S T U V W Y Stocking policy: 10 sales aty scrapped aty profit 10 0 Stocking policy: 20 sales aty scrapped qty profit 20 0 Stocking policy: 30 sales aty scrapped qty profit 30 0 12 Stocking policy: 40 sales aty scrapped qty profit 30 10 4.5 Stocking policy: 50 sales aty scrapped aty profit 30 20 4 8 B C 1 demand in units Probability Random # 2 10 0.20 0 - 19 3 3 20 0.20 20-39 4 30 0.20 40-59 5 40 0.20 60 - 79 6 50 0.20 80-99 7 8 9 10 Trials Rand # Demand 11 1 55 30 12 2 13 3 14 4 15 5 16 6 17 7 18 8 19 9 20 10 21 22 avg profit 23 -3