*********PLEASE ANSWER USING EXCEL ONLY, THANK YOU!

Inventory model Inputs Outputs Annual demand 25,000 Optimal order quantity Holding cost per unit $27 Orders/year Set up cost per order $100 Total annual cost What would Set up cost per order have to be to cause Total annual cost to be $7000? Use data table to set up a sensitivity analysis table showing what happens to Orders/year as the setup cost per order goes from 50 to 150. Then graph the results. 430 58 $11,619