1 Problem Sarah owns a bakery in Georgetown that specializes in selling fresh bread. She purchases...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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) 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)
Expert Answer:
Related Book For
Quality Inspired Management The Key to Sustainability
ISBN: 978-0131197565
1st edition
Authors: Harold Aikens
Posted Date:
Students also viewed these general management questions
-
In terms of the inovice that has been received the recording clerk of AD should check for the price, terms and account details on the invoice against which document?
-
14. Discuss and identify if the following hypothetical scenarios meet the definition of a budget variance keeping in mind what the definition of a budget variance is (see above under definitions): 1....
-
The difference between case law and common is which of the following? O Common law creates law and case law interprets existing law. There is no difference. Case law is criminal law and common law is...
-
Kramer began operations early in 2012 and made the following purchases: February 5..................200.................$5 June 10......................500...................6 October...
-
Below is a graph of f(x). Use this graph to find the following derivative values. (Enter 'DNE' if the derivative does not exist.) (click on graph to enlarge) a. f'(-2.5) = b. f'(0) = c. f'(1) = d....
-
An independent auditor has completed substantive tests of balance sheet and income statement accounts, and now plans to begin procedures designed to determine whether there are any loss contingencies...
-
The following account appears in the ledger prior to recognizing the jobs completed in June: Work in Process Balance, June 1 .......... $ 40,000 Direct materials .......... 270,000 Direct labor...
-
Selected financial data regarding current assets and current liabilities for ACME Corporation and Wayne Enterprises, are as follows: ($ in millions) S ACME Corporation Wayne Enterprises Current...
-
Identifytwo (2) additional needs or barriers to participation related to each of the five areas stated; Behavioural or psychological disorders Child at risk of harm Family circumstances and needs,...
-
When the following loop is executed: for (i=0;i <10;i++) d = fun(i); what is the earliest itera- tion that can start triggering "Segmentation fault (core dumped)" when compiled without stack protec-...
-
On April 3, trader M, SHORTED two (2) gasoline futures for delivery month May for the market price of cents67.85/gallon. There are 42,000 gallons in one futures. The required initial and maintenance...
-
We were Bang Quay's coworkers. Words may not be Adequate to express how sorry we feel. Please accept our heartfelt sympathies on the loss of your love one." The following Information pertains to...
-
What should include in the tax return, explaination for all the items? Car Costs Seymour Description - Subaru, cost = $35,000, bought 2015-02-15 January 1 odometer December 31 odometer Business...
-
You have been asked to value a project on behalf of a large IT infrastructure company. The company has provided the following information (assume all cash flows are in ZAR millions): Peers Year...
-
how do you plot the graphs in part b and how to do part c? In March 2008, Tom Lafontaine, CEO of Avalanche Logistics, a trucking company, was evaluating a new proposal that would require substantial...
-
Firm M's earnings and stock price tend to move up and down with other firms in the S&P 500, while Firm W's earnings and stock price move counter cyclically with M and other S&P companies. Both M and...
-
How do network effects help Facebook fend off smaller social-networking rivals? Could an online retailer doing half as much business compete on an equal footing with Amazon in terms of costs? Explain.
-
The following measurements were collected hourly from two production processes. a. Construct a run chart for each of the processes. b. What can you conclude from the pattern of points on these two...
-
Is lean production a requirement for achieving third-generation quality? Can lean production be implemented in a push scheduling environment?
-
How does a team differ from a club (e.g., a service club like Rotary)? How does a team differ from a committee? Explain.
-
An annealing furnace has a belt that moves material in at a specific velocity, \(U\) (Figure P10.34). Only the region inside the oven is heated and the material sees a radiant heat flux of...
-
As a biochemical engineer you are evaluating a drug delivery system for an artificial protein to combat Alzheimer's. The protein is very large (200,000 molecular weight) and bulky and is sensitive to...
-
Consider the mass transfer example concerning diffusion into a falling film shown in Figure P10.38. A new inventor claims that he can rig the device to operate such that the flux of \(a\) from the...
Study smarter with the SolutionInn App