2. Warwick and Roberts Ltd. Assemble light chairs for conference venues. Each chair requires a Z-shaped aluminium frame, two padded plastic panels and two aluminium handles. Three screws are used to fasten each padded plastic panel to the Z-shaped aluminium frame and two screws of the same type are used for each aluminium handle. The sales department has produced the following expected orders: Week number Predicted sales 1 60 2 20 3 40 30 4 The current level of stock and ordering information is as follows: Part Z-shaped Opening stock for week 1 Delivery time from placing order with EOQ supplier (weeks) 80 1 40 aluminium frame Padded-plastic 150 1 150 panels Aluminium 170 1 75 handles Screws 350 2 400 Answer the following questions: a. Based on the sales forecast, work out the weekly aggregate demand for each part used in the assembly process. (20 marks) b. Generate the requirements record cards for each part for the four weeks, including the demand, opening stock, orders released, and deliveries received. (20 marks) c. Evaluate whether the current production forecast is realistic. In case any problems are found what might be done to solve them? (10 marks)