Use The Bill Of Materials And Inventory Records To Determine

Use The Bill Of Materials And Inventory Records To Determine The Quant

Use the bill of materials and inventory records to determine the quantity of purchased items necessary to assemble 20 end items if the manufacturer uses lot-for-lot ordering. There are no end items currently on hand, and none of the components have any scheduled receipts. (50 points) Component On-hand Component On-hand A 5 D 15 B 75 E 3 C 10 F 20 END ITEM A(2) C(2) B(2) D(2) B(3) F(2) E(1) Name Title Name Title Name Title Name Title Name Title Name Title Team Title Name Company Name Company Name Department Name END ITEM A(2) C(2) B(2) D(2) B(3) E(1) F(2)

Paper For Above instruction

Introduction

Effective inventory management is critical in manufacturing, especially when striving to meet production goals while minimizing costs. This paper demonstrates how to determine the quantities of components to purchase for producing a specified number of end items using the bill of materials (BOM) and inventory records, assuming lot-for-lot ordering. The case study involves calculating procurement needs for 20 units of an end product, considering no initial stock and no scheduled receipts of components.

Understanding Bill of Materials and Inventory Records

The bill of materials (BOM) provides a detailed list of components required to assemble one unit of the end product. Inventory records indicate the current stock levels of each component. Together, these tools assist in determining purchasing requirements based on the production volume and existing inventory.

In this scenario, the BOM specifies the components and quantities needed per unit:

- A: 2 units

- C: 2 units

- B: 2 units

- D: 2 units

- E: 1 unit

- F: 2 units

The initial inventory levels are:

- A: 5

- B: 75

- C: 10

- D: 15

- E: 3

- F: 20

Since there are no scheduled receipts or beginning inventory for end items, procurement calculations focus solely on the BOM and current stock levels.

Calculation Methodology

Lot-for-lot ordering involves purchasing exactly the amount of components needed for the immediate production order, minimizing excess inventory.

The total component requirements for 20 end items are calculated as:

- A: 20 units * 2 = 40 units

- C: 20 * 2 = 40 units

- B: 20 * 2 = 40 units

- D: 20 * 2 = 40 units

- E: 20 * 1 = 20 units

- F: 20 * 2 = 40 units

Subtracting the current inventory from these totals indicates the purchase quantities:

| Component | Required for 20 units | Current Inventory | Purchase Needed |

|-------------|-------------------------|---------------------|-----------------|

| A | 40 | 5 | 35 |

| B | 40 | 75 | 0 |

| C | 40 | 10 | 30 |

| D | 40 | 15 | 25 |

| E | 20 | 3 | 17 |

| F | 40 | 20 | 20 |

Accordingly, the manufacturer must purchase:

- 35 units of A

- 0 units of B (already sufficient)

- 30 units of C

- 25 units of D

- 17 units of E

- 20 units of F

This calculation ensures exact component quantities required for 20 end items without excess, aligned with the principles of lot-for-lot ordering.

Implications for Manufacturing and Inventory Control

This approach supports lean inventory practices by preventing overstocking of components. It emphasizes the importance of accurate BOM and inventory data for effective procurement. Additionally, this method facilitates cash flow management and reduces carrying costs.

However, reliance on lot-for-lot ordering can risk stockouts if demand fluctuates or delays occur. Therefore, companies might consider safety stock levels or periodic review procedures to buffer against variability.

Conclusion

Using the BOM and inventory data, manufacturers can precisely determine procurement needs for assembly. For producing 20 units of the end product, the required purchase quantities are 35 A, 0 B, 30 C, 25 D, 17 E, and 20 F, leveraging lot-for-lot ordering to minimize excess inventory. This process exemplifies efficient inventory management, balancing production demands with optimal stock levels, thereby supporting cost-effective manufacturing operations.

References

  • Heizer, J., Render, B., & Munson, C. (2020). Operations Management (13th ed.). Pearson.
  • Jacobs, F. R., & Chase, R. B. (2018). Manufacturing Planning and Control for Supply Chain Management (7th ed.). McGraw-Hill Education.
  • Chopra, S., & Meindl, P. (2016). Supply Chain Management: Strategy, Planning, and Operation (6th ed.). Pearson.
  • Nelson, W., & Dailey, A. (2014). Fundamentals of Manufacturing Management. Wiley.
  • Wilson, J. M. (2019). Inventory Management: Principles, Concepts, and Techniques. Routledge.
  • Rushton, A., Croucher, P., & Baker, P. (2014). The Handbook of Logistics and Distribution Management. Kogan Page.
  • Stevenson, W. J. (2021). Operations Management. McGraw-Hill Education.
  • Bowersox, D. J., Closs, D. J., & Cooper, M. B. (2019). Supply Chain Logistics Management. McGraw-Hill Education.
  • Martin, J. (2017). Lean Inventory Management Techniques. Journal of Supply Chain Management.
  • Cheng, T. C. E. (2018). Practical Inventory Management. Wiley.

Related Assignments