Using the actual sales (in units) over the past 15 months, a demand planner at a leading e-commerce firm hasforecasted the demand for a popular consumer product as shown below. Forecast 1 and Forecast 2 represent theoutputs of two comparative forecasting methods currently used by the sales and marketing, and operationsdepartments of the firm.MonthOctober 22November 22December 22January 23February 23March 23April 23May 23June 23July 23August 23September 23October 23November 23December 23Actual sales (units)120 000138 000172 000120 000114 00098 000118 000112 000132 000138 000108 000126 000144 000162 000189 000QUESTION 24Determine the mean absolute deviation of Forecast 1.A 234 290 unitsa 18 721 unitsc 19 524 units22 670 unitsQUESTION 25Determine the mean absolute deviation of Forecast 2.A 21 638 unitsa 35 280 unitsc. 19 330 units23 600 unitsForecast 1 (units)133 280130 620127300121 440120 750119 000121 600124 900121 500122400126 720133 780Forecast 2 (units)143 330143 330135 330110 670110 000109 330120 670127 330126 000124 000126 000144 000

The question is about forecasting.Given :To find :24 ) Mean absolute deviation of forecast 125 )…

Answered: Using the actual sales (in units) over…

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter10: Statistics

Section10.2: Representing Data

Problem 22PFA

See similar textbooks

Similar questions

Compare the primary types of forecasting methods used to determine demand.
Briefly explain how the organization forecast sales for its products.a. Using historical sales data, choose a quantitative technique to forecast sales for thatorganisation for the next sales period. Comment on the appropriateness of thetechnique used.b. Describe three strategies that the organization uses to compete and comment on theappropriateness of these strategies
United Dairies, Inc., supplies milk to several independent grocers throughout Dade County, Florida. Managers at United Dairies want to develop a forecast of the number of half-gallons of milk sold per week. Sales data for the past 12 weeks follow and have been transferred in the data file UDFMilk.xlsx download(also posted under week 11 module). Week Sales Week Sales 1 2750 7 3300 2 3100 8 3100 3 3250 9 2950 4 2800 10 3000 5 2900 11 3200 6 3050 12 3150 By Thursday, April 15 (11:55pm PST), answer the following 2 questions and attach a word doc or excel file to show your work. Use the data in the file UDFMilk.xlsx downloadto construct a time series plot. What type of pattern exists in the data? Use exponential smoothing with to develop a forecast of demand for week 13.
Intergarated products Need to estimate its pc sales for the nextnext year. the most recent six years of revenue data for the companys line of xt personal computers and those of the industry, is found in the table below; Year XT PC Sales (000,000) All Industry PC Sales Revenue 1 2.4 4.6 2 5.9 8.6 3 15.5 10.7 4 27.8 14.8 5 35.9 18.5 6 38.1 19.4 a) Assuming that the sales data above are representative of sales expected next year , use time series regression analysis to forecast next years sales b) determine the correlation correlation for he ime forecast and interpret is meaning c) find the coefficient of determination for the time series forecast and intpret it s meaning d) perform a regression analysis between the annual sales revenues of XT Personal computers and all personal computers if the estimate of next years industry PC sales revenues is $21.9 billion? e) which independent variable should intergrated products coporation IPC choose for its forcasting of sales…
Lovely Lawns, Inc., intends to use sales of lawn fertilizer to predict lawn mower sales. The store manager estimates a probable six- week lag between fertilizer sales and mower sales. The pertinent data are: Fertilizer Number of Fertilizer Number of Sales Mowers Sold Sales Mowers Sold Period (tons) (six-week lag) Period (tons) (six-week lag) 1 1.6 10 8. 1.3 7 1.3 8 1.7 10 3 1.8 11 10 1.2 6. 4 2.0 12 1.9 11 2.2 12 12 1.4 1.6 9. 13 1.7 10 7 1.5 14 1.6 a. Determine the correlation between the two variables. Does it appear that a relationship exists between these variables will yield good predictions? (Do not round intermediate calculations and round your answer to 3 decimal places.) it appears that a positive v relationship exists between these variables. b. Obtain a linear regression line for the data. (Negative values should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 3 decimal places.) Y = O Xi + c. Predict expected lawn mower sales…
The Sun Devils Corporation is deciding which of two forecasting models to use. The forecasts for the two models and actual demand are provided below: -Select- Model 2 MAD MAPE RSFE What does the RSFE indicate? Model 1 tends to -Select- forecasts demand. Model 2 tends to -Select- forecasts demand. Which forecast is better? Why? % MONTH SALES 1 155 2 200 3 210 195 160 170 145 175 170 175 Compute the MAD, MAPE, and RSFE for the two forecasting methods. Do not round intermediate calculations. Round your answers for the MAD and MAPE to two decimal places and for the RSFE to the nearest whole number. Use a minus sign to enter a negative value, if any. Accuracy measure Model 1 % 6 7 8 9 10 MODEL 1 MODEL 2 FORECASTFORECAST 140 220 205 210 150 160 170 170 155 185 180 215 185 185 135 185 125 190 145 165 is better because it provides a -Select- MAD, MAPE, and absolute value of RSFE.
In predicting a person’s income, identify two possible quantitative predictor variables and two possible qualitative predictor variables.
An online clothing company is keeping track of their customers purchases. Company also offers a credit card where customers get additional offers if they use that card when they make purchases from their online store. For those customers who has their credit card, the company has additional information such as age, yearly income, etc. The company management is interested in looking at the relationship between the income (in 1000s of dollars) and the total yearly purchases from their store for these credit card holders . They have gathered this information from a random sample of 42 credit card holders. Below provided is a partial MINITAB output for predicting the yearly purchases from the income. Identify the response and the predictor variable in this study. Write the equation of the least squares regression line for predicting the total yearly purchase from the income of the customer. What percentage of variation in total yearly purchase is explained by income of the customer?…
You are interested in studying the relationship between dietary fat intake and pubertal onset. a. Define Cofounder b. Identify at least 3 potential variables that may confound the primary relationship of interest.
An online business sells two varieties of cat food, 'standard' and 'luxury'. It orders these from its supplier each October for the year ahead. The data for 2021 and 2022 are displayed in Table 1. Table 1 2021 2022 Standard price (£ per kg) 36.20 38.90 Standard expenditure (£) 285.62 268.41 Luxury price (£ per kg) Luxury expenditure (£) 44.50 49.70 431.21 497.97 (a) Calculate the (chained) price index for 2022, taking 2021 as the base year. (b) The RPI for October 2021 was 312.0, and the RPI for October 2022 was 356.2. Use this information, together with your calculation from (a), to compare the change in cat food prices with the overall change in this period. (c) An RPI index-linked pension was £450 per month in October 2021. How much should the pension be per month in October 2022? Give your answer rounded to the nearest pound. (d) Calculate the purchasing power of the pound in October 2022 compared with October 2021. Give your answer rounded to the nearest penny.
The National Entrepreneurship and Innovation Programme has initiated a business incubation venture ahead of schedule in the venture lifecycle. Something that must be done is to do a justification for the project. Since very little information is known about the project, the estimates are considered to be rough estimates. The accompanying table is the project manager’s gauge of the income that will occur throughout the following five years: End of Year Cash Flow In (GHC) Cash Flow Out (GHC) 1 0 500,000.00 2 300,000.00 90,000.00 3 400,000.00 100,000.00 4 100,000.00 175,000.00 5 50,000.00 35,000.00 What is the payback period for the project. show workings If the net present value (NPV) for each of the cash flows were calculated at a 10% interest rate, what would the NPV cash flow be at the end of five years? Comment on the feasibility of the project.

Recommended textbooks for you

Glencoe Algebra 1, Student Edition, 9780079039897…

Algebra

ISBN:

9780079039897

Author:

Carter

Publisher:

McGraw Hill

Big Ideas Math A Bridge To Success Algebra 1: Stu…

Algebra

ISBN:

9781680331141

Author:

HOUGHTON MIFFLIN HARCOURT

Publisher:

Houghton Mifflin Harcourt

Glencoe Algebra 1, Student Edition, 9780079039897…

Algebra

ISBN:

9780079039897

Author:

Carter

Publisher:

McGraw Hill

Big Ideas Math A Bridge To Success Algebra 1: Stu…

Algebra

ISBN:

9781680331141

Author:

HOUGHTON MIFFLIN HARCOURT

Publisher:

Houghton Mifflin Harcourt

SEE MORE TEXTBOOKS