Part 1 of 2 -- Build a table First, let's practice a simple problem: Build ONE basic table to have it ready to sell on Day 7. Compute when you'll need to procure each component. Enter the quantity in the right cell. The Day 7 sale is already done for for. Then, go to the next sheet to build a Tesla! Note: None of the items have lot-size requirements nor safety stock. Day 1 Demand 2 3 4 5 6 7 8 9 10 11 12 13 Tables 1 Orders 1 Tables Top Legs 1 4 Bill of Materials Table Procurement Lead Time Top 2 days Legs 3 days Top (1) Legs (4) Production Lead Time Table 1 day 1 day 1 day Learning Activity: When to order the parts that you need? Part 2 of 2 -- Build a Tesla Roadster! 3 days Note: See table below for list of items, quantities and days as shown visually here. Compute a MRP plan to build 50 Roadsters for sale on day 10. Your plan will automatically compute Revenues and Costs. You will make the most profit by optimizing your inventory with a correct MRP! 2 days 1 day 2 days Days 1 2 3 4 5 6 7 8 9 10 11 12 13 Profit (or loss ) $ Cars ready for sale --> Quantity per next higher assembly Lead Time (days) Check your order! Final Assembly (production) 1 1 3 2 2 Body (orders) Axle assembly (production) Axle (orders) Wheel (orders) Spare wheel (orders) 1 2 2 1 1 1 Sales Teslas (on-time) Teslas (late) - Backorders Teslas