solution

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 Lot Size: 75 units

Current on-hand inventory = 70 units Lead Time: 2 weeks

Week	1	2	3	4	5	6	7	8
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

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?

b. What is the (as of now) total estimate of ‘un-booked’ supply (i.e., ATP inventory quantities) of the end product (Tricycle 3000)?