Develop a regression model to predict costs

Reference no: EM131401664

Chips:

A start-up company has developed an improved electronic chip for use in laboratory equipment. The company needs to project the manufacturing cost, so it develops a spreadsheet model that takes into account the purchase of production equipment, overhead, raw materials, depreciation, maintenance, and other business costs.

The spreadsheet estimates the cost of producing 10,000 to 200,000 chips per year, as seen in the table. Develop a regression model to predict Costs based on the Level of production.

Chips Produced (1000s)	Cost per Chip ($)
10	146.1
20	105.8
30	85.75
40	77.02
50	66.1
60	63.92
70	58.8
80	50.91
90	47.22
100	44.31
120	42.88
140	39.05
160	37.47
180	35.09
200	34.04

Reference no: EM131401664

Questions Cloud

Problem regarding the financial markets : Why did the u.s government help the bear sterns but the Lehman brothers go bankrupt, which caused a freeze in the financial markets, not only domestically but also internationally?

What are the characteristics for the three different bonds : How does atoms bind with each other? What are the characteristics for the three different bonds studied in class? What is pH? What is the normal pH of blood? How does or body regulates the pH of our blood?

Debt security determine the size of its term premium : What characteristics of a debt security determine the size of its term premium?

Describe the shape of the yield curve : Describe the shape of the yield curve if investors think that short-term interest rates are likely to increase in the future. Why does the yield curve have this shape?

Develop a regression model to predict costs : The spreadsheet estimates the cost of producing 10,000 to 200,000 chips per year, as seen in the table. Develop a regression model to predict Costs based on the Level of production.

What is meant by vertical and horizontal conflicts : BSBWOR502 LEAD AND MANAGE TEAM EFFECTIVENESS. List 15 different actions you would take to assist in the resolution of conflict. What is meant by vertical and horizontal conflicts? What is meant by constructive and destructive conflicts

Determining the comparable default risk : Why is the interest rate on a security sold by a city government usually less than the interest rate on a security sold by a corporation if both have comparable default risk?

Expected future interest rates on short-term bonds : Explain why investors might compare the interest rate on a long-term bond with the expected future interest rates on short-term bonds

What is me stock price today : a) What is ME's stock price today? b) What is ME's stock price in twenty years from now?

User Account

All Pages