Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3. Assignment Renovain Home Improvement Store. The Renovain Home Improvement Store will assign an employee to each of the five departments: Appliances, Flooring, Outdoor Living,

image text in transcribed

3. Assignment Renovain Home Improvement Store. The Renovain Home Improvement Store will assign an employee to each of the five departments: Appliances, Flooring, Outdoor Living, Kitchen, and Tools. There are seven employees available who have past experience in all of these five departments. The company collected sales performance information for each worker on each day he or she was assigned to a department. The average daily sales of each employee for each a department are shown in the Table. a. Find the optimal assignment of employees to departments so that the average daily sales of the five employees combined are as large as possible. What would the daily average sales be in an optimal assignment? Department Sales ($) Outdoor Appliances Flooring Kitchen Living 1,000 525 370 275 Tools Joshua 532 1,250 450 285 250 540 850 480 320 330 550 Employee 1,400 490 375 350 580 Adan Tyson Valley Lacole Haemon 1,125 505 365 345 190 950 540 195 315 350 1,050 300 385 325 545 Average daily sales of employees by department b. New Constraint: Joshua and Adnan are long term employees. Company management decided that at least one of these two people must be included in the optimal solution. What is the new optimal solution? How much did the profit change because of this restriction? c. Tyson and Valley are the least experienced employees. Company management decided that at most one of these two people can be included in the optimal assignment. Keep the constraint of part b as you add this new constraint. What is the new optimal solution? How much did the profit change because of this added restriction? 3. Assignment Renovain Home Improvement Store. The Renovain Home Improvement Store will assign an employee to each of the five departments: Appliances, Flooring, Outdoor Living, Kitchen, and Tools. There are seven employees available who have past experience in all of these five departments. The company collected sales performance information for each worker on each day he or she was assigned to a department. The average daily sales of each employee for each a department are shown in the Table. a. Find the optimal assignment of employees to departments so that the average daily sales of the five employees combined are as large as possible. What would the daily average sales be in an optimal assignment? Department Sales ($) Outdoor Appliances Flooring Kitchen Living 1,000 525 370 275 Tools Joshua 532 1,250 450 285 250 540 850 480 320 330 550 Employee 1,400 490 375 350 580 Adan Tyson Valley Lacole Haemon 1,125 505 365 345 190 950 540 195 315 350 1,050 300 385 325 545 Average daily sales of employees by department b. New Constraint: Joshua and Adnan are long term employees. Company management decided that at least one of these two people must be included in the optimal solution. What is the new optimal solution? How much did the profit change because of this restriction? c. Tyson and Valley are the least experienced employees. Company management decided that at most one of these two people can be included in the optimal assignment. Keep the constraint of part b as you add this new constraint. What is the new optimal solution? How much did the profit change because of this added restriction

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions