Purchase Solution

Linear programming: Formulation and excel solution

Not what you're looking for?

Ask Custom Question

Danson furniture buys 2 products for resale: big shelves (B) and medium shelves (M). Each big shelf costs $500 and requires 100 cubic feet of storage space, and each medium shelf costs $300 and requires 90 cubic feet of storage space. The company has $75000 to invest in shelves this week, and the warehouse has 18000 cubic feet available for storage. Profit for each big shelf is $300 and for each medium shelf is $150. What is the optimal purchase quantity of each shelf and what is the maximum profit?

Purchase this Solution

Solution Summary

Excel file contains formulation and optimal solution of linear programming problem. Excel solver is used.

Solution Preview

Hello

Here is the algebraic formulation
Decision variables:
B - Number of big shelves produced and sold
M - Number of medium shelves produced and sold
Objective ...

Purchase this Solution


Free BrainMass Quizzes
Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Operations Management

This quiz tests a student's knowledge about Operations Management