This preview shows pages 1–2. Sign up to view the full content.
Online Homework System
Assignment Worksheet
2/12/10  8:02 PM
Name:
____________________________
Class:
OPM 311
Class #:
____________________________
Section #:
____________________________
Instructor:
Suman Niranjan
Assignment:
Homework 2
Question 1: (10 points)
Use the excel sheet to compute liner trend (only if necessary)
Chapter 3: Problem 37 Determining a linear trend
Freight car loadings over a 12year period at a busy port are as follows:
Week
Number
Week
Number
Week
Number
1
220
7
350
13
495
2
245
8
360
14
475
3
274
9
408
15
480
4
275
10
380
16
510
5
315
11
428
17
548
6
310
12
450
18
541
a.
Determine a linear trend line for freight car loadings.
(Round your answers to 3 decimal places.)
b.
Use the trend equation to predict loadings for weeks 25 and 26.
(Round your answers to 3 decimal places.)
c.
The manager intends to install new equipment when the volume exceeds 784 loadings per week.
Assuming the current trend continues, the loading volume will reach that level in approximately how many more weeks?
(Round your
answer to the nearest whole number.)
Answer:
a. Y= ____________ + ____________ t
b. The forecasted demand for week 25 and 26 is ____________ and ____________
respectively.
c. It would take approximately ____________ more weeks.
Question 2: (10 points)
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.
 Spring '08
 Rui

Click to edit the document details