Hi, this is a lab I'm having trouble with! its configured to be in excel. I'm just having trouble getting started with the question and interpreting it.

You have been engaged as a consultant to the chemical company that is evaluating two contractor bids on a site cleanup project.As you would expect, the costs of the processes are related to the percent of impurities that will be removed from the soil.From past experience on the two processes that will be used by the two bidding companies, the chemical company has determined that an estimated cost function for theprocess to be used by Briggs Environmentalis given by the rule cB= [5.2p/(96-p)] +0.15p and the estimated cost for the process used by Jason's Cleanup is given by the rule cJ=[5p/(95-p)] - 0.1p where p is the percent of impurities that will be removed and the cost is in THOUSANDS of dollars.

Note: since p is the percent of impurities removed, it ranges in value from 0 to 100 inclusive.

The CEO of the chemical company would prefer to use the Jason's, since there has beena long standing relationship with them.The problem is that the chemical company must award the contract before the final regulations are available from the DEP on the required level of impurities that must be removed at the site.At this point, the ruling could be anywhere from 87 to 95% removal.

As a consultant, you are to prepare report analyzing the two contractors and their associated cost functions.Your report should describe a decision making method for choosing between the company Briggs and Jason's, recognizing that the CEO of the chemical company favors Jason's; yet the rules on what percent of the impurities must be removed have not as yet be established by the DEP, and the CEO will be fired if the company's costs are excessive.

Your report should be written on the next sheet (entitled "Your Solution") and that is the only sheet you should hand in.Be sure, if it needs more than one page, that your names are on all pages.

1. What interval of values of p should you use?(Pay attention to the second paragraph in the problem description!)(4pts)

2. In column G, make a table of values of p; in column H, make a table of values of the cost function for Briggs; in column I, make a table of values of the cost function for Jason's.Because costs tend to increase as purity increases, pay particular attention (by including more values of p) near the upper end of your interval.Use Excel to draw (via connected scatter-plot) two graphs, one for Briggs cost, one for Jason's. Put the two on the SAME AXIS.Print the graph on one sheet of paper (large)Label axis and give the graph a title. (40pts)

3)What is the limit of the cost of Briggs cleanup as P95 from the left?

----------------------------------------------------------------(3pts)

What is the limit of the cost of Jasons cleanup as p->95 from the left?

-----------------------------------------------------------------(3pts)

3. Whatdo you observe about the Briggs cost function? (10pts)Do not compare to Jasons, just describe the Briggs cost function.

4. What do you observe about Jason's cost function? (10pts)

Do not compare to Briggs, just describe the Jason's

cost function.

5. ( 30 pts.)Based on your observations, what is your recommendation?You must explain the basis for this recommendation.Use some numbers in your explanation.