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

  To develop appropriate annual goals

To develop appropriate annual goals which of the following areas should  NOT be considered on those goals: - Customer satisfaction - Cost of poor quality

  Analyze implications of changes in project scheduling

Analyze implications of changes in project scheduling. Evaluate application of project management techniques in terms of the firm's business operational goals and requirements.

  How much of her loss may she deduct as an ordinary loss

Years later, she contributed an additional $20,000 to the corporation to try to help the corporation get through some trying times.

  Receive federal funding for post-secondary education

Prisoners can receive federal funding for post-secondary education.

  Determining the appropriate? quantity-in-stock

determining the appropriate? quantity-in-stock for each of his? firm's items and managing inventory costs

  Challenges includes the scarcity of drinking water

How would you recommend the solution for shanghai port of their challenges includes the scarcity of drinking water, school dropouts and insecurity.

  Which business cost containment approach

Which business cost containment approach is being used in the healthcare industry?

  Describe your purpose to impact plan

Describe your Purpose to Impact plan. What is your purpose statement? What is your first critical step to implement your impact plan?

  Identify whether the failure was legal or ethical

WestJet apologized to Air Canada on Monday and will pay $15.5 million to settle a lawsuit over a case of corporate espionage. What were the points of failure in this incident? For each failure point, identify whether the failure was legal or ethical...

  A leadership structure establish a communication plan set

At a minimum, the team must: decide on a name select a leadership structure establish a communication plan set a schedule for the project.

  Productivity of the two options

Calculate and compare the multi-factor (labour, input and overhead) productivity of the two options. Which location is preferred?

  Tacit collusion strategies and strategic alliance strategies

What are the critical differences between tacit collusion strategies and strategic alliance strategies?

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