2. How much of each product should Houston Power Tools produce? Based on this recommendation, what is the total profit?
Table 1 - Word Search ACROBAT Draw Design 7 Layout References Review Help Mailings View Calibri Body AaBbccd AaBbCcDd AaBbcc Aa 1 Normal 1 No Spac. Heading 1 He BIU X X Y A Paragraph Font 1 1 4 tab Table 1. Products Description Demand Wholesale Product (units) Price W18PD WIT 18 Amp Power Drill 9375 57 HIBPD Houston 18 Amp Power Drill 35714 60 W7SCS WIT 7.5" Circular Saw 8280 81 H75CS Houston 7.5" Circular Saw 23376 65 HI4PD Houston 14 Amp Power Drill 14540 55 WOORS WIT Reciprocating Saw 1533 70 Note: llammerd llardware has a firm order for 2800 units of 119SCS and 1000 units of WINPD that must be filled this month Table 2. Factory Labor Capacity Department Waco Plant Electric Motor 38000 Forming/milling 37200 Finishing 11750 Assembly 34960 Testing 81600 Packaging 66155 Table 3. Bill of Labor Product Electric Motor Forming Finishing Assembly Testing Packaging 0.46 0.07 W18PD 0.12 0.72 0.27 0.32 H18PD 0.61 0.17 0.13 0.85 0.24 0.27 0.07 0.15 0.26 W75CS 0.36 0.16 0.67 0.09 0.10 0.49 0.58 H75CS 0.11 0.42 0.09 0.05 0.28 H14PD 0.32 0.17 0.49 0.10 0.44 0.11 WOORS 0.44 0.22 0.55 Table 4. Raw Material Requirements and Warehouse Inventory Levels Product Polystyrene Aluminum Copper Wire Machine Steel (lbs) (lbs) (feet) (lbs) W18PD 0.77 0.99 7.13 0.73 tonn 40 70 Paint Igals) 0.03 na 1 e O 2 search lije Hole - Word Draw Design Layout References Mailings Review View Help ACROBAT Search abri (Body 11 . A A. AE. AaBbccd AaBbccd AaBb 1 Normal 1 No Spac. Heading 3 IU.abs X A Font 1 Paragraph 4 0.09 5 H14PD WOORS 1 0.05 0.10 0.42 0.49 0.28 0.44 0.32 0.44 6 0.17 0.22 0.11 Paint 0.73 0.03 Table 4. Raw Material Requirements and Warehouse Inventory Levels Product Polystyrene Aluminum Copper Wire Machine Steel (ib.) (lbs) (feet) (lbs) W18PD 0.77 0.99 7.13 H18PD 1.18 0.49 9.70 0.78 W75CS 1.00 3.96 16.64 2.85 H75CS 1.89 3.06 11.16 2.02 H14PD 1.04 0.45 11.04 0.67 WOORS 0.86 0.49 19.11 0.78 Inventory on Hand 156000 165240 767250 114274 0.03 0.05 0.05 0.03 0.04 3120 Table 5. Raw Materials Raw Material Polystyrene (ib.) Aluminum (lb) Copper Wire (foot) Machine Steel (lb.) Paint Igal.) Table 6. Standard Costs Cost 0.22 1.28 0.34 2.73 7.88 Shipping Product W18PD HIBPD W75CS H75CS H14PD WOORS Misc. Material 5.31 3.41 4.75 4.03 3.64 5.25 Variable Overhead 3.22 3.41 3.59 3.09 2.99 3.58 Labor 21.62 22.58 21.55 20.85 18.73 23.32 4.32 4.68 5.23 5.78 5.56 5.23 P O arch II W . GB x lyje Table 1 - Word Search ACROBAT Draw Design 7 Layout References Review Help Mailings View Calibri Body AaBbccd AaBbCcDd AaBbcc Aa 1 Normal 1 No Spac. Heading 1 He BIU X X Y A Paragraph Font 1 1 4 tab Table 1. Products Description Demand Wholesale Product (units) Price W18PD WIT 18 Amp Power Drill 9375 57 HIBPD Houston 18 Amp Power Drill 35714 60 W7SCS WIT 7.5" Circular Saw 8280 81 H75CS Houston 7.5" Circular Saw 23376 65 HI4PD Houston 14 Amp Power Drill 14540 55 WOORS WIT Reciprocating Saw 1533 70 Note: llammerd llardware has a firm order for 2800 units of 119SCS and 1000 units of WINPD that must be filled this month Table 2. Factory Labor Capacity Department Waco Plant Electric Motor 38000 Forming/milling 37200 Finishing 11750 Assembly 34960 Testing 81600 Packaging 66155 Table 3. Bill of Labor Product Electric Motor Forming Finishing Assembly Testing Packaging 0.46 0.07 W18PD 0.12 0.72 0.27 0.32 H18PD 0.61 0.17 0.13 0.85 0.24 0.27 0.07 0.15 0.26 W75CS 0.36 0.16 0.67 0.09 0.10 0.49 0.58 H75CS 0.11 0.42 0.09 0.05 0.28 H14PD 0.32 0.17 0.49 0.10 0.44 0.11 WOORS 0.44 0.22 0.55 Table 4. Raw Material Requirements and Warehouse Inventory Levels Product Polystyrene Aluminum Copper Wire Machine Steel (lbs) (lbs) (feet) (lbs) W18PD 0.77 0.99 7.13 0.73 tonn 40 70 Paint Igals) 0.03 na 1 e O 2 search lije Hole - Word Draw Design Layout References Mailings Review View Help ACROBAT Search abri (Body 11 . A A. AE. AaBbccd AaBbccd AaBb 1 Normal 1 No Spac. Heading 3 IU.abs X A Font 1 Paragraph 4 0.09 5 H14PD WOORS 1 0.05 0.10 0.42 0.49 0.28 0.44 0.32 0.44 6 0.17 0.22 0.11 Paint 0.73 0.03 Table 4. Raw Material Requirements and Warehouse Inventory Levels Product Polystyrene Aluminum Copper Wire Machine Steel (ib.) (lbs) (feet) (lbs) W18PD 0.77 0.99 7.13 H18PD 1.18 0.49 9.70 0.78 W75CS 1.00 3.96 16.64 2.85 H75CS 1.89 3.06 11.16 2.02 H14PD 1.04 0.45 11.04 0.67 WOORS 0.86 0.49 19.11 0.78 Inventory on Hand 156000 165240 767250 114274 0.03 0.05 0.05 0.03 0.04 3120 Table 5. Raw Materials Raw Material Polystyrene (ib.) Aluminum (lb) Copper Wire (foot) Machine Steel (lb.) Paint Igal.) Table 6. Standard Costs Cost 0.22 1.28 0.34 2.73 7.88 Shipping Product W18PD HIBPD W75CS H75CS H14PD WOORS Misc. Material 5.31 3.41 4.75 4.03 3.64 5.25 Variable Overhead 3.22 3.41 3.59 3.09 2.99 3.58 Labor 21.62 22.58 21.55 20.85 18.73 23.32 4.32 4.68 5.23 5.78 5.56 5.23 P O arch II W . GB x lyje
