Hiland’s TV-Radio Store must determine how many TVs and radios to keep in stock. ATV requires 10 square feet of floor space, whereas a radio requires 4 square feet; 5000 square feet of floor space is available.

ATV sale results in an $80 profit, and a radio earns a profit of $20. The store stocks only TVs and radios. Marketing requirements dictate that at least 60% of all appliances in stock be radios. Finally, a TV ties up $200 in capital, and a radio $50. Hiland wants to have at most $60,000 worth of capital tied up at any time.

a. Determine how to maximize Hiland’s profit.

b. Use SolverTable to explore how much profit the minimum percentage of radio requirement is costing Hiland’s.

c. Use SolverTable to explore how much profit the upper limit on capital being tied up is costing Hiland’s.