Better Gardens Sdn. Bhd. has a factory manufacturing garden tools in Shah Alam. The company sells...

 

Transcribed Image Text:

Better Gardens Sdn. Bhd. has a factory manufacturing garden tools in Shah Alam. The company sells its garden tools to distributors as well as directly to hardware stores and DIY outlets in the whole of Klang Valley. The six most popular small garden tools which the company. manufactures are digging forks, hand trowels, hoes, rakes, spades, and shovels. Each of these tools is made from durable steel and has a wooden handle. The manufacturing process of these tools goes through two stages. The first stage includes two operations-stamping out the metal tool heads and drilling screw holes in them. The completed tool heads then proceed to the second stage, which includes an assembly operation where the handles are attached to the tool heads, a finishing step, and packaging. The processing times per tool for each operation are provided in the following table: Tool (hr/unit) Total hrs available per Нос Rake Shovel Spade Operation Fork Trowel 0.12 0.09 Stamping 0.04 0.05 0.18 0.07 Drilling 0.05 0.05 0,13 0.15 0.12 Assembling 0.06 0.07 0.14 0.08 0.11 0.09 Finishing 0.05 0.06 0.22 0.03 0.10 0.11 Packaging 0.03 0.04 0.16 0.05 0.14 0.16 The company has 1,200 square meters of sheet steel available each month. The unit price and the metal required for each tool and the monthly contracted sales are provided in the following table: Fork Trowel Hoe Rake Shovel Spade Unit Price (RM) 20.00 21.00 30.00 25.00 28.00 40.00 month 550 450 700 650 585 Sheet Metal (m²) Monthly Contracted Sales 2000 1500 1600 900 0.08 0.12 0.16 0.21 0.24 0.28 1100 1000 The company's director wishes to ensure that the monthly sales demand is met on time and he uses scientific techniques to run his business. As a result, he is willing to use overtime production in order to meet its sales requirements, and the company also has an arrangement with a local tool and die company to manufacture the tool heads if needed. The company feels comfortable subcontracting the first stage operations because it is easier to detect defects prior to assembly and finishing. However, the company does have 150 hours of overtime available each month for each operation in both stages. The regular production and overtime costs per tool for both stages are provided in the following table: (b) (c) Fork Trowel (d) Hoe Rake Shovel Spade Stage 1 Stage 2 Regular Cost Overtime Cost Regular Cost. (RM) 6.00 7.00 10.00 8.00 9.00 11.00 (RM) 6.50 7.50 10.70 8.60 9.70 12.00 INSTRUCTIONS: The cost of subcontracting in stage 1 adds 30% to the regular production cost. The company wants to establish a production schedule for regular and overtime production in each stage and for the number of tool heads subcontracted, to maximize its monthly profit. (a) (RM) 4.50 4.00 5.50 4.20 4.50 6.00 Overtime Cost (RM) 4.80 4.50 6.20 4.70 5.00 6.60 Formulate a complete lincar programming model in algebraic form that shows the individual constraints and decision variables for this problem. (5 marks) Formulate this same model on an Excel spreadsheet. Then use the Excel Solver to solve the model. (10 marks) Based on your solution in part (b) what are the most critical resources in the production process? (5 marks) Using the sensitivity report produced in your Excel solution, discuss the implications if there are changes in the critical resources identified in part (c). (10 marks) -END OF PAPER- CREATE AN EXCEL FILE WITH SHEET 1 CONTAINING SOLUTION TO QUESTION 1, PART (b) (iv) with h-0.5. SHEET 2 CONTAINING SOLUTION TO QUESTION 1, PART (b) (iv) with h-0.05. SHEET 3 CONTAINING SOLUTION TO QUESTION 2 PART (b). NAME YOUR EXCEL FILE AS "STUDENT ID.XLSX" AND UPLOAD YOUR EXCEL FILE TO ELEARN. SUBMIT THE REST OF THE ASSIGNMENT IN HARD COPY. Better Gardens Sdn. Bhd. has a factory manufacturing garden tools in Shah Alam. The company sells its garden tools to distributors as well as directly to hardware stores and DIY outlets in the whole of Klang Valley. The six most popular small garden tools which the company. manufactures are digging forks, hand trowels, hoes, rakes, spades, and shovels. Each of these tools is made from durable steel and has a wooden handle. The manufacturing process of these tools goes through two stages. The first stage includes two operations-stamping out the metal tool heads and drilling screw holes in them. The completed tool heads then proceed to the second stage, which includes an assembly operation where the handles are attached to the tool heads, a finishing step, and packaging. The processing times per tool for each operation are provided in the following table: Tool (hr/unit) Total hrs available per Нос Rake Shovel Spade Operation Fork Trowel 0.12 0.09 Stamping 0.04 0.05 0.18 0.07 Drilling 0.05 0.05 0,13 0.15 0.12 Assembling 0.06 0.07 0.14 0.08 0.11 0.09 Finishing 0.05 0.06 0.22 0.03 0.10 0.11 Packaging 0.03 0.04 0.16 0.05 0.14 0.16 The company has 1,200 square meters of sheet steel available each month. The unit price and the metal required for each tool and the monthly contracted sales are provided in the following table: Fork Trowel Hoe Rake Shovel Spade Unit Price (RM) 20.00 21.00 30.00 25.00 28.00 40.00 month 550 450 700 650 585 Sheet Metal (m²) Monthly Contracted Sales 2000 1500 1600 900 0.08 0.12 0.16 0.21 0.24 0.28 1100 1000 The company's director wishes to ensure that the monthly sales demand is met on time and he uses scientific techniques to run his business. As a result, he is willing to use overtime production in order to meet its sales requirements, and the company also has an arrangement with a local tool and die company to manufacture the tool heads if needed. The company feels comfortable subcontracting the first stage operations because it is easier to detect defects prior to assembly and finishing. However, the company does have 150 hours of overtime available each month for each operation in both stages. The regular production and overtime costs per tool for both stages are provided in the following table: (b) (c) Fork Trowel (d) Hoe Rake Shovel Spade Stage 1 Stage 2 Regular Cost Overtime Cost Regular Cost. (RM) 6.00 7.00 10.00 8.00 9.00 11.00 (RM) 6.50 7.50 10.70 8.60 9.70 12.00 INSTRUCTIONS: The cost of subcontracting in stage 1 adds 30% to the regular production cost. The company wants to establish a production schedule for regular and overtime production in each stage and for the number of tool heads subcontracted, to maximize its monthly profit. (a) (RM) 4.50 4.00 5.50 4.20 4.50 6.00 Overtime Cost (RM) 4.80 4.50 6.20 4.70 5.00 6.60 Formulate a complete lincar programming model in algebraic form that shows the individual constraints and decision variables for this problem. (5 marks) Formulate this same model on an Excel spreadsheet. Then use the Excel Solver to solve the model. (10 marks) Based on your solution in part (b) what are the most critical resources in the production process? (5 marks) Using the sensitivity report produced in your Excel solution, discuss the implications if there are changes in the critical resources identified in part (c). (10 marks) -END OF PAPER- CREATE AN EXCEL FILE WITH SHEET 1 CONTAINING SOLUTION TO QUESTION 1, PART (b) (iv) with h-0.5. SHEET 2 CONTAINING SOLUTION TO QUESTION 1, PART (b) (iv) with h-0.05. SHEET 3 CONTAINING SOLUTION TO QUESTION 2 PART (b). NAME YOUR EXCEL FILE AS "STUDENT ID.XLSX" AND UPLOAD YOUR EXCEL FILE TO ELEARN. SUBMIT THE REST OF THE ASSIGNMENT IN HARD COPY.

Answer rating: 100% (QA)

Variables marked in purple in pic no of each tool type formed in regular hour overtime hour and subcontracted for phase 1 and phase 2 Objective market ... View the full answer