Tucson Machinery, Inc. manufactures numerically controlled machines, which sell for an average price of $0.5 million each.

Question:

Tucson Machinery, Inc. manufactures numerically controlled machines, which sell for an average price of

$0.5 million each. Sales for these NCMs for the past two years were as follows.

Quarter Quantity (Units) Quarter Quantity (Units)

Last Year I

II III IV 12 18 26 16 This Year I

II III IV 16 24 28 18

a. Find a line using regression in Excel.

b. Find the trend and seasonal factors.

c. Forecast sales for next year.

TW-111

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

ISE Operations And Supply Chain Management

ISBN: 9781260575941

16th International Edition

Authors: F. Robert Jacobs, Richard B. Chase

Question Posted: