project

1. Label a tab in EXCEL Problem 1 Matt's Master Photography and complete the following. a. Matt's Master Photography has $6000 available per year for advertising. Newspaper ads cost $100 each and he can afford a maximum of 21 ads annually. Radio ads cost $300 each and he can afford a maximum of 28 annually at this price. Each newspaper ad is estimated to reach 6000 potential customers (brides and families with children), and each radio ad is estimated to reach 8000 potential customers. Of course Matt wants to maximize the number of ad exposures to potential customers. Write the objective function and the system of constraints, then set up a workspace in an Excel program to find the maximum possible number of exposures to potential customers. b. Write a sentence that tells the number of newspaper and radio ads used, the cost, and the number of potential customers reached. c. Create a new tab in EXCEL. labeled Problem I(c) Matt's Master Photograpby and complete the following. What if the available cost is $8,000 ? Since the newspaper ads maximized in the previous constraint conditions, it is decided to let both the radio ads and the newspaper ads be 20; enter these amounts in the cells that maximize these values. Write the new system of constraints, then open the solver menu, and solve with these new constraints. d. Write a sentence that tells the number of newspaper and radio ads used, the cost, and the number of potential customers reached c. Write a short paragraph telling how the constraints may be changed, and how they can affect the value of the variables which optimize the problem. 2. Label a new tab in EXCEL Problem 2(a) Suzanne's Supervisory Service and complete the following. a. Suzanne's Supervisory Services has $12,000 available for advertising. The following table gives the costs per ad and the number of people exposed to its ads for three different media (with numbers in thousands). a. Suzanne's Supervisory Services has $12,000 available for advertising. The following table gives the costs per ad and the number of people exposed to its ads for three different media (with numbers in thousands). How many ads of each type should Suzanne purchase if she wishes to maximize the number of exposures? Set up a workspace in an Excel program and solve the problem. b. In a new tab titled 2(b) work the following: It is determined that a more realistic expectation for media exposure is: 6,000 to the newspaper, 10,000 to the radio, and 8,000 to the TV. Make the change in the optimization function and solve the problem with this new parameter. c. In a new tab titled 2(c) work the following: Another estimate of the expectation for media exposure is: 4,000 to the newspaper, 4,000 to the radio, and 8,000 to the TV. Make the change in the optimization function and solve the problem with this new parameter. d. Write a short paragraph telling how the parameters may be changed, and how they can affect the value of the variables which optimize the problem. 3. Label a new tab in EXCEL. Problem 3 Amir's Asian Deli and Catering and complete the following. Amir's Asian Deli and Catering has only two menus: 1 (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 weck to operate the threefacilities are summarized in the following table; 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