is this right so far? how would I get answer to cell with xxxx in it.

Problem 2) Jet Manufacturing Company needs to schodule operations for the next six weeks. Create a Master Schedule including Available-to-Promise (ATP) Inventory for each time period in the scheduling horizon using the following information: Beginning Inventory of 68 units; Forecasted Demand of 30 units per period; Standard Production Quantity of 75 units per lot, and confirmed Customer Orders of 42 units for Week 1,33 units for Wock 2,20 units for Week 3,20 units for Wock 4, 15 units for Week 5, and 12 units for Week 6. Fill in the table with the given information and then complete the entire table by filling it in-filling in the table suffices for showing your work. 12 points Week Week Week Week Week Week 1 2 3 4 5 6 Beginning 68 26 22 25 40 10 Inventory Forecasted Demand 30 30 30 30 30 30 Customer Orders 42 33 20 20 15 12 26 (7) 10 (8) 75 (5) 75 (20) 75 75 Initial Projected On- Hand Inventory Production Schedule Standard Quantity 75 Revised Projected On-Hand Inventory Available-to- Promise Inventory 26 68 67 70 10 55 26 22 25 40 XOCOK