What is the expected exposure on the lost profits claim

Assignment Help Applied Statistics

Reference no: EM131921761

a. Create a histogram of the weekly operating profits from the prior year of operation, using 6 equal sized bins. What is the mode on the histogram? How would you define it? Which probability distribution does the histogram resemble? (You may wish to use the Excel file Harvey's Case.xls at the Gateway web site.)

b. What was the average weekly profit for the prior 12-month period? Determine and define the variance and standard deviation of weekly profit.

c. How confident are you of this estimate? Calculate a 99% confidence interval for weekly profits, assuming that sigma is unknown. What does this tell you about weekly profits?

d. Based on the above, what is the expected exposure on the lost profits claim? To formally test Mr. Cooper's claim, test to see if there was a significant difference in mean weekly profits between the first 6 months of the year and the last 6 months. Use a 0.05 significance level and assume equal variances.

Does this support Mr. Cooper's claim? b. Having thought about Mr. Cooper's suggestion, you consider several options as an estimate of lost profits.

These include

1) the full year,

2) the last six months only,

3) a weighted average that gives twice the weight to the last six months as to the first six months, or

4) some other weighted average.

Which method do you think gives the most accurate estimate of lost profits?

Attachment:- harveys-tree-farm-data.xls

Reference no: EM131921761

Questions Cloud

Create a graph of your table results : Create a one-way table to show the sensitivity of profit to the variable cost per unit. (You must use Excel Data Table function for this)

Which form or forms of conflict were displayed : Which of the causes listed in the book were at the root of the conflict? Which form or forms of conflict were displayed?

What is return on equity : Suppose a firm’s EBT is $3 million and its tax rate is 35%. If the current price of the firm’s shares is $25, what is the return on equity?

Define and explain the significance of entities : What are the problems of managing data resources in a traditional file environment and how are they solved by a database management system?

What is the expected exposure on the lost profits claim : what is the expected exposure on the lost profits claim? To formally test Mr. Cooper's claim, test to see if there was a significant difference in mean weekly

Why does retained earnings have opportunity cost : Why does retained earnings have an opportunity cost? Shouldn't these be cost free funds for the firm to invest? Explain.

Discuss about the mrp planning schedule : Indicate the correct net requirements, planned order receipts, and planned order releases to meet the gross requirements.

Wayang kulit and dance repertoire : Describe the types of instruments used in a Gamelan ensemble. How does this music compare with the Western styles of music you have

Develop an analysis of the investments : Develop an analysis of these three investments in Excel. Use expected value to determine which of the three alternatives you should choose.

User Account

All Pages