WeaponCost(gold pieces)Damage to medium targetsCritical damageWeight(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 shouldhis 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 Explain the results in sentence form.

Answered: Weapon Cost (gold pieces) Damage to…

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

Related questions

Question

Weapon

Cost

(gold pieces)

Damage to medium targets

Critical damage

Weight

(pounds)

Throwing axe

Javelin

Longsword

Mace (light)

Spear

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?