Formulate a linear programming model for this problem

Assignment Help Other Subject
Reference no: EM131855536

Mal-Wart truck fleet hires temporary drivers for four- and eight-hour shift during holiday sales season. Four-hour shifts start at 6am, noon, and 2pm; eight-hour shifts start at 6am, 8am, noon, and 2pm.

The number of drivers needed varies during the day. The table below shows the minimum number of drivers that are needed each two-hour time block throughout the day. (For example, Mal-Wart needs 37 drivers from 8am to 10am.)

Time

6am

8am

10am

Noon

2pm

4pm

6pm

8pm

Drivers needed

63

37

21

33

48

55

27

17

A driver's pay depends on the hours worked. A driver gets paid $10 per day, plus $7 per hour worked, plus a $1 hour premium for each hour worked before 8am or after 6pm. Mal-Wart would like to pay as little as possible while having enough drivers at all times.

1. Formulate a linear programming model for this problem and type it in worksheet 1 of your Excel file.

2. In worksheet 2 of your Excel file, formulate an Excel model that corresponds to your mathematical model; and use Solver to find the optimal solution to the problem.

Reference no: EM131855536

Questions Cloud

Home care and hospice professional : Please send me article about Journal of the home care and hospice professional (coverage beginning January 2000)
Discuss the possible reasons for his intended course : The Management Accountant is considering stopping the calculation and analysis of material cost variances until the price volatility subsides.
Attitudes evidence-based practices : You are interested in nurses' attitudes Evidence-Based Practices. Which method do you think would work best to obtain this information
Read the questionnaires versus interviews section : Read the Questionnaires Versus Interviews section in the textbook. How are these guidelines similar and different from data collected by nurses when giving
Formulate a linear programming model for this problem : Formulate a linear programming model for this problem and type it in worksheet 1 of your Excel file.
What kind of control structure would you use : What kind of control structure would you use to decide which segment a given letter falls into and to print out the corresponding digit?
Two practice-specific concepts : Two Practice-Specific Concepts: Identification, discussion, and documentation from the literature of your perspective
How do you manage your own personal inventory of suppliers : How do you manage your own personal inventory of various supplies? Do you stock up or wait until you run out of something before you replace it? Why?
Discuss the pros and cons of staffing : Discuss the pros and cons of staffing the nursing department based on acuity of illness

Reviews

Write a Review

Other Subject Questions & Answers

  Determine current needs and uses of long-term care services

Determine two current needs and uses of long-term care services. Determine the main way(s) the overall needs and uses of long-term care services have evolved.

  Use the texas statutes-what is teds net monthly income

Jennifer and Ted are getting divorced. They both live in Texas. Jennifer has hired your firm to represent her in the divorce proceedings. Jennifer and Ted have two children, Max (9) and Susan (14). Ted works for a local distribution company. Ted has ..

  Relate a present health issue to a health education program

in a 3-5 page paper give a brief overview of your training describe your audience and identify the learning principles

  Research the professional standards

Research the professional standards for law enforcement officers and private security officers in your state.

  What are the short-term and long-term costs and benefits

What are the major effects on caseflow management of the decision by jurisdictions to insert ADR requirements into divorce case processing?

  What is the meaning of human history

What is the nature of the world around you? What is a human being? What happens to a person at death?

  What are common stereotypes of the specific minority groups

What are common stereotypes of the specific minority groups explained in the training guide? How may one differentiate those stereotypes from accurate descriptions of the minority groups?

  What inspired me to pursue a career in hospitality industry

You will be applying for the Hotel and Restaurant Foundation (HARF). What inspired me to pursue a career in the hospitality industry?

  Explain philosphical approaches to ethical decision-making

Select 2 of the philosphical approaches to ethical decision-making and write down 3-page paper contrasting two approaches.

  How you would revise-replace your original measurement plan

The center point of research studies is the body of data collected to answer the research question. These data must be measured, which is the act of sorting them out and quantifying them in some cohesive way in order to construct meaning-but how c..

  Equal rights amendment

What Amendment, known as the Equal Rights Amendment, states, "Equality of rights under the law shall not be denied or abridged by the United States or by any state on account of sex?"

  What was done specifically to deter young people

Was gang activity the reason the community policing effort got started or was gang activity recognized as a problem along the way?

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