Question

The B & W Leather Company wants to add handmade belts and wallets to its product line. Each belt nets the company $18 in profit, and each wallet nets $12. Both belts and wallets require cutting and sewing. Belts require 2 hours of cutting time and 6 hours of sewing time. Wallets require 3 hours of cutting time and 3 hours of sewing time. If the cutting machine is available 12 hours a week and the sewing machine is available 18 hours per week, what ratio of belts and wallets will produce the most profit within the constraints?

Answer 1

Answer:

1.50 Belts must not be produced.

3.00 Wallets should be produced.

Step-by-step explanation:

To solve this linear programming problem, we can use Solver in Excel, as shown in the attached file.

Two decision variables are created: Belts and Wallets.

There are two restrictions regarding the cutting and sewing required for each type of Product.

The optimal solution is:

The maximum optimal profit is $63.00

1.50 Belts must not be produced.

3.00 Wallets should be produced.

Download xls

<span class="sg-text sg-text--link sg-text--bold sg-text--link-disabled sg-text--blue-dark"> xls