i really need part d but help with part c would be useful as well

The Old Hickory Furniture Company manufactures chairs on the basis of the BOM shown below. At the present time, the Inventories of parts and lead times are as follows: Chair Leg Seat assembly Back assembly Rails (4) Top Spindles (4) (4) Weeks of Lead Time 2 1 Chairs Leg assembly Back sinembly Rails Tags Top Epindles On Hand 100 50 25 40 100 150 30 80 1 1 2 2 The firm would like to produce 600 chairs in week 5 and 300 chairs in week 6. d. What is the effect of changing the master schedule to 300 chairs in week 5 and 400 chairs in week 6? Answer is complete but not entirely correct. Week Assembly hours required Week 2 Week 3 0 Week 4 0 Week 5 0 X Problem 15-4 (LO 15-3) The Old Hickory Furniture Company... The Old Hickory Furniture Company manufactures chairs on the basis of the BOM shown below. At the present time, the inventories of parts and lead times are as follows: Chair Seat Leg assembly Back assembly Rails Top Spindles Legs (4) Chairs Leg assembly Back assembly Seat Rails Legs Top Spindles On Hand 100 50 25 40 100 150 30 80 Weeks of Lead Time 1 2 1 3 1 1 2 2 The firm would like to produce 600 chairs in week 5 and 300 chairs in week 6. Click here for the Excel Worksheet File Use this file to solve problems a. Develop a materials plan for all the parts using L4L. Enter only the planned order releases for each part. Enter O if there are no planned order releases for a given part in a particular week. Answer is complete and correct. Woek 6 Week 1 0 Planned Order Releases Week 3 Week 4 0 500 300 0 Week 2 0 450 Week 5 300 SIS O 0 0 0 0 0 475 300 0 0 Chairs Log Assembly Back Assembly Seat Rails Legs Top Spindles 460 1.700 1,650 445 DOO 300 1.200 1,200 0 sls oo 0 9 O 0 0 300 0 0 0 0 0 1.200 1,820 b. What actions should be taken now? Seats, rails, legs, tops, and spindles should be ordered immediately. Seats, rails, legs, tops, and spindles should not be ordered immediately. c. Assume it takes one hour to assemble backs, one hour to assemble legs, and two hours to finish completed chairs. Total assembly time for all three types of assembly is limited to 1000 hours per week. Will this capacity constraint cause a bottleneck in assembly? If it does, what can be done? d. What is the effect of changing the master schedule to 300 chairs in week 5 and 400 chairs in week 6? Answer is complete but not entirely correct. Week Assembly hours required 0X Week 2 Week 3 0 Week 4 0 Week 5 0 X