please use Word

Question 10 10 pts Resource Planning Complete the Projected on Hand Inventory and Planned Order Release rows. 3 4 5 12 2 10 20 15 20 25 45 ItemA Gross Requirements Scheduled Receipts Projected on Hand Inventory | 25 Planned Order Releases 35 Q = 15, LT = 1; SS = 15 Upload the question with your answer in a file, acceptable file formats are: Excel and Word Upload Choose a File Forecasting Based on the information shown below, Month Actual Demand 770 Jan Feb Mar 820 920 Apr May 880 840 Jun 905 a. Develop forecasts for March to July using a 2-period weighted moving average model (w1 = 0.80.2 -0.20). b. Calculate MAD, and MSE using the data from March to June. Upload the question with your answer in a file, acceptable file formats are: Excel and Word