GSW3CS
2 years ago
1
GSW3CS.docx
CasualFurnitureCaseStudyHomework.xlsx
- GSCM530f9abc-11_11_20247_34PM-transcript1.docx
GSW3CS.docx
The Casual Furniture Company
The Casual Furniture Company (CFC) makes a variety of bookshelves for homes and businesses. The shelves come in various heights, widths, materials, and finishes. Effective requirements planning is essential for CFC’s performance, and it uses MRP for planning.
The MPS and MRP records are shown for one of CFC’s products, part number 4 × 3-01, a four-foot-high and three-foot-wide standard depth oak bookshelf. The BOM as a product structure diagram is shown in Figure 14-19.
FIGURE 14-19 Bookshelf 4 × 3-01 BOM
CFC uses one-week time buckets and a planning horizon of eight weeks. The MPS for the 4 × 3-01 Bookshelf is shown in Figure 14-20.
FIGURE 14-20 MPS Bookshelf 4 × 3-01
Table Summary: Summary
The cabinets are built in the cabinet assembly department and the shelves, backs, sides, and ends are made in the cutting department. The component lot size, lead time, available inventory and safety stock are shown in Figure 14-21. Two associates work in the cutting department, making the available capacity 80 hours per week, without overtime. The processing time for each component in the cutting department is shown in Figure 14-22. Also note that there is a scheduled receipt of 600 brackets in week 1 and a scheduled receipt of 1000 oak sheets in week 1.
FIGURE 14-21 Component Lot Size and Inventory Information
FIGURE 14-22 Cutting Department Processing Time
Questions
1) Develop the MRP for all of the components.
2) During week 1 of the plan, the bracket supplier notifies CFC that the order for 600 units will not arrive as planned. Instead, 300 will arrive this week and 300 will arrive next week, instead of all 600 arriving at the same time. Will this affect production and, if so, to what extent?
3) Now that the plan has been developed, is it feasible to consider the capacity of the cutting department? What recommendations do you have?
4) If you could change the lead times or lot-sizing policies used for any of the components, what changes would you make? Why?
THIS SHOULD BE BASED ON BOOK: Managing Operations Across the Supply Chain BY Morgan Swink. PLEASE ONLY USE THIS BOOK AS YOUR GUIDE (CHAPTER 14)
Please review the transcript attached and use the insights from there to answer all these questions thoroughly. Also, please use the excel sheet to aid with answering (fill in all the information needed).
image1.png
image2.png
image3.png
image4.png
CasualFurnitureCaseStudyHomework.xlsx
Questions
| Casual Furniture Company |
| 1. Develop the MRP for all of the components. |
| 2. During week 1 of the plan, the bracket supplier notifies CFC that the order for 600 units will not arrive as planned. Instead, 300 will arrive this week and 300 will arrive next week, instead of all 600 arriving at the same time. Will this affect production and, if so, to what extent? |
| 3. Now that the plan has been developed, is it feasible to consider the capacity of the cutting department? What recommendations do you have? |
| 4. If you could change the lead times or lot-sizing policies used for any of the components, what changes would you make? Why? |
BOM, MPS, & Lot Sizing
Ch. 14 Case (Casual Furniture)
| Casual Furniture Company Case | ||||||||
| MPS | ||||||||
| Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | |
| Bookshelf 4 x 3-01 BOM | 70 | 70 | 80 | 90 | 60 | 80 | 80 | 70 |
| MRP Record | Part Name: Bookshelf 4 x 3-01 | |||||||
| Lot Size Rule: L4L Lead Time: 0 Available Inventory: 0 Safety Stock: 0 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 |
| Gross requirements | 70 | 70 | 80 | 90 | 60 | 80 | 80 | 70 |
| Scheduled receipts | ||||||||
| Available inventory | ||||||||
| Net requirements | ||||||||
| Planned order receipts | ||||||||
| Planned order releases | ||||||||
| MRP Record: 1 per book shelf | Part Name: Cabinet | |||||||
| Lot Size Rule: L4L Lead Time: 2 weeks Available Inventory: 120 Safety Stock: 0 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 |
| Gross requirements | ||||||||
| Scheduled receipts | ||||||||
| Available inventory | ||||||||
| Net requirements | ||||||||
| Planned order receipts | ||||||||
| Planned order releases | ||||||||
| MRP Record: 1 per Cabinet | Part Name: Back | |||||||
| Lot Size Rule: L4L Lead Time: 1 week Available Inventory: 100 Safety Stock: 0 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 |
| Gross requirements | ||||||||
| Scheduled receipts | ||||||||
| Available inventory | ||||||||
| Net requirements | ||||||||
| Planned order receipts | ||||||||
| Planned order releases | ||||||||
| MRP Record: 2 per Cabinet | Part Name: Side | |||||||
| Lot Size Rule: L4L Lead Time: 1 week Available Inventory: 200 Safety Stock: 0 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 |
| Gross requirements | ||||||||
| Scheduled receipts | ||||||||
| Available inventory | ||||||||
| Net requirements | ||||||||
| Planned order receipts | ||||||||
| Planned order releases | ||||||||
| MRP Record: 2 per Cabinet | Part Name: End | |||||||
| Lot Size Rule: L4L Lead Time: 1 week Available Inventory: 200 Safety Stock: 0 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 |
| Gross requirements | ||||||||
| Scheduled receipts | ||||||||
| Available inventory | ||||||||
| Net requirements | ||||||||
| Planned order receipts | ||||||||
| Planned order releases | ||||||||
| MRP Record: 3 per Bookshelf | Part Name: Shelf | |||||||
| Lot Size Rule: FOQ = 500 Lead Time: 1 week Available Inventory: 300 Safety Stock: 0 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 |
| Gross requirements | ||||||||
| Scheduled receipts | ||||||||
| Available inventory | ||||||||
| Net requirements | ||||||||
| Planned order receipts | ||||||||
| Planned order releases | ||||||||
| MRP Record: 4 per Bookshelf | Part Name: Bracket | |||||||
| Lot Size Rule: FOQ = 600 Lead Time: 1 week Available Inventory: 0 Safety Stock: 0 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 |
| Gross requirements | ||||||||
| Scheduled receipts | ||||||||
| Available inventory | ||||||||
| Net requirements | ||||||||
| Planned order receipts | ||||||||
| Planned order releases | ||||||||
| MRP Record 1 per Back, Side, End, & Shelf | Part Name: Oak Sheet | |||||||
| Lot Size Rule: FOQ = 1,000 Lead Time: 2 week Available Inventory: 500 Safety Stock: 30 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 |
| Gross requirements | ||||||||
| Scheduled receipts | ||||||||
| Available inventory | ||||||||
| Net requirements | ||||||||
| Planned order receipts | ||||||||
| Planned order releases | ||||||||
| Gross requirements = the total amount of an end item that is required | ||||||||
| Scheduled receipts = the quantity that has been ordered but not yet received | ||||||||
| Net requirements = gross requirements minus the sum of scheduled receipts and available inventory at the end of the last period which is the inventory available at the start of the current period. | ||||||||
| When safety stock is needed, the net requirements are calculated based on the gross requirements plus safety stock minus the sum of scheduled receipts and available inventory at the end of the last period (the starting inventory of current period). Of course, if the total of available inventory plus scheduled receipts is greater than the gross requirements, then the net requirements is zero. | ||||||||
| Available inventory is the inventory quantity that is available at the end of a period (see equation 14.1). | ||||||||
| Available inventory at the start of the period + scheduled receipts + planned order receipts - gross requirements | ||||||||
| Planned order receipt = The amount that is planned to arrive at the beginning of a period. | ||||||||
| Planned order release = The amount of an item that is planned to be ordered in a period. |
image1.png
image2.png
image3.png
image4.png
- Sexuality and Development
- MGT415 Group Behavior in Organizations Group Behavior Week 3 Assignment Best Workplace
- Week 3
- BUS 435 Week 5 DQ 1 ( MBO ) ~ 2 Different Answers To Help You Score Better ~ ( Latest Syllabus - Updated Jan, 2015 - Perfect Tutorial - Scored 100% )
- BUS 435 Week 2 Assignment ( Business Concept ) ~ ( Latest Syllabus - Updated Jan, 2015 - Perfect Tutorial - Scored 100% )
- ECE Homework- Single Sideband Generation
- For Essays Guru
- New Bus308 Statistics for Managers
- Developmental psychologists are not interested in
- Part 2 - Humanities Project