Formulate and solve a linear programming model

Assignment Help Operation Management
Reference no: EM1388275

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

Previous Q& A

  Calculate the number of glucose molecules

A one hundred ml vessel is filled with water separated in equal parts by a semipermeable membrane. The molecular weight cut off of the membrane is 100g/mol.

  Probability of a false negative test

What is the probability of a false negative test (the probability that a person having muscular distrophy tests negative)?

  Ethical considerations and disabled candidates

Please help me answer the following questions about a candidate that has degenerative progressive condition which could result in disability. He is considered to be the 1 pick for a job, but his physicians aren't capable to predict whether the dis..

  Introduction to cohen calculation

What was the purpose of calculating a Cohen's d? When is a Cohen's d calculated? Interpret d=.90. What does it mean in this example?

  Explain the chemical changes

ssume you have just eaten a sausage and egg sandwich for breakfast. Explain the chemical changes that occur in the sandwich as it passes through the parts of the GI tract.

  Program to read sales amount-calculate sales commissions

Write down the program to read the sales amount and calculates sales commissions using following scheme.

  Constructing a boxplot for the data

The numbers of years served by selected past members of the U.S. Supreme Court is listed below. Find the percentile rank for each value. Which value corresponds to the 40th percentile? Construct a boxplot for the data and comment on their shape.

  Task of discussing protection of health information

You've been given the task of discussing the protection of health information with the new medical assistant in your office. You know that protecting health information goes farther than offices physically protecting it.

  Create direct-mapped data cache for the byte offset

Create the 128KB direct-mapped data cache which uses a 32 bit address and 16 bytes per block. Compute the following: How many bits are utilized for the byte offset?

  Total cholesterol concentration

The total blood cholesterol concentrations, in mg/dL, are shown below for a random sample of six people. In the table below, x is the age of the subject and y is the subject's total cholesterol concentration. Find the 95% prediction interval when ..

Reviews

Write a Review

 

Similar Q& A

  Discuss the positive aspects of globalization

Discuss the positive aspects of globalization and contrast these with the negative aspects of globalization from the perspective of a small business

  Determine average value of a loyal customer

manufacture of business copier workstations has a 75 percent customer retention rate. ir accounting department approximates incremental contribution to profit and overhead as 40 percent. Determine average value of a loyal customer.

  Find out the probability that full-fare demand

Find out the probability that full-fare Demand F is less than X*, the ideal number of seats that should be set aside for full fare passengers.

  Illustrate what is optimal inventory policy

Consider Avionic Manufacturing Business that wishes to meet a demand of 10 units per month by purchasing items from a vendor with a lead time of 3-quarters of a month. Illustrate what is optimal inventory policy and total cost of system under optim..

  What is the essence of the global challenge facing

What is the essence of the global challenge facing American firms? Describe how the challenge is different for companies headquartered

  If the digital system has a life of ten years and a salvage

If the digital system has a life of ten years and a salvage value of $ 10,000 at that time, what is the IRR of the new system? Should this project be undertaken?

  Responsibilities of the hrm department

a sales coordinate promoted to the sales assistant manager and the hotel have to hire a new coordinate

  Which amounts to allocating about wheatie

Wheatie should be allocated 35% more space than Grano, which amounts to allocating about 57% to Wheatie also 43% to Grano. Illustrate what do you think.

  Explain would you structure various types of communication

Based on se needs, explain how would you structure various types of communications-memos, voice mail message, also so forth-for a virtual worke.

  Illustrate what networking avenues will you use to better

Illustrate what steps you will take to obtain additional skills you might need. Illustrate what networking avenues will you use to better understand your field of interest get advice also help you self-market.

  A manager is quite concerned about the recent deterioration

A manager is quite concerned about the recent deterioration of a section of the roof on a building that houses her firm's computer operations.

  Elucidate how do perform a steep analysis to understand

Do you have any information on the Nucor Steel Organization. Elucidate how do I perform a STEEP analysis to understand the general environment facing Nucor.

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