Forecast Duff has experienced the following demand for Duff Swill, Duff Original, and Duff 200 for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Forecast Duff has experienced the following demand for Duff Swill, Duff Original, and Duff 200 for the last 8 years. Develop an adjusted exponential smoothing model (a = 0.30, B = 0.20) and a linear trend line model for all three variations of Duff Beer. Compare the MAD for each variation's forecast and choose an overall forecasting style that seems to be the most accurate. Demand (Barrels) Year Duff Swill Duff Original Duff 200 1 4789 4260 3000 2 4890 4510 3120 5100 4050 3370 4 5124 3720 2900 5199 3900 2987 6500 3470 1800 7 7345 2890 1785 8 8901 3100 1823 Quantity Discounts Regardless of the variation of Duff beer, Duff is always sold in a 12 oz can. Duff has been purchasing manufactured cans for each of its beers from the Aluminati at the quantity discount price below. However, after digging though the financials and connecting the dots, you are beginning to think the Aluminati may be a conspiracy. Recently you have contacted Aluminate who are eager for your business they have quoted you the competitive prices shown below. Use the forecast model previously chosen as the best predict sales for year 9 and order the appropriate number of cans. You may find the conversion chart handy 1 Barrel = 31 Gallons = 248 pints = 330 12 oz cans Quanity Aluninati Price Aluminate 500,000 - 999,999 0.75 0.7 1,000,000 - 1,999,999 0.67 0.62 2,000,000 - 2,999,999 0.59 0.54 3,000,000 - 3,999,999 0.51 0.46 4,000,000 - 4,999,999 0.43 0.44 5,000,000 - 5,999,999 0.35 0.4 6,000,000 - 6,999,999 0.27 0.27 7,000,000 - 7,999,999 0.19 0.19 8,000,000 8,999,999 9,000,000 9,999,999 0.11 0.11 0.03 0.03 Holding Cost per can $0.01 $0.02 Delivery Cost per trip $800 $780 Forecast Duff has experienced the following demand for Duff Swill, Duff Original, and Duff 200 for the last 8 years. Develop an adjusted exponential smoothing model (a = 0.30, B = 0.20) and a linear trend line model for all three variations of Duff Beer. Compare the MAD for each variation's forecast and choose an overall forecasting style that seems to be the most accurate. Demand (Barrels) Year Duff Swill Duff Original Duff 200 1 4789 4260 3000 2 4890 4510 3120 5100 4050 3370 4 5124 3720 2900 5199 3900 2987 6500 3470 1800 7 7345 2890 1785 8 8901 3100 1823 Quantity Discounts Regardless of the variation of Duff beer, Duff is always sold in a 12 oz can. Duff has been purchasing manufactured cans for each of its beers from the Aluminati at the quantity discount price below. However, after digging though the financials and connecting the dots, you are beginning to think the Aluminati may be a conspiracy. Recently you have contacted Aluminate who are eager for your business they have quoted you the competitive prices shown below. Use the forecast model previously chosen as the best predict sales for year 9 and order the appropriate number of cans. You may find the conversion chart handy 1 Barrel = 31 Gallons = 248 pints = 330 12 oz cans Quanity Aluninati Price Aluminate 500,000 - 999,999 0.75 0.7 1,000,000 - 1,999,999 0.67 0.62 2,000,000 - 2,999,999 0.59 0.54 3,000,000 - 3,999,999 0.51 0.46 4,000,000 - 4,999,999 0.43 0.44 5,000,000 - 5,999,999 0.35 0.4 6,000,000 - 6,999,999 0.27 0.27 7,000,000 - 7,999,999 0.19 0.19 8,000,000 8,999,999 9,000,000 9,999,999 0.11 0.11 0.03 0.03 Holding Cost per can $0.01 $0.02 Delivery Cost per trip $800 $780
Expert Answer:
Related Book For
Stats Data and Models
ISBN: 978-0321986498
4th edition
Authors: Richard D. De Veaux, Paul D. Velleman, David E. Bock
Posted Date:
Students also viewed these business communication questions
-
Is there any reason to think that SKI may be holding too much inventory? If so, how would that affect EVA and ROE?
-
Is there any reason to think that SKI may be holding too much inventory? If so, how would that affect EVA and ROE? Discuss.
-
Is there any reason to think that SKI may be holding too much inventory? If so, how would that affect EVA and ROE?
-
Draw a graph showing the marginal revenue (MR) and marginal cost (MC) of increasing the tax rate (t) in the Peltzman model of regulation represented by equation (19.1). Place the tax rate on the...
-
An individual contributes property with a FMV in excess of basis to a corporation in exchange for stock. The property is subject to a mortgage. In each of the following instances, determine the basis...
-
To find out whether a new serum will arrest leukemia, 9 patients, who have all reached an advanced stage of the disease, are selected. Five patients receive the treatment and four do not. The...
-
T. Christian Cooper was a partner to Sanders and Richard Campbell d/b/a The Mullen Company. In 2001, Cooper helped bring about a management agreement between The Mullen Co. and Newnan Crossing...
-
Consider a three- firm supply chain consisting of a retailer, manufacturer, and supplier. The retailers demand over an 8- week period was 100 units each of the first 2 weeks, 200 units each of the...
-
What is immediate, up-to-date information? What is Real-time systems Information governance?
-
Use Microsoft Visio or Visible Analyst to view and print the contextlevel data flow diagram for the computer inventory system as Chip and Anna did E2 Use the Repository feature or the Repository web...
-
Present and future values of $1 at 3% are presented below: FVA $1 PVA $1 FVAD $1 PVAD $1 PV $1 1.03000 0.97087 1.0000 0.97087 1.0300 1.00000 1.06090 0.94260 2.0300 1.91347 2.0909 1.97087 2.91347...
-
The U.S. government has provided billions of dollars for broadband Internet access nationwide, including grants for rural broadband access, expansion of computer center capacity, and sustainable...
-
How do conflicting views of market structure influence the ideas of classical and Keynesian macroeconomists regarding price and wage flexibility and how quickly the economy adjusts to long-run...
-
Consider the following variables: real GDP, consumer spending, investment, unemployment, inflation, stock prices, interest rates, and credit spreads. Classify each as procyclical, countercyclical, or...
-
The 2020 coronavirus crisis has been devastating. However, not all industries and not all firms have suffered. Some may have profited from these events. Why have some industries and some firms...
-
As a Chinese MNE executive working in the United States or an American MNE executive working in China in 2020, you feel that the host-country government officials and media have become noticeably...
-
1. Explain what would happen in the following markets given the following demand or supply shocks. In your answer clearly state what happened to supply or demand (whether it increased or decreased)...
-
Highland Theatre is owned by Finnean Ferguson. At June 30, 2014, the ledger showed the following: Cash, $6,000; Land, $100,000; Buildings, $80,000; Equipment, $25,000; Accounts Payable, $5,000;...
-
Most roller coasters get their speed by dropping down a steep initial incline, so it makes sense that the height of that drop might be related to the speed of the coaster. Here's a scatterplot of top...
-
A friend of yours claims to be psychic. You are skeptical. To test this you take a stack of 100 playing cards and have your friend try to identify the suit (hearts, diamonds, clubs, or spades),...
-
Weighing trucks One kind of scale for weighing trucks can measure their weight as they drive across a plate. Is this method consistent with the traditional method of static weighing? Are the...
-
The Milham Theatre Club has been in existence for a number of years. Members pay an annual subscription of 15 which entitles them to join trips to professional productions at a reduced rate. On 1...
-
The accounting records of the Happy Tickers Sports and Social Club are in a mess. You manage to find the following information to help you prepare the accounts for the year to 31 December 2015. (1)...
-
A business both buys loose tools and also makes some itself. The following data is available concerning the years ended 31 December 2014, 2015 and 2016. You are to draw up the Loose Tools Account for...
Study smarter with the SolutionInn App