The purpose of this assignment is to employ linear optimization techniques, interpret results, and determine optimal solutions for business problems. Using specified data files, chapter example files, and templates from the “Assignment Files” topic material, complete Problems below. Use Microsoft Excel’s Solver Add-In to complete these problems. For each of these problems, run the Solver’s Answer and Sensitivity Reports. Interpret and summarize the key results.25. A chemical company manufactures three chemicals: A, B, and C. These chemicals are produced via two production processes: 1 and 2. Running process 1 for an hour costs $400 and yields 300 units of A, 100 units of B, and 100 units of C. Running process 2 for an hour costs $100 and yields 100 units of A and 100 units of B. To meet customer demands, at least 1000 units of A, 500 units of B, and 300 units of C must be produced daily. (Use 25 tempate.xlsx)A. Use Solver to determine a daily production plan that minimizes the cost of meeting the company’s daily demands.28. During the next four months, a customer requires, respectively, 500, 650, 1000, and 700 units of a commodity, and no backlogging is allowed (that is, the customer’s requirements must be met on time). Production costs are $50, $80, $40, and $70 per unit during these months. The storage cost from one month to the next is $20 per unit (assessed on ending inventory). It is estimated that each unit on hand at the end of month 4 can be sold for $60. Assume there is no beginning inventory. (Use 28 tempate.xlsx)A. Determine how to minimize the net cost incurred in meeting the demands for the next four months.31. For a telephone survey, a marketing research group needs to contact at least 600 wives, 480 husbands, 400 single adult males, and 440 single adult females. It costs $3 to make a daytime call and (because of higher labor costs) $5 to make an evening call. The file 31 template.xlsx lists the results that can be expected. For example, 30% of all daytime calls are answered by a wife, 15% of all evening calls are answered by a single male, and 40% of all daytime calls are not answered at all. Due to limited staff, at most 40% of all phone calls can be evening calls.A. Determine how to minimize the cost of completing the survey. 32. A furniture company manufactures tables and chairs. Each table and chair must be made entirely out of oak or entirely out of pine. A total of 15,000 board feet of oak and 21,000 board feet of pine are available. A table requires either 17 board feet of oak or 30 board feet of pine, and a chair requires either 5 board feet of oak or 13 board feet of pine. Each table can be sold for $800, and each chair for $300. (Use 32 tempate.xlsx)A. Determine how the company can maximize its revenue.37. A company that builds sailboats wants to determine how many sailboats to build during each of the next four quarters. The demand during each of the next four quarters is as follows: first quarter, 160 sailboats; second quarter, 240 sailboats; third quarter, 300 sailboats; fourth quarter, 100 sailboats. The company must meet demands on time. At the beginning of the first quarter, the company has an inventory of 40 sailboats. At the beginning of each quarter, the company must decide how many sailboats to build during that quarter. For simplicity, assume that sailboats built during a quarter can be used to meet demand for that quarter. During each quarter, the company can build up to 160 sailboats with regular-time labor at a total cost of $1600 per sailboat. By having employees work overtime during a quarter, the company can build additional sailboats with overtime labor at a total cost of $1800 per sailboat. At the end of each quarter (after production has occurred and the current quarter’s demand has been satisfied), a holding cost of $80 per sailboat is incurred. (Use 37 tempate.xlsx)a. Determine a production schedule to minimize the sum of production and inventory holding costs during the next four quarters.To receive full credit on the assignment, complete the following. Ensure that all Solver settings are defined through the use of the Solver dialog box. Ensure that Excel files include the associated cell functions and/or formulas if functions and/or formulas are used. Include a written response to all narrative questions presented in the problem by placing it in the associated Excel file. Include Answer and Sensitivity Reports interpretation and summary of key results. Place each problem in its own Excel file. Ensure that your first and last name are in your Excel file names.