Determine best baking quantity to maximize profit

Assignment Help Operation Management

Reference no: EM131673537

A local baker sells fresh fruit pastries at the farmer's market every Saturday. The baker wants to establish a consistent baking policy to simplify planning for each weekend. Demand for the pastries is uncertain, but average sales have been about 200 pastries, with a standard deviation of 25 pastries.

At the farmer's market, the pastries sell for $4.00 each. If there are pastries leftover after the market closes, a local coffee shop may buy some of the leftover pastries for $1.60 each for resale in their shop. How many pastries the coffee shop will take is uncertain, and depends on their anticipated demands. There is a 30% chance the coffee shop will accept a maximum of 50 leftover pastries, a 40% chance that they will accept a maximum of 20 leftover pastries, a 20% chance that they will accept a maximum of 10 pastries, and a 10% chance they will not accept any pastries. If there are more pastries leftover than what the coffee shop will accept, they will be donated to a local food pantry and there will be no additional revenues from those pastries.

The production cost of a batch of pastries is $20.00. There are a dozen pastries per batch.

The farmer's market is full of competition and the baker will lose customers if he is unable to meet demand. He views this as a cost of lost profit, and will assume a loss of $1.00 per unit of unmet demand.

Compare baking policies from 15 batches to 24 batches. Run 1000 iterations of the model.

Analyze your results to determine the best baking quantity to maximize profit.

Questions:

1- Please provide the Simulation Modeling with all necessary inputs and decisions (Decision, Uncertainty and Output). Show the formulas and calculations used.

2- Make the following changes and show formula with calculations:

Set the Number of Batches produced to 15

Set the Farmer's Market Demand to 200

Set the Coffee Shop Demand to 10

What is the cost of lost profits under these conditions?

What is the total profit with these settings?

What is the total production cost with these settings?

What is the total revenue with these settings?

3 - Make the following changes and show formula with calculations:

Set the Number of Batches produced to 18

Set the Farmer's Market Demand to 200

Set the Coffee Shop Demand to 10

What is the revenue from the coffee shop with these settings?

4- After analyzing the results of your simulation, which baking policy would you recommend and why?

Reference no: EM131673537

Questions Cloud

Explain how response bias influences the outcomes of a study : Explain why measures of dispersion and measures of central tendencies are important when doing data analysis and interpretation in an experimental study.

Explain the difference between a one- and a two-tail test : Explain the difference between a one- and a two-tail test. When is each used - Did we show beyond a reasonable doubt that Dusty was not telling the truth

Describe how the talent pipeline offers the best candidates : Describe how the talent pipeline offers the best candidates to organizations, and determine how to access the pipeline for your industry or profession.

What is the variable rate for airplane depreciation : High-Low Method, Cost Formulas Refer to the information for Fly High Airlines above. Use the high-low method to answer the following questions.

Determine best baking quantity to maximize profit : Analyze your results to determine the best baking quantity to maximize profit. What is the cost of lost profits under these conditions?

Do you believe one technique is better than the other : Do you believe one technique is better than the other? Why or why How would you employ this technique within your organization? What changes would you adopt?

Develop annual cost formulas for airplane depreciation : Changing the Cost Formula for a Month to the Cost Formula for a Year Refer to the information for Fly High Airlines above.

What is the method of least squares : Method of Least Squares, Developing and Using the Cost Formula The method of least squares was used to develop a cost equation to predict the cost of receiving.

Develop talent within your current or former organization : Describe three effective ways to develop talent within your current or former organization and how they would support the organization's goals.

User Account

All Pages