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
ISE Operations And Supply Chain Management
ISBN: 9781260575941
16th International Edition
Authors: F. Robert Jacobs, Richard B. Chase
Question Posted: