1) An ice cream shop sells single scoop ice cream cones that come in three flavors: chocolate only, vanilla only, and chocolate-vanilla twist. The cones are prepackaged and sold to a supermarket daily. The ingredients used along with the minimum demand of each flavor are shown as follows:

Ice Cream Flavor

Chocolate Vanilla Chocolate-Vanilla

Ingredient:

Chocolate 4 oz. 0 oz. 3 oz.

Vanilla 0 oz. 4 oz. 2 oz.

Min daily demand: 20 scoops 15 scoops 10 scoops

Each day, 40 pounds of chocolate and 38 pounds of vanilla are supplied to the ice cream shop from an outside vendor. The chocolate, vanilla, and chocolate-vanilla twist each yield a profit of $2.00, $2.50, and $3.00 per cone, respectively. How many chocolate, vanilla, and chocolate-vanilla twist cones must prepackage daily to maximize daily profits?

2) A warehouse stocks five different products, A, B, C, and D. The warehouse has a total of 100,000 square feet of floor space available to accommodate all the products that it inventories. The monthly profit per square foot for each product is as follows:

Product Profit per square foot

A $4.50

B $3.00

C $2.75

D $3.75

Each product must have at least 10,000 ft2, and no single product can have more than 25% of the total warehouse space. The warehouse manager wants to know the floor space that should be allocated to each product to maximize profit.

How to use excel solver to do these questions?

Thanks.