Q1. TonTon Company manufactures two types of products: type A and type B. The labor and raw material requirements as well as profit for each product are provided in the following table. Profit ($) Product Type A Product Type B Availability (per month) Labor Hour 2 4 800 Raw material 1 (kg) 8 10 no limit Raw material 2 (kg) 4 3 500 2 It is assumed that the amount of products can have fractional values. In order to determine the amount of products that will be produced, Ton Ton has set the following goals. The first goal is the most important goal Goal 2 is considered to be 0.8 times as important as the Goal 1, while Goal 3 is considered to be half as important as the first goal. Goal 1: The monthly profit should be at least $170. Goal 2: No more than 1,000 kgs of raw material 1 should be used per month. Goal 3: At least 55 units of type A should be produced. Formulate this goal programming problem and provide the Excel solution. Q1. TonTon Company manufactures two types of products: type A and type B. The labor and raw material requirements as well as profit for each product are provided in the following table. Profit ($) Product Type A Product Type B Availability (per month) Labor Hour 2 4 800 Raw material 1 (kg) 8 10 no limit Raw material 2 (kg) 4 3 500 2 It is assumed that the amount of products can have fractional values. In order to determine the amount of products that will be produced, Ton Ton has set the following goals. The first goal is the most important goal Goal 2 is considered to be 0.8 times as important as the Goal 1, while Goal 3 is considered to be half as important as the first goal. Goal 1: The monthly profit should be at least $170. Goal 2: No more than 1,000 kgs of raw material 1 should be used per month. Goal 3: At least 55 units of type A should be produced. Formulate this goal programming problem and provide the Excel solution