Question: White & Becker Tools (W&B) requires 2,000 electric motors next month for its product line of weed trimmers. Each motor is composed of three components:

White & Becker Tools (W&B) requires 2,000 electric motors next month for its product line of weed trimmers. Each motor is composed of three components: a coil, a shaft, and housing. W&B has the capability to produce these components or purchase them from an outside vendor. The costs of producing them and purchasing them are shown in the following table.

White & Becker Tools (W&B) requires 2,000 electric motors next

The components that are produced by W&B must pass through three departments: fabrication, molding, and inspection. The number of hours each component requires in each department and the total number of hours available next month in each department are shown in the following table:

White & Becker Tools (W&B) requires 2,000 electric motors next

In order to determine the number of components that will be produced and the number that will be purchased, W&B has set the following goals, in rank order:
Rank 1: The total costs to produce and purchase components next month should not exceed $14,000.
Rank 2: Idle time in the fabrication department should be minimized.
Rank 3: At least 200 coils should be purchased from the vendor next month.
Determine the number of components produced and purchased next month, according to these ranked goals.

COMPONENT Coil Shaft Housing PRODUCTION COST PER UNIT $2.60 $1.80 $1.40 PURCHASE COST PER UNIT $3.12 $2.16 $1.68 DEPART COIL SHAFT HOUSING AVAILABILITY MENT Fabrication0 0.2 Inspection 0.2 03 (HR.) 3,000 3,000 1,800 (HR.)(HR.)(HR.) 0.6 0.3 0.4 Molding 04 0.7

Step by Step Solution

3.47 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespacenowrap msorotate0 msobackgroundsourceauto msopatt... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

718-M-S-L-P (1155).xlsx

300 KBs Excel File

Students Have Also Explored These Related Statistics Questions!