Vikas

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

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? 
 
Financial Accounting Assignment Help, Financial Accounting Homework help, Financial Accounting Study Help, Financial Accounting Course Help
Answered
Other / Other
01 Feb 2016

Answers (1)

  1. Vikas

    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 Devel

    If we consider the 3 period moving averages then, it can be found th ****** ******
    To see full answer buy this answer.
    Answer Attachments

    2 attachments —

    • img
      Finance204166.doc
    • img
      Moving_Average204167.xls

Report As Dispute

Share Your Feedback

Give Review : A+ A B C D F