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?

Reviews

Write a Review

Business Management Questions & Answers

  Which to track non-documented workers and potential terroris

A bill has just been introduced in the Legislature, with wide bi-partisan support, that would create a database for creating a "network" of information by which to track non-documented workers and potential terrorists.

  Select a company or industry with which you are familiar

select a company or industry with which you are familiar have access to its financial information. gain faculty

  Llustrate what are their company goals

From the annual reports you previewed, illustrate what is the company’s corporate strategy? Illustrate what are their company goals and were they successful in achieving those goals? Please list the company of the annual report you previewed.

  Describe three pieces of legislation

Describe three pieces of legislation that have been critical in defining the rights of management and unions.

  What two fundamental product strategies do companies

What two fundamental product strategies do companies choose between when selling their products in the global marketplace?

  Why are securities laws frequently referred to as full discl

1. How are the SIPC and FDIC similar? Why are securities laws frequently referred to as full disclosure laws, and what is the role of the SEC?  2. In an underwriting, what role does each of the following play?  the investment banker  the syndicate  t..

  Replacement from a standard deck

Find the probability of getting four consecutive aces when four cards are drawn without replacement from a standard deck of 52 playing cards.

  Salary and benefit packages of comparable organizations

Compare and contrast salary and benefit packages of at least three comparable organizations in the same industry. Examine what 21st-century employees consider to be benefits (see this week's recommended readings for a start)

  Description of organizational change1-why is organizational

description of organizational change1-why is organizational change so difficult?2-what are the similarities and

  Winner''s curse

In section 1 of your document, you should examine where, when, and by who your particular research topic was conceived and what it 'looked' like at that time. Your research should include the seminal work that laid the foundation for your topic.

  What your portfolio return

The monthly returns for News Corp, First Data, and Whirlpool were 8.24%, -2.59%, and 10.13%. What's your portfolio return?

  Business continuity and disaster recovery planning models

Compare and Contrast various Business Continuity & Disaster Recovery Planning models.

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