1.Create a regression model in excel using the below data Data: Toyota Corolla: 2800, 1.8L, 28 (city), 37 (HWY) Hyundai Elantra: 2773, 1.8L, 27, 37 Chevy Cruze: 3084, 1.8L, 25, 36 Ford Focus: 2932, 2.0L, 26, 35 Dodge Dart: 3186, 2.0L, 25, 36 Volkswagen Jetta: 3025, 1.4L, 28, 39 Nissan Sentra: 2832, 1.8L, 27, 36 Mazda3: 2799, 2.0L, 29, 41 Kia Forte: 3836, 1.8L, 25, 37 Mistubishi Lancer: 2888, 2.0L, 25, 34 First number is the weight, the second number is the engine litter size, the third number is the MPG for city, the fourth number is the MPG for highway. 2. The Weinberger Electronics Corporation manufactures four highly technical products that it supplies to aerospace firms that hold NASA contracts. Each of the products must pass through the following departments before they are shipped: wiring, drilling, assembly and inspection. The time requirement in hours for each unit produced and its corresponding profit value are summarized in the following table: Use Excel QM Department Product Wiring Drilling Assembly Inspection Unit profit XJ201 0.5 0.3 0.2 0.5 9 XM897 1.5 1 4 1 12 TR29 1.5 2 1 0.5 15 BR788 1 3 2 0.5 11 The production available in each department each month, and the minimum monthly production requirement to fulfill contracts, are as follows: Department Capacity (hours) Product Minimum Prod. Level Wiring 15,000 XJ201 150 Drilling 17,000 XM897 100 Assembly 26,000 TR29 300 Inspection 12,000 BR788 400 The production manager has the responsibility of specifying production levels for each product for the coming month. Help him by calculating( that is, setting up the cnstraints and objective funtion) Weinberger's problem using LP. PLease show work 3. An air conditioning manufacturer produces room air conditioners at plants in Houston, Phoenix , and Memphis. These are sent to regional distributors in Dallas, Atlanta, and Denver. The shipping cost vary, and the company would like to find the least-cost way to meet the demands at each of the distribution centers. Dallas needs to receive 800 air conditioners per month. Atlanta needs 600, and Denver needs 200. Houston has 850 air conditioners available each month, Phoenix has 650, and Memphis has 300. The shipping cost per unit from Houston to Dallas is $8, to Atlanta is $12, and to Denver is $10. The cost per unit from Phoenix to Dallas is $10, to Atlanta is $14, and to Denver is $9. The cost per unit from Memphis to Dallas is $11, to Atlanta is $8, and to Denver is $12. How many units should be shipped from each plant to each regional distribution center? What is the total cost for this? Use Excel QM 4. Question #1 In a job shop operation, four jobs may be performed on any of four machines. The hours required for each job on each machine are presented in a following table. The plant supervior would like to assign jobs so that total time is minimized. Find the best solution. Use Excel QM COSTS Machine 1 Machine 2 Machine 3 Machine 4 A12 10 14 16 13 A15 12 13 15 12 B2 9 12 12 11 B9 14 16 18 16 5. Roscoe Davis, chairman of a colleges business department, has decided to apply a new method in assigning professors to courses next semester. As a criterion for judging who should teach each course, Professor Davis reviews the past two years teaching evaluations (which were filled out by students). Since each of the four professors taught each of the four courses at one time or another during the twoyear period, Davis is able to record a course rating for each instructor. These ratings are shown in the table. Find the best assignment of professors to courses to maximize the overall teaching rating. Course Professor Statistics Management Finance Economics Anderson 90 65 95 40 Sweeney 70 60 80 75 Williams 85 40 80 60 McKinney 55 80 65 55