Ordered each time to minimize inventory costs

Assignment Help Operation Management

Reference no: EM132121771

As an inventory control manager, you are responsible for determining purchase quantities for commodities used in the plant. One such item is a specialty machine oil. You pay 5 $/gal for this oil when it is purchased. Storing the oil costs your company 25% of unit cost per year. Ordering costs average 10 $/order. Each year the company uses about 500 gallons. Determine:

a) How many gallons (EOQ) should be ordered each time to minimize inventory costs.

b) The oil is only sold in and delivered in 55 gallon drums. How many drums should be ordered per order to minimize costs? Hint: Determine TC for full drum quantity above and below the EOQ quantity. Choose the lower TC.

c) Using a spreadsheet, make a graph of order cost, carry cost, and total cost versus quantity ON ONE CHART. Identify all three cost curves in the legend box, label all axes and titles, include major gridlines for both vertical and horizontal grids, use a quantity range from 15 to 130 units incrementing by 5 units (i.e., x values starting at 15, then 20, 25, 30, 35, etc, to 130). Also, use spreadsheet tools to put an unfilled circle around the intersection of the carry costs and the order costs.

d) What impact (determine by percentage) will the purchasing of the oil in 55 gallon drums as compared to the cost if using an EOQ quantity (when making the comparison, only use the pertinent TC’s, do not use TIC’s).

Reference no: EM132121771

Questions Cloud

How strong are the industry competitive forces : “How Strong Are the Industry’s Competitive Forces?”

What is the average inventory of handbooks : How many days of demand will be supported by this order quantity? What is the average inventory of handbooks?

Strategically relevant factors in the macro-environment : “What Are the Strategically Relevant Factors in the Macro-Environment?” and “What Are the Five External Factors that impact the Company?”

Prepare a report to comment on the suitability of ABB : HA2011 Managerial Accounting Assignment, Holmes Institute, Australia. our group is required to prepare a report to comment on the suitability of ABB

Ordered each time to minimize inventory costs : How many gallons (EOQ) should be ordered each time to minimize inventory costs.

Choice over the consumption of two goods : Assume that the government distributes some stamps that are good to buy 5 units of good x.

Explain your business E-commerce processes : To explain your business E-commerce processes. How it will look likes in terms of design and format (draft).

When talking about economics and the history of it : When talking about Economics and the history of it. For the past recessions the U.S. has had

In thinking about organization with which you are familiar : In thinking about an organization with which you are familiar, can you give examples of the Human Relations or Human Resources approaches being used?

User Account

All Pages