Calculate a three quarter moving average forecast

Assignment Help Data Structure & Algorithms

Reference no: EM1380162

The Fastgro Fertilizer Corporation distributes fertilizer to various lawn and garden shops. The corporation must base its quarterly production schedule on a forecast of how many tons of fertilizer will be demand from it. The company has gathered the following data for the past three years from its sales records.
year-------Quarter--------Demand for Fertilizer(tons)

1 1 105
2 150
3 93
4 121
2 5 140
6 170
7 105
8 150
3 9 150
10 170
11 110
12 130

a) Calculate a three-quarter moving average forecast for quarters 4 through 13 and compute the forecast for each quarter.
b) Develop a seasonally adjusted forecast for the demand data for fertilizer. Then use a linear trend line model to compute a forecast estimate for demand in year 4.

Reference no: EM1380162

Questions Cloud

Creating an hierarchy chart : Regal Brakes Corporation requires to automate its payroll calculation system. To compute payroll, first the gross pay is calculated, which is equal to the item of the number of hours and hourly rates.

Discussion on clustering and data mining : Clustering is generally used along with classification in some applications. In such a case, typically clustering is applied to a dataset to recognize natural grouping of the objects in the dataset,

Understanding planning stage of the audit process : Prepare a memo to the audit partner on the ‘state of the company's industry' and associated risk factors and prepare a list of three useful sources and perform overall analytical procedures

Design a control unit for simple hand held video game : Create a control unit for a simple hand held video game in which a character on the display catches objects. Only demonstrate the transition diagram

Calculate a three quarter moving average forecast : The Fastgro Fertilizer Corporation distributes fertilizer to various lawn and garden shops. Calculate a three-quarter moving average forecast for quarters 4 through 13 and calculate the forecast for each quarter.

Inventory management including warehouse management : The aim of the course is to give fundamental knowledge of supply chain management and establish understanding of logistics terminology and concepts

Question about pure aloha : A group of N stations share a 56-kbps pure ALOHA channel. Every station outputs a 1000-bit frame on an average of once every one-hundred secs, even if the previous one has not yet been sent.

Creating a chart for it system : Make a chart that demonstrate the breakdown of the overall IT systems at a big corporation or breakdown a particular aspect of the IT systems such as the network or the business applications systems.

Interchange contents of working registers : Make a stack at 1000h and use the stack to interchange the contents of all of working registers. Exchange AX with DX, BX with CX, and DI with SI.

User Account

All Pages