Round to the nearest whole number
Not what you're looking for?
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.
Purchase this Solution
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.
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 = ...
Purchase this Solution
Free BrainMass Quizzes
Basics of Economics
Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.
Economic Issues and Concepts
This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.
Elementary Microeconomics
This quiz reviews the basic concept of supply and demand analysis.
Pricing Strategies
Discussion about various pricing techniques of profit-seeking firms.
Economics, Basic Concepts, Demand-Supply-Equilibrium
The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.