Better Gardens Sdn. Bhd. has a factory manufacturing garden tools in Shah Alam. The company sells...
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Expert Answer:
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
Related Book For
Mathematical Applications for the Management Life and Social Sciences
ISBN: 978-1305108042
11th edition
Authors: Ronald J. Harshbarger, James J. Reynolds
Posted Date:
Students also viewed these accounting questions
-
A manufacturing company sells its products directly to customers and operates 5 days a week, 52 weeks a year. The production department of this company can produce at the rate of 60 units per day....
-
In 2015, the initial year of its existence, Pacifica Company's accountant, in preparing both the income statement and the tax return, developed the following list of items causing differences between...
-
H pic manufactures vehicle parts. The company sells its products to a number of independent distributors who resell the goods to garages and other retail outlets in their areas. H pic has a policy of...
-
Find the deflection y(x) of a cantilever beam embedded at its left end and free at its right end when the load is as given in Example 10.
-
If X is a random variable having a normal distribution, what are the probabilities of getting a value (a) Within one standard deviation of the mean; (b) Within two standard deviations of the mean;...
-
When CUCs major expense items remain identical quarter after quarter as a percentage of revenues, it is a signal that the reported expenses and revenues are being ___________ .
-
Allied Electronics in Exhibit 14-8, page 704, is most likely to earn net income of \(\$ x\) next year. How much is \(\$ x\) ? a. \(\$ 90,000\) b. \(\$ 79,000\) c. \(\$ 75,000\) d. \(\$ 54,000\)
-
EKC Company uses the retail inventory method. The following information for 2016 is available: Required: Compute the cost of the ending inventors under each of the following cost flow assumptions...
-
What can be a recommended alternative strategy for implementation to achieve optimal competitive positioning for the company Patagonia ? What revisions to the corporate structure should be made to...
-
Franklin Joiner, director of health, education, and welfare, had just left a meeting with the states newly elected governor and several of the other recently appointed department heads. One of the...
-
Wader, a public limited company, is assessing the nature of its provisions for the year ended 31 May 2007. The following information is relevant: (a) Wader is assessing the valuation of its...
-
A sample of helium gas containing \(6.02 \times 10^{2.3}\) atoms at atmospheric pressure \(\left(1.01 \times 10^{5} \mathrm{~Pa} ight)\) occupies a volume of \(22.4 \times 10^{-3} \mathrm{~m}^{3}\)....
-
Why would two objects made of nonconducting material make a poorer capacitor than two objects of the same shape made of material that is an electrical conductor?
-
Suppose that we can use wire of \(1.0-\mathrm{mm}\) diameter to make either a single loop of wire or a solenoid, and we wish to compare, for a given current, the magnetic fields at the center of...
-
Two very long wires each carry a linear charge density \(\lambda\). They initially repel each other with a force \(F\). If the wires are immersed in distilled water, with what force do they repel...
-
Wire \(1,3.0 \mathrm{~m}\) long and of linear mass density \(0.010 \mathrm{~kg} / \mathrm{m}\), is initially held in place and carries \(10 \mathrm{~A}\) of current to the right. Very long wire 2 is...
-
Revenue Management Detailed Market Segmentation of hotels Fairmont Pacific Rim Vancouver , Coast Coal by Apa (Vancouver) and Hilton Downtown Vancouver. Considering amenities they offer , who are...
-
Do the three planes x + 2x + x 3 = 4, X X 3 = 1, and x + 3x = 0 have at least one common point of intersection? Explain.
-
Suppose the rate of change of the percent P of U.S. households with cable/satellite TV can be modeled by where t is the number of years past 1975. (a) Use integration and the data point for 2010 to...
-
Newton's law of cooling (and warming) states that the rate of change of temperature u = u(t) of an object is proportional to the temperature difference between the object and its surroundings, where...
-
(a) Form the profit function for the cost and revenue functions in Problem 3, and find the maximum profit. In problem 3, If a company has total costs C(x) = 15,000 + 35x + 0.1x2 and total revenues...
-
Consider the quarterly real GDP of United Kingdom, Canada, and the United States from the first quarter of 1980 to the second quarter of 2011. The data are available from the Federal Reserve Bank of...
-
Derive the error-correction form in Equation (5.68) for a \(\operatorname{VAR}(p)\) model. P-1 Azt = zt-p+Azti + c(t) + (B)at, i=1 (5.68)
-
Housing markets in the United States have been under pressure since the 2007 subprime financial crisis. In this problem, we consider the housing starts for the West and South regions of U.S. Census....
Study smarter with the SolutionInn App