F01.justanswer.com
) Clio’s Floral Shoppe buys roses each week from Panama. Orders are placed online on Saturday night, and early Monday morning roses arrive at the airport in a box refrigerated with dry ice. The roses cost $8 a dozen and are sold on a cash-and-carry basis for $28 a dozen. Roses left over at the end of the week are put in a trash collector in an alley behind the store. Past sales (rounded to the nearest ten dozen) are as follows:?Dozens of Roses????????? Relative??? Demanded???????????? Frequency???????? 110?????????????????????? ? ? 5???????? 120???????????????????????? 20???????? 130???????????????????????? 25???????? 140???????????????????????? 30???????? 150???????????????????????? 20?The owner of Clio’s Floral Shoppe wants to compare two ordering rules for ordering roses: (1) order last week’s demand plus 10 dozen extra (as safety stock), (2) order 130 dozen every week. She wants to run an eight-week simulation to compare the average weekly profit for the two rules. Last week's demand was for 110 dozen. She generated the following random numbers for weeks 1?8, respectively: 63, 13, 67, 50, 71, 25, 44, and 00.?a. What is the random number range corresponding to each of the five demand quantities?b. Simulate eight weeks of operation using each of the ordering rules and compute the average weekly profit resulting from each rule.c. create a spreadsheet model in Excel for Problem 4. Rerun the model for 100 weeks of operation and 500 weeks of operation (trials) using random numbers you generate, rather than the random numbers supplied above. Compare the average weekly profit for the 8-week simulation, 100-week simulation and 500-week simulation. What conclusions do you draw? ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- power spectral density the basics
- sample test questions test 1
- unequal probability sampling
- competency examples with performance statements
- au
- ma s1 probability and discrete probability distributions
- columbia university in the city of new york
- advanced excel statistical functions formulae
- san jose state university
- random numbers and stochastic simulations in excel