Purchase Solution

Linear Programming

Not what you're looking for?

Ask Custom Question

Using Excel, please solve the following:

The Hickory Cabinet and Furniture Company produces sofas, tables, and chairs at its plant in Greensboro, N.C.. The plant uses three main resources to make furniture- wood, upholstery, and labor. The resource requirements for each piece are as follows:

(See chart in attached file)

The furniture is produced weekly and is stored in a warehouse until the end of the week, when it is shipped out. The warehouse has a total capacity of 650 pieces of furniture. Each sofa earns $400 profit, each table $275, and each chair $190. The company wants to know how many pieces of each type of furniture to make each week to maximize profit.

a) Formulate a linear programming model for this problem.
b) Solve the model using the computer.

Purchase this Solution

Solution Summary

Provides solution to linear programming problem using Excel Solver.

Purchase this Solution

Free BrainMass Quizzes
Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Introduction to Finance

This quiz test introductory finance topics.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

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.