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.

... 3. Determine the number of days of the following loan. Loan Date Due Date Number of Days October 20 December 18 (Points : 2). ... (Round to the nearest cent, 2 ...

... N=? Round up to the nearest whole number. 6. You are given the sample mean and the sample standard deviation. ...Round up to the nearest whole number as needed. ...

... of care, rounding to the nearest whole dollar, based upon a five (5) day in-patient stay. (c) Using the aforementioned regression model, predict the number of ...

... b) Complete the statement. (Round to the nearest hundredth.). 11 cm = _____ in. 29. ... 36. Find the five-number summary of the following set of numbers. ...

... (round to the nearest whole number of jobs) Sara Pacheco is a sophomore in college and earns a little extra month by making beaded key ring accessories. ...

...Round your answer to the nearest whole number 2. Casper Energy Exploration reports that the corporation's assets are valued at $184676000, its liabilities are ...

... Learning Resources Be sure to give a word explanation of why Lulu is wrong, and show the correct way to round the number to the nearest hundredth. ...

...Round results to the nearest 0.01 percentage ... n A = compounded interest P = Principle amount r = interest rate t = time (in years) n = number of times in ...

... the number of trades executed for a day in which the number of incoming ... of calls in trades in increments of 100 with results rounded to the nearest 10s place ...