QUESTION 2 [45 pts] You are scheduling production of your popular Rustic Coffee Table. The table requires a top, four le

[answerhappygod]

Question 2 45 Pts You Are Scheduling Production Of Your Popular Rustic Coffee Table The Table Requires A Top Four Le 1 (198.55 KiB) Viewed 47 times

QUESTION 2 [45 pts] You are scheduling production of your popular Rustic Coffee Table. The table requires a top, four legs, 1/8 gallon of stain, 1/16 gallon of glue, 2 short braces between the legs and 2 long braces between the legs, and a brass cap that goes on the bottom of each leg. You have 100 gallons of glue in inventory, but none of the other components. All items except the brass caps, stain, and glue are ordered on a lot-for-lot basis. The caps are purchased in quantities of 1,000, stain and glue by the gallon. Lead time is 1 day for ach item. COFFEE TABLE Top Glue Base Assembly Legs Short braces Long braces Brass Caps a) Schedule the order releases necessary to produce 640 coffee tables on days 5 and 6, and 128 on days 7 and 8. (See Appendix A1.) b) Using the data for coffee table, build a labor schedule when the labor standard for each top is 2 labor hours; each leg including brass cap installation requires %4 hour, as does each pair of braces. Base assembly requires 1 labor-hour, and final assembly requires 2 labor- hours. What is the total number of labor-hours required each day, and how many employees are needed each day at 8 hours per day? (See Appendix A2.) 2/3 APPENDICES A1. Example MRP Form Lead Lot Time On Safety Allo-Low- Item Time Hand Stock cated Level ID Code Size 1 periods) Stain A2. Labor schedule table Hrs Lead Coffee Table Master Schedule Required Time Table Assembly Top Preparation Assemble Base Long Brace (2) Short Brace (2) Leg Total Hours Employees need @ 8 hrs. each 2 SBY 201 BAT Gross Requirements. Scheduled Receipts Projected On Hand Net Requirements 5 Planned Order Receipts Planned Order Releases Gross Requirements Scheduled Receipts Projected On Hand Net Requirements Planned Order Receipts Planried Order Releases) Gross Requirements Scheduled Receipts Projected On Hand Net Requirements Planned Order Receipts Planned Order Releases Gross Requirements Scheduled Receipts Projected On Hand Net Requirements Planned Order Receipts Planned Order Releases Gross Requirements Scheduled Receipts Projected On Hand Net Requirements Planned Order Receipts Planned Order Releases Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Day 8 A YUK 3 KA www Period (week, day) 4 5 6 7 3/3 8