You run an animal shelter facility and are asked to purchase food supply for the next month. You normally purchase two types of food, Purina and Natural Choice. Purina costs \( \$ 180 \) per bag. Each bag weighs 80 pounds and can feed as many as six animals per month. The Natural Choice bag costs \( \$ 110 \), weighs 60 pounds, and can feed four animals per month. There is a new type of food, Pedigree, which you must consider purchasing. Pedigree food costs \( \$ 110 \) per bag. Each bag of Pedigree weighs 180 pounds and can feed as many as 16 animals per month. You have been given a maximum budget of \( \$ 2,800 \) for this purchase, although you don't have to spend that much. The facility has room for no more than 2,000 pounds. You can only buy whole bags of each food. Create an adequate mode and solve it in Excel to maximize the number of animals to be fed during the month.
Upstudy ThothAI Solution
Quick Answer
Step-by-step Solution
Enter your question here…