Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. tucson machinery, incorporated, manufactures numer

Tucson Machinery, Incorporated, manufactures numerically controlled machines, which sell for an average price of $12.0...

80.2K

Verified Solution

Question

Finance

Tucson Machinery, Incorporated, manufactures numerically controlled machines, which sell for an average price of $12.0 million each. Sales for these NCMs for the past two years were as follows: Use Exhibit 3.10.

QUARTER LAST YEAR QUANTITY (UNITS) QUARTER THIS YEAR QUANTITY (UNITS)
I 12 I 18
II 18 II 24
III 26 III 28
IV 16 IV 21

A.

Find the equation of a simple linear regression line using Excel.

Note: Round your answers to 3 decimal places.

Y= + T

B.

Compute trend and seasonal factor from a linear regression line obtained with Excel.

Note: Do not round intermediate calculations. Round your answers to 3 decimal places.

Period Trend Forcast Seasonal Factors
Last Year 1
2
3
4
5
This year 1
2
3
4
5

C.

Forecast sales for next year using the above seasonal factors.

Note: Do not round intermediate calculations. Round your answers to 2 decimal places.

Period Forecast(Units)
Next year 1
2
3
4

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students