{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Grp Company Sales Forecast _5

# Grp Company Sales Forecast _5 - Brigham Young University...

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

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

View Full Document

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.

Unformatted text preview: Brigham Young University Institute of Business Management ManEc 453 Money, Banking and Financial Markets Group Assignment #5 Due: November 14, 2012 GROUP FORECASTING EXERCISE Each group has been assigned a company to observe during the course of the semester. This assignment consists of preparing a sales forecast for that company for 2012. A written report is to be submitted containing a) the company's sales data used to estimate the forecasting equation, b) the equation with relevant statistical parameters, c) the values of the independent macro variables for 2012 used to generate the forecast and d) the forecast in a table as presented below : Sales History and Forecast for ________________ Data in \$ millions Qtr 1 Qtr 2 Qtr 3 Qtr 4 Total 2009 1,148 1,156 1,160 1,162 4,625 2010 1,176 1,204 1,240 1,247 4,867 2011 1,214 1,191 1,168 1,191 4,764 2012 Team Forecast from the Summary Sheet Note: There are 7 tabs in this spread sheet, all should be completed and handed in. Team Members: FORECAST ANALYSIS TEAM Year over Year TREND MACRO ANALYST FORECAST % Change 2012:1 1,233 1,227 1,140 2012:2 1,241 1,264 2012:3 1,249 1,302 2012:4 1,258 1,341 TOTAL 2012 4,981 5,134 5,240 Regression Line: Sales = 898.1+ 8.17 (Time) T-Stat = 9.16 R- Squared = 0.69 Data in \$ millions...
View Full Document

{[ snackBarMessage ]}

### Page1 / 7

Grp Company Sales Forecast _5 - Brigham Young University...

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

View Full Document
Ask a homework question - tutors are online