what are the sum functions, and solver supposed to look like?

Page Layout Formulas Data Review View Tell me Insert v ) V 11 ' ' ab ce General WE 480 X Delete a. Av .00 V C 8 % ) Conditional Format Cell Formatting as Table Styles Format v Sort & Filter Find & Select B D E F G . tics Total Budget $40.000 Total storage size (cu. ft.) 500 Platter-of-Plenty Classic-Cup Three-Column-Regal Previous Wholesale Current Wholesale Retail Price Profit Platter-of-Plenty Classic-Cup Three-Column-Regal Existing Customer Orders Platter-of-Plenty Classic-Cup Three-Column-Regal Storage requirement (cu.ft.) Provide solutions by adhering to the Spreadsheet Design Guidelines; at the very least, use color to indicate decision variables, objective functions, and constraints Be sure to include Solver analysis specific to the problem you are solving. Be sure to provide enough detail to convey understanding . . 1. Bin Packing Variant Medal Winner is the general manager of AwardCo. Medal received information from Trinity's Trophy Warehouse about special dealer pricing on selected team trophies. The Platter-of-Plenty, which usually costs $123 wholesale, is now $110. The Classic-Cup, which usually costs $248 wholesale, is now $229. The famed Three-Column-Regal, which usually costs $417 wholesale, is now $385. It seems like a great opportunity to stock up on some fast-moving trophies to increase profit! Medal received a report of the retail prices of each item: The Platter-of-Plenty has a retail price of $220; there are 46 existing customer orders. The Classic-Cup has a retail price of $325; there are 24 existing customer orders. Finally, the Three Column-Regal has a retail price of $525; there are 18 existing customer orders. Medal only has a small storage area in the back of his storefront. His order must fit in 500 cubic feet of storage space. From his inventory, Harold learns that each Platter-of-Plenty requires 1.5 cubic feet of storage space. Each Classic-Cup requires 2.75 cubic feet of storage space and each Three-Column-Regal requires 3.5 cubic feet of storage space. Given Medal's total budget of $40,000, how many trophies should he order? IMPORTANT HINT: You must constrain your variables to integers