Compute mad for each set of forecasts

Assignment Help Operation Management

Reference no: EM131920656

Problem

Two different forecasting techniques (F1 and F2) were used to forecast demand for cases of bottled water. Actual demand and the two sets of forecasts are as follows:

	PREDICTED DEMAND
Period	Demand	F1	F2
1	68	63	62
2	75	66	61
3	70	73	70
4	74	65	71
5	69	71	73
6	72	69	73
7	80	70	76
8	78	72	80

a. Compute MAD for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 2 decimal place.)

MAD F1

MAD F2

(Click to select)F1F2None appears to be more accurate.

b. Compute the MSE for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 2 decimal places.)

MSE F1

MSE F2

(Click to select)F1F2None appears to be more accurate.

c. In practice, either MAD or MSE would be employed to compute forecast errors. What factors might lead a manager to choose one rather than the other?

Either one might already be in use, familiar to users, and have past values for comparison. If (Click to select)tracking signalscontrol charts are used, MSE would be natural; if (Click to select)control chartstracking signals are used, MAD would be more natural.

d. Compute MAPE for each data set. Which forecast appears to be more accurate? (Round your intermediate calculations to 2 decimal places and and final answers to 2 decimal places.)

MAPE F1

MAPE F2

(Click to select)F1F2None appears to be more accurate.

Reference no: EM131920656

Questions Cloud

Can the system enforce the chinese wall model and why : Suppose initially user Alice can read all the companies' data. After Alice reads Shell Oil's data, which companies' data can Alice still read?

At what price must pens be sold to obtain a monthly profit : A producer of felt-tip pens has received a forecast of demand of 34,000 pens for the coming month from its marketing department.

Which city appears to be the better choice : A manufacturer has decided to locate a new factory in northwestern United States to serve growing demand in that market.

Calculate the unit cost of mt glass beginning inventory : Calculate the unit cost of M.T. Glass' beginning inventory. Enter your answer with two places after the decimal point (i.e., $9.80).

Compute mad for each set of forecasts : Compute MAD for each set of forecasts. Given your results, which forecast appears to be more accurate?

Calculate the amount of net income reported on mt glass : Calculate the amount of net income reported on M.T. Glass, Inc.'s income statement for June using the FIFO method.

Compute the order price at which msi would be indifferent : Should MSI accept the special order? Compute the special order price at which MSI would be indifferent between accepting or rejecting the special order.

What sequence should be used : The Budd Gear Co. specializes in heat-treating gears for automobile companies. At 8:00 a.m., when Budd's shop opened today.

Compute cost of goods purchased and cost of goods sold : Assuming that Mountain Lake Corporation uses the periodic system, compute cost of goods purchased and cost of goods sold.

User Account

All Pages