Weapon Cost (gold pieces) Damage to medium targets Critical damage Weight (pounds) Throwing axe 8 6 12 2 Javelin 1 6 12 2 Longsword 15 8 32 4 Mace (light) 5 6 12 4 Spear 2 8 24 6 The Orc leader Achluk has up to 50,000 gold pieces to spend on an arsenal of axes, maces, and spears for his army of orcs for a planned assault on Hobshire, in which he would like to inflict as much damage on medium targets (like humans and hobbits) as possible. To avoid excessive transportation costs, Achluk needs to limit the total weight of the arsenal to 40,000 pounds or less, as his orcs are particularly fond of axes but not particularly skilled at spear-throwing, he would like to include at least as many axes as spears in the arsenal. What should his weapons arsenal look like, and how much damage on medium targets can be inflicted? Define the variables. Construct the objective and constraint functions. Use Excel to use the simplex method to optimize the objective function. Paste the Excel output below

Weapon Cost (gold pieces) Damage to medium targets Critical damage Weight (pounds) Throwing axe 8 6 12 2 Javelin 1 6 12 2 Longsword 15 8 32 4 Mace (light) 5 6 12 4 Spear 2 8 24 6 The Orc leader Achluk has up to 50,000 gold pieces to spend on an arsenal of axes, maces, and spears for his army of orcs for a planned assault on Hobshire, in which he would like to inflict as much damage on medium targets (like humans and hobbits) as possible. To avoid excessive transportation costs, Achluk needs to limit the total weight of the arsenal to 40,000 pounds or less, as his orcs are particularly fond of axes but not particularly skilled at spear-throwing, he would like to include at least as many axes as spears in the arsenal. What should his weapons arsenal look like, and how much damage on medium targets can be inflicted? Define the variables. Construct the objective and constraint functions. Use Excel to use the simplex method to optimize the objective function. Paste the Excel output below

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.
Weapon Cost (gold pieces) Damage to medium targets Critical damage Weight (pounds) Throwing axe 8 6 12 2 Javelin 1 6 12 2 Longsword 15 8 32 4 Mace (light) 5 6 12 4 Spear 2 8 24 6 The elf leader Galandir has up to 30,000 gold pieces to spend on an arsenal of javelins, longswords, and spears for her band of elves for a planned assault on Mordruk in which she would like to inflict as much critical damage possible. For the sake of swiftness the total weight of Galandir’s arsenal cannot exceed 3000 pounds, and as the elves are particularly skilled at javelin-throwing she would like to include at least half as many javelins as swords. What should her weapons arsenal look like, and how much critical damage can be inflicted? Define the variables. Construct the objective and constraint functions. Use Excel to use the simplex method to optimize the…
11-20 Monohan Machinery specializes in developing weed-harvesting equipment that is used to clear small lakes of weeds. George Monohan, president of Monohan Machinery, is convinced that harvesting weeds is far better than using chemicals to kill weeds. Chemicals cause pollution, and weeds seem to grow faster after chemicals have been used. George is contemplating the construction of a machine that would harvest weeds on narrow rivers and waterways. The activities that are necessary to build one of these experimental weed-harvesting machines are listed in the following table. Construct a network for these activities. 11-21 After consulting with Butch Radner, George Monohan was able to determine the activity times for constructing the weed-harvesting machine to be used on narrow rivers. George would like to determine ES, EF, LS, LF, and slack time for each activity. The total project completion time and the critical path(s) should also be determined. (See Problem 11-20 for details.) The…
PREAMBLE The recent Akosombo Dam spillage has displayed an estimated 35,857 people including children. People have lost their belongings and livelihoods. Schools, hospitals, and shops have been destroyed. The United Nations Relief and Works Agency (UNRWA) in collaboration with the Government of Ghana and the Youth Association of the area has decided to relocate permanently the displaced citizens to a 5,000-hectare piece of land acquired from the chiefs and people of Saglemi in the Greater Accra Region. The UNRWA will provide funding to the tune of US$600 million. The funds for the acquisition of the land are provided by the Government of Ghana and the United Tongu Youth Association in the Diaspora. The Entire Project has been contracted to a Consortium of three colleagues at KNUST. The College of Art and Built Environment, College of Engineering, College of Health Sciences, and College of Social Sciences. 2. THE PROJECT The relocation is in FOUR PHASES as follows: Phase 1:…
Scenario You are going to plant a rectangular flower bed consisting of tulips in the middle surrounded by daisies on the outside. You have the same amount of each flower and will need an equal area for each. You want the border of daisies to be uniform around the tulips in the middle, as shown in the diagram below:
Sigma Airway: In 2021, Sigma Airway was considering the possibility of adding a new economy class to the two existing classes - first class and tourist -in the hope that the total contribution to its profit from fares might be increased. Ms. Somsri, the marketing manager for Sigma had to decide within the next week whether or not to introduce such as a change. If introduced, the new class would have to be retained for at least 100 days. Somsri felt that the essential question to be answered in her analysis was whether such a deal would attract sufficient new customers to offset the loss of revenue from existing tourist customers switching to the lower-contribution economy class. Somsri, having had some experience with these problems in the past, made the following assessments: On an average day she felt that there was a 1 in 3 chance that 200 new customers would be attracted to the new class, a 1 in 3 chance at the figure would be around 100 new customers, and a 1 in 3 chance that it…
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…
BJ is the manager of a Grocery Store. She now needs to replenish her supply of strawberries. Her regular supplier can provide as many cases as she wants. However, because these strawberries already are very ripe, she will need to sell them tomorrow. BJ estimates that she will be able to sell 10, 11, 12, or 13 cases tomorrow. She can purchase the strawberries for $3 per case and sell them for $8 per case. However, any unsold case tomorrow will be sold to nearby Cafeterias at a flat price of $2 per case. BJ now needs to decide how many cases to purchase today to be offered for sale tomorrow. BJ has checked the store's records on daily sales of strawberries. On this basis, she estimates that the prior probabilities are 0.2, 0.4, 0.3, and 0.1 for being able to sell 10, 11, 12, and 13 cases of strawberries tomorrow. (a) Develop a decision analysis structured model of this problem using Excel formulas by identifying the decision alternatives, the states of nature, and the payoff table. (b)…
5. Meg Jones, the CEO of Ajax Computer Company, and Brad Smith, its Director of Operations, had been discussing how to increase the firm’s production of the company’s flagship XR58. The XR58 was particularly important because it sold 12,500 of them in the most recent year for $950, at a gross margin of 55%. After a lot of discussion, they decided to pursue an incentive system designed to increase production by 12% in the next year. After Brad discussed this possible incentive with the production team, the team determined that it could increase production by this amount without adding any more people or equipment. They believed they could accomplish this improvement primarily through process redesign. To incent them to do the hard work of process improvement, Brad told the team that it would receive 25% of the increased profits if it met the new production goal. For this team of 20 people, this would mean an additional compensation of _________ for each team member, on average, for…
A rural cooperative purchased a trencher at a cost of P230,500.00. It is estimated that the trencher will have a salvage value of P25,000.00 after digging 300,000 meters of irrigation canals. Determine the book value of the trencher after two years, if it was used to dig 50,000 meters on the first year and 75,000 meters on the second year. (Ans. P144,875.00)
ABCar Co is a new type of car company. They hire various subcontractors namely DesignCar Ltd., who designs the cars, ManuCar Inc., who manufactures the vehicles, and TestCar Co., who tests the cars before they are put into full production. Recently, ABCar Co has received many complaints about the failure of the braking system. There is a dispute between ABCar Co, DesignCar Ltd., ManuCar Inc., and TestCar Co. as to who is responsible for the problem and who must bear the cost to fix it. Referring to the dispute resolution mechanisms you explained in question 3 (a) (you don't need to reproduce the information), which dispute resolution mechanism would you select to resolve this dispute and why would you select it? Why would you reject the other ones?
Hyewon Kim owns her own catering business. She continually monitors her other expense costs, including the cost of liability insurance for drivers of her catering vans. This year, Hyewon’s auto insurer advises her that insurance rates for her coverage will increase by 15 percent next year. The insurance company also states that if Hyewon will institute a preemployment drug-testing program for those employees who will drive her vans, there will be no insurance rate increase. Hyewon does not currently require potential employees to agree to be drug-tested prior to becoming employed in her business, but it is legal to do so in her state. What should Hyewon tell potential employees about her reason for implementing a preemployment drug-testing program? What should she do if a potential employee refuses to agree to the test?