entire quantity ordered arrives at one time, that the demand for the item is constant over time, and that no shortages 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,000 i=0.3