Additional investigation into manufacturing costs reveal that at least 20% of the man-hours 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 man-hours 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) man-hours 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) man-hours. Formulate and develop a LP model accounting for this new constraint.
NOTE: I NEED ANSWER TO EACH QUESTION AND EXCEL SOLUTION