question A manufacturer is developing a facility plan to provide production capacity for the factory. the amount of capacity required in the future depends on the number of products demanded by its customers. The data below reflect past sales of its products. a) use simple linear regression to forecast annual demand for the products for each of the nnext 3 years. b) determine the correlation coefficient for the data and interpret its meaning. c) find the coefficient of determination for the data and interprete its meaning. year annual sales (number of products year annual sales (number of products) 1 490 5 461 2 487 6 475 3 492 7 472 4 478 8 458

question A manufacturer is developing a facility plan to provide production capacity for the factory. the amount of capacity required in the future depends on the number of products demanded by its customers. The data below reflect past sales of its products. a) use simple linear regression to forecast annual demand for the products for each of the nnext 3 years. b) determine the correlation coefficient for the data and interpret its meaning. c) find the coefficient of determination for the data and interprete its meaning. year annual sales (number of products year annual sales (number of products) 1 490 5 461 2 487 6 475 3 492 7 472 4 478 8 458

Contemporary Marketing

18th Edition

ISBN:9780357033777

Author:Louis E. Boone, David L. Kurtz

Publisher:Louis E. Boone, David L. Kurtz

Chapter14: Pricing Strategies

Section14.2: Forecasting Demand

Problem 1LO

See similar textbooks

Similar questions

Under what conditions might a firm use multiple forecasting methods?
QUESTION 2 The number of patients coming to the Healthy Start Maternity clinic has been increasing steadilyover the past eight months. You are provided with some historical data as follows: Month Clinic attendance (in thousands)1 3.42 3.93 4.54 5.05 5.86 5.97 6.58 6.7 a. Identify and give a brief explanation of the:-i. Dependent variableii. Independent variable b. Use simple linear regression to forecast annual demand for months 9 and 10 by using thetabular method to:-i. Derive the values for the intercept and slope. ii. Derive the linear regression equation. iii. Plot the linear regression line. iv. Develop a forecast of the clinic attendance for months 9 and 10.
QUESTION 1The table below shows the sales figures for a brand of shoe over the last 12 months. Months SalesJanuary 69February 75March 86April 92May 95June 100July 108August 115September 125October 131November 140December 150 a. Using the following, forecast the sales for the months up to January the following year:- ii. A three period weighted moving average using weights of 1, 2 and 3. Assign thehighest weight to the most recent data.
QUESTION 2:The manager of YTL Computers wants to develop next year’s quarterly forecasts of salesrevenue for its brand laptops. The sales are seasonal and the company believes that thefollowing most recent eight quarters of sales should be representative of next year’ssales: Year Quarter Sales (millions of dollars) 1 1 9.2 1 2 5.4 1 3 4.3 1 4 14.1 2 1 10.3 2 2 6.4 2 3 5.4 2 4 16.0 Determine the forecast of next year’s quarterly sales revenue for this line of laptops.Show all your workings.
QUESTION 1The table below shows the sales figures for a brand of shoe over the last 12 months.Months SalesJanuary 69February 75March 86April 92May 95June 100July 108August 115September 125October 131November 140December 150a. Using the following, forecast the sales for the months up to January the following year:-i. A simple three month moving average. ii. A three period weighted moving average using weights of 1, 2 and 3. Assign thehighest weight to the most recent data. iii. Exponential Smoothing when α= .6 and the forecast for March is 350.iv. Determine which of the three forecasting technique is the most accurate usingMAD. b. The following table shows the number of televisions sold over the last ten years at alocal electronic store.YEAR TV SALES1 1502 3003 4804 6005 6306 6407 7008 8259 90010 980i. Using trend projection, develop a formula to predict sales for years 11 and 12. Youhave to show all working. You will need to develop a table to calculate the slope andthe intercept.…
Question 2 i. Differentiate between independent and dependent variable in forecasting. ii. The last seven weeks of sales at KC car dealership can be seen in Table 2 below. Table 2 Week Sales 1 25 2 30 3 27 4 31 5 27 6 29 7 30 8 a. Use a three-period weighted-moving average forecast to determine a forecast for the 8th week using weights of 3, 2, and 1 (where the most recent week receives the highest weight). (Round all forecasts to the nearest whole unit.) b. Calculate the MAD for this forecast. c. What does the MAD indicate?
20- Forecasting is very important in predicting the future sales of a company. Can you identify the wrong statement about forecasting from the options below? a. Short range forecasts are less accurate than long range forecasts b. The underlying casual system will remain same in the future c. Forecast for group of items is accurate than individual item d. Forecasts are rarely perfect
QUESTION 1 The table below shows the sales figures for a brand of shoe over the last 12 months. Months SalesJanuary 69February 75March 86April 92May 95June 100July 108August 115September 125October 131November 140December 150 a. Using the following, forecast the sales for the months up to January the following year:-i. A simple three month moving average. ii. A three period weighted moving average using weights of 1, 2 and 3. Assign thehighest weight to the most recent data. iii. Exponential Smoothing when α= .6 and the forecast for March is 350.iv. Determine which of the three forecasting technique is the most accurate using MAD
Question 18 A tire company needs a forecast for studded tires in the next forecast period. The company typically uses an exponential smoothing forecast using a smoothing constant of alpha = 0.20. The demand for the most recent period was 100 and the forecast for the same period was 110. Based on this information, what is the tire company's forecast for the next period? Group of answer choices a. 100 tires b. 102 tires c. 108 tires d. 110 tires e. Impossible to determine
Q1 Given the Supply chain cost for a service is PKR 195 and the customer value is PKR 225. Determine supply chain surplus and consumer surplus. Q2 PizzaHut is a franchise based model which serves customers a variety of pizzas and related products. The service is purely customized. Identify whether the model is push-based supply chain or pull based supply chain. Can we a have push-pull boundary in PizzaHut case? How? Q3 Discuss Qualitative forecasting technique. Explain the situations where we use Qualitative methods. Discuss Delphi forecasting method and its challenge.
QUESTION 5 Choose the answer with the best match. Elements of a Good Forecast, Meaningful: The benefits should outweigh the costs It should work consistently The degree of accuracy of the forecast should be stated The forecasting horizon must cover the time necessary to implement possible changes so that its results can be used The units measured should be useful to those using the forecast QUESTION 6 There are two main approaches to forecasting. Choose the best two: Quantitative, Consumer Judgmental, Quantitative Sales force, Judgmental Historical, Consumer Expert, Executive QUESTION 7 Describe the following: Andon Maintaining equipment in good condition Maintaining a workplace that is clean System for moving work to the next station as it is completed System of lights used at each workstation to…
q1- Daily highs in Sacramento for the past week (from least to most recent) were: 95, 102, 101, 96, 95, 90 and 92. Develop a forecast for today using a weighted moving average, with weights of .6, .3 and .1, where the highest weights are applied to the most recent dataq2- Consider the following demand and forecast. Period Demand Forecast 1 7 10 2 12 15 3 18 20 4 22 If MAD = 2, what is the forecast for period 4? Answer 21 22 23 none of the aboveq3- A normal distribution has a mean of 500 and a standard deviation of 50. A manager wants to simulate one value from this distribution, and has drawn the number 1.4 randomly. What is the simulated value?Q4- The local operations manager for the IRS must decide whether to hire 1, 2, or 3 temporary workers. He estimates that net revenues will vary with how well taxpayers comply with the new tax code. The following payoff table is given in thousands of dollars (e.g. 50 = $50,000). If he thinks the chances of low, medium, and high compliance are…