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.

Reviews

Write a Review

Business Management Questions & Answers

  Explain description of decision making

Explain description of Decision making - Megley Cheese Company is a small manufacturer of several different cheese products.

  Suppose the demand curve for a monopolist is qd

Suppose the demand curve for a monopolist is QD = 500 - P, and the marginal revenue function is MR = 500 - 2Q. The monopolist has a constant marginal and average total cost of $50 per unit. a. Find the monopolist's profit-maximizing output and price...

  Description - effect of properimproper communication

description - effect of properimproper communication channelsdsecribe a scenario where a manager selected a proper

  Analyze the concepts of professional and applied ethics

Analyze the concepts of professional and applied ethics and determine

  Lewin and kotter models of change

In this week's reading we have learned about Lewin's and Kotter models of change. One of the Lewin's Model you discussed is unfreezing stage which is initiated through motivation

  Explain can terrorism ever be justified

Respond to the question "Can Terrorism Ever Be Justified?" In your response, carefully avoid the pitfalls of the unreflective thinker and the challenged thinker-support your argument with facts and evidence and in light of at least one

  Organizations prepare employees for change

How do organizations prepare employees for change?

  Defined benefit and defined contribution pension

Show the relative advantages and disadvantages of defined benefit and defined contribution pension schemes from both the employee and employer perspectives.

  Summarize challenges experienced within customer service

Explain the methods of communication used to reach identified external stakeholders of the business. Summarize challenges experienced within customer service, or customer satisfaction as a result of virtual communication failures

  How business move from mail order to being online presence

How can the business move from mail order to being an online presence? What are the benefits and challenges that the business should be aware of before becoming an e-business?

  Research and apply the content from recent articles

Research and apply the content from recent articles about planning electronic commerce initiatives. You must cite at least 3-5 sources outside of the class textbook. Write a minimum of 3 to 5 pages for the body of the research paper (using APA writin..

  Determine two strategic changes for honda motor company

Discuss two strategic changes you would deploy for Honda Motor Company as strategist for the organization.

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