please show the work and equations

Using the gross requirements schedule below", prepare an alternative ordering system that always orders 100 units the week prior to a shortage (a fixed order quantity of 100). What is the cost of this ordering system? 2 3 4 5 6 7 Period 1 Gross requirements 25 8 0 9.10 30 55 20 40 0 10 50 30 *Holding cost = $1/unit/week; setup cost = $200; lead time = 1 week; beginning inventory = 25 units. Prepare a net requirements plan (enter your responses as whole numbers). 1 2 3 4 5 6 7 8 9 10 25 20 40 0 10 50 30 0 30 55 25 Period Gross requirements On-hand at beginning of period On-hand at end of period Net requirements (Insert O for negative values) Order receipt Order release I DI II III The holding cost of this ordering system is $(enter your response as a whole number). The setup cost of this ordering system is $(enter your response as a whole number). The cost of this ordering system is $(enter your response as a whole number)