part a

Please answer the following questions. Share screenshots from your work on Excel and/or graphs or other work and email the Excel files as well. This must be your own work only. This is due on December 6th by 11:59 pm EST. Conducting an Apple focus group survey The marketing group for Apple plans to conduct a telephone survey to determine consumer attitudes toward a new cell phone that is currently under development. In order to have a sufficient sample size to conduct the analysis, they need to contact at least 300 young males (under age 40), 140 older males (over age 40), 200 young females (under age 40), and 250 older females (over age 40). It costs $2.4 to make a daytime phone call and $3.20 to make an evening phone call (due to higher labor costs). This cost is incurred whether or not anyone answers the phone. The table below shows the likelihood of a given customer type answering each phone call. Assume the survey is conducted with whoever first answers the phone. Also, because of limited evening staffing, at most one-third of phone calls placed can be evening phone calls. How should the marketing group conduct the telephone survey so as to meet the sample size requirements at the lowest possible cost? a. Formulate and solve a linear programming model for this problem on a spreadsheet.(do excel) b. Formulate this same model algebraically. c. Use the graphical method by hand to solve this model. (ch 2 apply max / min) Please answer the following questions. Share screenshots from your work on Excel and/or graphs or other work and email the Excel files as well. This must be your own work only. This is due on December 6th by 11:59 pm EST. Conducting an Apple focus group survey The marketing group for Apple plans to conduct a telephone survey to determine consumer attitudes toward a new cell phone that is currently under development. In order to have a sufficient sample size to conduct the analysis, they need to contact at least 300 young males (under age 40), 140 older males (over age 40), 200 young females (under age 40), and 250 older females (over age 40). It costs $2.4 to make a daytime phone call and $3.20 to make an evening phone call (due to higher labor costs). This cost is incurred whether or not anyone answers the phone. The table below shows the likelihood of a given customer type answering each phone call. Assume the survey is conducted with whoever first answers the phone. Also, because of limited evening staffing, at most one-third of phone calls placed can be evening phone calls. How should the marketing group conduct the telephone survey so as to meet the sample size requirements at the lowest possible cost? a. Formulate and solve a linear programming model for this problem on a spreadsheet.(do excel) b. Formulate this same model algebraically. c. Use the graphical method by hand to solve this model. (ch 2 apply max / min)