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.

Reviews

Write a Review

Operation Management Questions & Answers

  Elucidate how would you present the recommendations

Elucidate how would you present the recommendations also illustrate what data also tools would you use during the presentation.

  Goods and service design concepts

Determine the types of inventories these companies currently manage and describe their essential inventory characteristics and analyze how each of their goods and service design concepts are integrated.

  Identify how the issues of due process

identify how the issues of due process and just cause are linked to employer disciplinary actions.

  Draw the project network using aon

task time estimates for the modification of an assembly line at Jim Goodale's Carbondale, Illinois, factory are as follows.

  Elucidate how has dell used its sales also build-to-order

Elucidate how has Dell used its sales also build-to-order model to develop an exceptional supply chain.

  Which methods are considered better first-choice methods

In your own words, describe crashing, fast tracking, and scope reduction as means of schedule compression. When would each be appropriate? Which methods are considered better first-choice methods by most project sponsors?

  What is the best production order quantity

The production process is most efficient when 12 units per day are produced at a cost of $119 per unit. Setup cost is $39. Inventory carrying cost at Johnson is determined to be 8 percent annually.

  Describe the concept of capacity

Describe the concept of capacity and how managing capacity can improve operations and the supply chain flow of goods and services.

  What are the key planning factors for competitive success

What are the key planning factors for competitive success? Provide an example of an organization that has achieved competitive success through planning. Provide an example of an organization that has failed to achieve competitive success as the re..

  Why is this an important concern for all businesses today

What should you do after the fact when your company's information security has been breached?

  Elements for developing competitive hr business strategy

Provide a broad description of the value of understanding the strategic challenges and opportunities facing the business organization today

  Elucidate how can this pitfall be avoided

Illustrate what do you think happens in a company which creates teams just for sake of having teams as it's a fad or just as it sounds good. Elucidate how can this pitfall be avoided.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd