Question: Good day help! Answer letter b, and please fill out the colored cells in the excel thank you! And show the solution please! 7.3.* A


Good day help! Answer letter b, and please fill out the colored cells in the excel thank you! And show the solution please!
7.3.* A young couple, Eve and Steven, want to divide their main household chores (marketing, cooking, dishwashing, and laundering) between them so that each has two tasks but the total time they spend on household duties is kept to a minimum. Their efficiencies on these tasks differ, where the time each would need to perform the task is given by the following table. Time Needed per Week (Hours) Marketing Cooking Dish Washing Laundry Eve 4.5 7.8 3.6 2.9 Steven 4.9 7.2 4.3 3.1 a. Formulate a BIP model in algebraic form for this problem. b. Formulate and solve this model on a spreadsheet. Time Needed (hours) Marketing Eve Steven Cooking Dishwashing Laundry Cooking Dishwashing Laundry Does Task? Marketing Eve Steven Total 0 Tasks Performed 0 0 0 0 Total Time (hours) correct answer -------> 18.4 hoursStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
