QUESTION TWO GM Motors of Lusaka produces electronic motors for power actuated values for block makers in Lusaka. The GM Motors has been in operational for a year now and Mr. Banda, the plant manager, thinks that the growth in sales will continue for the years to come. Mr. Banda wants to develop a long range forecast to be used to plan facility requirements for the next three years. The sales records for the past ten years have been accumulated; Years Annual Sale (K’000) 2007 1000 2008 1300 2009 1800 2010 2000 2011 2000 2012 2000 2013 2200 2014 2600 2015 2900 2016 3200 Required: a) Develop a regression equation for predicting the sales for the electronic motors. b) Use the regression equation to predict the sales for the next three year. c) Find the relationship between the sales and the years. Explain what your finding means.

QUESTION TWO GM Motors of Lusaka produces electronic motors for power actuated values for block makers in Lusaka. The GM Motors has been in operational for a year now and Mr. Banda, the plant manager, thinks that the growth in sales will continue for the years to come. Mr. Banda wants to develop a long range forecast to be used to plan facility requirements for the next three years. The sales records for the past ten years have been accumulated; Years Annual Sale (K’000) 2007 1000 2008 1300 2009 1800 2010 2000 2011 2000 2012 2000 2013 2200 2014 2600 2015 2900 2016 3200 Required: a) Develop a regression equation for predicting the sales for the electronic motors. b) Use the regression equation to predict the sales for the next three year. c) Find the relationship between the sales and the years. Explain what your finding means.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter7: Nonlinear Optimization Models

Section: Chapter Questions

Problem 56P

See similar textbooks

Similar questions

Question 1 ) The monthiy sales Of yamizí Battery company are asfollows:- Month Jales 2000 2100 1500 1400 1300 Calcuiate fore cost sales for June using each of the fo llowing method: - i) Naive Method 1M 3 Month Simple moving averoger Ti) Exponentral smoothing using an a =0:3 cand may forecast of 1600 units.
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 3: Jane is trying to forecast demand for her store, using moving average with n=2, Fill in the missing cells with correct values and find average error for first quarter and second quarter of year 2000 E Enroll- Year Quarter ment Forecast Error Abs Error 1997 313 3. 2 285 4 3 312 5. 4 339 6. 1998 1 359 7 320 356 385 6. 10 1999 396 367 11 397 12 423 13 14 2000 1 15 2000 3412M4
Q.No.04. What does BOM stands for? Why it is necessary for any firm to have correct forecast of BOM?
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.
QUESTIONS: Quarterly demand for a washing machine is as shown. 1. After obtaining initial estimates for level, trend, and seasonal factors. forecast the demand for the first quarter of year III using Winter's model with a 6- - 0,25 where x is the last two digits of your student number. 2. Make a tracking signal analysis for the forecast and evaluate Maks Year I II Quarter 1 2 3 4 1 2 3 4 Demand 1900 1224 4000 5600 4800 1048 6200 8000
Question 03 Suppose you sell stylish leather bags targeting young office going people who can use your bags to carry laptops and necessary stuff. You have already launched leather bags in February of this year and now based on the demand results of last 7 months, you want to predict the demand for your bags for the month of September. Hence, you want to select the right forecasting techniques and you are considering 2 period Moving Average, Naive technique and Exponential Smoothing (use any value between .10 - .15 as the value of alpha). Now figure out the better forecasting technique among 2 period Moving Average, Naive technique and Exponential Smoothing by doing the error calculation with the help of MAD, MSE, MAPE. Period Demand 2period Moving Average (Demand forecast) Naive technique (Demand forecast) Exponential Smoothing (Demand forecast) February 70 75 ** ** March 74 78 ** ** April 80 ** ** ** May 88 ** ** ** June…
Question 2 Mr. Ferdinand is a well known entrepreneur who sells fresh organic beef to persons in the local community. Customers love the quality of meet that Mr. Ferdinand sells so they tend to recommend his product to other persons. Recently, Mr. Ferdinand has been rumning out of beef to sell to his customers. One customer suggests to him that he must use past sales records to forecast demand for his beef so that he can meet his customers demand. Using a numerical example, demonstrate to Mr. Ferdinand how he can use a three- week and a four-week weighted moving average to forecast demand for his beef. I. II. Show how Mr. Ferdinand can test the accuracy of his forecast. III. Explain to Mr. Ferdinand two ways in which he can benefit from doing forecast for his beef. 日正

Question 2 Mr. Ferdinand is a well known entrepreneur who sells fresh organic beef to persons in the local community. Customers love the quality of meet that Mr. Ferdinand sells so they tend to recommend his product to other persons. Recently, Mr. Ferdinand has been running out of beef to sell to his customers. One customer suggests to him that he must use past sales records to forecast demand for his beef so that he can meet his customers demand. I Using a numerical example, demonstrate to Mr. Ferdinand how he can use a three- week and a four-week weighted moving average to forecast demand for his beef. II. Show how Mr. Ferdinand can test the accuracy of his forecast. II. Explain to Mr. Ferdinand two ways in which he can benefit from doing forecast for his beef.
If the forecasted value of the time series variable for one period is 28.5 and the actual value observed for the same period is 32, what is the forecast error for that period? Question 19 options: 3.5 2 -3.5 4
QUESTION 4 Suppose the following are the seasonal indices for the first three quarters of the year for a quarterly series: Quarter Seasonal Index Q1 72.4 Q2 85.3 Q3 109.6 Remember that the seasonal indices should average 100 so you should be able to infer the seasonal index for Q4. Furthermore, suppose that the estimated coeffcients from a regression of the deseasonalized series on Time are given below: Coefficients Intercept 2,506 Time 71.3 If the original value of the series in a Q1 was 2,040, then what is the seasonally adjusted value? (please round your answer to 1 decimal place)
Question 4 The below data represent the advertising expenditure and sales of Little Liu Ltd from year 2008 to 2017. Table: Advertising Expenditure vs. Sales from 2008 to 2017 Year Advert. Expenditure Sales (x, £000) (y, £000) 2008 8 30 2009 12 40 2010 11 29 2011 5 29 2012 14 43 2013 3 17 2014 6 20 2015 8 30 2016 4 22 2017 9 40 Total 80 300 Work out the values of parameters of the relationship shown in the Figure (i.e. work out the equation of the relationship).