How many drums should be ordered per order to minimize costs

Assignment Help Operation Management

Reference no: EM132120333

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.

Reference no: EM132120333

Questions Cloud

Describe one implementation model : After reading your scholarly resources, describe one implementation model that is significant for the success of policy implementation.

Analyze data from the survey : Submit your 10-item survey and a brief explanation of the survey design used to construct it. Be sure to include the operationalized definitionl.

List and discuss the roles and responsibilities of household : List and discuss the roles and responsibilities of households (individual and family), communities, and NGOs in a public health emergency.

Post an explanation of the process : Post an explanation of the process that you followed in order to provide feedback to your partner.

How many drums should be ordered per order to minimize costs : The oil is only sold in and delivered in 55 gallon drums. How many drums should be ordered per order to minimize costs?

Define relevant aspects of the organization performance : Select one diagnostic model (i.e., 6-box, 7S, congruence, or one of the others) to apply to the chosen companies. Choose the model that you and your team feel

The physical characteristics of a community : The built environment is comprised of entities that form the physical characteristics of a community, including but not limited to buildings, roads.

Need to write a code for connecting segments : Need to write a code for connecting segments (Lines) a special case of TSP. The problem is to connect lines in 2d/ 3d space with path obstructions

Personality to others via symbolic products and services : How do you communicate your personality to others via symbolic products and services? What would this imply about your personality?

User Account

All Pages