Reference no: EM131442310
(THE QUESTION IS FROM PRODUCTION AND OPERATIONS ANALYSIS , 7TH EDITION, CHAPTER 3RD, 36TH PROBLEM)( THE PROBLEM IS MOSTLY SOLVED IN EXCEL)
The yeasty brewing company produces a popular local beer known as iron stomach. Beer sales are some what seasonal, and yeasty is planning its production and workforce levels on march 31st for the next six months. the demand forecasts are as follows:
month production days forecast demand (in hundreds of cases)
april 11days 85cases
may 22days 93cases
june 20days 122cases
july 23days 176cases
august 16days 140cases
sept 20days 63cases
As of march 31, yeasty had 86 workers on the payroll. over a period of 26 working days when there were 100 workers on the payroll, yeasty produced 12000 cases of beer. The cost to hire each worker is $125 and cost of laying off each worker is $300.Holding costs amount to 75 cents per case per month.
As of march 31, yeasty expects to have 4500 cases of beer in stiock, and it wants to maintain buffer inventory of 1000 cases each month. It plans to start october with 3000 cases on hand.
a) Based on the information find the minimum constant workforce plan for yeasty over the six months, and determining hiring, firing, and holding costs associated with that plan.
b) Suppose that it takes one month to train a new worker. How will that affect your solution?
c) Suppose that the maximum number of workers that the comapny can expect to be able to hire in one month is 10. How will it affect your solution in part (a)?
d) Formulate the problem levels as a linear program. ( you may ignore the conditions in parts (b) and (c))
e) Sove the resulting linear program. Round the appropriate variables and determine the cost ofyour solution.
f) Suppose yeasty doesnt not wish to fire any workers.What is the optimal plan subject to this constraint?
|
Solving linear programming problem
: The objective function line (i.e., iso-profit line) is a method for solving a linear programming problem generally going to have a greater value as it is moved further from the origin a line with the same profit at all points parallel to all other is..
|
|
Significantly changed since the policies enactment
: A number of policies can protect patients from faulty, dangerous, or unnecessary medicines, medical procedures, and services. After completing the reading for the week identify one such policy, summarize how it protects patients, and state whether or..
|
|
Result of successful training program
: One of the following does not belong in the list of criteria on which a team’s strength must be evaluated initially when the team is formed and later periodically. One of the following will not be a result of a successful training program.
|
|
Rocky mountain order each time it places an? order
: Rocky Mountain Tire Center sells 8 comma 000 ?go-cart tires per year. The ordering cost for each order is ?$40 ?, and the holding cost is 40 ?% of the purchase price of the tires per year. How many tires should Rocky Mountain order each time it place..
|
|
Formulate the problem levels as a linear program
: The yeasty brewing company produces a popular local beer known as iron stomach.Beer sales are some what seasonal, and yeasty is planning its production and workforce levels on march 31st for the next six months. Based on the information find the mini..
|
|
Reviewing resumes you obtained from an online service
: Why should the selection process be adapted to fit the organization's job descriptions? Suppose your organization needs to hire several computer programmers, and you are reviewing resumes you obtained from an online service. What kinds of information..
|
|
Process be adapted to fit the organizations job description
: What activities are involved in the selection process? Think of the last time you were hired for a job. Which of those activities were used in selecting you? Should the organization that hired you have used other methods as well? Why should the selec..
|
|
Browse the newspapers and magazines
: Almost every day Sally took a break at lunch and went to the International News Stand—a magazine store—to browse the newspapers and magazines and chat with the owner, Conrad. Often she bought a magazine. One day she went there, browsed a bit, and too..
|
|
Innovative technology in production to increase efficiency
: The toy industry is very fickle and innovation is critical. Sales for January 2017 showed only a 3% rise over January 2016 leaving the company managers concerned about meeting projected sales targets for 2017. use innovative technology in production ..
|