Kindly do this in excel please c. Rachel knows that she can increase next month's plant capacity by using overtime labor. She can increase the plant's labor-hourcapacity by 25 percent. With the new assembly plant capacity, how many Family Thrillseekers and how many Classy Cruisers shouldbe assembled? Auto AssemblyAutomobile Alliance, a large automobile manufacturing company, organizes the vehicles it manufactures into three families: afamily of trucks, a family of small cars, and a family of midsized and luxury cars. One plant outside Detroit, Michigan, assemblestwo models from the family of midsized and luxury cars. The first model, the Family Thrillseeker, is a four-door sedan with vinyl seats,plastic interior, standard features, and excellent gas mileage. It is marketed as a smart buy for middle-class families with tight budgets, andeach Family Thrillseeker sold generates a modest profit of $3,600 for the company. The second model, the Classy Cruiser, is a two-doorluxury sedan with leather seats, wooden interior, custom features, and navigational capabilities. It is marketed as a privilege of affluencefor upper-middle-class families, and each Classy Cruiser sold generates a healthy profit of $5,400 for the company.Rachel Rosencrantz, the manager of the assembly plant, is currently deciding the production schedule for the next month. Specifically,she must decide how many Family Thrillseekers and how many Classy Cruisers to assemble in the plant to maximize profit for thecompany. She knows that the plant possesses a capacity of 48,000 labor-hours during the month. She also knows that it takes six labor-hours to assemble one Family Thrillseeker and 10.5 labor-hours to assemble one Classy Cruiser.Because the plant is simply an assembly plant, the parts required to assemble the two models are not produced at the plant. Instead, theyare shipped from other plants around the Michigan area to the assembly plant. For example, tires, steering wheels, windows, seats, anddoors all arrive from various supplier plants. For the next month, Rachel knows that she will only be able to obtain 20,000 doors fromthe door supplier. A recent labor strike forced the shutdown of that particular supplier plant for several days, and that plant will not beable to meet its production schedule for the next month. Both the Family Thrillseeker and the Classy Cruiser use the same door parts,with four needed for the Family Thrillseeker and two for the Classy Cruiser.

Decision Variables: Suppose-F be the no. of Family Thrill seekers to be assembled in the next monthC…

c. Rachel knows that she can increase next month's plant capacity by using overtime labor. She can increase the plant's labor-hour capacity by 25 percent. With the new assembly plant capacity, how many Family Thrillseekers and how many Classy Cruisers should be assembled?

c. Rachel knows that she can increase next month's plant capacity by using overtime labor. She can increase the plant's labor-hour capacity by 25 percent. With the new assembly plant capacity, how many Family Thrillseekers and how many Classy Cruisers should be assembled?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter11: Simulation Models

Section: Chapter Questions

Problem 69P: The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon...

See similar textbooks

Similar questions

The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.
A company is setting up an assembly line to produce 90 units per hour. The table below identifies the work elements, times, and immediate predecessors. Work Element Time (Sec.) Immediate Predecessor(s) A 25 - B 18 A C 20 A D 5 B, C E 12 C F 8 E G 16 D, F H 12 G Use one of the heuristic decision rules described in Table below to balance the assembly line so that it will produce 90 units per hour. Clearly state the decision rule you use and complete the below table using the selected rule. Decision Rule Logic Longest work element Picking the candidate with the longest time to complete is an effort to fit in the most difficult elements first, leaving the ones with short times to “fill out” the station. Shortest work element This rule is the opposite of the longest work element rule because it gives preference in workstation assignments to those work elements that are quicker. It can be tried…
Sibanye Stillwater Ltd. said it might cut more than 2,000 jobs at some gold mining operations in South Africa that are struggling to make a profit. The Johannesburg-based precious metals producer will enter into consultations with labour groups and other stakeholders on the proposed restructuring, which could affect 1,959 employees and 465 contractors at its Beatrix 4 shaft and Kloof 1 plant. The operations aren’t profitable as they are running out of commercially viable ore, and they face rising costs and lower output levels, Sibanye said in a statement. “To allow shafts and operating plants that are no longer sustainable to continue operating at a loss will threaten the remaining life of mine of the other South African gold operations,” said Richard Stewart, Sibanye’s chief regional officer for Southern Africa. Sibanye, the largest employer in South Africa’s mining sector, was hit by a workers’ strike over wages for almost three months earlier this year. The…
As part of a quality improvement initiative, Enterprise Technology employeescomplete a three-day training program on teaming and a two-day training programon problem-solving. The manager of quality improvement has requested that atleast eight training programs on teaming and at least ten training programs on problem-solving be offered during the next six months. In addition, senior-level managementhas specified that at least twenty-five training programs must be offered during this period.Enterprise Technology hires a consultant to teach the training programs. Duringthe next quarter, the consultant has eighty-four days of training time available. Each trainingprogram on teaming costs ten-thousand dollars and each training program on problem-solvingcosts eight thousand dollars. a. First step is to formulate a linear programming model that can be used to determine thenumber of training programs on teaming and the number of training programs onproblem-solving that should be offered in…
Monica Britt has enjoyed sailing small boats since she was 7 years old, when her mother started sailing with her. Today, Monica is considering the possibility of starting a company to produce small sailboats for the recreational market. Unlike other mass-produced sailboats, however, these boats will be made specifically for children between the ages of 10 and 15. The boats will be of the highest quality and extremely stable, and the sail size will be reduced to prevent problems of capsizing. Her basic decision is whether to build a large manufacturing facility, a small manufacturing facility, or no facility at all. With a favourable market, Monica can expect to make R90,000 from the large facility or R60,000 from the smaller facility. If the market is unfavourable, however, Monica estimates that she would lose R30,000 with a large facility and she would lose only R20,000 with the small facility. Because of the expense involved in developing the initial moulds and acquiring the…
Projects W, X, Y, and Z are each being screened according to four criteria:Potential Return on Investment, Lack of Technological Risk, Environmental“Friendliness,” and Service to Community:• Project W: Return, high; Risk, medium; Environment, medium; Service, low• Project X: Return, medium; Risk, high; Environment, medium; Service, low• Project Y: Return, medium; Risk, medium; Environment, high; Service, high• Project Z: Return, medium; Risk, medium; Environment, high; Service, low.Create a scheme for screening the projects, assuming equal weight for all criteria.Which project comes out best; which word explain the output of scope with help of figure. How risk been evauted while describing the scope management.
Gotham City has 10,000 streetlights. City investigatorshave determined that at any given time, an average of 1,000lights are burned out. A streetlight burns out after an averageof 100 days of use. The city has hired Mafia, Inc., to replaceburned-out lamps. Mafia, Inc.’s contract states that thecompany is supposed to replace a burned-out street lamp inan average of 7 days. Do you think that Mafia, Inc. is livingup to the contract?
Read the following case and answerthe questions given below:Students in Mrs. Rickshaw’s Student Success class are required to do a half hour team presentation on a topic of their choice. Mrs. Rickshaw randomly assigns students to teams. Students have approximately four weeks to research and prepare, including two hours of class time. Marks are given based on an instructor evaluation of the presentation combined with a peerevaluation by their team members.Jane, Robert, Danny, Sharon and Liz were assigned to Team 3. During their first team meeting they introduced themselves and began to decide on a topic.After 45 minutes, they were still trying to settle on a topic. They finally settled on Money Management, however the instructor informed them that another team had already chosen that topic but Conflict Management was still available. During the last 15 minutes of class time, Robert tried to convince the group that they should present a role-play of conflict. Sharon wanted to do…
See the answer A local movie studio wants to determine which of two new scripts they should select for their next major production. The manager feels that script #1 has a 70% chance of earning Php100 million over the long run, but a 30% chance of losing Php20 million. If this movie is successful, then a sequel could also be produced, with an 80% chance of earning Php50 million, but a 20% chance of losing Php10 million. On the other hand, she feels that script #2 has a 60 % chance of earning Php120 million, but a 40% chance of losing Php30 million. If successful, its sequel would have a 50% chance of earning $80 million and a 50% chance of losing Php40 million. As with the first script, if the original movie is a "flop," then no sequel would be produced. What is the expected payoff from selecting script #2?
At Brick House Masonry Supply, it is time for annual pay raises for the fork lift operators. Cody currently earns $23.04 per hour and is receiving a raise equivalent to 3.125% of his current pay. Gregg currently earns $22.75 per hour and is receiving a raise equivalent to 0.04 of his current pay. Kendall currently earns $22.60 per hour and is receiving a raise equivalent to of his current pay. List the employees in order from least hourly pay to greatest hourly pay based on their pay after the raises have gone into effect.
Sarah Chang is the owner of a small electronics company. In six months, a proposal is due for an electronic timing system for the next Olympic Games. For several years, Chang’s company has been developing a new microprocessor, a critical component in a timing system that would be superior to any product currently on the market. However, progress in research and development has been slow, and Chang is unsure whether her staff can produce the microprocessor in time. If they succeed in developing the microprocessor (probability p1), there is an excellent chance (probability p2) that Chang’s company will win the $1 million Olympic contract. If they do not, there is a small chance (probability p3) that she will still be able to win the same contract with an alternative but inferior timing system that has already been developed. If she continues the project, Chang must invest $200,000 in research and development. In addition, making a proposal (which she will decide whether to do after…
Sarah Chang is the owner of a small electronics company. In six months, a proposal is due for an electronic timing system for the next Olympic Games. For several years, Chang’s company has been developing a new microprocessor, a critical component in a timing system that would be superior to any product currently on the market. However, progress in research and development has been slow, and Chang is unsure whether her staff can produce the microprocessor in time. If they succeed in developing the microprocessor (probability p1), there is an excellent chance (probability p2) that Chang’s company will win the $1 million Olympic contract. If they do not, there is a small chance (probability p3) that she will still be able to win the same contract with an alternative but inferior timing system that has already been developed. If she continues the project, Chang must invest $200,000 in research and development. In addition, making a proposal (which she will decide whether to do after…