Which of the above forecasts is best

Assignment Help Operation Management

Reference no: EM13254168

Deliverable Length: 3-4 pages

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

Day - Demand - Day - Damand
1          200        8             150
2          134        9              182
3          157        10             197
4          165        11              136
5           177       12              163
6           125        13              157
7           146        14              169

Develop a spreadsheet to answer the following questions.

Calculate a forecast of the above demand using a 3- and 5-period moving average.
Graph these forecasts and the original data using Excel. What does the graph show?

•Which of the above forecasts is best? Why?

Reference no: EM13254168

Questions Cloud

Why is a people strategy strategic : Why is a people strategy strategic? Provide an example to validate your answer.

Contract negotiations : You are in contract negotiations. The seller is insisting on a time and material contract. What are some of the concerns with a time and material contract vehicle?

Evaluate the equilibrium partial pressures : At a certain temperature, Kp = 1.42 for the reaction PCl5 PCl3 + Cl2. Calculate the equilibrium partial pressures and the total pressure if the initial partial pressures are PpCl5= 2.88 atm , PpCl3 = 1.98 atm , and PCl2 = 1.42 atm.

Instructions of research paper : The instructions of research paper is to write about steganography techniques and applications - types and techninques of steganography and then discuss in-depth how is is used, which technique is popular, include Figures of how the technique is us..

Which of the above forecasts is best : Develop a spreadsheet to answer the following questions.

What is the steady state error for a ramp input : A process has dynamics G(s)=1/(4s^s+s+1). Apply a unity negative feedvack controller of the form G.c(s)=1/(s+b). (a) Report the transfer function T(s) of the closed-loop system. (b) Report T(s) to 2nd order and report the reduced transfer function T..

Make-or-buy analysis : You have been assigned to do a make-or-buy analysis. What factors will you likely include in your make-or-buy evaluation?

Compute the equilibrium concentrations of h20 : At 1000K , the value of Kc for the reaction C+H20 CO+ H2 is 3.0*10^-2. Calculate the equilibrium concentrations of H20, CO2, and H2, in a reaction mixture obtained by heating 5.70 mol of steam and an excess of solid carbon in a 5.50 L container.

What number of units must be produced to break even : Assume a new product has a fixed cost of $900, a variable cost of $4.50 each, and a selling price of $5.50 each. What number of units must be produced to break even?

User Account

All Pages