Formulate and solve a linear programming model

Assignment Help Operation Management

Reference no: EM13221662

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

Questions Cloud

Describe the vapor pressure of pure propyl chloride : The vapor pressure of pure propyl chloride is 347 torr at 25°C and that of pure propyl bromide is 133 torr at 25°C. Assume that the solution is an ideal solution.

How would be break down the scenario in economic terms : Economic Decision whether to stay out of town or spent the night. The town is 150 miles from my house which takes 2.5 hours of drive time. The hotel cost $119.00 per night. While I will have 5 hours my time value is $25.00 per hour of non-producti..

What is the most critical step in capital budgeting process : What is the most critical step in the capital budgeting process? Explain.

Describe what is the molecular weight of the compound : The freezing point of an aqueous solution containing 15 g of a nonelectrolyte in 150 mL water is -5.4°C. What is the molecular weight of the compound? Kf = 1.86°C/m for water.

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

Find the mean and the variance of x : Suppose a random variable X has a discrete uniform distribution on the first m positive integers. Find the mean and the variance of X. What are the mean and the variance if X equals the outcome when rolling a fair six-sided die

Determine the molecular weight of the solute : A 4.305-gram sample of a nonelectrolyte is dissolved in 105 grams of water. The solution freezes at -1.23°C. Calculate the molecular weight of the solute. Kf for water = 1.86°C/m.

General issues you might deal with as a manger : What type of experiences and training you think you will need today to achieve a management position like in a Humane Society Animal Shelter organization.

Evaluate the boiling point of a solution : Calculate the boiling point of a solution prepared by dissolving 70.0 g of naphthalene, C10H8 (a nonvolatile nonelectrolyte), in 220.0 g of benzene, C6H6. The Kb for benzene = 2.53°C/m. The boiling point of pure benzene is 80.1°C.

User Account

All Pages