Question: Problem 1: An electrical contractor's records during the last five weeks indicate the number of the job requests: Week: 1 2 3 4 Requests: 5

Problem 1: An electrical contractor's records
Problem 1: An electrical contractor's records during the last five weeks indicate the number of the job requests: Week: 1 2 3 4 Requests: 5 20 22 18 21 22 Predict the number of requests for week 6 using each of these methods: a. Nave. b. A four-period moving average. c. Exponential smoothing with (=0.30. Use 20 for week2 forecast. Problem 2: The following data were collected during a 13 month from a company's sales reports. The report shows for each month, how much the company has spent for advertising (x) and how much sales were made during that month (y). Both the advertising and sales dollars are in units of $million. The Chief Executive Officer of the company is interested in the impact of the advertising spending on the actual sales. Month Month 8 9 78 70 80 84 10 72 81 11 85 51 96 88 12 13 | 90 30 (a) Obtain a linear regression line for the data. (Hint: You need to calculate a and b to get the linear regression equation: y= a + bx) (b) Predict the sales figures in month 14 and 15 if the advertising budgets allocated for months 14 and 15 are $25 million and $30 million, respectively

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!