Homework #3 (Due by 12pm Oct 5th 2018 Take Home) Walther has a roadside produce stand where he sells oats
(Due by 12pm Oct 5th 2018 Take Home)
Walther has a roadside produce stand where he sells oats, peas, beans, and barley. He buys these products at per-pound wholesale prices of respectively, $1.05, $3.17, $1.99, and $0.95.; he sells them at per-pound retail prices of, respectively, $1.29, $3.76, $2.23, and $1.65. Each day the amount demanded (in pounds) could be as little as zero for each product, and as much as 10, 8, 14, and 11 for oats, peas, beans, and barley, respectively; he sells only whole-pound amounts, no partial pounds. Assume a discrete uniform distribution for daily demand for each product over its range; assume as well that Walther always has enough inventory to satisfy all demand. The summer selling season is 90 days, and demand each day is independent of demand on other days.
Create a spreadsheet simulation that will, for each day as well for the whole season, simulate Walther’s total cost, total revenue, and total profit.
Conduct multiple simulations and estimate average value and standard deviation for Walther’s total cost, total revenue, and total profit. (60 points)
Draw bar charts (with standard deviation error bars) for Walther’s total cost, total revenue, and total profit for the whole season. (30 points)
Prepare a report in WORD file with show your simulation and simulation results with appropriate description. (10 points.
Homework Writing Online | 100% Money Back Guarantee