$\backslash$table$[[,$Beg. Inv,Safety Stock,Usage Week $1,$Usage Week $2],[,$Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday$],[$Part $1,200,500,0,400,400,400,200,0,0,0,400,400,400,400,0,0],[$Part $2,100,400,400,0,400,0,400,0,0,300,0,300,0,300,0,0],[$Part $3,400,400,200,400,200,400,400,0,0,200,300,300,300,300,0,0],[$Part $4,300,300,0,300,300,300,400,0,0,0,400,400,300,300,0,0],[$Part $5,600,800,600,600,500,600,600,500,0,500,500,500,600,500,500,0],[$Part $6,400,500,500,500,300,500,400,400,0,500,400,400,400,400,500,0],[$Part $7,700,900,800,200,400,400,500,400,0,700,200,500,500,500,0,0],[$Part $8,500,600,800,400,600,400,400,0,0,700,300,500,400,500,0,0],[$Part $9,900,800,900,700,800,800,800,600,0,1000,800,900,800,700,0,0],[$Part $10,0,100,0,0,500,0,0,0,0,0,500,0,0,0,0,0],[$Total$,4100,5300,4200,3500,4400,3800,4100,1900,0,3900,3800,4200,3700,3900,1000,0]]$

Guidelines

Don't miss a shipment

Plan neec. to cover a minimum of the shipments and be up to safety stock levels by Monday of Week $2$ and by the end of Week $2$

Conditional formatting $-$ indicates a condition where your beginning inventory does not cover the shipment

Your total build for the each day is based on $4000$ units per day $(2000$ units per shift; Monday through Friday, $2$ shifts $-$ Saturday is up to you $-$ you can schedule one shift or two as long as other criteria are met; you may also schedule Sunday as long as other criteria are met$)$

NOTE: Working Sundays is very costly$-$double pay for employees $-..$

The Beginning Inventory cannot exceed $9300$ units total, including the end of week $2$

You need to schedule in increments of $100$ units for each part number