Statistics Questions Need Excel Spreadsheet Filled Out

/in /by

Statistics Questions Need Excel Spreadsheet Filled Out

I am attaching an Excel Spreadsheet that has all of the things I need to input.  Answers alone will not help me.  I need all of the parts of the equation filled out.  Any answers I put in are probably wrong.

Q 2- The Retread Tire Company recaps tires. The fixed annual cost of the recapping operation is $60,000. The variable cost of recapping a tire is $9. The company charges $25 to recap a tire. a. For an annual volume of 12,000 tires, determine the total cost, total revenue, and profit. b. Determine the annual break-even volume for the Retread Tire Company operation. 
Q-4 

 Evergreen Fertilizer Company produces fertilizer. The company’s fixed monthly cost is $25,000,

and its variable cost per pound of fertilizer is $0.15. Evergreen sells the fertilizer for $0.40 per

pound. Determine the monthly break-even volume for the company.

Q- 12

If Evergreen Fertilizer Company in Problem 4 changes the price of its fertilizer from $0.40 per

pound to $0.60 per pound, what effect will the change have on the break-even volume?

Q – 14

14. If Evergreen Fertilizer Company increases its advertising expenditures by $14,000 per year, w

effect will the increase have on the break-even volume computed in Problem 13?

Chapter 11

Q- 18

The following probabilities for grades in management science have been determined based on past

records:

Grade Probability

A .10

B .30

C .40

D .10

F .10

1.00

The grades are assigned on a 4.0 scale, where an A is a 4.0, a B a 3.0, and so on. Determine the

expected grade and variance for the course.

Q- 26

The weight of bags of fertilizer is normally distributed, with a mean of 50 pounds and a standard

deviation of 6 pounds. What is the probability that a bag of fertilizer will weigh between 45 and 

55 pounds?