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 a Find a line using regression in Excel b Find the trend and seasonal factors c Forecast sales for next year QUARTER QUANTITY (UNITs) QUANTITY (UNITS) QUARTER Last Year This Year 12 18 26 16 16 24 28 18 I3D II IV II IV

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

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) QUANTITY (UNITS) QUARTER Last Year This Year 12 18 26 16 16 24 28 18 I3D II IV II IV

a. Find a line using regression in Excel.

b. Find the trend and seasonal factors.

c. Forecast sales for next year.

QUARTER QUANTITY (UNITs) QUANTITY (UNITS) QUARTER Last Year This Year 12 18 26 16 16 24 28 18 I3D II IV II IV

Step by Step Solution

★★★★★

3.42 Rating (165 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

A to c Within Excel two methods can be used to compute the intercept and slope from a regression mod... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

287-B-M-L-S-C-M (1619).docx

120 KBs Word File

Students Have Also Explored These Related Management Leadership Questions!

a company purchased 10,000 pounds of raw materials at a cost of $2.50 per pound. However, the standard price per pound was $2.00. 1. Calculate the direct materials price variance. 2. Determine if...

The following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year. Use time series...

Becker Tools sold 32,400 hammers at an average price of $15.10 in Year 1 and 27,450 hammers at an average price of $15.50 in Year 2. What was the percent change from Year 1 to Year 2 in: a. The...

Daniels Consulting provides consulting service at an average price of $120 per hour and incurs variable cost of $60 per hour. Assume average fixed cost are $3900 a month. Requirements 1. What is the...

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. Use Exhibit...

Exhibit 18.10 Computing a Seasonal Factor from the Actual Data and Trend Line 700 600 500 400 300 200 100 1 1 II HE IV 1 1 1 II IV -2011 + -2012 Seasonal factor (average of same quarters in both...

TIME SENSITIVE 1h 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...

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: Use Exhibit...

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: Use Exhibit...

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: Use Exhibit...

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: Use Exhibit...

Suppose SSC has decided to distribute $50 million, which it presently is holding in very liquid short-term investments. SSCs value of operations is estimated to be about $1,937.5 million. SSC has...

Why do consumers pay twice as much for Bayer aspirin than for generic aspirin when they know that the two are chemically identical?

Question 5 ( 2 points ) What principle states that natural processes operate the same now as in the past? Empiricism Deductive reasoning Uniformitarianism Catastrophism

The directors of Mylo Ltd are currently considering two mutually exclusive investment projects. Both projects are concerned with the purchase of new plant. The following data are available for each...

Reconsider part (c) of Problem 6-1. Use the regression model to generate response surface and contour plots of the tool life response. Interpret these plots. Do they provide insight regarding the...

An Otto cycle engine has a total displacement of 0.0040 m3. Its compression ratio is 9.0. It is fueled with gasoline having a specific heating value of 45,500 kJ/kg. Its mass air-to-fuel ratio is...

The prices of different house types in south-east England are given in the table below: (a) If the numbers of each type of house in 1991 were 1898, 1600, 1601, 499 and 1702 respectively, calculate...

It is often useful to perform a sensitivity analysis, where you show how your estimate of intrinsic value varies according to different estimates of D 1 , r s , and g. To do so, recalculate your...

SPECIAL CASE ANALYSIS Go to Case 10.3, Wagner v. Columbia Pictures Industries, Inc., 146 Cal.App.4th 586, 52 Cal.Rptr.3d 898 (2 Dist.2007),on pages 226-227.Read the excerpt and answer the following...

What feature in project management information systems can be used to resolve overallocation of project resources?

What was the first major project management information system that is now commonly used for managing very large projects?

What type of chart compares the current project schedule with the original baseline schedule so that deviations from the original plan can be easily noticed?

Old MathJax webview Rick Sanchez (Player 1) wants to conduct an experiment on Morty Smith (Player 2), but Morty is not agreed to it. Hence Rick is trying to catch Morty and Morty is hiding from Rick....

QUESTION 1 Organisational integration happens when a company's internal and external factors successfully mesh. Every company, large or small, has certain internal characteristics such as management...

The present value of $1 invested at the end of each year for n years is $10. The present value of $1 invested at the end of each year for 2n years is $12. Calculate i. (use a percentage number,...