IvanRivera6.MM305_Unit5_Project

# IvanRivera6.MM305_Unit5_Project - I van Rivera MM305...

This preview shows pages 1–2. Sign up to view the full content.

MM305 Quantitative Analysis for Managers Unit 5 Project Please download this document to your computer and save it using the naming convention specified in the course syllabus. After completing and saving the project problems, submit your project in the Drop Box for Unit 5. 1. Data collected on the yearly demand for 50-pound bags of fertilizer at Sunshine Garden Supply are shown in the following table. Year Demand for Fertilizer (1,000s of Bags) 1 4 2 7 3 5 4 5 5 10 6 7 7 8 8 9 9 11 10 14 11 15 a. Develop a three-year moving average to forecast sales in year 12. Three year moving average forecast for year 12 =(15+14+11)/3=13.33 in bags per thousand b. Develop a 3-year weighted average to predict demand in year 12. Sales in the most recent year is given a weight of 2 and sales in the two years prior to that are each given a weight of 1. c. Develop a regression/trend line to estimate the demand of fertilizer in year 12. Trend line demand equation = 2.8 + 0.9727*year , Putting year =12, Demand =

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 3

IvanRivera6.MM305_Unit5_Project - I van Rivera MM305...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online