Use the Simulation according to the commands given in the question image to solve the following problems:And using excel, if possible I need to send the offline solution (file) via gmail. thank you Use Monte Carlo Simulation to solve the following problem.Pierre's can bake the bread only in batches of a dozen loaves each. Each loaf costs 25¢ tomake. Past data have shown that this demand ranges from 36 to 96 loaves per day. A loafsells for 40¢, and any bread left over at the end of the day is sold to a charitable kitchen for asalvage price of 10¢/loaf. If demand exceeds supply, we assume that there is a lost-profit costof 15¢/loaf (because of loss of goodwill, loss of customers to competitors, and so on). Thedemand can be categorized into three types: high, average, and low with probabilities of .30,.45, and .25, respectively.The demand distribution is shown as in the tableDemand Distribution by Demand CategoriesCb Demand ProbabilityDistributionDemandHighAverageLow36.05.10.1548.10.20.2560.2530.3572.30.25.1584.20.10.0596.10.05.05Pierre's would like to determine the optimal number of loaves to bake each day to maximizeprofit (revenues salvage revenues cost of bread cost of lost profits).

Pierre's can bake the bread only in batches of a dozen loaves each. Each loaf costs 25¢ to make. Past data have shown that this demand ranges from 36 to 96 loaves per day. A loaf sells for 40¢, and any bread left over at the end of the day is sold to a charitable kitchen for salvage price of 10¢/loaf. If demand exceeds supply, we assume that there is a lost-profit co of 15¢/loaf (because of loss of goodwill, loss of customers to competitors, and so on). The demand can be categorized into three types: high, average, and low with probabilities of .30 .45, and .25, respectively. The demand distribution is shown as in the table

Pierre's can bake the bread only in batches of a dozen loaves each. Each loaf costs 25¢ to make. Past data have shown that this demand ranges from 36 to 96 loaves per day. A loaf sells for 40¢, and any bread left over at the end of the day is sold to a charitable kitchen for salvage price of 10¢/loaf. If demand exceeds supply, we assume that there is a lost-profit co of 15¢/loaf (because of loss of goodwill, loss of customers to competitors, and so on). The demand can be categorized into three types: high, average, and low with probabilities of .30 .45, and .25, respectively. The demand distribution is shown as in the table

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

I need answer typing clear urjent no chatgpt used i will give upvotes full explanation
1– Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. You must have an excel file with formulas within the cell. 2. Gas & Go is considering offering movie rentals through a self-service company that would locate a machine on the inside of the market store. BlueBox would charge an annual lease fee of $500 for delivery, setup and maintenance, and there is an energy cost of $0.08 for every video rented. GreenFilms would charge an annual lease of only $400, but the energy cost for every video rental is $0.10 due to the larger size of the machine. Customers rent each movie for $1.00, regardless of the company, and the Gas & Go would earn 30% of that revenue for each rental. a. At what volume in number of rental transactions would the two options have the same cost?
Pls do fast its urgent.. i will give like for sure Solution must be in typed form. I need explain of this question with correct answer.
Ple
Miss Jones is a small business entrepreneur who cu rently does everything manually. She is the head chef at her small cook shop which has many loyal repeat customers. Her assistant helps with cooking as well as the paperwork. Miss Jones also employs someone to makes deliveries to customers. Customers order via telephone and everything is handwritten. There are various issues such as missing orders, receipts and customer contact information. Two stand- alone computers and a printer are in the office. One computer is not working due to a virus and the other is not connected to the printer so no printing can be done at this time. The assistant accidentally deleted all files on this second computer which therefore is not being used.
please answer in 30 minutes. its urgent.
A linear programming computer package is needed. Epsilon Airlines services predominately the eastern and southeastern United States. A vast majority of Epsilon's customers make reservations through Epsilon's website, but a small percentage of customers make reservations via phone. Epsilon employs call-center personnel to handle these reservations along with any problems with the website reservation system and for the rebooking of flights for customers if their plans change or their travel is disrupted. Staffing the call center appropriately is a challenge for Epsilon's management team. Having too many employees on hand is a waste of money, but having too few results in very poor customer service and the potential loss of customers. Epsilon analysts have estimated the minimum number of call-center employees needed by day of week for the upcoming vacation season (June, July, and the first two weeks of August). These estimates are given in the following table. Min s.t. Monday Tuesday…