Find a line using regression in excel

Assignment Help Operation Management
Reference no: EM132783660

Please put in Microsoft Excel format as needed and please provide thorough explanations and solutions/answers and attach a Microsoft Excel file. Thank you!

Tuscon Machinery, Inc. manufactures numerically controlled machines, which sell for an average of $0.5 million each. Sales for these NCMs for the past two years were as follows:

Quarter Quarter Quarter

Last Year Quantity (Units) This Year Quantity (Units)

1 12 I 16

II 18 II 24

III 26 III 28

IV 16 IV 18

a. Find a line using regression in Excel.

b. Find the trend and seasonal factors.

c. Forecast sales for next year.

Reference no: EM132783660

Questions Cloud

What is the principal message of capital asset pricing model : What is the principal message of the Capital Asset Pricing Model (CAPM)? What are its assumptions? What is Beta? Is high beta good or bad for a company?
How types of legislation can affect business : Explain how types of legislation (eg Equal Employment Opportunity) can affect business operations and workplace relationships.
Provide measurements and identify critical to quality : Continuing with your last report, you will provide measurements and identify critical to quality (CTQs),
What is the probability of having 4 of more people : -What is the probability of having 4 of more people in the system and therefore running out of room? Again, you must show your calculations.
Find a line using regression in excel : Tuscon Machinery, Inc. manufactures numerically controlled machines, which sell for an average of $0.5 million each. Sales for these NCMs for the past two years
Record the transactions about covington ltd : Record the above transactions. Covington Ltd. was incorporated as a private company on January 2, 2018, and is authorized to issue an unlimited
How many gallons of paint must you start : How many gallons of paint must you start with to have 4800 gallons of paint that can be sold?
Discusses management role-style or approach : Conduct a web search seeking a current article that discusses a management role, style, or approach.
Which is true of a? network : Which is true of a? network? It allows different computers to share the same information. / It connects a? computer's hardware to the software

Reviews

Write a Review

Operation Management Questions & Answers

  Types of ethics issues and related violations

Now that you have a feel for the types of ethics issues and related violations that at times (hopefully infrequently) arise,

  Developing the organic juicing company

Imagine you are developing the organic juicing company with retail stores and a franchising system in San Antonio, Texas.

  Describe multiplicity of relationship between two classes

Describe the multiplicity of a relationship between two classes and give an example.

  Apply operations management techniques to increase profits

Brandon's computer shop has hired a consultant to help apply operations management techniques to increase profits. Currently the shop sells most of its computers to a high-end customized online retailer and sales are steady at 250 per mth. what is th..

  Does the stock price determine the direction of netflix

Based upon Netflix 2014 Annual Report Form 10-k filings, review and analyze Netflix key strategies. Describe what type of competitive advantage Netflix is currently pursuing? Is the strategy short- or long-term? Why? Does the stock price determine th..

  Police investigated numerous serious crimes committed

Mr. Property Management owned the Chalmette Apartments. Over a two-year period, police investigated numerous serious crimes committed at the apartment complex.

  Was there in your judgment anything morally objectionable

Was there in your judgment anything morally objectionable in Princeton's hiring of Singer in this position?

  Container store focus on employee motivation case study

What are the lessons learned in the Acuity Insurance and the Container store focus on Employee motivation case study?

  The detailed method should only be used on large dollar bids

Any one of the seven techniques for cost analysis may be used to fulfill the requirement for cost analysis. Commercial items are exempt from the requirements for cost or pricing data and CAS. The burden of proof for reasonableness of cost is always o..

  Describes several approaches to dealing with stress

The text describes several approaches to dealing with stress and ways to support psychological hardiness.

  Write a minimum of a four-page biography on older adult

Write a minimum of a four-page biography on older adult. Explain How the knowledge gained? would assist you in working with older adults?.

  Setting up information desk manned by one employee

A new shopping mall is considering setting up an information desk manned by one employee.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd