MBA 6300 online Homework Assignment #6 Linear Programming Models Instructions: After the student calculates the answers to this homework he/she must submit the answers by placing them in the Assignment # _ Submittal Link in Bb by midnight of the date shown in the Course Roadmap and Syllabus. The Instructor does not allow late submissions therefore a score of zero (0) will be recorded for the assignment if submitted after midnight Eastern Time of the due date. Solutions for the assignment will be released in Bb the morning after the due date for access by students. Total points for the assignment is 65. Note: There is no partial credit given; either the answer is correct or incorrect. After you have submitted your answers in the Assignment #_ Submission Link, upload the Excel file (provided you by the Instructor) containing your answers and calculations into the Home Work #_ Supporting Documentation Submission link prior to the due date and time. As stated in the syllabus a score of zero will be awarded for the assignment if this Excel file is not submitted. NOTE: UNLESS EXPRESSLY STATED CARRY YOUR ANSWERS TO TWO (2) DECIMAL PLACES. Scenario 1: The All Season Corporation manufactures two electrical products: air conditioners and large fans. The assembly process for each is similar in that both require a certain amount of wiring and drilling. Each air conditioner takes 6.7 hours of wiring and 6.85 hours of drilling. Each fan must go through 4.95 hours of wiring and 5.65 hours of drilling. During the next production period, 310 hours of wiring time are available and up to 335 hours of drilling time may be used. Each air conditioner sold yields a profit of $75.70. Each fan assembled may be sold for a $55.95 profit. (5 points each for a total of 10 points) Question 1: Formulate and solve this LP production mix situation to find the best combination of air conditioners and fans and that yields the highest profit. Feel free to use the Excel template provided or the corner point method. Question 2: Round your Solution Values to a whole number and calculate the profit using the rounded solution. Scenario 2: All Season's management realizes that it forgot two critical constraints (see Question #1 above). In particular, management decides that there should be a minimum number of air conditioners and fans produced in order to fulfill a contract to a good customer. (5 points each for a total of 10 points) Question 3: If All Season decides that at least 32 air conditioners and 15 fans should be produced, what would be the optimal solution? Use the Excel template provided or the corner point method. Question 4: Round your Solution Values to a whole number and calculate the profit using the rounded solution. Dr. Mike's MBA 6300 Homework #6 Page 1 Scenario 3: The ABC Corporation manufactures three electrical products; humidifiers, fans and air cleaners. The manufacturing process is composed of three processes: wiring, packaging and assembly. During the next production period, 2250 hours of wiring time are available, 70 hours of packing and up to 1590 hours of assembly time may be used. The following table presents the production requirements per unit: (5 points each for a total of 10 points) Bill of Labor Product Humidifiers Air Cleaners Fans Standard Costs Product Humidifiers Air Cleaners Fans Wiring 2.5 hrs. 1.75 hrs. 1.75 hrs. Material $23.50 $28.15 $8.55 Assembly 3.25 hrs. 4.5 hrs. 2.9 hrs. Labor $9.50 $8.35 $7.25 Overhead $28.50 $19.75 $11.25 Packaging 1.45 hrs. 1.0 hrs. 1.75 hrs. Selling Price $90.35 $75.25 $41.80 Question 5: Formulate and solve this LP production mix situation to find the best combination of air conditioners, humidifiers and fans and that yields the highest profit. Feel free to use the Excel template provided or the corner point method. Question 6: Round your Solution Values to a whole number and calculate the profit using the rounded solution. Scenario 4: Management did not like the solution presented in Scenario 3 above and, based on its open order file, placed additional constraints on the model. First there was an open order for at least 20 humidifiers, and 15 air cleaners, which have to be made, additionally after checking the inventory decided that 10 additional fans should be made. (5 points each for a total of 10 points) Question 7: Formulate and solve this LP production mix situation to find the best combination of air conditioners, humidifiers and fans and that yields the highest profit. Feel free to use the Excel template provided or the corner point method. Question 8: Round your Solution Values to a whole number and calculate the profit using the rounded solution. Scenario 5: Using the data and constraints presented in Scenarios 3 & 4 and the fact that have hired two additional people to work in the Packaging Department which adds 80 hours to the time available and the constraint that no more than 25 humidifiers could be produced: (5 points each for a total of 10 points) Dr. Mike's MBA 6300 Homework #6 Page 2 Question 9: Formulate and solve this LP production mix situation to find the best combination of air conditioners, humidifiers and fans and that yields the greatest profit. Feel free to use the Excel template provided or the corner point method. Question 10: Round your Solution Values to a whole number and calculate the cost using the rounded solution. Scenario 6: The ABC Corporation management has hired a cost accountant to make some recommendations regarding the cost allocation of labor used to produce air cleaners. The average wages of personnel performing particular processes are presented in the table below. Assembly $13.25 Wiring $15.10 Packaging $9.75 Material Handling $13.10 Additional investigation into manufacturing costs reveal that at least 20% of the manhours must be allocated to performing material handling tasks, 50% must be allocated to wiring and assembly and 30% must be allocated to wiring and packaging. If a block of 55 manhours is analyzed answer the following questions: (5 points each for a total of 15 points) Question 11: Formulate and develop a LP model to find the best combination of labor hours and that yields the lowest cost. Feel free to use the Excel template provided or the corner point method. Question 12: The prior analysis revealed a flaw in the data; the accountants ignored the constraint that a minimum of fifteen (15) manhours had to be allocated to Wiring. Formulate and develop a LP model accounting for this new constraint. Question 13: The prior analysis revealed another flaw in the analysis; the accountants failed to identify that packaging is over allocated thus they want to add another constraint stating that packaging must be allocated a maximum of twelve (12) manhours. Formulate and develop a LP model accounting for this new constraint. Dr. Mike's MBA 6300 Homework #6 Page 3