# Question

A manufacturing firm seeks to develop a better forecast for an important product, and believes that there is a trend to the data. OM Explorer’s Trend Projection with Regression Solver has been set up with the 47 demands in the history file. Note the “Load Problem 26 Data” button in the Trend Projection with Regression Solver that when clicked will automatically input the demand data. Otherwise, you can enter the demand data directly into the Inputs sheet.

a. What is your forecast for December of Year 4, making period 1 as the starting period for the regression?

b. The actual demand for period 48 was just learned to be 5,100. Add this demand to the Inputs file and change the starting period for the regression to period 2 so that the number of periods in the regression remains unchanged. How much or little does the forecast for period 49 change from the one for period 48? The error measures? Are you surprised?

c. Now change the time when the regression starts to period 25 and repeat the process. What differences do you note now? What forecast will you make for period49?

a. What is your forecast for December of Year 4, making period 1 as the starting period for the regression?

b. The actual demand for period 48 was just learned to be 5,100. Add this demand to the Inputs file and change the starting period for the regression to period 2 so that the number of periods in the regression remains unchanged. How much or little does the forecast for period 49 change from the one for period 48? The error measures? Are you surprised?

c. Now change the time when the regression starts to period 25 and repeat the process. What differences do you note now? What forecast will you make for period49?

## Answer to relevant Questions

A project for improving a billing process has the following precedence relationships and activity times:a. Draw the network diagram.b. Calculate the slack for each activity. Which activities are on the criticalpath?Paul O’Neill, former U.S. Treasury Secretary, estimates that arguably half of the $2 trillion a year that Americans spend on health care is needlessly wasted. Brainstorm up to 10 blue-sky ideas to solve the following ...Referring to problem 4, the operations manager at Macon Controls believes that pessimistic demand has a probability of 20 percent; expected demand has a probability of 50 percent and optimistic demand has a probability of 30 ...The Yankee Fork and Hoe Company is a leading producer of garden tools ranging from wheelbarrows, mortar pans, and hand trucks to shovels, rakes, and trowels. The tools are sold in four different product lines ranging from ...Supertronics, Inc., would like to know how the firm’s profitability is altered by product mix. Currently, product mix is determined by giving priority to the product with the highest per unit contribution margin (defined ...Post your question

0