Purchase Solution

Linear Programming

Not what you're looking for?

Ask Custom Question

To the extent permitted by local law, each Acme Home Improvements store, including AMC, is open from 7 am - 11 pm every day. Acme Mexico City planners have provided the following table, which identifies the minimum number of customer service employees estimated to be needed on the floor of the store each hour of the day:

Customer Service Employees

Time Period
Minimum number needed on the floor

7 am - 8 am
10

8 am - 9 am
12

9 am - 10 am
18

10 am - 11 am
22

11 am - 12 pm
22

12 pm - 1 pm
26

1 pm - 2 pm
26

2 pm - 3 pm
26

3 pm - 4 pm
26

4 pm - 5 pm
26

5 pm - 6 pm
28

6 pm - 7 pm
28

7 pm - 8 pm
24

8 pm - 9 pm
22

9 pm - 10 pm
14

10 pm - 11 pm
12

Full-time customer service employees at AMC work a 9 hour shift (8 hours of work plus a 1 hour meal break) either from 7 am to 4 pm or from 2 pm to 11 pm. Workers on the 7-4 shift are assigned an hour-long lunch break at either 11 am or 12 noon. Workers on the 2-11 shift are assigned an hour-long dinner break at either 5 pm or 6 pm.

Part-time customer service employees work four consecutive hours per day and their shifts can start any hour between 7 am and 7 pm.

By corporate policy, which is consistent with Mexican labor law, the company limits part-time customer service employees hours to 50% of the day's total required hours.

Further, in the interest of proper supervision of employees and employee safety, management has a policy that the actual number of customer service employees on the floor in the store should never exceed 30 during any given time period.

Part-time customer service employees earn $500 per day, and full-time customer service employees earn $1100 per day in salary and benefits

Assignment Taskings

Each student prepares a customer service employee daily assignment schedule for Acme Mexico City that addresses the following tasks:

An executive summary
An optimal schedule for full-time and part-time customer service employees that minimizes personnel costs to the extent congruent with the qualitative factors that you determine are relevant
A discussion of the process used to determine the schedule, to include a discussion of all model assumptions and of your qualitative factors

Purchase this Solution

Solution Summary

The solution goes into a great amount of detail regarding the question being asked. Step by step explanation is provided for each part of the question which makes it very easy to follow along for anyone with just a basic understanding of the concepts. Overall, an excellent response to the question being asked.

Solution Preview

I have attached an Excel file which has the model results to answer your question 1. The response to question 2 is below.

The process that was used to determine the ...

Purchase this Solution


Free BrainMass Quizzes
Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.