Information about statistics-linear programming

Reference no: EM1397198

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.

Reference no: EM1397198

Questions Cloud

Calculate the rate constant for the reaction : Calculate the rate constant for the reaction when the reactant concentration in a first-order reaction is given 7.30×10-2M after 15.0s and it is also reported 4.40×10-3M after 65.0s . ?

Mean length of commercials : The director of a radio broadcasting company wants to determine whether the mean length of commercials on his station is equal to 24 seconds.

Calculate the difference in mass : calculate the difference in mass that is hold by a 500.0mL flask at a temperature of 0.0°C from that at temperature of 20.0 °C? (you can assume the volume of the sample at 0.0 °C temperature =volume of the sample at 20.0°C)

Influence of trojan war and iraq war on people : Why does war occur , and how does it influence people who have been involved? Choose the war or similar conflict (Trojan War, American Civil War.

Information about statistics-linear programming : Biggio's Department Store has six employees available to assign to four departments in the store: home furnishings, china, appliances, and jewelry.

Define membrane potential and sodium equilibrium potential : Define membrane potential (Vm) and sodium equilibrium potential (ENa). Which of these, if any, changes during the course of an action potential?

Enough evidence to support the claim : This test result prompts a state administrator to declare that the mean score for the sate's eighth graders on the examination is more than 275. at a=.04, is there enough evidence to support the claim.

Calculate the specific heat of substance : Initially A sample of a substance of 23.43 g weight has temperature 24.2 °C then it absorbs heat and reached to temperature 122.0 degree Celsius; calculate the specific heat of this substance if it absorbs 2167 joule heat

Formulate integer programming problem : An airline owns an aging fleet of Boeing 737 jet airplanes. It is considering a major purchase of up to 17 new Boeing model 757 and 767 jets.

User Account

All Pages