Compute the current cost of imis inventory practices

Assignment Help Supply Chain Management

Reference no: EM131699532

Assignemnt: Supply Chain Management: Economic Order Quantity and Safety Stock

A. Based on the Microwave Inventory Case, using the spreadsheet perform a sensitivity analysis and evaluate potential additional benefits focusing in Economic Order Quantity and Safety Stock. See the attached spreadsheet to be fill out. On the spreadsheet perform the following:

1. Calculate the current cost of IMI's inventory practices using the CURRENT tab of the template provided.

2. What would be the potential benefits of selecting both the production batch sizes and the reorder points more scientifically? Do this by completing columns B through H of the ANALYSIS tab of the template provided. Using the concepts of Economic Order Quantity and Reorder Point, explain the difference between this model and IMI's current practice.

3. What if IMI was able to fully standardize the heavy-duty model to the point where the language and power supply customizing features could be added in a modular fashion immediately before shipping to the warehouse that needs them? You consulted with the production superintendent, who indicated that this could be done, but that it would add one day to the ship time to add these customizing features to the standard microwave just prior to shipping.

Consider it this way. IMI maintains a warehouse right next to their factory and they store inventory for models A, B, C, D, E, and F. Therefore they have to maintain separate inventory for each of the models. If they standardize to a single model, it may take them a day to ship, but they only need to keep one type of microwave in their warehouse.
For this part use the SINGLE MODEL column of the ANALYSIS tab and consider the impact RISK POOLING has should IMI combine all models.

Using the inventory concepts we discussed in class, explain to IMI why they might achieve some cost benefit by embracing the idea of replacing all of their models with a single model.

4. Assuming that you have now convinced IMI to standardize on a single model of microwave, investigate other opportunities that IMI may have to reduce costs or improve customer service. Look at the components of total cost (not limited to transportation time, order cost, supply or demand variability) and make a recommendation to IMI on where else they may want to focus their efforts. Justify your recommendations.

5. Perform a sensitivity analysis and evaluate potential additional benefits focusing in Economic Order Quantity and Safety Stock.

6. On the spreadsheet add a column and consider:

• Reducing set-up times
• Reducing production or lead times?
• What about variances

B. Using the information of the spread sheet analyzed the inventory situation.

Based on the spreadsheet summarized results and deliver in form or report.

• what you have discovered
• Draw conclusions and summarize findings
• In what other areas might you invest?

Report shall be professionally structured, well-organized, insightful, start with an executive overview, and conclude by emphasizing the most important parts of the analysis.

Attachment:- Microwave-Inventory-Case.rar

Reference no: EM131699532

Questions Cloud

Does economics indicate that this was surprising : As income transfer programs accompanying the War on Poverty increased beginning in the latter half of the 1960s, what happened to the poverty rate?

Defining leadership : an influence relationship among leaders and followers who intend real changes and outcomes that reflect their shared purpose

Graphically the process of the market forces : Describe conceptually and graphically the process of the market forces that drive the deviant price levels (higher and lower than equilibrium price levels).

What influence did photography have on american culture : What influence did photography have on American culture? Class, can you describe the ascendancy of photography as fine art

Compute the current cost of imis inventory practices : Assignemnt: Supply Chain Management: Compute the current cost of IMI's inventory practices using the CURRENT tab of the template provided.

Government favoritism to allocate investment funds : When the government uses subsidies, tax credits, and other forms of government favoritism to allocate investment funds

Indicate the bolt arrangement with a sketch : Select the number and arrangement of 3 4 -in. -diameter A325-N high-strength bolts required to resist an axial tensile load of 150 kips for the butt joint.

Diagram depicting a firm cost-minimizing choice : Draw a simple isocost/isoquant diagram depicting a firm's cost-minimizing choice of labor and capital.

Discuss costs of early childhood programs : A prosctive parent wants to know why the cost of your preschool center is so much more than the one down the street

User Account

All Pages