Question: Hi, I need help solving this excel based question. If this can be shown in excel format as well that would help a lot! Thank
Hi, I need help solving this excel based question. If this can be shown in excel format as well that would help a lot! Thank you!
A couple, Luis and Benson, want to divide their main household chores (cleaning, cooking, dish washing, laundry) between them so that each has two tasks but the total time spent on household duties is kept to a minimum. Their efficiencies on these tasks differ, where the time each would need to perform each of the task is given in the table below:

Formulate a binary programming model for this problem. What are the decision variables, objective function, and constraints? Use Excel's Solver to find and describe the optimal solution.
\begin{tabular}{|l|c|c|c|c|} \hline & \multicolumn{4}{|c|}{ Time Needed } \\ \hline & Cleaning & Cooking & Dish Washing & Laundry \\ \hline Luis & 4.5 & 7.8 & 3.6 & 2.9 \\ \hline Benson & 4.9 & 7.2 & 4.3 & 3.1 \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
