i really need answer d but help with c is welcome

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 Legs Top Spindles 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. Week 1 Planned Order Releases Week 3 Woek 4 0 500 300 0 Wook 6 300 Week 6 0 Week 2 0 450 0 SIS DI 0 0 0 0 0 300 475 0 0 460 Chairs Log Assembly Back Assembly Seat Rails Legs Top Spindles 0 0 olololo 0 0 0 0 1,700 1,650 445 ol 300 1.200 1,200 300 1,200 0 0 0 0 0 0 0 0 0 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 0 x 0 Week 2 Week 3 Week 4 0 X Week 5 0 X