****USE EXCEL PROBLEM SOLVER***

**PLEASE SHOW ALL FORMULAS AND CONSTRAINTS**

The Happy Wanderers Division of Block C Enterprises has decided to add chocolate candy to its list of snack foods offered in its stores. To insure freshness, these candies will be manufactured daily in the store and will be sold in one pound packages. The types of candies to be sold will include plain chocolate, half & half chocolate with peanuts, half & half chocolate with cashews, half & half chocolate with coconut, half & half chocolate with raisins, half & half chocolate with caramels and a deluxe mix consisting of equal parts of chocolate, cashews, raisins and caramels. In addition, the peanuts, cashews, raisins and caramels will be sold in one pound packages. At the present time, the available capacity and the purchase cost for each ingredient are as follows: INGREDIENT CAPACITY COST CHOCOLATE PEANUTS CASHEWS COCONUT RAISINS CARAMELS 210 POUNDS PER DAY 150 POUNDS PER DAY 120 POUNDS PER DAY 60 POUNDS PER DAY 200 POUNDS PER DAY 100 POUNDS PER DAY $0.40 $0.80 $2.40 $1.00 $0.60 $0.40 Initially, the prices for each variety with chocolate will be $8.00, the varieties with cashews will be $14.00 and the individual packages of peanuts, raisins and caramels will sell for $6.50. Calculate the number of pounds of each variety of chocolate should be produced? Market analysis has shown that sales will be improved if the minimum daily capacity for each variety is 20 pounds. How does this change the solution