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

User Account

All Pages