Solution-Temporary drivers for four and eight-hour shift

Temporary drivers for four and eight-hour shift

Assignment Help Business Management

Reference no: EM131166513

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.

Formulate a linear programming model for this problem and type it in worksheet 1 of your Excel file.
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: EM131166513

Questions Cloud

Determine the weight of cylinder per ft length of cylinder : A long, solid cylinder of radius 2 ft hinged at point A is used as an automatic gate, as shown in Fig. P3-61E. When the water level reaches 15 ft, the cylindrical gate opens by turning about the hinge at point A.

Explain some of the benefits african americans enjoyed : Explain some of the benefits African Americans enjoyed during the Reconstruction period (schools, Freedman's Bureau, free labor). Also, point out some of the drawbacks and problems with Reconstruction, why was this revolution "unfinished"?

Main theories of industrial relations-unitary : Discuss the three main theories of Industrial Relations, Unitary, Pluralist and Marxist. What are the main features of these three theories? What are some of the similarities and differences between these three theories?

Why would the recent focus on victims of global terrorism : How are the various facets of the general environment likely to be important for BGC (Boys and Girls Club)? Why would the recent focus on victims of global terrorism be a threat to the BGC

Temporary drivers for four and eight-hour shift : 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.

According to the business cycle dating committee : According to the business cycle dating committee of the National Bureau of Economic Research (NBER), the U.S. economy entered into a recession (now dubbed the 2007-2009 recession) in December 2007. By the time that the NBER made its announcement in l..

Does the institution consider other areas of excellence : Does the institution consider other areas of excellence apart from academic achievements in class? For example do they look at extra curriculum activities as much of importance as academic achievements?

Determine the moment of the weight of the body about point o : The body is composed of slender bar which has a mass pper unit of length. Determine the moment of the weight of the body about point O.

Establish protocols that alleviate stress of test-taker : Establishing protocols that alleviate stress and anxieties of test-taker. Protecting test materials and raw data. Maintaining confidentiality of test results.

User Account

All Pages

Temporary drivers for four and eight-hour shift

Reference no: EM131166513

Reference no: EM131166513

Questions Cloud

Reviews

Write a Review

Business Management Questions & Answers

Explain tax planning strategy

What would you do if you were in vinny barbieri position

Compute percentage of parts will not meet the weight specs

Explain with respect to the ethics of actions

Database designer to ensure the integrity of keys.

Inventory turnover can be computed 2 different ways

How should pam proceed as a visionary leader

Question regarding the principles of management

Determining the income from the units

When ethical intent may not be sufficient

Significance of a new entrants

What happened when retains the goodwill of the customer

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT