Find a line using regression in excel

Assignment Help Operation Management
Reference no: EM132783673

Please complete in Microsoft Excel for the parts of the questions indicated below and please provide a thorough explanation/solutions and provide Microsoft Excel attachment. Keep in mind I am novice with Microsoft Excel and still learning the software as well. Thank you so much!

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: EM132783673

Questions Cloud

What effects did changing political and religious regimes : Gordon Childe identified social stratification and occupational specialization, which included specialists in religion, politics, and administration.
Describe the target market : Describe the target market for your chosen company, Demographic Description: Age, income range, gender, family size, education, occupation, et cetera.
Describe two or three challenges organizations : Describe two or three challenges organizations might face when implementing quality standards.
Review and develop new organisational values : Describe the steps required to review and develop new organisational values.
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
What amount of sales revenue will be reported : The company keeps no work in process inventory. What amount of sales revenue will be reported on the 2018 budgeted income statement
What company is a leader in sustainability : What is operations & supply chain management? What are some cool jobs that involve O&SCM?
Identify the style of the work of art : Assume you have been given the ability to travel back in time, and you are about to set off on a trip to the nineteenth and twentieth centuries.
What is the after-tax income : Expenses for the year are $615,000, and it claims $135,000 in depreciation expenses. What does it pay in taxes, and what is its after-tax income?

Reviews

Write a Review

Operation Management Questions & Answers

  Product design problem

When Billie Aherne learned that the government was soliciting contracts for the manufacture of microcomputer components, she read the solicitation carefully. What happened? What mistake did Billie make in terms of the new venture? How could this prob..

  Could the total quality lead have responded differently

Mark, Donna, and their children, along with another family, traditionally attended Easter brunch at a large downtown hotel. This year, as in the past, Donna called and made a reservation about three weeks prior to Easter. Were the hostess’s actions c..

  What are the strengths of your approach

What strategy will you use and why? What are the strengths of your approach? What immediate things will you need to focus on to actualize this strategy? What will you need to focus on in the longer term?

  Increase local sales taxes to fund street repairs

A political campaign organization is supporting a proposed initiative that will increase local sales taxes to fund street repairs.

  Describe the legal systems involvement

Describe what capacity evaluations are, what purpose they serve, who is responsible for performing them, and what role they play in the healthcare system.

  General goals of organization compensation system

Discuss the general goals of an organization's compensation system, including how a compensation strategy works to support the organization's business strategy.

  How can southwest implement this proposal successfully

Also, how can southwest implement this proposal successfully? from the point of view of finance, marketing, and Human resources?

  Used to encourage or deter imported goods and materials

Write a 3 page paper reviewing one precise example of a governmental action that was used to encourage or deter imported goods and materials.

  Which areas would you target for improvement and why

Consider the maturity level of the Project Management processes and practices in your current or a previous organization.

  Name the four major ethical principles of medical care

Name the four major ethical principles of medical care.

  What is the risk priority number

Design FMEA has been applied to a new ignition switch for a company’s line of riding lawn mowers. It has been concluded that failure severity (S) is 4, probability of occurrence (O) is 6, probability of detection (D) is 8. What is the Risk Priority N..

  How merger going to create value in a weak fashion market

Coach is buying Kate Spade for $2.4 Billion. How is the merger going to create value in a weak fashion market? How has the growth of e-commerce affected.

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