Unit 4 – Quality Control & Supply Chain Management Assignment

profiletopclassjob
 (Not rated)
 (Not rated)
Chat

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

 

Day

Demand

Day

Demand

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?
    • 11 years ago
    Unit 4 – Quality Control & Supply Chain Management Assignment
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      unit_4_-_quality_control__supply_chain_management_assignment.xlsx