Following are the data on demand for white bread loaves at a bakery. Day 1 2...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Following are the data on demand for white bread loaves at a bakery. Day 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Period 5 6 7 8 8 a. Develop a linear trend equation for the above data on demand for white bread loaves at a bakery (use of Excel's Trendline, with display Equation on chart option, is recommended), and use it to forecast demand on day 16. (Round the final answers to 2 decimal places.) Y = 9 10 11 12 13 14 Loaves 195 213 219 225 230 Forecast demand on day 16 b. The variations around the linear trend line seem to have above- and below-the-line runs. Therefore, use trend-adjusted exponential smoothing with a = 0.4 and ß = 0.3 to model the bread demand. Use the first four days to estimate the smoothed initial trend that you use for periods 4 and 5 (use the increase from day 1 to day 4 divided by 3). Also, use A4 to estimate S4. Start forecasting day 5. What is the forecast for day 16? (Round the final answers to 2 decimal places.) 15 16 235 249 255 254 263 Forecast for day 16 278 278 281 289 314 TAFt Following are the data on demand for white bread loaves at a bakery. Day 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Period 5 6 7 8 8 a. Develop a linear trend equation for the above data on demand for white bread loaves at a bakery (use of Excel's Trendline, with display Equation on chart option, is recommended), and use it to forecast demand on day 16. (Round the final answers to 2 decimal places.) Y = 9 10 11 12 13 14 Loaves 195 213 219 225 230 Forecast demand on day 16 b. The variations around the linear trend line seem to have above- and below-the-line runs. Therefore, use trend-adjusted exponential smoothing with a = 0.4 and ß = 0.3 to model the bread demand. Use the first four days to estimate the smoothed initial trend that you use for periods 4 and 5 (use the increase from day 1 to day 4 divided by 3). Also, use A4 to estimate S4. Start forecasting day 5. What is the forecast for day 16? (Round the final answers to 2 decimal places.) 15 16 235 249 255 254 263 Forecast for day 16 278 278 281 289 314 TAFt
Expert Answer:
Answer rating: 100% (QA)
a To develop a linear trend equation for the given data on demand for white bread loaves you can use ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these general management questions
-
Zents Inc. produces and sells a single product. The selling price of the product is $240.00 per unit and its variable cost is $108.00 per unit. The fixed expense is $407,880 per month. The break-even...
-
On April 23, 2022, Protanica Company, a florist, purchased $112,000 of merchandise, terms were 3/15, n/45 from Botail Garden Center. Protanica returned $7,500 of damaged merchandise to Botail, which...
-
A manufacturer purchases a part for use at both of its plants-one at Roseville, California, the other at Akron, Ohio. The part is available in limited quantities from two suppliers. Each supplier has...
-
HL Co. uses the high-low method to derive a total cost formula. Using a range of units produced from 1,500 to 7,500, and a range of total costs from $21,000 to $45,000, producing 2,000 units will...
-
Use the differential equation approach to find i (t) 0 for t > 0 in the circuit in figure and plot the response including the time interval just prior to opening the switch. 2kN 12V t =0 3kN 3k0 6kN...
-
Discuss the advantages and disadvantages of sampling.
-
Plaintiffs operated a concession foods business called Festival Foods that provided food services at carnivals and festivals. The tangible assets of the business included a truck and servicing...
-
Chocolate Bars, Inc. (CBI), manufactures creamy deluxe chocolate candy bars. The firm has developed three distinct products: Almond Dream, Krispy Krackle, and Creamy Crunch. CBI is profitable, but...
-
1 Define Management? Explain its features, importance and nature? 2 Briefly explain about functions of management 3 Define leadership and explain leadership styles? 4 Briefly explain about decision...
-
Summarizes current non-GAAP reporting practices in the industry; TOYOTA VS HONDA Include tables or other appropriate visualizations that reflect information about your companies, including...
-
Suppose a business owner has a choice of 7 locations in which to establish her business, she decides to rank each location according to a certain criteria, such as price of the store and parking...
-
Once actual numbers from a physical inventory count are returned, what will the accounting department do with the information?
-
How should the broader area of impact measurement evolve? Should impact measurement, reporting and management become as rigorous as financial reporting and management? What should the relationship be...
-
Mid-latitude weather is largely influenced by processes that redistribute excess energy from the sub-tropics too higher latitudes. It is in the mid-latitudes that warm tropical air masses come in...
-
2. Prove that a binary tree with depth d has at most 2d leaves. 3. Lets say the following is the distribution of smokers in the population Smokes | Does not smoke | Total 0.18 0.49 0.14 0.51 0.32 1...
-
The Hamilton Company is using an automated bench lathe that cost $ 150,000 five years ago. Its current market value is only $20,000. The old lathe hed been straight line depreciated over a ten year...
-
You along with two of your friends are planning to open a beauty and cosmetic store at downtown Toronto. One of your friends has worked at Sephora for 10 years and has expertise in makeup techniques...
-
A survey of 70 college freshmen asked whether students planned to take biology, chemistry, or physics during their first year. Use the diagram to answer each question. How many of the surveyed...
-
Ann hires a nanny to watch her two children while she works at a local hospital. She pays the 19-year-old nanny $125 per week for 48 weeks during the current year. a. What is the employer's portion...
-
John Fuji (age 37) moved from California to Washington in December 2011. He lives at 468 Cameo Street, Yakima, WA 98901. John's Social Security number is 571-78-5974 and he is single. His earnings...
-
Diego, age 28, married Dolores, age 27, in 2012. Their salaries for the year amounted to $46,479 and they had interest income of $3,500. Diego and Dolores' deductions for adjusted gross income...
-
Consider absence from work as an example of organizational behaviour. What are some of the factors that might predict who is likely to be absent from work? How might you explain absence from work?...
-
Do you think that organizations should base their hiring decisions on applicants personalities? What are the advantages and disadvantages of doing this? If an organization were to do this, what...
-
Use the contingency approach to describe a task or an organizational department where a more classical management style might be effective. Then do the same for a task or department where the human...
Study smarter with the SolutionInn App