I need the answer in Excel with the formulas showing please. my ID # is 80081519.

Thanks!

For problem3, compute "X" adding all the digits of your ID number Example: ID number 81123456 X=8+1+1+2+3+4+5+6 = 30 3. Excelsior Springs Ltd. schedules production of one end product, Hi-Sulphur, in batches of 70 units whenever the projected ending inventory balance in a period falls below 7 units. It takes one period to make a batch of 70 units. Excelsior currently has "2X" units on hand. The sales forecast for the next 5 periods is given in the following table (25 points) 0 1 30 15 2 30 7 3 30 6 3 4 40 Period 5 6 40 40 1 45 Forecast Orders Projected Available Balance Available to promise MPS 2x Prepare a time-phased MPS record for Hi-Sulphur. DELL