Write an equation that predicts the total cost

Assignment Help Financial Management

Reference no: EM131989267

Solve Using an Excel Spreadsheet:

You work for a company that builds environmentally controlled inventory storage facilities for electronic parts.

All the facilities you have built in the past are listed in the table below.

Assuming no inflation, write an equation that predicts the total cost of one of your storage facilities.

The objective is to produce a reasonable model that fits the existing data with an R 2 > 0.95.

("Reasonable" in this case excludes anything greater than a 3rd order polynomial.)

Floors	Gross Floor Area (ft²)	Perimeter (ft)	Total Cost
2	600	200	$2,084,440
3	500	103	$1,703,1715
1	1000	800	$3,659,600
4	1435	450	$6,158,784
1	2000	179	$5,341,878.5
2	600	98	$1,800,574
3	780	74	$2,295,105
4	1400	500	$6,347,960
1	600	196	$1,800,574
2	3000	219	$8,248,677
3	600	600	$4,032,540
4	4000	800	$14,638,400
1	600	100	$1,666,990
2	400	234	$1,669,782
3	2540	700	$9,390,006
4	600	500	$4,310,840

Reference no: EM131989267

Questions Cloud

Managing and completing a Marketing Research Plan for Nike : With these steps for the research outline for Nike - Define the research objective: What is your hypothesis? Define the marketing situation

What is the implied risk-free rate : The prices of European call and put options on a non-dividend-paying stock with an expiration date in 12 months and a strike price of $120 are $20 and $5.

What is their yield to maturity : They pay a dollar100 annual common and have a 15-year maturity, but they can be called in 5 years at dollar1.125.

What was the effective annual interest rate being applied : If the bank paid interest based on monthly compounding, what was the effective annual interest rate being applied to Sonia's money?

Write an equation that predicts the total cost : You work for a company that builds environmentally controlled inventory storage facilities for electronic parts.

How many kanbans would be needed in each case : How many kanbans would be needed in each case? a. Demand is increased to 200 circuit boards per hour. b. The lead time for components is increased to 30 minutes

What is included in taxpayers gross estate : What is included in Taxpayer's gross estate if Taxpayer dies two years after the conveyance, but Sister has paid the post-transfer premiums?

How determined each item that affected adjusted gross income : Write a letter to Carmin explaining how you determined each item that affected adjusted gross income and any items you excluded from gross income.

Fmla time off from his job to care for partner : Jared requested FMLA time off from his job to care for his partner, Samuel, who was suffering from a particularly acute case of adult mumps.

User Account

All Pages