Question: please help with excels or risk solver this is the only part I need help with Instructions: Answer the following questions using the Risk Solver

please help with excels or risk solver this is the only part I need help with

please help with excels or risk solver this is
Instructions: Answer the following questions using the Risk Solver Platform (RSP) Excel add-in. University Florists makes bouquets from a variety of materials. The Daily Special Bouquet is priced at $20. The florist assembles this bouquet each day from a variety of low cost flowers he buys from his flower supplier. The actual cost of flowers ranges uniformly from $2 to $7, with all intermediate values being equally likely. The florist (who studied management science many years ago) knows that the time to assemble a bouquet is normally distributed with a mean time of 5 minutes and standard deviation of 1 minute. This will be the time required for all of the Daily Special Bouquets for that day. The florist values his labor time at $10 per hour. Sales are normally distributed with a mean of 10 bouquets per day with a standard deviation of 1 bouquet. What formulas should go in cells B8:B14 to simulate daily profits for the store? A B D E $20 Constant Normal Sid dev 1 Average Lo Average 10 $2 $7 5 Sed dev 1 Cont. Uniform Normal Constant $10 1 Initial Conditions: 2 Sales Price 3 Number of Bouquets: 4 Cost of Flowers 5 Labor Time 6 Labor Cost 2 8 Cost of Flowers 9 Labor Time (Min) 10 Labor Cost 11 Total Cost 12 Profit/Bouquet 13 Bouquets Sold 14 Total Profit $4.41 2.55 $0.43 4.83 $15.17 12.20 $184.99 The

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!