Compute the forecasted demand

Assignment Help Operation Research

Reference no: EM13711303

Compute the forecasted demand with a moving average

I need help with the following:

The ABC Floral Shop sold the following number of geraniums during the last 2 weeks:

Day 1: Demand: 200

Day 2: Demand 134

Day 3: Demand 157

Day 4: Demand 165

Day 5: Demand 177

Day 6: Demand 125

Day 7: Demand 146

Day 8: Demand 150

Day 9: Demand 182

Day 10: Demand 197

Day 11: Demand 136

Day 12: Demand 163

Day 13: Demand 157

Day 14: Demand 169

Develop a spreadsheet to answer the following questions.

Problem- Calculate a forecast of the above demand using a 3- and 5-period moving average.

Part 1- Graph these forecasts and the original data using Excel. What does the graph show?

Part 2- Which of the above forecasts is best? Why?

You need to describe the forecasted demand with a moving average and solve the above problem.

Reference no: EM13711303

Questions Cloud

Explain how many grams of n2 at it''s melting point : The molar heat of fusion for nitrogen is 710 j/mole. How many grams of N2 at it's melting point, can be melted by 1080 joules of heat

Sketch the plot of electrical conductivity anainst titre : Sketch the plot of electrical conductivity anainst titre volume(A VS V) you would expect to observe when the strong acid HCl is titrated with the strong base NaOH. Explain the shape of the plot and clearly indicated the end point

Sketch a potential energy diagram for rotation : Sketch a potential energy diagram for rotation about the C-C bond in propane (eclipsed and staggered conformations)

Explain operation and improvement : I want more explanation about this process. I am inviting company to improve my business operation improvement process. As the vendor is providing.

Compute the forecasted demand : You need to describe the forecasted demand with a moving averag. Graph these forecasts and the original data using Excel. What does the graph show. Which of the above forecasts is best.

Determine the formula for the compound : Use Lewis theory to determine the formula for the compound that forms between the two elements listed

Substances in order decreasing magnitude of lattice energy : Arrange the following substances in order of decreasing magnitude of lattice energy. Rank from largest to smallest magnitude of lattice energy. To rank items as equivalent, overlap them.

What type of compound is likely to form : Atoms from an element in group IIA are allowed to react with atoms from an element in group VIIA. What type of compound is likely to form

Draw the product of cyclohexene oxide : Draw the product of cyclohexene oxide, sodium methoxide and hydronium workup. Draw the product of 2-methylpropene oxide, and hydrogen chloride in diethylether workup

User Account

All Pages