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 Les Sent assembly Back assembly Rails 4) Leps Top Spindles (4) Weeks of Lead Time 1 1 Chairs Leg annembly Back assembly Seat Rat Lego Top Spindies On Hand 100 SO 25 40 100 150 30 1 1 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 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 but not entirely correct. Week 1 0 0 Week 5 0 0 Week 6 0 0 0 Chairs Leg Assembly Back Assembly Sent Rais Legs Top Spindles Planned Order Releases Week 2 Week 3 Week 4 0 0 0 03 03 0 0 03 o 03 0 0 03 0 0 03 0 0 0 % 0 0 0 D 0 0 03 0 03 03 03 0 0 0 0 D o 0 0 0 0