Corresponding data table to find number of loaves to bake

Assignment Help Operation Management

Reference no: EM13899204

The owners of Good Taste, a bakery in Lewisburg, PA are attempting to determine how many loaves of their famous raisin bread to bake for the first day of the upcoming county fair. Company accounting records show that each loaf of raisin bread costs $1.30 to make. Good Taste plans to sell each loaf for $2.75. Unsold loaves can be sold on the county fair’s second day as “day-old” products. The owners plan to sell such loaves for $1.00 each. The bakery owners believe that the number of loaves they will sell on the county fair’s first day follows the probability distribution as provided in the file. Their goal in deciding how many loaves to bake is to maximize expected profit from these sales.

1) Develop an Excel simulation model in the attached shell.

2) Develop a corresponding data table to find the best number of loaves to bake.

Reference no: EM13899204

Questions Cloud

Nevertheless be maintained at previous levels : If the average amount of time a product goes without failing decreased by some amount, that product's availability could nevertheless be maintained at previous levels by __________ its __________.

There is qualitative notion in their estimates : Many experienced operations and project managers rely significantly on quantitative analysis to project future data. However, there is a “qualitative notion in their estimates. Define this notion and how would you use it in projecting future data?

Why so many projects do not achieve level of expectation : What do you think are the major causes of why so many projects do not achieve their level of expectation? If you are assigned a major project, what process would you put into place that might lead to success and why?

What could have been done better or more concisely : Find two websites from possible competitors to your company or organizations with a similar mission to yours. What are some particular things about this website that you admire? What could have been done better or more concisely? Could any of the inf..

Corresponding data table to find number of loaves to bake : The owners of Good Taste, a bakery in Lewisburg, PA are attempting to determine how many loaves of their famous raisin bread to bake for the first day of the upcoming county fair. Company accounting records show that each loaf of raisin bread costs $..

What is the wavelength of the x-rays used : X-rays of an unknown wavelength are diffracted by a gold sample. the 2theta angle was 64.582degrees for the {220} planes. What is the wavelength of the x-rays used? (The lattice constant of gold = 0.40788nm; assume first order diffraction, n=1.)

Examines for malcolm baldrige national quality award : In recent years, the Board of Examines for the Malcolm Baldrige National Quality Award has consisted of between __________ members from across the U.S.

What empirical data were used in their analysis : What have we learned from the events in Ferguson, MO? Discuss the U.S Department of Justice report and the finding of pervasive racial bias in the police department and the court system. What empirical data were used in their analysis? Did they use t..

Quality at the ritz-carlton hotel company : Ritz-Carlton . The name alone evokes images of luxury and quality. As the first hotel company to win the Malcolm Balrige National Quality Award, the Ritz treats quality as if it is the heartbeat of the company. This means a daily commitment to meetin..

User Account

All Pages