Question: In the employee scheduling example, suppose that each full-time employee works eight hours per day. Thus, Monday's requirement of 17 workers can be viewed as

In the employee scheduling example, suppose that each full-time employee works eight hours per day. Thus, Monday's requirement of 17 workers can be viewed as a requirement of 8(17) = 136 hours. The post office can meet its daily labor requirements by using both full-time and part-time employees. During each week a full-time employee works eight hours a day for five consecutive days, and a part-time employee works four hours a day for five consecutive days. A full-time employee costs the post office $15 per hour, whereas a part-time employee (with reduced fringe benefits) costs the post office only $10 per hour. Union requirements limit parttime labor to 25% of weekly labor requirements.

a. Modify the model as necessary, and then use Solver to minimize the post office's weekly labor costs.

b. Use SolverTable to determine how a change in the part-time labor limitation (currently 25%) influences the optimal solution.

Step by Step Solution

★★★★★

3.44 Rating (183 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Employee scheduling Hourly cost fulltime 15 Hourly ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

1209-M-S-D-A(8904).xlsx

300 KBs Excel File

Students Have Also Explored These Related Statistics Questions!

How much influence can the employee requirements for one, two, or three days have on the weekly schedule in the employee scheduling example? You are asked to explore this in the following questions....

In the employee scheduling example, suppose the employees want more flexibility in their schedules. They want to be allowed to work five consecutive days followed by two days off or to work three...

In the employee scheduling example, suppose that the company can force employees to work one day of overtime each week on the day immediately following this five-day shift. For example, an employee...

please help me answer q3 and Q15 5. where this incle of 1. Use a one-way SolverTable to investigui the total number of employees changes. In the employee scheduling example, suppose that each...

In the employee scheduling example, suppose that each full - time employee works eight hours per day. Thus, Monday s requirement of 1 7 employees can be viewed as a requirement of 8 ( 1 7 ) = 1 3 6...

9 . In the employee scheduling example, suppose that each full - time employee works eight hours per day. Thus, Monday's requirement of 1 7 employees can be viewed as a requirement of 8 ( 1 7 ) = 1 3...

In the post office example, suppose that each full-time employee works eight hours per day. Thus, Mondays requirement of 17 workers can be viewed as a requirement of 8(17) 136 hours. The post office...

1 In the post office example, suppose that each full-time employee works 8 hours per day. Thus, Mondays requirement of 17 workers may be viewed as a requirement of 8(17) 136 hours. The post office...

In the post office example, suppose that each full-time employee works 8 hours per day. Thus, Mondays requirement of 17 workers can be viewed as a requirement of 8(17) 136 hours. The post office can...

Determine the values for M and B 1. The limit: lim f(z) exists when M in which case, lim, f(x) - 2. The limit: lim f(2) exists when B-in which case, lim (2) - all answers should be given as numbers...

A firm is reviewing a project with a labor cost of $18.90 per unit.Raw materials cost of $21.63 a unit, and fixed costs of $8,000 a month. Sales are projected at 7,200 units total for the 3-year life...

8 Multiple Choice 1 point The accommodation conflict style may be appropriate when you have strong feelings about an important issue or when immediate action is needed in an urgent situation. False...

1.1. dF(y) 11 00 sin(x -y)t dtl

Under the present tax system, C corporation income is taxed twice, once when earned and again when the shareholders receive dividends or sell their stock. Nevertheless, the C corporation form is...

Some tax analysts contend that many corporations can shift the burden of corporate taxation to consumers in the form of higher prices. In what other ways might a corporation attempt to shift the...

Acorn Corporation has a $5,000 NSTCG and a $9,000 NLTCL in the current year. Last year, Acorn had a $3,000 NLTCG. No other capital gains or losses were reported in prior tax years. a. Do the NSTCG...

Your Assignment (!) consists of two parts: one, regression analysis, and two, univariate analysis (Forecasting). I will provide the regression data (Table 1) for you work which save you a lot of...

Hampton Industries had $47,000 in cash at year-end 2018 and $19,000 in cash at year-end 2019. The firm invested in property, plant, and equipment totaling $250,000 the majority having a useful life...

Aaron wants to have $ 1 3 9 , 1 1 2 . 2 1 in 7 years. He plans to make regular savings contributions of $ 1 0 , 8 0 0 . 0 0 per year for 7 years, with the first of these regular savings contributions...