model are that only a single item is considered, that the entire quantity ordered arrives at one time, that the demand for the item is constant over time, and that nhortages are allowed. Let Dj= annual demand for item j Cj= unit cost of item j Sj= cost per order placed for item j i= inventory carrying charge as a percentage of the cost per unit W= the maximum amount of space available for all goods wj= space required for item j The decision variables are Qj, the amount of item j to order. The model is: Minimize j=1N[CjDj+QjSjDj+iCj2Qj] s.t j=1NwjQjW Qj0j=1,2,N Set up a spreadsheet model for the following data: W=5,000i=0.2 Solve the problem using Excel Solver. Hint: You will need to start with decision variable values that are greater than 0 for Solver to find a solution. If required, round your answers to two decimal places