Graph these forecasts and the original data using excel

Assignment Help Operation Management

Reference no: EM1389502

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?

Reference no: EM1389502

Questions Cloud

Review the competencies required of hr management : Review the competencies required of HR management and recommend at least two additional areas in which HR managers

Determine net pressure driving glomerular filtration : Suppose if the average hydrostatic pressure in glomerular capillaries is 55 mmHg, the hydrostatic pressure in Bowman's space is fifteen mmHg, the average colloid osmotic pressure in the glomerular.

Pros and cons for restructering : Critically discuss the pros and cons for restructering. Discuss the preconditions to allow such restructuring and what are the obstacles expected?

Total variance of the investment as investment risk : The variance of the return per share is 4 for stock 1 and 100 for stock 2. The covariance of the return between the two stocks is 5 per share. Use the total variance of the investment as investment risk.

Graph these forecasts and the original data using excel : Graph these forecasts and the original data using Excel. What does the graph show? Which of the above forecasts is best? Why?

Components of a successful proposal : Mention the core components of a successful proposal. In one document, list the funding source, the web address for the funding guidelines, and create a checklist of required and optional components required in a grant proposal.

Summarize the consumer responses with a frequency table : In a marketing study, 100 consumers were asked to select the best digital music player from the iPod, the iRiver, and the Magic Star MP3. To summarize the consumer responses with a frequency table, how many classes would the frequency table have?

Determine approximate gfr : Assume you want to evaluate kidney function in a 55-year¬-old, obese man with type II diabetes,and you ask him to collect his urine over a twenty-four hour period.

Write political science reserch paper : Write political science reserch paper for me that should be 6 to 8 pgs double spaced .it has to have proper citation.kindly let me know the charge

User Account

All Pages