Question

In: Operations Management

Arlo Industries manufactures three types of dog collars: a deluxe model with solid leather and upgraded...

Arlo Industries manufactures three types of dog collars: a deluxe model with solid leather and upgraded leash rings, a standard model using a "leatherette" compound, and a bargain model that they sell to discount outlets. The profit contributions of these collars are $12 Deluxe, $10 Standard, and $8 Bargain. All collars must be cut, assembled and shipped using three different production lines. The following table shows the time (in minutes) for each operation:

Production Line

Deluxe

Standard

Bargain

Cutting

10

7

6

Assembly

8

7

6

Shipping

5

5

5

Next month, the company estimates there will be 380 hours available for cutting, 370 hours for assembly and 400 hours available for shipping. In addition, up to 80 hours of overtime is available that can be used on either the cutting and/or assembly production lines at a cost of $20 per hour. The company has already received orders for 1200 deluxe collars, 1000 standard collars, and 600 bargain collars that must be filled, but believes they can sell as many collars as they can make. The company is interested in maximizing profit, subject to the constraints listed above.

**Please answer me**

Solutions

Expert Solution

Let no. of deluxe models be D, Std. Model be S and Bargain model be B.

Total Profit = 12D + 10S + 8B

We have to maximize this total profit

Subject to constraints:

10D + 7S + 6B <= 380*60........Constraint for No. of minutes available for cutting

8D + 7S + 6B <= 370*60...........Constraint for No. of minutes available for Assembly

5D + 5S + 5B <= 400*60............Constraint for No. of minutes available for Shipping

Let x, y, z be overtime hours used for Cutting, Assembly, and Shipping respectively. hence, we get

10D + 7S + 6B <= (380 + x)*60

8D + 7S + 6B <= (370 + y)*60

5D + 5S + 5B <= (400 + z)*60

x + y + z <= 80*60......................Constraint for no. of Overtime hours available

Total profit will become:

P = 12D + 10S + 8B - 20(x + y + z)

Also,

D >= 1200..............................Constraint for minimum production based on orders received for Deluxe collars

S >= 1000..............................Constraint for minimum production based on orders received for Standard collars

B >= 600..............................Constraint for minimum production based on orders received for Bargain collars

D, S, B, x, y, z >= 0...............Non-negativity constraint as these cannot be negative

We solve the above LPP in Excel Solver as shown below:

The above solution in the form of formulas along with Excel Solver extract is shown below for better understanding and reference:

As seen from above,

No. of Deluxe Collars = 1200

No. of Std. Collars = 1500

No. of Bargain Collars = 600

Total Profit = $32,600

-----------------------------------------------------------------------------------------------------------------------

In case of any doubt, please ask through the comment section before Upvote/downvote.

If you liked the answer, please give an upvote. This will be quite encouraging for me, thank-you!!!


Related Solutions

Arlo Industries manufactures three types of dog collars: a deluxe model with solid leather and upgraded...
Arlo Industries manufactures three types of dog collars: a deluxe model with solid leather and upgraded leash rings, a standard model using a "leatherette" compound, and a bargain model that they sell to discount outlets. The profit contributions of these collars are $12 Deluxe, $10 Standard, and $8 Bargain. All collars must be cut, assembled and shipped using three different production lines. The following table shows the time (in minutes) for each operation: Production Line Deluxe Standard Bargain Cutting 10...
A company manufactures three types of luggage: economy, standard, and deluxe.
  A company manufactures three types of luggage: economy, standard, and deluxe. Thecompany produces 1000 pieces each month. The cost for making each type of luggage is$20 for the economy model, $30 for the standard model, and $40 for the deluxe model.The manufacturer has a budget of $25,700. Each economy piece requires 6 hours oflabor, the standard model requires 8 hours of labor and the deluxe requires 12 hours oflabor. The manufacturer has a total of 7400 hours of labor...
Barnett Products manufactures three types of remote-control devices: Economy, Standard, and Deluxe.
Barnett Products manufactures three types of remote-control devices: Economy, Standard, and Deluxe. The company, which uses activity-based costing, has identified five activities (and related cost drivers). Each activity, Its budgeted cost and related cost driver is identified below.  The following information pertains to the three product lines for next year: What is Barnett's pool rate for the material-insertion activity?
A company that manufactures video cameras produces a basic model and a deluxe model. Over the...
A company that manufactures video cameras produces a basic model and a deluxe model. Over the past year, 32% of the cameras sold have been of the basic model. Of those buying the basic model, 35% purchase an extended warranty, whereas 46% of all deluxe purchasers do so. If you learn that a randomly selected purchaser has an extended warranty, how likely is it that he or she has a basic model? (Round your answer to four decimal places.)
Hi Tech Products manufactures three (3) types of CD players: Cheap, Econo and Deluxe. Hi Tech...
Hi Tech Products manufactures three (3) types of CD players: Cheap, Econo and Deluxe. Hi Tech uses an activity-based product costing system. The company has identified five (5) activities. Each activity, its cost and related activity driver are identified below: Activity                                                    Activity Cost                                            Activity Driver Material handling                                  $225 000                                                   Number of parts Material insertion                                 $2 475 000                                               Number of parts Automated machinery                          $840 000                                                   Machine hours Finishing                                                   $170 000                                                   Labour hours Packaging                                                 $170 000                                                   Orders shipped Total manufacturing cost                    $3...
HiTech Products manufactures three types of remote-control devices: Economy, Standard, and Deluxe. The company, which uses...
HiTech Products manufactures three types of remote-control devices: Economy, Standard, and Deluxe. The company, which uses activity-based costing, has identified five activities (and related cost drivers). Each activity, its budgeted cost, and related cost driver is identified below Activity Cost Material Handling $225,000 Material Insertion $2,475,000 Automated machinery $840,000 Finishing $170,000 Packaging $170,000 The following information pertains to the three product lines for next year: Economy Standard Deluxe   Unit 2 be prod. 10,000 5,000 2,000 Order 2 ship 1,000 500...
HiTech Products manufactures three types of remote-control devices: Economy, Standard, and Deluxe. The company, which uses...
HiTech Products manufactures three types of remote-control devices: Economy, Standard, and Deluxe. The company, which uses activity-based costing, has identified five activities (and related cost drivers). Each activity, its budgeted cost, and related cost driver is identified below. Activity Cost Cost Driver   Material handling $269,000      Number of parts   Material insertion 3,390,000      Number of parts   Automated machinery 872,000      Machine hours   Finishing 256,000      Direct labor hours   Packaging 256,000      Orders shipped             Total $5,043,000           ...
Siegel Company manufactures a product that is available in both a deluxe model and a regular...
Siegel Company manufactures a product that is available in both a deluxe model and a regular model. The company has manufactured the regular model for years. The deluxe model was introduced several years ago to tap a new segment of the market. Since introduction of the deluxe model, the company’s profits have steadily declined and management has become increasingly concerned about the accuracy of its costing system. Sales of the deluxe model have been increasing rapidly. Manufacturing overhead is assigned...
Siegel Company manufactures a product that is available in both a deluxe model and a regular...
Siegel Company manufactures a product that is available in both a deluxe model and a regular model. The company has manufactured the regular model for years. The deluxe model was introduced several years ago to tap a new segment of the market. Since introduction of the deluxe model, the company’s profits have steadily declined and management has become increasingly concerned about the accuracy of its costing system. Sales of the deluxe model have been increasing rapidly. Manufacturing overhead is assigned...
Siegel Company manufactures a product that is available in both a deluxe model and a regular...
Siegel Company manufactures a product that is available in both a deluxe model and a regular model. The company has manufactured the regular model for years. The deluxe model was introduced several years ago to tap a new segment of the market. Since introduction of the deluxe model, the company’s profits have steadily declined and management has become increasingly concerned about the accuracy of its costing system. Sales of the deluxe model have been increasing rapidly. Manufacturing overhead is assigned...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT