Assume that you are the president and CEO of Acme Fireworks and Rocketry. You have 3 products: A roadrunner seeking missle that earns $7.50 profit and requires 12kg semtex, 100kg of rocket fuel, and 100 labor hours to create An anti-roadrunner bomb that earns $3.50 profit and requires 50kg semtex, 0kg of rocket fuel, and 110 labor hours to create A piano that earns $12 profit and requires 0kg semtex, 0kg rocket fuel, and 200 labor hours to create. You have 5000 labor hours. You have 1500kg semtex. You have 2500kg rocket fuel. You must make at least 2 of each item.
Give the maximum amount of profit that can be earned on a Bomb that does not generate a change in the product mix.
Using Excel to solve this question.