Please help me for the question 4.3 that refer the value of sales forcase in question 4.2(solved).

I need to see the table which have been calculated both of the production plan and the inventory and I've already knew the concept about 2 questions of 4.2 and 4.3. Could you please help me fill in the value as the attached pic table? Thank you in advance.

June Sep July 7097 Aug 6516 Oct 6187 Nov 6132 6401 96 SOP Sales forecase(cases) Production Plan Inventory Working days Capacity(Shipping cases) Utilization NRG-A(cases) NRG-B(cases) 22 7333 0 18 6000 20 6667 23 7667 20 6667 0 Dec Remark 5987 Refer from Question 4.2 Need Answer 96 from June in Question 4.2 17 Need Answer 5667 is Working day 333.33 ols Production Plan/Capacity 100 is 0.7"Prodction Plan is 0.3* Production Plan 0 ololo ololo Ooo Ooo Exercise 4.3 Using the Fitter sales forecast for July through December that you created in Exercise 4.2, develop a spreadsheet for sales and operations planning for those same months. Use the format of the spreadsheet shown in Figure 4-5. The number of working days for each month is shown in Figure 4-13. For your production plan, try to keep the capacity utilization at 95 % or less. To disaggregate the plan for the group into plans for NRG-A and NRG-B bars, use 70 % of sales for NRG-A bars and 30 percent for NRG-B bars. Aug. July 22 Sept. 20 Oct. 23 Working Days Nov. 20 Dec. 17 18 Figure 4.13 The number of working days at Fitter Snacker, July through December 42 Sales and Operations Planning Dec. May Jan. 5906 5906 100 Feb. 5998 5998 100 100 Sales and operations planning 1) Sales forecast 2) Production plan om producten olen 3) Inventory 4) Working days 5) Capacity (shipping cases) 6) Utilization 7) NRG-A (casos) 70.0% 8) NRG-B (cases) 30.0% 21 20 March 6061 6061 100 23 7666 79% 4243 1818 April 6318 6318 100 21 6999 90% 4423 1895 June 7128 6950 96 22 7333 95% 4865 2085 6476 6650 274 21 6999 95% 4655 1995 6666 6999 84% 4134 1772 00% 4199 1799