1) Assignment Problem Simulation: Use the solver in Excel to find the assignment of persons to tasks that minimize the total cost. Costs for tasks and persons are given in the Excel. Each person can do only one task. To formulate this assignment problem, answer the following three questions. a) What are the decisions to be made? Hint: To assign a task, enter 1 (Yes) or 0 (No) b) What are the constraints on these decisions? Hint: Demand & Supply c) What is the overall measure of performance for these decisions? d) Solve the model using solver

	Arkel	Kallex	Total Profit
Production quantity
Unit profits			0
Constraints	Production Requirements per Unit	Used	Available
Drums required			0
Labor required			0
Rubber hosing required			0
Decision variables
Objective functions
LHS constrains