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

Questions Cloud

Describe the contemporary issue in detail : Describe the contemporary issue and explain what external stressors are associated with this issue. Outline assessment strategies to screen for this issue.
Essay incorporating their personal philosophy of leadership : Students will be required to submit a reflective essay incorporating their personal philosophy of leadership and analyse an organisational leadership issue.
Define how the nursing theory supports nursing practice : Provide three evidence-based examples that demonstrate how the nursing theory supports nursing practice. Provide support and rationale for each.
Difference among line-line-staff and matrix organization : Write the difference among line, line-staff, functional & matrix organization? what is attitude and ethics?
Standard form with appropriate use of sumproduct functions : Construct an Excel spreadsheet model of your linear program in “standard form” with appropriate use of SUMPRODUCT functions.
What is the strategic plan of the program : Access The Agency for HealthCare Research and Quality (AHRQ) website and select one of the multiple funded programs available to research.
Principles of self-interested egotism : Ayn Rand uses the trial scene in The Fountainhead to vindicate her hero, Howard Roark, and her principles of self-interested egotism.
Review problem on accessing health records online : What ethical concerns do you have about the sharing of health data online? The response must be typed, single spaced, must be in times new roman font.
Describe various risk factors to adolescent pregnancy : Adolescent pregnancy is viewed as a high-risk situation because it poses serious health risks for the mother and the baby. Describe various risk factors.

Reviews

Write a Review

Operation Management Questions & Answers

  Worked extensively in japanese manufacturing

"Class: As you already know, Total Quality Management was developed by a management consultant named William Deming, who worked extensively in Japanese manufacturing.

  Some of the legal implications of job analysis process

Explain some of the legal implications of the job analysis process and substantiate it with examples.

  Describe your targeted career area

Determine what training, education and/or other background you might need to be promoted into such a position.

  Other automobile manufacturer brand images

Think about Ford and other automobile manufacturer’s brand images.

  Difficult adaptation issue involved in foreign assignment

Would you like to have a foreign assignment? What do you think would be the most difficult adaptation issue involved in a foreign assignment?

  Reconsidering its current inventory control system

Crew Soccer Shoes Company is reconsidering its current inventory control system and distribution strategy for soccer shoes. The information regarding the shoes is as follows: Annual Demand = 1000 pairs/year Lead time = 1 week Order cost = $35/order H..

  Faced with making an it system procurement

As IT systems become more sophisticated, their costs increase, as does the complexity of implementation. If you are the CEO of a small private organization and you are faced with making an IT system procurement, would you support a custom or off-the-..

  Significance of fully integrated delivery system

What is the significance of a fully integrated delivery system (IDS)? Describe its development in terms of horizontal and vertical integration. Describe its development in terms of the limited health care premium dollar. What is its impact on custome..

  On any new product development project a real project

ON ANY NEW PRODUCT DEVELOPMENT PROJECT A REAL PROJECT

  Discuss some of the personal traits

Discuss some of the personal traits that you believe would be important for business leaders today. Are they more important in some situations than in others? What skills would a leader need to have to be effective managing in a virtual environment?

  Principles apply in both private and public organizations

Recently, the U.S. Supreme Court ruled that cities could have voucher program that give money directly to parents, and the parents can then choose between competing schools: public and private. The idea for promoting such a ruling was to create compe..

  Materials management and purchase management

Explain why your business is located where it is. Discuss issues pertinent to its location - Requesting that the company should be a local company in oman

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