Barbara's Commercial Bakery (BCB) has been in business for quite a few years and has a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Barbara's Commercial Bakery (BCB) has been in business for quite a few years and has a sterling reputation for their sourdough bread. They sell the bread in lots of 12 to both wholesalers and retailers. Fearing they may run into some shortages of key ingredients due to supply chain issues, they wanted to be able to get a handle on their "expected monthly demand." This would allow them to get a better handle on ingredient purchases. BCB has always kept copious records so they were able to produce the last five years of demand. DEMAND FREQUENCY PROBABILITY 3/60 = 0.05 9/60 0.15 500 3 520 9 540 15 560 18 580 9 600 6 60 MONTHS 1.00 15/60-0.25 18/60-0.30 9/60-0,15 6/60-0.10 Based on these numbers, Barbara was able to manually calculate an "expected monthly demand" of dozen loaves. But Barbara, who only recently completed her undergraduate degree, knew that these probability values reflect only the "long term behavior. In the "short term" the occurrence of demand could be quite different from these probability vales. So she needed a concept that in the "short term" generated values that do not exhibit any certain pattern but in the "long term" conform exactly to the required probability distribution. She knew that these issue could be addressed with the use of RANDOM NUMBERS. Barbara did not have to buy expensive software as she remembered Excel could handle this. She started by establishing a "cumulative probability" that would be associated with a demand quantity and a random number range. When she got a random number in a certain range that would designate the demand for the month. She then remembered another Excel function that could tie this process together, LOOKUP FUNCTION. She dug out some class notes and was able to get to the textbook companion website and bring up file 10-1. She simply deleted what was in there and put her own numbers in. She now had her "simulated monthly demand." Having gone this far Barbara now realized that it would not be much of an additional step to use the simulated monthly demand to see what her profit would be. She remembered it being called "Expected Profit Simulation." To her five year demand history, a couple of other inputs were necessary to proceed. Based on competitive pricing and other market issues, Barbara estimated the average selling price of a dozen loaves to be between $40 and $60 as the cost of ingredients varies. Knowing this she estimates her profit margin to be between 20% and 30% per dozen loaves. Her fixed cost of stocking and selling the bread is $3000 per month. She now feels she has enough to "simulate" her average profit per month. 1. What is BCB's "expected monthly demand?" 2. What is the "simulated monthly demand" and what is the "random number" that generated it? (send the file) 3. On your single replication, what is your demand, selling price and profit margin? (send the file) 4. If you did 200 replications, what would be your average monthly profit? (would be on same file as number three) Barbara's Commercial Bakery (BCB) has been in business for quite a few years and has a sterling reputation for their sourdough bread. They sell the bread in lots of 12 to both wholesalers and retailers. Fearing they may run into some shortages of key ingredients due to supply chain issues, they wanted to be able to get a handle on their "expected monthly demand." This would allow them to get a better handle on ingredient purchases. BCB has always kept copious records so they were able to produce the last five years of demand. DEMAND FREQUENCY PROBABILITY 3/60 = 0.05 9/60 0.15 500 3 520 9 540 15 560 18 580 9 600 6 60 MONTHS 1.00 15/60-0.25 18/60-0.30 9/60-0,15 6/60-0.10 Based on these numbers, Barbara was able to manually calculate an "expected monthly demand" of dozen loaves. But Barbara, who only recently completed her undergraduate degree, knew that these probability values reflect only the "long term behavior. In the "short term" the occurrence of demand could be quite different from these probability vales. So she needed a concept that in the "short term" generated values that do not exhibit any certain pattern but in the "long term" conform exactly to the required probability distribution. She knew that these issue could be addressed with the use of RANDOM NUMBERS. Barbara did not have to buy expensive software as she remembered Excel could handle this. She started by establishing a "cumulative probability" that would be associated with a demand quantity and a random number range. When she got a random number in a certain range that would designate the demand for the month. She then remembered another Excel function that could tie this process together, LOOKUP FUNCTION. She dug out some class notes and was able to get to the textbook companion website and bring up file 10-1. She simply deleted what was in there and put her own numbers in. She now had her "simulated monthly demand." Having gone this far Barbara now realized that it would not be much of an additional step to use the simulated monthly demand to see what her profit would be. She remembered it being called "Expected Profit Simulation." To her five year demand history, a couple of other inputs were necessary to proceed. Based on competitive pricing and other market issues, Barbara estimated the average selling price of a dozen loaves to be between $40 and $60 as the cost of ingredients varies. Knowing this she estimates her profit margin to be between 20% and 30% per dozen loaves. Her fixed cost of stocking and selling the bread is $3000 per month. She now feels she has enough to "simulate" her average profit per month. 1. What is BCB's "expected monthly demand?" 2. What is the "simulated monthly demand" and what is the "random number" that generated it? (send the file) 3. On your single replication, what is your demand, selling price and profit margin? (send the file) 4. If you did 200 replications, what would be your average monthly profit? (would be on same file as number three)
Expert Answer:
Answer rating: 100% (QA)
Facts to consider 1 NoBugs Corporation is the only producer of chips meeting Sterlings high specific... View the full answer
Related Book For
Posted Date:
Students also viewed these general management questions
-
Do you think the insolvency of Social Security can occur sooner as the result of the COVID-19 pandemic?
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Case: Getting it Right at Anns Baking World Concepts to consider in analysis: Human Resource Management | HRM Planning | Diversity | Organization Culture | Recruitment and Selection | Compensation |...
-
Write balanced equations based on the information given. (a) Solid magnesium + oxygen gas solid magnesium oxide (b) Nitrogen monoxide gas + oxygen gas nitrogen dioxide gas (c) Gaseous ethane(C2H6)...
-
The British government has stepped up its information campaign regarding foot and mouth disease by mailing brochures to farmers around the country. It is estimated that 99% of Scottish farmers who...
-
Light has a wavelength of 340.0 nm and a frequency of 5.403 Ã 1014 Hz when traveling through a certain substance. What substance from Table 26.1 could this be? Show your calculations. Table...
-
A uniform flow of \(110,000 \mathrm{ft}^{3} / \mathrm{s}\) is measured in a natural channel that is approximately rectangular in shape with a \(2650-\mathrm{ft}\) width and \(17.5-\mathrm{ft}\)...
-
Scripps Health is a long-standing and prominent nonprofit health-based organization that is based in the greater San Diego area. The organization experienced a severe financial downturn that led to...
-
Discuss the principles of process intensification (PI) and its role in achieving sustainable and efficient chemical processing, focusing on the reduction of equipment size, energy consumption, and...
-
Consider an individual whose preferences are defined over bundles of non-negative amounts of each of two commodities. Suppose that this individual's preferences can be represented by a utility...
-
1. There are many tools for evaluating entrepreneurial opportunities. Any tool needs to address three critical issues. Discuss the three critical issues. 2. Discuss the framework for evaluating...
-
Consider an agent whose behavior is best described by expected utility. Calculate the value of the following prospect for the agent, assuming u(x) =x and initial wealth w = 1000 Payoff Probability...
-
C. Home Insert Draw Page Layout X n AutoSave Paste C21 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 A Hours Worked Pay Rate...
-
3. The following diagram shows the domestic demand and supply curves for sunglasses. Assume that the world price for sunglasses is $10 per unit. 60 55- 50 45- 40 35 30 25 20 15 10 5 200 400 Supply...
-
When Olga Shapiro mentioned that the financial statements were materially misstated, what kind of opinion was this?
-
An economist estimated the learning curve for the production of Tesla vehicles to be: AC = 433,094*N -0.135 where AC = average production cost and N = cumulative production. Data used was annual....
-
14. A box contains 5 red balls, 8 white balls and 7 black balls. If one ball is selected at random, calculate the probability that is white or black.
-
If the joint cost function for two products is C(x, y) = xy2 + 1 dollars (a) Find the marginal cost (function) with respect to x. (b) Find the marginal cost with respect to y.
-
What is the difference between organizational structure and design?
-
What goals would be most likely to improve your learning and performance in an organizational behavior class?
-
What impact do different occupations have of the stress levels of workers in those jobs?
-
To correct the vision of a near-sighted patient, an optician needs to make a pair of eyeglasses using -3.0-diopter lenses. The lenses are plano-concave, and the front surface (that is, the surface...
-
A lens has an index of refraction of 1. 50 . Its left side curves outward with an absolute value of radius of curvature of \(0.15 \mathrm{~m}\), and its right side curves inward with an absolute...
-
You have a thin lens that is convex on both surfaces. The material of which the lens is made has index of refraction \(n=1.40\), and the radii of curvature are \(\left|R_{1} ight|=300 \mathrm{~mm}\)...
Study smarter with the SolutionInn App