1.

Please help excel solver keeps giving me an error

A manufacturer of baby cereals is test-marketing a new product next month, and requires 300 boxes made to specification. The firm plans to purchase the boxes from a number of small paper processors with whom it has dealt in the past, and has requested each of these suppliers to submit a bid. Nine suppliers have responded. Each has specified the maximum order quantity it can deliver by the beginning of next month, and to guarantee themselves some profit in the event that less than a break-even quantity is ordered, each has specified a setup charge. The bids are given in the table below. Decide how many boxes should be ordered from each supplier. Variable cost Supplier: Setup Cost Max order quantity Per box #1 Intal 200 $1+ 2 #2 Applo 225 $1+ 2 #3 Cicso 250 $1+ 0 #4 Tasle 275 $2+ 2 #5 Geegle 300 $2+ 2 #6 Fecabook 325 $2+ 6 #7 Amazen 300 $3+ 7 #8 Nutflix 250 $3+ 0 #9 Micronsot 200 $3+ 9 Build an Excel Solver model to solve the above problem. Keep your solver inputs in the excel file