Analyze the following scenario: Meals for the Homeless buys 30,000 large cans of green beans each year. The cost of each can of beans is $4. The cost to place an order for beans, including the time of the employee placing the order, shipping, and so forth, comes to $20 per order. The out-of-pocket carrying costs (for storage, etc.) are $0.30 per can per year. In addition, Meals calculates its interest at 5 percent. How many cans should be ordered at a time? How many orders should there be each year? What are the total ordering costs and carrying costs at the EOQ? Contrast the total of the ordering costs and carrying costs at EOQ to the total ordering and carrying costs if the cans were all ordered at the beginning of the year. Clearly label the calculations of the economic order quantity using Excel. Use formulas to calculate the EOQ and format the cells to insert a comma if there is more than three numbers. Round to the nearest whole number.

Solution Preview

See the attached file. Thanks

D=Annual Demand 30,000.00 units
Ch=Annual Carrying Cost $0.50 per unit per year
Co=Order Cost $20.00 per order
EOQ = ...

Solution Summary

This solution uses formulas to calculate the EOQ and formats the cells to insert a comma if there are more than three numbers.

1. Find P(3) when p=.70 (round to 5 places)
2. 57% of men consider themselves professional baseball fans. You randomly select 10 men and ask each if he considers himself a professional baseball fan. Find the probability that thenumber who consider themselves baseball fans is (a) exactly 8 (b) at least eight (c) less than 8

The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows
Year Mileage
1 3,100
2 4,000
3 3,500
4 4,000
5 3,700
Forecast the mileage for next year using a 2-year movi

The differences between two sets of dependent data are: -2 , -2 , -16 , -4 , -2. Find SD
Round to thenearest tenth (one decimal place).
See attached file for full problem description.

Math.floor may be used to round a number to a specific decimal place. The statement
y = Math.floor( x * 10 + 0.5 ) / 10;
rounds x to the tenths position (i.e., the first position to the right of the decimal point).
The statement
y = Math.floor( x * 100 + 0.5 ) / 100;
rounds x to the hundredths position (i.e., the se

How do you feel about mathematics now that you have completed MAT 115? Describe some coping mechanisms you developed in MAT 115 that you can use for your next math course.
Example: Find the GCF of 24 and 18
Example: Calculate the area of a circle that has a radius of 8 cm (use 3.14 for pi).
Example: Calculate the area o

1) The spread of a virus in an isolated community is modeled by N(t)=1100/1+49e^-0.3t, where N(t) is thenumber of people infected after t days.
a) Approximately how many people will be infected in 16 days?
___________
b) How long until 900 people have been infected? Round to thenearest day.
_________days
2) Solve

I would like to have the solution to the following sample problems in EXCEL format, so that I can see the formulas used. Thanks.
1. What is the current value of a zero-coupon bond that pays a face value of $1,000 at maturity in 9 years if the appropriate discount rate is 7%.
Please round your answer to thenearest cent.

A frequency distribution is shown below. Complete parts (a) through (e).
Thenumber of dogs per household in a small town.
Dogs 0 1 2 3 4 5
Households 1185 425 163 45 28 15
x P(x)
0
1
2
3
4
5
(a) Use the frequency distribution to construct a probability distribution.
(round to thenearest thousandth as

Need assistance in solving equation;
If the average cost per unit C(x) to produced x units is gievn by:
900
C(x)= -----
x+30
What do 600 units costs? round to round to thenearest cent..
$857.14
$899.95
$180.00
$18,000.00