Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 Problem Sarah owns a bakery in Georgetown that specializes in selling fresh bread. She purchases bread from a supplier at $2 per loaf

image

1 Problem Sarah owns a bakery in Georgetown that specializes in selling fresh bread. She purchases bread from a supplier at $2 per loaf and sells it at $4 per loaf. Any unsold bread at the end of the day is donated to a charity, incurring a fixed cost of $30 for transferring, irrespective of the number of unsold loaves. Sarah estimates that the demand for bread each day is a random variable following a uniform distribution ranging from 100 to 140 loaves. Given that Sarah orders 130 loaves on a Monday, answer the following questions: (i) What is the average daily demand for bread? (1 mark) (ii) How many loaves will be sold on Monday? (1 mark) (iii) How many loaves will be left over at the end of Monday's working hours? (1 mark) (iv) What will be the total profit for Monday? (1 mark) 2 Simulation Simulate the problem in Microsoft Excel 1000 times and answer the following questions. (i) What will be the average demand on Monday? (1 mark) (ii) On average, how many loaves will be sold on Monday? (1 mark) (iii) What will be the average number of leftover loaves at the end of Monday's working hours? (1 mark) (iv) What will be the average profit on Monday? (1 mark) (v) What is the minimum possible profit value, in the worst-case scenario, in June? (1 mark) (vi) What is the maximum possible profit value, in the best-case scenario, in June? (1 mark)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quality Inspired Management The Key to Sustainability

Authors: Harold Aikens

1st edition

131197568, 978-0131197565

More Books

Students also viewed these General Management questions

Question

How many degrees of freedom does ????e have?

Answered: 1 week ago

Question

CL I P COL Astro- L(1-cas0) Lsing *A=2 L sin(0/2)

Answered: 1 week ago