HW# 2 - Online Homework System Name: _ Class #: _...

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

View Full Document Right Arrow Icon
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 3-7 Determining a linear trend Freight car loadings over a 12-year 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)
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 6

HW# 2 - Online Homework System Name: _ Class #: _...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online