please solve on Excel step-by-step

Problem 3: 110 trailers of a specific model are required by MT to meet the demand at the beginning of week 6. A trailer requires one bed and one chassis subassembly. A chassis subassembly requires one frame, two axles and four wheels. Five chassis subassemblies, 100 frames, 100 axles, and 200 wheels are available in inventory. 30 Axles are scheduled to arrive in week 2. The purchase lead time for frames, axles, wheels, and beds is one week. Any quantity of chassis between 50 to 120 will require one week to assemble, and 110 trailers will require 2 weeks to assemble. Prepare the material requirements plan for axles. [10 Marks] Trailer Bed (1) Chassis Assembly (1) Frame (1) Axle (2) Wheel (4) Week 1 N 3 4 5 6 Production Schedule Beg. Inv. 0 Quantity 110 Beg. Inv. 1 1 N 3 4 un 6 110 Trailers LT = 2 wks. Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases Beg. Iny. 1 2 3 4 un 6 Chassis (1) LT = 1 wk Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases Beg. Iny. 2. 3 4 5 6. Axle (2) LT = 1 wk. Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases