Department Sales Employee Home Furnishings China Appliances Jewelry $340 560 $160 $610 520 1 $290 2 370 450 270 350 420 360 220 630 150 450 190 570 310 280 320 490 360 N34 56

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

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 perform better in some departments than in others. The average daily sales
for each of the six employees in each of the four departments are shown in the following table: Employee 3 has not worked in the china department before, so the manager does not want to assign
this employee to china.
Determine which employee to assign to each department and indicate the total expected daily sales. 

Department Sales
Employee
Home Furnishings
China
Appliances
Jewelry
$340
560
$160
$610
520
1
$290
2
370
450
270
350
420
360
220
630
150
450
190
570
310
280
320
490
360
N34 56
Transcribed Image Text:Department Sales Employee Home Furnishings China Appliances Jewelry $340 560 $160 $610 520 1 $290 2 370 450 270 350 420 360 220 630 150 450 190 570 310 280 320 490 360 N34 56
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Optimization models
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.