by X company is given below. sdund Forecast the demand for the pumps for the next three years. Year 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 42 39 Sales 30 33 37 48 50 55 58 46
Q: Month 1 2 3 4 5 No. of Cases 105 115 120 120 125 Month 6 7 8 9 10 No. of Cases 125 130 140 145 150…
A: Given data is
Q: Following are two weekly forecasts made by two different methods for the number of gallons of…
A: Given - Week Forcast Actual Demand 1 0.95 0.72 2 1.08 1.00 3 0.95 1.07 4 1.22 0.97
Q: produce their hev next generation Corporation is plannin iPhone the said product will compete the…
A: Given, Fixed cost for investment of new product = $4500000 Variable cost = $0.75 per unit. Selling…
Q: 6. Tread-On-Us Carpet & Tile Company sold 700,000 square t.et of carpet last year, 800,000 square…
A: Moving average is a method of forecasting. It is calculated by adding up all the data points of a…
Q: Following are two weekly forecasts made by two different methods for the number of gallons of…
A: Formula to solve this problem: - MAD=Sum of errornMSE = Sum of Squared errorn
Q: (b) Use a - 0.1 to compute the exponential smoothing values for the time series. (Round your answers…
A: We’ll answer the first question since the exact one wasn’t specified. Please submit a new question…
Q: National Scan, Ic., sells radio frequency inventory tags. Monthly sales for a seven-month period…
A: Given data- Month Sales (000) units Feb 13 Mar 16 Apr 10 May 18 Jun 20 Jul 21 Aug…
Q: Cadbury started an in-depth study to forecast customer demand based on data it previously recorded.…
A: The given question is solved in Step 2.
Q: (Round your answers to 2 decimal places.)Calculate MAD and MSE for the forecast. MAD = MSE %3D
A: THE ANSWER IS AS BELOW:
Q: The number of disk drives (in millions) made at a plant in Taiwan during the past 5 years follows.…
A: Given data:
Q: (a) Make a line chart for an m-period moving average to the exchange rate data shown below with m =…
A: Moving averages are used to forecast the value of next period using the data of past periods.…
Q: 1 Given the data below. Find the forecast value from June to December Month Actual Demand Forecast…
A: The method of least squares is a common technique in regression analysis to estimate the solution of…
Q: The number of internal disk drives (in million) made at a plant in Taiwan during the past 5 years…
A: a. Forecast using simple linear regression: Year (X) Disks (Y) X×Y X2 1 142 142 1 2 156 312…
Q: 6, 21 Quintile 1st 2nd Зrd 4th 5th % of Income, United States, 2010 % of Income, Bangladesh, 2010 10…
A: Here, I have to calculate the Gini Coefficient for United States in 2010 and Gini Coefficient for…
Q: 1. Develop a 5-month moving average for the below given. What will be the forecast month 15? Compute…
A: Moving Average is an important method to forecast the estimation, based on historical data, in…
Q: In your own words and it should be in paragraph form. Also, don't forget to conclude. 1. Discuss…
A: Forecasting is an absolute necessity if an enterprise wants to have a competitive advantage. Itis…
Q: Use the least square method to make the forecasting table. Compute the MAE and MSE
A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…
Q: Monthly sales ina company for a seven-period (Jan-July) were as follows: 19, 18, 16, 14, 17, 19,…
A: A simple moving average (SMA) is an arithmetic moving average, determined by taking the summation of…
Q: I'm trying to forecast how many TV's my shop will sell in 2021. I have data for the previous 4…
A: Forecasts generated applying exponential smoothing techniques are weighted averages of preceding…
Q: Sales of Cool-Man air conditioners have grown steadily during the past 5 years: (Round your ans to 2…
A: Case 1: As per the given table Following is the excel solution: Following are the formulas used:…
Q: The following table shows a tool and die company’s quarterly sales for the current year. What sales…
A: First, establish a relationship between the quarter and the sales:by an equation of the line (use…
Q: • 4.29 The number of disk drives (in millions) made at a plant in Taiwan during the past 5 years…
A:
Q: Hint: Exponential Smoothing: The company has accumulated the demand data, shown below, for its…
A: Exponential smoothing- F(t+1) = αAt + (1-α)Ft α = 0.5
Q: (in thousands) ɔ) The MAD for this model = 2.38 (round your response to two decimal places). c)…
A: Given data - Week Actual Forecast 1 17 17.00 2 21 17.00 3 19 17.80 4 23 18.04 5 18…
Q: Calculate the sales forecasted for the year 2021 using Exponential smoothing given a weight a of…
A: Given data is
Q: 4.5 The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest…
A: Given-
Q: d. Compute MAPE for each data set. Which forecast appears to be more accurate? (Round your…
A: MAPE: MAPE stands for the mean absolute percentage error. It is one of the methods used to measure…
Q: Two different forecasting models were used to forecastsales of a popular soda on a college campus.…
A: Solution - Introduction - [1] Forecasting Model - Forecasting models are one of the numerous methods…
Q: Given the following data of actual sales and forecast for the five months: Month 1, Month 2, Month…
A: Given data is
Q: The number of disk drives (in millions) made at a plant in Taiwan during the past 5 years follows:…
A: The forecast of disks to be produced next year can be computed as follows:
Q: The number of internal disk drives (in millions) made at a plant in Taiwan during the past 5 years…
A: BELOW IS THE SOLUTION TO THE QUESTION.
Q: Find the MAD and Tracking signal in below table. Do you think this forecast is acceptable? Why? How…
A: Given information- Period Actual demand Forecast 1 220 200 2 300 310 3 400 340 4 340 350…
Q: A large Portland manufacturer wants to forecast demand for a piece of pollution-control equipment.…
A: Forecasting Is a technique or method used by operations, sales managers or by management to take…
Q: Months Month 1 Month 2 Month 3 Month 4 Month 5 Sales 20 25 32 35 38 Please use the weight 0.45 for…
A: Given data:
Q: 4. A local moving company has collected data on the number of moves they have been asked to perform…
A: THE ANSWER IS AS BELOW:
Q: What is the importtance of forecasting room availability and room revenue for Front Office Managers.
A: Forecasting is the technique to estimate/predicting future values using different approaches. In…
Q: Calculate MSE for the 4 periods for which the actual and forecasted number of customers given in the…
A: Formula:
Q: a) Using the trend-projection (regression) method, develop a forecastfor the sales of Volkswagen…
A: Note: - Since the data for the 'Volkswagen Beetles' question is not given we will answer the…
Q: B. The owner of a small hardware store has noted a sales pattern that seems to parallel the number…
A:
Q: some of lts laptop omputer for during the last 12 ins were as follows: Price Per Chip $1.85 Price…
A: Using the Formula : Alpha α = 0.1 Month Price per chip Forecast Error Absolute…
Q: Q.2 Answer the following A large international sales organization has collected data on the number c…
A: Given data:
Q: ovid-19 is affecting every sector of society. It is expected that Covied-19 will remain there for…
A: Human Resource Planning is the strategical tool that helps in forecasting the current and future…
Q: Given the following sales data: week 1: 203 week 2: 185 week 3: 164 week 4: 151 week 5: 115 Forecast…
A: Given Sales Data - Week 1 203 Week 2 185 Week 3 164 Week 4 151 Week 5 115
Q: c. Comment on the strength of the relationship between the test scores and production ratings. The…
A: Coefficient of correlation = R Coefficient of Determination = R^2
Q: A newly operated company producing household items would want to forecast its sales volume for the…
A: Find the Given details below: Given Details Month Sales (Quantity) 1 300280 2 290295 3…
Q: The following gives the number of pints of type Bblood used a t Woodlawn Hospital in the past 6…
A: The formulas to be used are as follows: 3-week moving average= sum of previous 3 week pints/number…
Q: The following table shows a tool and die company's quarterly sales for the current year. What sales…
A: Quarter 1 Sales = 84.6 SR1=0.94 Deseasonalized = 84.60.94 = 90
Q: Using the data below, what is the value of MAD? Week Time Series Value Forecast 6. 4.00 7.00 4 6.00…
A: Week Time Series Value (A) Forecast (F) Error -=A-F |Error| 1 6 4 2 2 2 5 7 -2 2 3 4 6 -2 2…
3-
Step by step
Solved in 2 steps with 2 images
- Under what conditions might a firm use multiple forecasting methods?2-1 Sales of Cool-Man air conditioners have grown steadily during the past 5 years: DEMAND ADV SEPENT 2017 450 1200 2018 495 1650 2019 518 1710 2020 563 1860 2021 584 1960 Predict the demand of Year 2021 by: a. Using 3 moving average b. Using exponential smoothing with alpha = 0.30. The sales manager had predicted, before the business started, that year 1l's sales would be 410 air conditioners. c. Using the relationship between the sales and advertainment spent Which of the above value is the best predicated demand for Year 2021? 2-2 Three trials for the company stock control system were calculated as shown in the table below. The holding cost, shortage cost and ordering costs have been estimated to be $220, $80 and $170. The company has a high competition therefore they need to keep their customer and attract more new customers. Strategy 1 Strategy 2 Strategy 3 Reorder Quantity 200 600 400 Reorder Level 300 400 200 Lead Time 1 Number of days when stock out is occurred 20 12 Number of…The following table shows the quarterly sales (RM'000) for Afeef Café for the past 3 years. Quarter Year 2 3 4 2019 11 17 10 18 2020 19 24 17 29 2021 23 38 31 33 Based on the above data. (c) Forecast the sales for the third quarter of 2022.
- The K&R Camera shop sells all the latest cameras and accessories. To meet customer demand, the manager must forecast demand for items she sells. Lately the XR-42S zoom lens has been very popular. Recent monthly demand for this item has been as shown: Number of Lenses Month Sold 1 12 17 2 3 4 15 20 18 23 6.» 95 A cosmetics manufacturer's marketing department has developed a linear trend equation that can be used to predict annual sales of its popular Hand & Foot Cream. Ft = 80 + 25t where Ft = Annual sales (000 bottles), t is in years. Predict annual sales for year 6? 170 230 10 % 6 52 min 42 secsNew Accounts New Accounts Period 200 232 11 214 248 12 211 250 13 228 253 14 5 235 10 267 15 Using linear regression, what is your forecast for period 16? Less than 300 Between 301 and 308 Between 309 and 350 Period 1 2 3 4 O Higher than 350 Period 6 7 8 9 New Accounts 281 275 280 288 310
- Calculate the mean square error, mean absolute deviation and the Period Year Call Volume forecast Error 1 1 30 45 -15 2 2 25 15 10 3 2 55 65 -10 4 3 15 20 -5 Your answer?12.2 The manager of the I-85 Carpet outlet needs to be able to forecast accurately the demand for Soft Shag carpet (its biggest seller). If the manager does not order enough carpet from the carpet mill, customers will buy their carpets from one of the outlets many competitors. The manager has collected the following demand data for the past 8 months. Month 1 2 3 4 5 6 7 8 Demand for Soft Shag Carpet (1000 yd) 5 10 6 8 14 10 9 12 a. Compute a three-month moving average forecast for months 4 through 9.Q2: An economist who estimated the Keynesian money demand function in logarithmic form using data from Sri Lankan economy, obtained the graph on the left by using predicted and actual money demand. While the model was very successful in predicting money demand until 2010 (small forecast errors), it predicts a consistently higher money demand than actually occurred since then (growing forecast errors each period). 48 Ln(M) 4.75 4.7 4.65 4.6 4.55 Actual 4.5 Predicted ...... 4.45 Help this economist who has trouble explaining this situation, even if you do not know anything about the economy in question. Can you answer this question with details please? 6toz Stor
- *** Can you please demonstrate how to do parts d, e, f? Given: Year Demand 1 7 2 9 3 5 4 9 5 Predict the value for Year 5: 2 year moving average What is MSE for 2 year moving average? 2 year moving average using 0.6 (weight for the oldest period) and 0.4(weight for most recent period Exponential smoothing, =0.2 and forecast for Year 1 = 5 Linear trend Which forecast method has the least amount of error using MAD? What is the coefficient?Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: a. Using linear regression analysis, what would you estimate demand to be for each month next year? (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 2 standard errors of estimate for safety. How many additional units should be held to meet this level of confidence? (Do not round intermediate calculations. Round your answer to the nearest whole number.)Make a 15-year simple linear regression forecast. Example: Railroad Products Co. RPC Sales Car Loadings Year ($millions) (millions) 1 9.5 120 2 11.0 135 3 12.0 130 4 12.5 150 5 14.0 170 6 16.0 190 7 18.0 220