FShop sells fresh roses. At the start of the day, the owner buys fresh roses. The supplier charges $1 per rose if the order quantity is five or less. If the order is for more than five roses, the charge is $0.91 per rose. FShop can sell the roses at $1.95 each. Any roses remaining unsold at the end of the day are sold to a discount store at $0.45 each. Based on past data, the daily demand for fresh roses is estimated to be between 1 and 10 with equal probability. Given this information, we need to decide as to how many roses FShop should buy at the start of each day. Use Excel spreadsheet to analyze the problem. Once again, your boss is allergic to mathematical equations. Base your conclusion by mimicking or simulating for 30 days. (hint: set up a table with columns as follows: day#, demand, profit with 1 in stock, profit with 2 in stock .. profits with 10 in stock. Demand for each day can be mimicked by entering =randbetween(1, 10) in some unused area of the spreadsheet, copy it down 29 rows. Then copy these 30 cells to clipboard, and paste them under demand column in your table. This method mimics the demand. When you paste them, do not use paste, but use paste special function to paste only the values).Quantity5 or lessMore than 5Selling priceScrap Value Demand Cost Quantity06 Cumulativeprobability 52238431072539110659545552541155 Demand0.000.100.200.30…
FShop on roses
Plagiarism-free and delivered on time!
We are passionate about delivering quality essays.
Our writers know how to write on any topic and subject area while meeting all of your specific requirements.
Unlike most other services, we will do a free revision if you need us to make corrections even after delivery.
How it Works
Place an order
Fill out the order form.
Attach any custom instructions that is required to complete your order.
Pay online safely.
The order form will redirect you to a payment page.
Receive Order via Email
Once the order is complete, we’ll send it via the email provided on the order form.