(a) The Marino Company in Ventura County, southern California sells swimming pool equipment. The sales for swimming pool motors in southern California over the last 12 months is given in Table Q4(a). Forecast the demand from March to December of the current year using the following forecasting models. Use excel for the tabulation. (1) Three-month simple moving average; (i)Three-month weighted moving average. Use 0.7, 0.2, and 0.1 for the weights, with 0.7 for the most recent period, and 0.1 for the oldest period. (ii) Simple linear regression; (iv) Determine the MAD, and SE for all the models, and choose which model is most appropriate. Table Q4(a) Marino Company Sales of Swimming pool motors Quantity (units) 11,596 Month January February March 14,438 16,861 10,002 April May 15,106 June 17,941 July August September October 11,877 14,290 17,363 12,430 14,858 November December 16,833

(a) The Marino Company in Ventura County, southern California sells swimming pool equipment. The sales for swimming pool motors in southern California over the last 12 months is given in Table Q4(a). Forecast the demand from March to December of the current year using the following forecasting models. Use excel for the tabulation. (1) Three-month simple moving average; (i)Three-month weighted moving average. Use 0.7, 0.2, and 0.1 for the weights, with 0.7 for the most recent period, and 0.1 for the oldest period. (ii) Simple linear regression; (iv) Determine the MAD, and SE for all the models, and choose which model is most appropriate. Table Q4(a) Marino Company Sales of Swimming pool motors Quantity (units) 11,596 Month January February March 14,438 16,861 10,002 April May 15,106 June 17,941 July August September October 11,877 14,290 17,363 12,430 14,858 November December 16,833

Linear Algebra: A Modern Introduction

4th Edition

ISBN:9781285463247

Author:David Poole

Publisher:David Poole

Chapter7: Distance And Approximation

Section7.3: Least Squares Approximation

Problem 31EQ

See similar textbooks

Similar questions

The customer demand for a particular smart phone during Year 0 to Year 5 is given as 1,056,000, 1,032,000, 1,093,000, 1,024,000, 1,066,000, and 1,072,000. Using the Holt forecasting model with trend, what is the forecasted demand in year 10, where w = 0.4 and v = 0.5?a) 1,071,874b) 1,075,573c) 1,077,488d) 1,083,816
Compare the primary types of forecasting methods used to determine demand.
The LawnPlus Fertilizer Company distributes fertilizer tovarious lawn and garden shops. The company must base itsquarterly production schedule on a forecast of how manytons of fertilizer will be demanded from it. The companyhas gathered the following data for the past three yearsfrom its sales records. a. Compute a three-quarter moving average forecast forquarters 4 through 13 and compute the forecast errorfor each quarter.b. Compute a five-quarter moving average forecast forquarters 6 through 13 and compute the forecast errorfor each quarter.c. Compute a weighted three-quarter moving averageforecast using weights of 0.50, 0.33, and 0.17 for the most recent, next recent, and most distant data, respec-tively, and compute the forecast error for each quarter. d. Compare the forecasts developed in parts (a), (b), and(c) using cumulative error. Which forecast appears tobe most accurate? Do any exhibit any bias?
The problem is based on the following data given. Observations of the demand for a certain part stocked at a parts supply depot during the calendar year 2013 were ( as shown ). Using a four-month moving average, determine the two-step-ahead forecast for July through December 2013. (Hint: The two-step-ahead forecast for July is based on the observed demands in February through May.)
The Badrutt’s Palace Hotel St. Moritz which is one of the best Alpine hotels in Switzerland has provided you with their quarterly bookings data over the last 6 years as follows: Year Quarter-1 (Demand in units) Quarter-2 (Demand in units) Quarter-3 (Demand in units) Quarter-4 (Demand in units) 2018 45,000 22,000 64,000 33,000 2019 48,000 27,000 74,000 41,000 2020 52,000 32,000 83,000 46,000 2021 57,000 35,000 94,000 52,000 2022 61,000 42,000 104,000 56,000 2023 67,000 49,000 120,000 61,000 Required: i) Calculate the seasonal indices for each season using multiplicative index ii) Forecast the demand for each season of the year 2024 given that the annual demand forecast is 324,000 units. iii) Deseasonalize the actual demand data (2018-2023) above using the seasonal indices obtained in (a) above. iv) Generate OLS equation using the Deseasonalized data in (iii) above (in thousand units)
Sales of industrial vacuum cleaners at Yarena Supply CO. over the past 13 months are as follows: Sales in P1,000 Month Sales in P1,000 Month 11 January 14 August 14 February 17 September 15 March 12 October 10 April 14 November 15 May 16 December 17 June 11 January 11 July Using a moving average with three periods, determine the demand for vacuum cleaners for next February?
Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table: YEAR DEMAND FOR FERTILIZER (1,000S OF BAGS) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15 a) Develop a trend line for the demand for fertilizer using any computer software? b) For these three forecasts, 3-year moving average, a weighted moving average, and a trend line, which one would you use? Explain your answer?
If a researcher wants to find out the average monthly expenses of all university students in Edmonton, this average would be an example of ________ . a. samplecross out b. statisticcross out c. populationcross out d. parameter
An auctioneer of antique Iranian rugs kept records of his weekly auctions in order to determine the relationships among price, age of carpet or rug, number of people attending the auction, and the number of times the winning bidder had previously attended his auctions. He felt that, with this information, he could plan his auctions better, serve his steady customers better, and make a higher overall profit for himself. The results shown in the accompanying table were obtained.
Find out the next month after april income by using the forecasting method of the moving average method
The following information has been supplied by the Sales department of an IT company in Dublin (sales are in units). Year Period Sales 2010 Q1 100 Q2 125 Q3 127 Q4 102 2011 Q1 104 Q2 128 Q3 130 Q4 107 2012 Q1 110 Q2 131 Q3 133 Q4 107 2013 Q1 109 Q2 132 Q3 135 Q4 105 The three-period moving average for the third quarter of 2012 (rounded off to two decimals) is: A. 115.75 B. 131.00 C. 123.66 D. 124.67
Floyd Distributors, Inc., provides a variety of auto parts to small local garages. Floyd purchases parts from manufacturers according to the EOQ model and then ships the parts from a regional warehouse direct to its customers. For a particular type of muffler, Floyd's EOQ analysis recommends orders with Q* = 20 to satisfy an annual demand of 180 mufflers. Floyd's has 250 working days per year, and the lead time averages 15 days.Note: Use Appendix B to identify the areas for the standard normal distribution. What is the reorder point if Floyd assumes a constant demand rate? If required, round your answer up to the nearest whole number. r = fill in the blank 1 Suppose that an analysis of Floyd's muffler demand shows that the lead-time demand follows a normal probability distribution with µ = 12 and σ = 2.2. If Floyd's management can tolerate one stock-out per year, what is the revised reorder point? If required, round your answer up to the nearest whole number. r = fill in the blank…