Ask Question, Ask an Expert


Ask Operation Management Expert


To the extent allowed by local law, each Acme Home Improvements store, including Acme Mexico City (AMC), is open from 7 am - 11 pm every day.

Acme Mexico City planners have given the following table that identifies the minimum number of customer service employees estimated to be required on the floor of the store each hour of the day:

734_customer service employees.jpg

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, this is consistent with Mexican labor law, the company limits total part-time customer service employee daily hours to 50% of the day's total customer service employee hours (total hrs = part-time hrs plus fulltime hrs) worked.

In the interest of appropriate supervision of employees and employee safety rules, management has a policy which the number of customer service employees on the floor at any given time must never exceed 30.

Part-time customer service employees earn $500 per day, and full-time customer service employees earn $1100 per day in salary and benefits (here, $ = Moneda Nacional, that is, the Mexican peso).

Contract Statement of Work:

Develop a minimum cost day by day assignment schedule for the Acme Mexico City customer service employees.


1) A report which provides your recommended schedule/cost and illustrates your solution method. (Note: Try to provide a comprehensive description, but keep it simple enough). As well, be sure to comprise any suppositions or limitations for your model.

2) A copy of the documented spreadsheet model you develop, so that we can rerun it if the situation changes. For this work you will be paid a sum of $9,000 (Mexican pesos).

Additional funds (up to $1,000 pesos) are available under the contract if you can help with the given:

a) Finding out the cost of enforcing the part-time hours constraint (that is, How much money could we save if part-time hours are not limited to 50% of total hours?)

b) Finding out whether adding an additional lunch shift at 10 am and an additional dinner shift at 7 pm can lower our daily cost.

Operation Management, Management Studies

  • Category:- Operation Management
  • Reference No.:- M92712

Have any Question? 

Related Questions in Operation Management

What is an infosec program what functions constitute a

What is an InfoSec program? What functions constitute a complete InfoSec program? What organizational variables can influence the size and composition of an InfoSec program's staff? What is the typical size of the securi ...

Discuss the importance of worker retention of top

Discuss the importance of worker retention of top performers. What are the implications of this during a slow economy? Explain. With reference

Analyze the issues of using military force against

Analyze the issues of using military force against terrorism. Does one method work better than another? Explain your answer.

Q-1 explain the purpose of background investigationsq-2

Q-1. Explain the purpose of background investigations. Q-2. Explain why employee training is important? Also discuss Why career development is valuable to organizations Q-2. Describe the appraisal process. How should it ...

Create a matrix for 3 of the following tools used in

Create a matrix for 3 of the following tools used in quality improvement: Bar graph Histogram Pareto chart Pie chart Line chart Control chart Submit a report of 2-3 pages (with the matrix) that addresses the following: T ...

Discuss about the prejudice and discriminationstereotyping

Discuss about the prejudice and discrimination,stereotyping, glass ceiling,, bias, discrimination, give example for each one.

Process design amp supply chain evaluation -select a

Process Design & Supply Chain Evaluation - Select a company with which you are familiar. This could be your place of employment, a place you would like to work, or a business you frequent. Create a 14-slide presentation ...

In 200-300 word compare compensation plans for each of the

In 200-300 word compare compensation plans for each of the position in Ford Motor Company and the two jobs being a Engineer Specialist and a Production/Business Planning Analyst.

Triano brothers an insurance firm follows an administrative

Triano Brothers, an insurance firm, follows an administrative procedure for measuring the relative worth of its jobs. The organization does this by assembling and training a committee consisting of people familiar with t ...

Discussion video review - crew resource management crmcrew

Discussion: Video Review - Crew Resource Management (CRM) Crew Resource Management - Human Factors and their relationship with equipment, procedures, people and the environment. Please go to the following video - Crew Re ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro