y. They will build these stores in one of three sizes for each location - a convenience store (open 24 hours), standard store, and an expanded services store. The convenience store requires $4.125 million to build and 30 employees to operate. The standard store requires $8.25 million to build and 15 employees to operate. The expanded-services store requires $12.375 million to build and 45 employees to operate. The corporation can dedicate $82.5 million in construction capital, and 300 employees to staff the stores. On the average, the convenience store nets $1.2 million annually, the standard store nets $2 million annually, and the expanded services store nets $2.6 million annually. How many of each should they build to maximize revenue? Formulate the model for this problem in excel. Let X1 = # of convenience store X2 = # of standard store X3 = # of expanded-services store 2. A diet chart shows calories, protein, carbohydrate and fat content for four food items below. Sara wants a diet with minimum cost. The diet chart is as follows: Food Item 1 Food Item 2 Food Item 3 Food Item 4 Calories 400 200 150 500 Protein (in grams) 3 2 0 0 Carbohydrates ( in grams) 2 2 4 4 Fat (in grams) 2 4 1 5 Cost $0.50 $0.20 $0.30 $0.80 The chart gives the nutrient content as well as the per-unit cost of each food item. The diet has to be planned in such a way that it should contain at least 1,250 calories, 8 grams of protein, 10 grams of carbohydrates and 8 grams of fat. Formulate the model for this problem in excel. Let X1 = Food Item 1 X2 = Food Item 2 X3 = Food Item 3 X4 = Food Item 4