Analyze the inventories that are used to produce the Plasti-Brack product line. Determine an appropriate plan for improving the inventory situation. Justify your plan. Write a report to the VP of Operations. Use the Report Template provided.

INVENTORY
Assignment Overview
Case: The Excellent Manufacturing Company & Inventory
Note: Attached- Excellent Manufacturing Company (EMC). You will find information on (A) EMCBackground Information; (B) Product Brochure; (C) Plasti-Brack Information; (D) Manufacturing Processes; (E) Basic Financial Information about EMC; (F) Organizational Chart; (G) Plant Layout
COMPANY EMAIL
FROM: Gerald Garcia
SUBJECT: Inventory Project
I am looking over your productivity and process improvement plan. I can see that you put some effort into it.
I want to put in writing what we discussed the other day about inventory issues in the Plasti-Brack product line. I want you to do a thorough analysis of the inventory situation in the processes that generate these products. I want you to use your expertise and knowledge about inventory operations to determine a plan for improving the flow of the product, holding down inventories and costs, and making sure that we are accurate in our inventory records. Your analysis and plan will be used as a pilot and example for the other product managers to follow. So I am looking for an exemplary report with your plan, recommendations and justification.
Be sure to use the same report template that I provided in the first assignment.
Let me know if you have any questions as you proceed. Thanks.
–GG
*****Assignment
Analyze the inventories that are used to produce the Plasti-Brack product line. Determine an appropriate plan for improving the inventory situation. Justify your plan. Write a report to the VP of Operations. Use the Report Template provided. Consult EMC Financial Info (attached)for COGS and the Notes about Inventory at EMC. ALL IN ATACHMENTS
Assignment Expectations
Use the information provided in the Background readings. It is not necessary to do any additional research.
Review the Notes at the Excellent Manufacturing Company and become familiar with the various inventories for the Plasti-Brack product line.
Analyze the inventories including the raw material inventories, work-in-process, and finished goods. How could you apply the EOQ method? What are the implications of process set-up times?
Determine and discuss other inventory issues that you think are occurring in the processes for the Plasti-Brack product line, i.e., direct and indirect (overhead) costs, inventory turns, inventory accuracy, and inventory storage and movement.
Determine a plan for improving the inventory situation in the Plasti-Brack product line.
Justify your plan based on the concepts of inventory management.
READ the information provided by the resources and references on the Background page. Understand the theory and concept of inventory, inventory turns, EOQ, and Lean.
Study the information about the Plasti-Brack product line and inventories. Understand the EOQ formula and how it can be used to reduce the shop order quantities. Calculate the current Inventory Turns. Estimate how much you can increase turns by using the EOQ. Determine other ways you can improve inventory management.