Please Complete ASAP

For each problem: a. Define the decision variables for this problem, write the objective function and constraints. ( b. Set up an Excel worksheet and save it as an Initial worksheet. c. Complete the solver parameters, solve the problem, save the final worksheet and the answer report. (5) d. Write the quantity of wood products and the maximized profit. 1. You are an owner or manager of a production facility that is capable of producing three products, tables, chairs, and desks. From your employees and accountants, you have collected the following information: All three products are required to be processed on two machines, Machines A and B. Time required to process the three products on the machines is listed below: Customers generally like to buy 4 or more chairs with a table; therefore, you would like to produce at least 6 chairs per table. (30) 2. A senior class of 420 students want to run buses and vans for a class trip to Hyundai Car Manufacturing plant. Each bus can transport 50 students plus 3 chaperones and cost $1200 to rent. Each van transports 10 students and I chaperone and cost $100 to rent. There are 36 chaperones. How many vehicles of each type should you rent to minimize the total cost. (30) 3. A factory is currently producing two products: Danish cookies and animal crackers. The price to produce the cookies and the crackers are different due to the processing of the shapes. Each Danish cookie costs 4 cents to make, and each animal cracker costs 5 cents to make. This factory has $100,000 to spend making cookies and crackers this month. Cookies and crackers are made in batches of 1,000 each. For every 100 cookies produced, Danish cookies have 1 bad cookie, and for every 100 crackers produced, animal crackers have 3 bad crackers. These bad products are removed during the manufacturing process. The factory must make at least 10,000 quality cookies and 10,000 quality crackers this month. The products are each packaged and sold in bags of one dozen. Danish cookies sell for $8/ dozen and animal crackers sell for $9/ dozen. What is the maximum possible monthly profit this company can make? (40) For each problem: a. Define the decision variables for this problem, write the objective function and constraints. ( b. Set up an Excel worksheet and save it as an Initial worksheet. c. Complete the solver parameters, solve the problem, save the final worksheet and the answer report. (5) d. Write the quantity of wood products and the maximized profit. 1. You are an owner or manager of a production facility that is capable of producing three products, tables, chairs, and desks. From your employees and accountants, you have collected the following information: All three products are required to be processed on two machines, Machines A and B. Time required to process the three products on the machines is listed below: Customers generally like to buy 4 or more chairs with a table; therefore, you would like to produce at least 6 chairs per table. (30) 2. A senior class of 420 students want to run buses and vans for a class trip to Hyundai Car Manufacturing plant. Each bus can transport 50 students plus 3 chaperones and cost $1200 to rent. Each van transports 10 students and I chaperone and cost $100 to rent. There are 36 chaperones. How many vehicles of each type should you rent to minimize the total cost. (30) 3. A factory is currently producing two products: Danish cookies and animal crackers. The price to produce the cookies and the crackers are different due to the processing of the shapes. Each Danish cookie costs 4 cents to make, and each animal cracker costs 5 cents to make. This factory has $100,000 to spend making cookies and crackers this month. Cookies and crackers are made in batches of 1,000 each. For every 100 cookies produced, Danish cookies have 1 bad cookie, and for every 100 crackers produced, animal crackers have 3 bad crackers. These bad products are removed during the manufacturing process. The factory must make at least 10,000 quality cookies and 10,000 quality crackers this month. The products are each packaged and sold in bags of one dozen. Danish cookies sell for $8/ dozen and animal crackers sell for $9/ dozen. What is the maximum possible monthly profit this company can make? (40)