Calculate the bakery total monthly profit

Reference no: EM131064971

Put key concepts in formulating the problem for Monte Carlo simulation, developing the layout, using appropriate formulas for creating demand distribution, preparing data tables, and using Excel simulation for the specified number of iterations, finding solutions, and correctly interpreting outputs to answer the questions asked.

Your analysis of the questions posed must demonstrate an excellent understanding of the use and limitations of Monte Carlo Simulation.

1. Chelsea Truman sells celebrity magazines on Sunday morning in an area surrounded by three busy shopping centers. Demand for the magazines is distributed as shown in the following table:

DEMAND	PROBABILITY
50	0.05
75	0.10
100	0.25
125	0.30
150	0.20
175	0.10

Chelsea has decided to order 100 magazines from her supplier. Chelsea pays $2 for each magazine she orders and sells each magazine for $3. Unsold magazines can be returned to the supplier for $0.75.

(a) Simulate 1 year (52 Sundays) of operation to calculate Chelsea's total yearly profit. Replicate this calculation N times. What is the average yearly profit?

(b) Chelsea would like to investigate the profit ability of ordering 50, 100, 150, and 175 magazines at the start of each Sunday. Which order quantity would you recommend? Why?

2. The Paris Bakery has decided to bake 30 batches of its famous beignets at the beginning of the day. The store has determined that daily demand will follow the distribution shown in the following table:

DAILY DEMAND	PROBABILITY
15	0.08
20	0.12
25	0.25
30	0.20
35	0.20
40	0.15

Each batch costs the Paris Bakery $50 and can be sold for $100. The Paris Bakery can sell any unsold batches for $25 the next day.

(a) Simulate 1 month (25 days) of operation to calculate the bakery's total monthly profit. Replicate this calculation N times to compute the average total monthly profit.

(b) The Paris Bakery would like to investigate the profitability of baking 25, 30, 35, or 40 batches at the start of the day. Which quantity would you recommend? Why?

Reference no: EM131064971

Questions Cloud

Determine the coordinates and of the centroid c of area : Determine the coordinates and of the centroid C of the area shown in the figure.

Prepare the adjusting journal entries necessary : Sally's rice is unable to reconcile the bank balance at January 31. Sally's reconciliation is shown here. What is the proper adjusted cash balance per bank? What is the proper adjusted cash balance per books?

Determine the moment of inertia ix of a triangle : Determine the moment of inertia Ix of a triangle of base b and altitude h with respect to its base (see Case 4, Appendix D).

Balance sheets reveals an increase in accounts receivable : A) Peach Computer reports net income of $158,000. Included in net income is a gain on the sale of land of $16,500.

Calculate the bakery total monthly profit : Simulate 1 month (25 days) of operation to calculate the bakery's total monthly profit. Replicate this calculation N times to compute the average total monthly profit

Order to maintain this production capability : In 2016, Jeremy's Maple Syrup (JMS) Conglomerate had Net Income of $350,000 and cash provided by operating activities of $250,000, including a S 12,000 net cash outflow for interest payments.

Determine the moment of inertia ibb of a trapezoid : Determine the moment of inertia IBB of a trapezoid having bases a and b and altitude h with respect to its base (see Case 8, Appendix D).

Write the executive summary for the security policy : Choose a company for this project and consider the initial steps in creating a security policy. Develop security goals and components that make up a quality Executive Summary.

Calculate the return and risk of a two asset portfolio : Calculate the return and risk of a two asset portfolio. Asset 1 has an annualized expected real return of 5.5% and a weight of 35% in the portfolio. Asset 2 has an annualized expected real rate of return of 2.0% and a weight of 40% in the portfolio.

User Account

All Pages