Op Man HW 5 Chapters 14 &amp; 18

# forec as tforoc tober 6080 c us ing s imple linear

This preview shows page 1. Sign up to view the full content.

This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: = 306 + 7.4 = 313.4 units 8. awar d: 0.50 out of 0.50 points Problem 18-13 His toric al demand for a produc t is as follows : April May J une J uly Augus t September DEMAND 68 63 88 68 93 88 a. Us ing a s imple four­month mov ing av erage, c alc ulate a forec as t for Oc tober. (Round your answer to 2 decim al places.) Forec as t for Oc tober 84.25 b. Us ing s ingle ex ponential s moothing with α = 0.20 and a September forec as t = 54, c alc ulate a forec as t for Oc tober. (Round your answer to 2 decim al places.) Forec as t for Oc tober 60.80 c. Us ing s imple linear regres s ion, c alc ulate the trend line for the his toric al data. Say the X ax is is April = 1, May = 2, and s o on, while the Y ax is is demand. (Round your intercept value to the nearest whole num ber and slope value to 2 decim al places.) Y = 61 + 4.86 t d. Calc ulate a forec as t for Oc tober us ing y our regres s ion formula. (Round your answer to 2 decim al places.) Forec as t for Oc tober 95.00 Worksheet Problem 18­13 Learn...
View Full Document

Ask a homework question - tutors are online