Purchase Solution

Store space allocation planning problem

Not what you're looking for?

Ask Custom Question

Hiland's TV-Radio Store must determine how many TVs and radios to keep in stock. A TV requires 10 square feet of floor space, whereas a radio requires 4 square feet of floor space; 5000 square feet of floor space is available. A TV sale results in an $80 profit, and a radio earns a profit of $20. The store stocks only TVs and radios. Marketing requirements indicate 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. Formulate the linear programming problem
b. Solve using Excel Solver

Purchase this Solution

Solution Summary

The solution provides step by step guidance on how to formulate the problem mathematically. It includes a solution to the problem instance using Excel Solver.

Purchase this Solution


Free BrainMass Quizzes
Basics of corporate finance

These questions will test you on your knowledge of finance.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.