3. a. Amir's Asian Deli and Catering has only two menus: I (Ceylonese) and II (Bengali). He prepares these at three different facilities: A (the Avenues), B (Bountiful), and C (Cottonwood). The production capacities and costs per week to operate the three facilities are summarized in the following table: 400 II Cost/week A 200 100 $1000 B 200 200 $3000 100 $4000 How many weeks should each facility operate to fill Amir's orders at a minimum cost, and what is the minimum cost? Set up a workspace in an Excel program and solve the problem. B C 1 A Variables 2 3 #of weeks @ Facility A (A) 4 # of weeks @ Facility B (B) 5 # of weeks @ Facility C (C) 7 Objectives 8 9 Minimum Cost 10 11 Constraints 12 13 Menu I Ceylonese 14 Menu II Bengali 15 Cost per week Amount used Minimum 2000 1200 b. Write a short paragraph telling how minimizing constraints changes the problem. 3. a. Amir's Asian Deli and Catering has only two menus: I (Ceylonese) and II (Bengali). He prepares these at three different facilities: A (the Avenues), B (Bountiful), and C (Cottonwood). The production capacities and costs per week to operate the three facilities are summarized in the following table: 400 II Cost/week A 200 100 $1000 B 200 200 $3000 100 $4000 How many weeks should each facility operate to fill Amir's orders at a minimum cost, and what is the minimum cost? Set up a workspace in an Excel program and solve the problem. B C 1 A Variables 2 3 #of weeks @ Facility A (A) 4 # of weeks @ Facility B (B) 5 # of weeks @ Facility C (C) 7 Objectives 8 9 Minimum Cost 10 11 Constraints 12 13 Menu I Ceylonese 14 Menu II Bengali 15 Cost per week Amount used Minimum 2000 1200 b. Write a short paragraph telling how minimizing constraints changes the