Standard form with appropriate use of sumproduct functions

Assignment Help Operation Management
Reference no: EM132233977

Each year, a shoe manufacturing company faces demands (which must be met on time) for pairs of shoes: quarter 1, 4000; quarter 2, 7000; quarter 3, 8000; quarter 4, 3000. 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 600 pairs of shoes. Each worker is paid $6000 per quarter. At the end of each quarter, a holding cost of $10 per pair of shoes in incurred. Assume that at the end of each year, the ending inventory is 0.

a) Formulate a linear program to help company management determine how to minimize the cost per year (labor plus holding) of meeting the demand for shoes.

b) Construct an Excel spreadsheet model of your linear program in “standard form” with appropriate use of SUMPRODUCT functions.

Reference no: EM132233977

Logistics management and supply chain management

Differentiate between the concept of logistics management and supply chain management, including the relationship of each to the concept of the value-added chain. ?Describe th

Project change control in an agile project environment

Should the project manager be in charge of project change control in an agile project environment? Who should be in charge of project change control for a traditional project?

What are your views on just war

What are your views on "Just War"? Just war theory-the doctrine that war may be morally permissible under certain conditions-is a morally sound doctrine. Do you agree or disag

In an effort to reduce costs across the board

In an effort to reduce costs across the board, Pilchard wishes to hire recent graduates of MBA programs who have little experience. What if one or more of the older employees

Approach to addressing the situation

Describe a current event within your healthcare organization that requires leadership attention. Apply a leadership style that most closely represents your approach to address

Several collaboration tools that are useful for remote teams

List several collaboration tools that are useful for remote teams and explain how they help in running successful remote team projects? Would you be using those tools? If so,

What factors did the court consider in analyzing the case

For the Rowe vs. New Hampshire Motor Transport Association, write an analysis of each case using the following format: What was the Court’s ruling/decision? (i.e., what did th

Establishing and weighing of decision criteria

The process of rational (analytical) decision making involves problem identification, establishing and weighing of decision criteria, generation and evaluation of alternatives


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd