Solution-Formulate a linear programming model

Formulate a linear programming model

Assignment Help Business Management

Reference no: EM131164746

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

Questions Cloud

Discussion on decision making-factors and role of metrics : This is a team discussion on “Decision Making, Factors and Role of Metrics.” I posted three articles titled "Decision Making Consumers", “Pricing” and “Managing Customer Value Metrics” for this team discussion under Week 3 module. These three article..

How does use of visual elements enhance presentation : How does the use of visual elements enhance or detract from the presentation of research? - Will you add graphs, charts, or images to your draft(course paper)?

Tqm value analysis of product : TQM value analysis of product in 3 to 4 pages

Describe competency models and case-based decision making : Describe why the competencies of the past are not compatible with the competencies of the future for the global organization. Explain the competency-based and the traditional approach to training.

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

Performance image generators for simulation : Suppose Buckeye management sets an annual revenue growth target of 20%. Estimate the free cash flows each year for the next five years 2014-2018.

Describe a controversial counterterrorism tactic : From the second e-Activity, describe a controversial counterterrorism tactic that Israel currently utilizes. Summarize the key arguments for and against these tactics.

Summarize change management theory : Change management and the first three of the Five Disciplines theories. Summarize change management theory. Explain which of the three disciplines you chose and explain the theory behind your discipline

Can anyone be a change agent within an organization : Can anyone be a change agent within an organization? If so, what makes this type of environment effective for successful change? If not, who would be the change agents and why?

User Account

All Pages

Formulate a linear programming model

Reference no: EM131164746

Reference no: EM131164746

Questions Cloud

Reviews

Write a Review

Business Management Questions & Answers

Gap analysis and benchmarking for anthony''s orchard

Application practice and theory leadership1-assess yourself

Manufacturing, planning and control

Ethical and business dimensions of a chosen issue

Penalties for breach

Identifying important requirements to make decision

Illustrate what type of entrepreneur

Why might this be a valid criticism

Rooney rules effect on team diversity within the

Explain tangible versus intangible resources

Expalin merging organizational cultures

Dealing with discontent in leaders

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT