Formulate and solve a linear programming model in excel

Assignment Help Operation Management

Reference no: EM13249782

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: EM13249782

Questions Cloud

Construct a decision tree : Construct a decision tree. Compute the expected opportunity loss for each decision alternatives (i.e., draw a regret table).

Production cost report : Sweet Concoctions a syrup product that passes through three departments. Data for March for the first department follow: Work in process, March1- Gallons:80,000 Materials:$68,600 Labor:$28,000 Overhead:$50,000

Analyze memory performance for a write and read operation : The goal is to design a memory system to support a small amount of data storage outside of the processor. The design is to be based on the 16K bit CY7C128A SRAM organized as 2Kx8. (a) Provide a high-level block diagram for such an interface.

Determine the magnetic force on each wire : Two parallel wires of length 18 m are separated by a distance of a = 0.13 cm. The first carries a current of I1 = 5 A, What is the magnetic force on each wire

Formulate and solve a linear programming model in excel : 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.

Explain the metathesis reaction between sodium sulfide : What is the correct balanced net ionic equation which represents the metathesis reaction between sodium sulfide and aluminum chloride

What are some of the challenges : discuss some of the aspects of the transfer of training. What are the primary factors that play a role in the success of the process? How can application of the training objectives be sustained? What are some of the challenges?

How many dehumidifiers should be built in atlanta : How many dehumidifiers should be built in Atlanta, next month? How many in Phoenix?

Automobile manufacturers design : Automobile manufacturers design and build cars/pickups to target certain segments of our society. Fill out the attached HLC/Social Stratification Matrix by suggesting an automobile or pickup truck that has been designed for that segment.

User Account

All Pages