Calculate a forecast for october

Assignment Help Business Management

Reference no: EM13714176

Problem 18-13
Historical demand for a product is as follows:

DEMAND
April 62
May 57
June 82
July 62
August 87
September 82

a. Using a simple four-month moving average, calculate a forecast for October. (Round your answer to 2 decimal places.)

Forecast for October

b. Using single exponential smoothing with α = 0.10 and a September forecast = 56, calculate a forecast for October. (Round your answer to 2 decimal places.)

Forecast for October

c. Using simple linear regression, calculate the trend line for the historical data. Say the X axis is April = 1, May = 2, and so on, while the Y axis is demand. (Round your intercept value to the nearest whole number and slope value to 2 decimal places.)

Y = + t

d. Calculate a forecast for October using your regression formula. (Round your answer to 2 decimal places.)

Forecast for October

Reference no: EM13714176

Questions Cloud

Monopolistic competition or a differentiated oligopoly : Write a short (2-3 page, double-spaced, typed) essay identifying and describing the conditions you observed for a business in Monopolistic Competition or a Differentiated Oligopoly who differentiates their product. Your paper should also provid..

How much energy does the battery deliver during this time : A 1.5V battery delivers 9.0ma for 40 hours. During that time, the battery voltage drops linearly from 1.5V to 1.0 V. How much energy does the battery deliver during this time

Obtain what is the tension in the string : A child ties a 100 gram rock to a string and whirls the string with the rock on it in a circle above his head so the plane of the circle is parallel with the ground. what is the tension in the string

Saturated vapor at the outlet of refrigerators evaporator : R134a as a saturated liquid is throttled from 600 kPa to 100 kPa at a rate of 0.8 kg/min in a refrigerator. What is the cooling capacity, in kW, assuming the R134a is a saturated vapor at the outlet of the refrigerator's evaporator?

Calculate a forecast for october : a. Using a simple four-month moving average, calculate a forecast for October. (Round your answer to 2 decimal places.)Forecast for October b. Using single exponential smoothing with α = 0.10 and a September forecast = 56, calculate a forecast..

Find the speed of the wreckage just after the collision : A 950-kg car traveling west at 15.0 m/s collides with a 750-kg car traveling north at 20.0 m/s. The cars stick together. What is the speed of the wreckage just after the collision

Determine the associated maximum spacing of nails : The support below will be used to attach a climbing rope for young children at the point of load P. It is constructed using two 2-in. by 4-in. pieces of wood braced as shown. If the allowable bending stress is 600 psi, determine the largest load P th..

Calculate the temperature of the water : Liquid water at 25.0?C and 10.0 bar passes through a valve. The pressure drops to 1.00 bar. Calculate the temperature of the water in °C to three significant figures. You can assume that the water is an incompressible liquid with a density of 1000. k..

Identifying opportunity for improvements : Determine at least two (2) challenges in identifying Opportunity for Improvements (OFIs). Suggest at least one (1) strategy that business management can use to mitigate the challenges in question. Provide a rationale to support your suggestion..

User Account

All Pages