Employees work three consecutive quarters

Assignment Help Operation Management

Reference no: EM132233194

How would this question be answered using the SUMPRODUCT format in excel?

Each year, a shoe manufacturing company faces demands (which must be met on time) for pairs of shoes as shown in the table below.

Quarter 1 Quarter 2 Quarter 3 Quarter 4

Demand 6000 3000 8000 1000

Employees work three consecutive quarters and then receive one quarter off. For example, a worker might work during quarters 3 and 4 of one year and quarter 1 of the next year. During a quarter in which an employee works, he or she can produce up to 500 pairs of shoes. Each worker is paid £5000 per quarter. At the end of each quarter, a holding cost of £10 per pair of shoes is incurred.

a) Formulate algebraically a linear programme to minimise the cost per year (labour plus holding) of meeting the demands for shoes. To simplify the model, assume that at the end of each year, the ending inventory is 0. (You can assume that a given worker gets the same quarter off during each year.)

Reference no: EM132233194

Questions Cloud

Determine most effective markets for their products-services : Briefly describe health care provider with which you are familiar and determine the most effective markets for their products/services.

Describe one characteristic of a workplace situation : Identify and describe one characteristic of a workplace situation that may influence the way leader behavior affects follower responses.

What effect do you think the president message will have : What effect do you think the president's message will have on the nation's economy, particularly the nation's economic measures of well-being?

What is additional inventory carrying cost : What is the additional inventory carrying cost that will be incurred on this item because of your decision to increase the service level?

Employees work three consecutive quarters : Employees work three consecutive quarters and then receive one quarter off.

How many units of each good will she purchase : ECON300 A consumer has a budget of $500 to spend on two goods, X and Y. She likes to consumer a unit of X in combination with a unit of Y.

Discuss recruitment-retention and employee engagement : Discuss recruitment, retention, and employee engagement in the early career to the success of a career and differentiate between the employers’

Work with in acquiring project implementation resources : Of the departments/groups listed below, which might be essential to work with in acquiring project implementation resources?

Differentiate variations between licensures-certification : Differentiate the variations between licensures, certification, measures and accreditation, why it is significant to health care in the United States,

User Account

All Pages