Multi-period production planning at zeta

Assignment Help Operation Management
Reference no: EM131344949

Case Study: Multi-period Production Planning at Zeta, p.362

Attached is the case study. This needs to be completed in Excel and any diagrams need to be able to edited, they cannot be cut and pasted into the excel spreadsheet. ALSO please show your work in excel, utilizing solver. I need to be able to see how you came up with the answer. If completed correctly I will tip extremely well

1. Discuss the process of maximizing profits by determining how much of three products to produce each month given different demands, costs, and constraints.

*note there is one typo in the case - the first line of the second paragraph should read "The company can produce only up to 75,000..." not 7,500.

2. Create a linear programming that maximizes expected profits. Use Solver to determine how much of each product to make each month. Remember, there is no reason to make more than what is demanded and you can only make 75,000 total products each month. Calculate the total profit for the 6 months by subtracting the costs for each product by the sales. Assume you can sell everything you can make as long as it's less than the demand.

3. At a cost of 1 million dollars you can increase your maximum production from 75,000 a month to 80,000 a month. Is this investment worth it? Compare the maximum profit you found above with one in which the constraint of total production increases to 80,000 a month.

Month

LG

MG

HG

1

50,000

25,000

15,000

2

45,000

20,000

18,000

3

35,000

35,000

20,000

4

40,000

30,000

22,000

5

46,000

28,000

21,000

6

60,000

32,000


Reference no: EM131344949

Questions Cloud

Draw a block diagram to solve your equation : Draw a block diagram to solve your equation (vO(t) should be your output) using differentiators.- Draw a block diagram to solve your equation (vO(t) should be your output) using integrators.
Draw a supply and demand graph : Draw a supply and demand graph and identify the areas of consumer surplus and producer surplus. Given the demand curve, what impact will an increase in supply have on the amount of consumer surplus shown in your diagram
Demand for trains is unlimited : Each week, Giapetto can obtain all the needed raw material but only 100 finishing hours and 80 carpentry hours.  Demand for trains is unlimited, but at most 40 soldiers are bought each week.  Giapetto wants to optimize weekly profit (revenues - co..
Explain answer taking into account attitudes toward risk : "I propose executing one spammer per year. That way, even if we don't catch and convict many, the penalty will have substantial deterrent effect. Because the cost of executing them is much less than the cost of catching them, it is cost effective ..
Multi-period production planning at zeta : Attached is the case study. This needs to be completed in Excel and any diagrams need to be able to edited, they cannot be cut and pasted into the excel spreadsheet. ALSO please show your work in excel, utilizing solver. I need to be able to see h..
Calculate the rate of unemployment : Calculate the labour force. Calculate the percentage of people not in the labour force. Calculate the rate of unemployment. Calculate the labour force participation rate
Review the motivational ideas or theories addressed : Review the motivational ideas or theories addressed in the readings Using yourself as an example, do you feel that one or more of the ideas or theories are particularly effective in motivating you, or is there a better way you can be motivated?
Litigation process representative of employer : Recommend a plan or strategy to be followed by safety professionals if they become involved in the litigation process as a representative of an employer organization.
Explain background information on how that problem developed : Describe background information on how that problem developed or came into existence. Show why this is a societal problem, and provide perspectives from multiple disciplines or populations so that you fully represent.

Reviews

Write a Review

 

Operation Management Questions & Answers

  Optimal values of decision variables and objective function

First, what happens to the slope of the objective function when one of its parameter coefficients changes? If a parameter coefficient in the objective function changes too much in one direction, then elaborate upon whether it is possible for a new "c..

  Describe conflict causes in organizations

What causes conflict in organizations? Many of the organizational behavior topics that have been addressed in the class thus far include the opportunity for conflict to emerge.

  Identify and interpret interrelationships of the frames

Structural Frame and Metaphors/Issues and Options, Human Resources Frame and Metaphors/Issues and Options, Identify and interpret interrelationships of the frames

  Whats the evaluation and management code

Whats the Evaluation and Management code for this? A full-term healthy newborn girl received initial and subsequent hospital care services on July 7 and July 8, respectively.

  Process improvement that reduces processing time

A company has introduced a process improvement that reduces processing time for each unit, so that output is increased by 20% with less material, but one additional worker required. What increase in productivity is associated with the process improve..

  Revenue management assignments

Revenue Management Assignments II. San Francisco Express Airlines, SaFE for short, flies from PHL to SFO. On a Thursday evening flight, the number of last-minute no-shows and cancellations is Poisson distributed with mean 7.5. To maximize revenue fro..

  Did the group leader provide a meaningful academic argument

Does the paper provide a cohesive summary of the assigned concepts with an effective evaluation of their implications for organizational leadership? Did the Group Leader provide a meaningful academic argument or interpretation that demonstra..

  What is the maximum number of orders waiting

What is the maximum number of orders waiting to be packed? If we double the packing capacity (from 60 to 120 orders per hour), what impact does this have on your answers in parts b, c, and d?

  Discuss about the management century

Read the article, "The Management Century". Based on the content presented in the article, describe the evolution of management and how management practices have changed over time. How has our understanding of management changed over time? Why ha..

  What is a variable

What is a variable? Describe at least two levels of each variables selected above. Define what is meant by an operational definition of a variable. Use two of the variables you listed above and give an operational definition for each one.

  Impact will market commonality have on competitive responses

What impact will market commonality have on competitive responses in the auto industry?  What strategic actions and/or responses might occur as a result of your answer to question 1? Can Hyundai be identified as a late mover? If so, why? If you deter..

  Campbells intended expansion in emerging markets

What are the potential advantages and disadvantages of Campbell's intended expansion in emerging markets? Do you believe Campbell’s is using a multi country strategic approach or a global strategic approach? Fully explain your reasoning.

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