Purchase Solution

Inventory Management for workbooks: EOQ, holding costs

Not what you're looking for?

Ask Custom Question

Please use the attached excel worksheet to answer the problem.

William Beville's computer training school, in Richmond, stocks workbooks with the following characteristics:

Demand D = 19, 500 units/year
Ordering cost S = $25/order
Holding cost H = $4/unit/year

a) Calculate the EOQ for the workbooks.

b) What are the annual holding costs for the workbooks?

c) What are the annual ordering costs?

Attachments
Purchase this Solution
Solution Summary

Solution explains Inventory Management for workbooks: EOQ, holding costs, ordering costs

Solution Preview

Kindly refer to the attached file.

Demand D = 19, 500 units/year 
Ordering cost S ...

Purchase this Solution
Free BrainMass Quizzes
Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

View More Free Quizzes
Related BrainMass Solutions

  • Problems on ABC analysis for inventory control, EOQ

    Calculate the EOQ for the workbooks b. What are the annual holding costs for the workbooks c.

  • EOQ for Workbooks and Annual Holding Costs

    b- What are the annual holding costs for the workbooks? c- What are the annual ordering costs? Please see the attached file. The expert calculates EOQ for workbooks and annual holding costs.

  • EOQ Model

    b) What are the annual holding costs for the workbooks? c) What are the annual ordering costs? a) EOQ = SQRT(2DS/H) D = Annual Demand S = Ordering Cost , H = Holding Cost = SQRT(2*19500*25/4)= 494 Units (Rounded).

  • Joe Henry's machine shop: Inventory problem

    What is average inventory holding cost? C. Given EOQ, how many orders would be made each year? What would be the annual costs D. What is total annual cost of managing the inventory? E. What is the time between order. F.

  • Inventory Management

    or 148 bottles per order Average inventory=EOQ/2=148/2=74 units Annual holding costs=Average inventory*holding costs(H)=74*8=$ 592 (No. of orders=Annual demand/EOQ=2500/148=16.89 orders Annual ordering cost=No. of orders*ordering cost(S)=16.89

  • Inventory Management

    81153 Inventory Management A store has collected the following information on one of its products (10 pts): Demand = 10,000 units/year Standard deviation of weekly demand = 25 units Ordering costs = $30/order Holding costs = $4/unit/year

  • Manufacturing and Services of Southeastern Bell

    please provide references The response addresses the query posted in 743 words with APA references // Inventory management tools such as economic order quantity (EOQ), annual holding costs, annual ordering costs and the reorder point have been calculated

  • Support EOQ: Hospital Glove Simulation (UOP)

    Lot size vs. the EOQ and the inventory costs Operations Management - Inventory Management (Program) Simulation Solutions GBAM Page 10 of 10 Economic order quantity is the lot size that minimizes total annual inventory holding and ordering costs.

  • Inventory Management - Ordering and Inventory

    166369 Inventory Management - Ordering and Inventory The Bozo Co is reviewing their inventory management techniques and have come up with the following data on their inventory.

View More Related Solutions