Calculate the current cost of imis inventory practices

Assignment Help Supply Chain Management

Reference no: EM131697962

Supply Chain Management Assignment: 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: EM131697962

Questions Cloud

Describe the use of an operating lease : A manager decided to acquire some expensive equipment through the use of an operating lease even though a capital budgeting analysis showed.

Intrinsic and extrinsic rewards employees : Compensation represents both the intrinsic and extrinsic rewards employees receive for performing their jobs.

Categories of incentive pay plans : Briefly describe the three categories of incentive pay plans and give an example of each.

Explain the use of e-commerce shopping carts : Read at least three articles that are no more than 12 months old. Apply the content from the articles to the use of e-Commerce Shopping carts.

Calculate the current cost of imis inventory practices : Calculate the current cost of IMI's inventory practice using CURRENT tab of template provided. Explain difference between this model and IMI's current practice.

Supporting employee learning and development : What do you see as the role of social learning in supporting employee learning and development? How have you engaged in social learning.

Management of statement of cash flows : Management of Statement of Cash Flows, Ethical Issues Fred Jackson, president and owner of Bailey Company, is concerned about the company's ability.

Should fasb require all companies to use the direct method : Form a group with two to four other students, and discuss the merits of the direct and indirect methods. Which do you think investors might prefer?

Future of human resources : 1.Which of the following is likely to be TRUE in the future of human resources?

User Account

All Pages