Statistics - Linear Programming
Not what you're looking for?
Biggio's Department Store has six employees available to assign to four departments in the store: home furnishings, china, appliances, and jewelry. Most of the six employees have worked in each of the four departments on several occasions in the past and have demonstrated that they perfrom better in some departments than in others. The average daliy sales for each of the six employees in each of the four departments are shown in the following table:
Department Sales
Employee Home Furn China Appliances Jewelry
1 $340 $160 $610 $290
2 560 370 520 450
3 270 -- 350 420
4 360 220 630 150
5 450 190 570 310
6 280 320 490 360
Employee 3 has not worked in the china department before, so the manager does not want to assign this employee to china.
Using excel solver determine which employee to assign to each department and indicate total expected sales.
Purchase this Solution
Solution Summary
A Complete, Neat and Step-by-step Solution is provided in the attached file.
Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.