Eagle Stores is a retailer of office supplies. The monthly retail demand for a product is...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Eagle Stores is a retailer of office supplies. The monthly retail demand for a product is provided below from January 2015 to October 2016. DEMAND DATA Year Month 2015 2016 January 616 758 February 832 974 March 898 940 April 964 1106 May 880 1072 June 1016 988 July August 912 1004 828 870 September 894 1036 October 850 1018 November 1010 December 969 a. Use the naïve method to forecast the demand for November and December 2016. b. Use the moving average method with 5 periods to forecast the demand for November and December 2016. c. Use the exponential smoothing method with smoothing constant 0.8 to forecast the demand for November and December 2016. Initialize the forecasting method using the actual demand in January 2015. d. Fit a trend line to the demand data from January 2015 to December 2015. What is the trend line equation? e. What is the forecasted demand for November and December 2016 if you use this trend line equation? f. How reliable is this forecast from a statistical perspective? g. Compute the MAD of the trend line method used in part (d). Use the forecasts from January 2016 to October 2016 to compute the MAD of the method. h. What is the interpretation of MAD? i. Explain clearly why it is important to compute and track forecast accuracy. Eagle Stores is a retailer of office supplies. The monthly retail demand for a product is provided below from January 2015 to October 2016. DEMAND DATA Year Month 2015 2016 January 616 758 February 832 974 March 898 940 April 964 1106 May 880 1072 June 1016 988 July August 912 1004 828 870 September 894 1036 October 850 1018 November 1010 December 969 a. Use the naïve method to forecast the demand for November and December 2016. b. Use the moving average method with 5 periods to forecast the demand for November and December 2016. c. Use the exponential smoothing method with smoothing constant 0.8 to forecast the demand for November and December 2016. Initialize the forecasting method using the actual demand in January 2015. d. Fit a trend line to the demand data from January 2015 to December 2015. What is the trend line equation? e. What is the forecasted demand for November and December 2016 if you use this trend line equation? f. How reliable is this forecast from a statistical perspective? g. Compute the MAD of the trend line method used in part (d). Use the forecasts from January 2016 to October 2016 to compute the MAD of the method. h. What is the interpretation of MAD? i. Explain clearly why it is important to compute and track forecast accuracy.
Expert Answer:
Answer rating: 100% (QA)
a Forecast of Nov 10201056 x 1020 985Forecast of Dec 9851020 x 985 951 b MA4 forecast for Nov 1004870105610204 9875MA4 forecast for Dec 9875 flat fore... View the full answer
Related Book For
Introduction to Management Science A Modeling and Cases Studies Approach with Spreadsheets
ISBN: 978-0078024061
5th edition
Authors: Frederick S. Hillier, Mark S. Hillier
Posted Date:
Students also viewed these marketing questions
-
a. Mark first asks you to forecast daily demand for the next week using the data from the past 13 weeks. You should make the forecasts for all the days of the next week now (at the end of week 5),...
-
Punjab Company reported the following information for November and December 2014. Punjabs ending inventory at December 31 was destroyed in a fire. Instructions (a) Compute the gross profit rate for...
-
Brenda Company reported the following information for November and December 2014. Brendas ending inventory at December 31 was destroyed in a fire. Instructions (a) Compute the gross profit rate for...
-
A group of investors is considering buying the Wheelwright Corporation, but does not want to contribute to the companys financial support after the purchase. Wheelwrights management has offered the...
-
Using photo coordinates for points 4 and GYM on image 5, determine the scale of the photo.
-
Discuss the similarities and differences between Lp metric and AHP for ranking suppliers.
-
In what ways did the social-person and human relations approach influence management?
-
1. How many wheels sets should the manager order? 2. When should the wheel sets be ordered? Promotional Novelties provides a wide range of novelty items for its corporate customers. It has just...
-
Compare and contrast the way that KAMs are disclosed within and between audit firms. Document Preview: 22 December 2017 Company Announcements Office Australian Securities Exchange Limited Exchange...
-
You are buying a new car for $30,000 plus 5% taxes for a total cost of $31,500. You can pay cash for the entire amount by writing a check from your money market deposit account at the bank that...
-
Greenville Industries uses the accrual basis to account for all sales transactions. Sales for 2018 total $ 510, 000. Included in this amount is $ 55, 000 in receivables from sales on installment....
-
Advise BS on the income tax implications of the above. Fully explain your advice by reference to tax legislation, tax cases and tax principles.? BS owns a residential rental property (house) in the...
-
You are provided with a sample containing calcium carbonate and calcium oxide. The sample was analysed using thermoanalytical technique. Initial mass was found to be 160.5mg and the final mass was...
-
A car tire has a pressure of 37.0 psi at 30C. If the temperature drops to -5.0C, what is the pressure of the tire (in psi)? Assume the volume of tire is constant. fill in blank No Units in answer....
-
What are the three principal means of controlling metabolic reactions? 2. What did you find difficult or challenging from the roading?
-
Calculate the mass in grams of NaCl in a sample containing 1 . 1 moles ( MW NaCL 5 8 . 4 4 gmol - 1 )
-
8. If non-uniform quantization is to be implemented using the u- law with = 5. For an 8-bit quantizer, how many levels in total (approximately) are going to represent the signal for -40% to 40% of...
-
Draw and label the E and Z isomers for each of the following compounds: 1. CH3CH2CH==CHCH3 2. 3. 4. CH,CH2C CHCH2CH Cl CH3CH2CH2CH2 CH CH2CCCH2CI CHCH3 CH3 HOCH CH CCC CH O-CH C(CH
-
Do Problem 2.17 by using the Graphical Linear Programming and Sensitivity Analysis module in your Interactive Management Science Modules?
-
Ralph Edmund loves steaks and potatoes. Therefore, he has decided to go on a steady diet of only these two foods (plus some liquids and vitamin supplements) for all his meals. Ralph realizes that...
-
Read the referenced article that fully describes the management science study summarized in the application vignette presented in Section 11.6. Briefly describe how a queueing model was applied in...
-
Mirandas Motor Mechanics analysed the accounting records and other data for the business. The following information is made available for the year ended 30 June 2019. 1. Salaries and wages owing to...
-
The unadjusted trial balance of the general ledger of Antonios Small Appliance Repair Service on 30 June 2019 is presented below (ignore GST). Additional data for adjustment purposes 1. Supplies on...
-
The unadjusted trial balance of Helenas Hire Cars is shown below (ignore GST). Additional information 1. Petrol purchased on credit for $680 and used during the last week in June has not been paid...
Study smarter with the SolutionInn App