Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

hello, I need help solving the following problems using excel (Linear solution with solver): 1)In the post office example, suppose that each full-time employee works

hello, I need help solving the following problems using excel (Linear solution with solver):

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 may meet its daily labor requirements by using both full-time and part-time employees. During each week, a full-time employee works 8 hours a day for five consecutive days, and a part-time employee works 4 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 part-time labor to 25% of weekly labor requirements. Formulate an LP to minimize the post offices weekly labor costs.

2) During each 4-hour period, the Smalltown police force requires the following number of on-duty police officers: 12 midnight to 4 A.M.8; 4 to 8 A.M.7; 8 A.M. to 12 noon 6; 12 noon to 4 P.M.6; 4 to 8 P.M.5; 8 P.M. to 12 midnight4. Each police officer works two consecutive 4-hour shifts. Formulate an LP that can be used to minimize the number of police officers needed to meet Smalltowns daily requirements.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

Do people make rational decisions?

Answered: 1 week ago