apter 15: Materials requirements Planning and ERP arning Activity: When to order the parts that you need? Part 2 of 2 -- Build a Tesla Roadster! 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 MRPI 1d Days 1 2 3 4 5 7 Cars ready for sale -> Lead Time Quantity per next higher assembly (days) Final Assembly (production) 1 Body(orders) 1 Axle assembly (production) 2 m NNE Axle lorders) 18 x fx A B D E F G Days 1 2 3 4 5 Cars ready for sale --> Quantity per next higher assembly Lead Time (days) + Final Assembly (production) 1 Body (orders) 1 3 2 Axle assembly (production) Axle (orders) Wheel (orders) Spare wheel (orders) NHN NN 2 1 1 1 Sales Teslas (on-time) Teslas (late) Backorders Teslas Inventory of Teslas 1 0.5 0.5 Formulas Dald REVIEW VIEW Show/Hide Comment a Translate New Delete Previous Next Comment Show All Comments Hide Ink Protect Protect Sheet Workbook Always Open Read-Only D E F G H 1 M N o P 0 Days 1 2 3 5 6 7 8 9 9 10 11 12 13 Profit or sale -> $ d Time days) Check 1 3 NN 1 1 f Teslas Parts Inventory Body Axe Assembly Ande Week 4 - A-Learning Activity Q - Search Sheet Review View 2+ Share Show Hide Comment Show All Comments Hide ink Sew Delete Previous Next ment Protect Protect Sheet Workbook Always Open Read-Only T V w H L 0 M N 10 Profit (or loss) 11 12 13 $ Check your order! Parts Inventory 1 body Ade Assembly Axle -Wheel Spare wheel 05 0 10 13 12 13 1 2 10 11 12 13 apter 15: Materials requirements Planning and ERP arning Activity: When to order the parts that you need? Part 2 of 2 -- Build a Tesla Roadster! 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 MRPI 1d Days 1 2 3 4 5 7 Cars ready for sale -> Lead Time Quantity per next higher assembly (days) Final Assembly (production) 1 Body(orders) 1 Axle assembly (production) 2 m NNE Axle lorders) 18 x fx A B D E F G Days 1 2 3 4 5 Cars ready for sale --> Quantity per next higher assembly Lead Time (days) + Final Assembly (production) 1 Body (orders) 1 3 2 Axle assembly (production) Axle (orders) Wheel (orders) Spare wheel (orders) NHN NN 2 1 1 1 Sales Teslas (on-time) Teslas (late) Backorders Teslas Inventory of Teslas 1 0.5 0.5 Formulas Dald REVIEW VIEW Show/Hide Comment a Translate New Delete Previous Next Comment Show All Comments Hide Ink Protect Protect Sheet Workbook Always Open Read-Only D E F G H 1 M N o P 0 Days 1 2 3 5 6 7 8 9 9 10 11 12 13 Profit or sale -> $ d Time days) Check 1 3 NN 1 1 f Teslas Parts Inventory Body Axe Assembly Ande Week 4 - A-Learning Activity Q - Search Sheet Review View 2+ Share Show Hide Comment Show All Comments Hide ink Sew Delete Previous Next ment Protect Protect Sheet Workbook Always Open Read-Only T V w H L 0 M N 10 Profit (or loss) 11 12 13 $ Check your order! Parts Inventory 1 body Ade Assembly Axle -Wheel Spare wheel 05 0 10 13 12 13 1 2 10 11 12 13