Explore BrainMass

The optimal quantity of bookcase

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Work-force planning
All-Basa, Inc., produces two models of bookcases, for which relevant data are summarized as follows:

Bookcase 1
- Selling Price $15
- Labor Required 0.75 hour/unit
- Bottleneck machine time required 1.5 hours/unit
- Raw Material Required 2 bf/unit

Bookcase 2
- Selling Price $8
- Labor Required 0.5 hour/unit
- Bottleneck machine time required 0.8 hours/unit
- Raw Material Required 1 bf/unit

Each week, up to 400 board feet (bf) or raw material (RM) is available at a cost $1.50/bf. The company employs four workers, who work 40 hours per week for a total regular-time labor supply of 160 hours per week. They work regardless of production volumes, so that their salaries are treated as fixed costs. There are 320 hours per week available on the bottleneck machine.
In the absence of advertising, 50 units per week of bookcase 1 and 60 units of bookcase 2 will be demanded. Advertising can be used to stimulate the demand for each product. Experience shows that each dollar spent on advertising bookcase 1 increases demand for bookcase 1 by 10 units, while each dollar spent on advertising bookcase 2 increases demand for bookcase 2 by 15 units. At most $100 per week can be spent on advertising.
Formulate a LP program (not integer programming) to maximize the profit and determine how much of each product (P1 and P2) to produce each week, how much raw material (RM) to buy, how much overtime to use (OT), and how much advertising to buy for each product (A1 and A2). You must use the notation given in the parenthesis for each variable.
a) What is the maximum profit value?
b) If overtime costs only $4/hour (and all other parameters unchanged), how much overtime should All-Bala use?
c) If each unit of bookcase 1 sold for $15.50 (and all other parameters unchanged), what will the optimal profit per week be?
d) What is the most All-Bala should be willing to pay for another unit of raw material?
e) If each worker were required to work 45 hours per week (and all other parameters unchanged), what would the company's profit be?
f) If each unit of bookcase 2 sold for $10 (and all other parameters unchanged), what would be the optimal quantity of bookcase 2 to produce.

© BrainMass Inc. brainmass.com October 25, 2018, 2:30 am ad1c9bdddf

Solution Summary

Find the optimal quantity of bookcase.

See Also This Related BrainMass Solution

Spreadsheets Linear Production "Production Planning"

Production Planning. The Bogard Corporation produces three types of bookcases, which it sells to large office supply companies. The production of each bookcase requires two machine operations, trimming and shaping, followed by assembly, which includes inspection and packaging. All three type require 0.4 hour of assembly time, but the machining operations have different processing times, as shown here, in hours per unit.

Standard Narrow Wide
Timmer 0.2 0.4 0.6
Shaper 0.6 0.2 0.5

Each Machine is available 150 hours per month, and the current size of the assembly department provides capacity of 600 hours. Each bookcase produced yields a unit profit contribution as follows:

Standard Narrow Wide
Profit $8 $6 $10

a. What are the optimal production quantities for the company?

b. What is the pattern in the optimal allocations?

View Full Posting Details