Question 1 A manufacturer makes two products: A and B. Each of them must go through a process with 3 steps. More specifically, each unit of A requires 5 hours of drilling, then 2 hours of bolting, and finally 1 hour of painting. Each unit of B on the other hand needs 2 hours of drilling, then 1 hour of bolting, and 2 hours of painting. In each week, there are 2000 hours of drilling, 1000 hours of bolting, and 3000 hours of painting available. Each unit of A earns a profit of 1000 dollars and each unit of B earns a profit of 2000 dollars. The manufacturer needs to decide how many units of each product to make to maximize its weekly profit. Each unit of A earns a profit of 1000 dollars and each unit of B earns a profit of 2000 dollars. The manufacturer needs to decide how many units of each product to make to maximize its weekly profit. Create two worksheets in Excel. Name the first sheet as "Math" and put down the math model in it. Name the second sheet as "Solver". In the second sheet, translate the Math model to Excel model and use Solver to find the optimal solution. Attach Excel file here. A candidate for mayor in a small town is figuring out how to arrange her last-minute advertising in the days preceding the election. Two types of ads will be used: radio and online. Each radio ad costs $500 and reaches an estimated 1,000 senior people and 500 non-senior people (e.g., young people). Each online ad costs $1200 and reaches an estimated 1000 seniors and 3,000 non-seniors. The campaign manager needs to decide the number of radio ads and the number of online ads so that the total cost of ads is minimized while at the same time at least 100,000 seniors and at least 150,000 non-seniors are reached. Create two worksheets in Excel. Name the first sheet as "Math" and put down the math model in it. Name the second sheet as "Solver". In the second sheet, translate the Math model to Excel model and use Solver to find the optimal solution. Attach Excel file Create two worksheets in Excel. Name the first sheet as "Math" and put down the math model in it. Name the second sheet as "Solver". In the second sheet, translate the Math model to Excel model and use Solver to find the optimal solution. Attach Excel file here. Question 1 A manufacturer makes two products: A and B. Each of them must go through a process with 3 steps. More specifically, each unit of A requires 5 hours of drilling, then 2 hours of bolting, and finally 1 hour of painting. Each unit of B on the other hand needs 2 hours of drilling, then 1 hour of bolting, and 2 hours of painting. In each week, there are 2000 hours of drilling, 1000 hours of bolting, and 3000 hours of painting available. Each unit of A earns a profit of 1000 dollars and each unit of B earns a profit of 2000 dollars. The manufacturer needs to decide how many units of each product to make to maximize its weekly profit. Each unit of A earns a profit of 1000 dollars and each unit of B earns a profit of 2000 dollars. The manufacturer needs to decide how many units of each product to make to maximize its weekly profit. Create two worksheets in Excel. Name the first sheet as "Math" and put down the math model in it. Name the second sheet as "Solver". In the second sheet, translate the Math model to Excel model and use Solver to find the optimal solution. Attach Excel file here. A candidate for mayor in a small town is figuring out how to arrange her last-minute advertising in the days preceding the election. Two types of ads will be used: radio and online. Each radio ad costs $500 and reaches an estimated 1,000 senior people and 500 non-senior people (e.g., young people). Each online ad costs $1200 and reaches an estimated 1000 seniors and 3,000 non-seniors. The campaign manager needs to decide the number of radio ads and the number of online ads so that the total cost of ads is minimized while at the same time at least 100,000 seniors and at least 150,000 non-seniors are reached. Create two worksheets in Excel. Name the first sheet as "Math" and put down the math model in it. Name the second sheet as "Solver". In the second sheet, translate the Math model to Excel model and use Solver to find the optimal solution. Attach Excel file Create two worksheets in Excel. Name the first sheet as "Math" and put down the math model in it. Name the second sheet as "Solver". In the second sheet, translate the Math model to Excel model and use Solver to find the optimal solution. Attach Excel file here
