Answer the two questions ('a' and 'b') below based on the MPS table you completed above (in Question 28). a. What is the total supply (i.e., the total 'actual' quantities of inventory) of the Tricycle 3000 (you units will have available) over the entire planning horizon? b. What is the (as of now) total estimate of un-booked' supply (i.e., ATP inventory quantities) of the end product (Tricycle 3000)? units Questions 28 - 30. Cranstron Inc. manufactures various types of bicycle and tricycle targeting a wide range of ages of customers. Preparing for the next two months' market demand (eight weeks), they are now working on a resource and production planning for the Tricycle 3000, including Master Production Schedule (MPS) and Materials Requirements Planning (MRP) Inventory Records. Complete the MPS table below for the Tricycle 3000, including ATP inventory levels. (For full credit, show your work using a blank sheet to create and fill out the table as shown below, and then upload the completed MPs table back into Canvas.) Master Production Schedule - Tricycle 3000 units Lot Size: 75 Current on-hand inventory = 70 units Lead Time: 2 weeks Week 1 2 3 4 5 6 7 00 Forecast 30 20 35 50 35 35 0 40 Customer orders (booked) 22 30 15 9 0 0 5 3 Projected on-hand inventory MPS quantity MPS start Available- to-promise (ATP) inventory Answer the two questions ('a' and 'b') below based on the MPS table you completed above (in Question 28). a. What is the total supply (i.e., the total actual' quantities of inventory) of the Tricycle 3000 (you will have available) over the entire planning horizon? units b. What is the (as of now) total estimate of un-booked' supply (i.e., ATP inventory quantities) of the end product (Tricycle 3000)? units