Solving linear programming model

Assignment Help Operation Management

Reference no: EM13100720

Each hour from 10 A.M. to 7 P.M., First National Bank of Gainesville receives checks and must eventually process them. Its goal is to process all checks the same day they are received. The bank currently has 20 check processing machines, each of which can process up to 400 checks per hour. It takes one worker to operate each machine. This bank hires both full-time and part-time workers. Full-time employees work 10 A.M. to 6 P.M., 11 A.M. to 7 P.M., OR noon to 8 P.M., and are paid $180 per day. Part-time employees work either 2 P.M. to 7 P.M. OR 3 P.M. to 8 P.M., and are paid $90 per day. The number of checks typically received each hour is 2500 between 10-11, 3000 between 11-N, 3500 between N-1, 4000 between 1-2, 4500 between 2-3, 5000 between 3-4, 4500 between 4-5, 4000 between 5-6, 3500 between 6-7, and 3000 between 7-8. Formulate and solve a linear programming model in Excel to develop a work schedule that processes all checks by 8 P.M. and minimizes daily labor costs.

Reference no: EM13100720

Questions Cloud

Conducting a demand analysis and forecast for pizza : By conducting a demand analysis and forecast for pizza, you will be able to make a decision whether The Pizza Company should establish a presence in your community.

Exponential-uniform and normal probability : What is the probability the circuit will last more than 3000 hrs. What is the probability the circuit will last between 2500 and 2750 hours and what is the probability the circuit will fail within the first 2000 hrs.

What is the electric force between the proton and electron : what is the electric force between the proton and electron inside of a hydrogen atom? What must the speed of the electron be? Radius=0.47 x 10^-9.

Number of deaths from copd in the group excessive : Suppose that among workers exposed to asbestos in a shipyard in 1980, 33 died over a 10-year period from COPD, whereas only 24 such deaths would be expected based on statewide mortality rates. Is the number of deaths from COPD in this group excess..

Solving linear programming model : Each hour from 10 A.M. to 7 P.M., First National Bank of Gainesville receives checks and must eventually process them. Its goal is to process all checks the same day they are received.

How much time does it take until the book hits the floor : After solving a difficult physics problem, an excited student throws his book straight up. It leaves his hand at 3.7 m/s from 1.5 m above the ground. How much time does it take until the book hits the floor?

Estimating the proportion of washing machines : A manufacturer wishes to estimate the proportion of washing machines leaving the factory that is defective. How large a sample should she check in order to be 93 percent confident that the true proportion is estimated to within 0.014?

What is the second balls velocity at that point : A tennis ball gun launches tennis balls at 17.6 m/s . It's pointed straight up and launches one ball; 2.0 s later, it launches a second ball. I already found - At what time (after the first launch) are the two balls at the same height? = 2.8s What..

Identify and explain the order qualifiers and order winners : United Airlines, Inc.is a major American airline headquartered in Chicago, Illinois. It is a wholly owned subsidiary of United Continental Holdings and the world's largest airline in terms of fleet size.

User Account

All Pages