Statistics Questions Need Excel Spreadsheet Filled Out

Oct 25th, 2014
Anonymous
Category:
Engineering
Price: \$40 USD

Question description

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:

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?

(Top Tutor) sameer_09
School: UCLA

Studypool has helped 1,244,100 students

Review from student
Anonymous
" Outstanding Job!!!! "

1825 tutors are online

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors