Gemstone Tool Company (GTC) is a privately held firm that competes in the consumer and industrial...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Gemstone Tool Company (GTC) is a privately held firm that competes in the consumer and industrial market for construction tools. In addition to its main manufacturing fa- cility in Seattle, Washington, GTC operates several other manufacturing plants located in the United States, Canada, and Mexico. These plants produce their entire range of products, including power drills and saws, nail guns, and hand-held tools such as hammers, screwdrivers, wrenches, and pliers. For the sake of simplicity, let us suppose that the Winnipeg, Canada plant only produces wrenches and pliers. Wrenches and pliers are made from steel, and the process involves molding the tools on a molding machine and then assembling the tools on an assembly machine. The amount of steel used in the production of wrenches and pliers and the daily availability of steel is shown in the first line of Table 7.3. On the next two lines are the machine utilization rates needed in the production of wrenches and pliers and the capacity of these ma- chines as well. Finally, the last two rows of the table indicate the daily market demand for these tools and their variable (per unit) contribution to earnings. For example, according to the second column of Table 7.3, each wrench produced by GTC uses 1.5 lbs. of steel, and spends 1.0 hour on the molding machine and 0.3 hour on the assembly machine. The demand for wrenches is 15,000 per day. Every 1,000 wrenches produced (and then sold) contributes $130 to the earnings of GTC. According to the fourth column of Table 7.3, the amount of steel available per day is 27,000 lbs. The amount of molding machine capacity is 21,000 hours per day and the amount of assembly machine capacity is 9,000 hours per day. GTC would like to plan for the daily production of wrenches and pliers at its Winnipeg plant so as to maximize the contribution to earnings. In particular, GTC would like to answer the following questions: Now suppose that GTC is planning for next quarter, and that they would like to de- termine how much steel to contract for with local suppliers for the next quarter. Sup- pose that steel contracts are typically arranged for daily deliveries over the entire quarter, and that the market price for such contracts is $58.00/1,000 lbs. of steel. Let us define the decision variable: S= the amount of steel to contract for, for next quarter, in 1,000 lbs./day. GTC would like to determine the optimal value of S. We suppose that the fol- lowing aspects of the problem are known: • The market price of steel is $58.00/1,000 lbs. • The utilization of steel, assemby machine hours, and molding machine hours in wrenches and pliers is the same as given in the original problem. • The molding machine capacity is the same as in the original problem, namely 21,000 hours/day. • The demand for wrenches and pliers is the same as in the original problem, namely 15,000 wrenches per day and 16,000 pliers per day. . The unit contribution to earnings of production of pliers is the same as in the original problem, namely $100/1,000 units. However, we also suppose that the following aspects of the problem are uncertain: • The assembly machine capacity for next quarter is uncertain. GTC has ordered new assembly machines to replace, as well as to augment, their existing assem- bly machines, but it is not known if these new machines will be delivered in time to be used next quarter. Let us suppose that the assembly machine capacity for next quarter will either be 8,000 hours/day (with probability 0.5) or 10,000 TABLE 7.3 Data for the Gemstone Tool Company Steel (lbs) Molding Machine (houn) Assembly Machine (hours) Demand Limit (tools/day) Contribution to Earnings (5/1,000 units) 3 Wrenches 1.5 1.0 0.3 15,000 $130 Pliers 1.0. 10 05 16,000 $100 Availability 27.300 lbs/day 21,000 hours/day 9,000 hours/day Please define two decision variables W as the number of wrenches to be produced per day (in 1000 units) and P as the number of pliers to be produced per day (in 1000 units). (1) Formulate a mathematical programming model that maximizes revenue per day. Clearly specify the objective function and constraints. -6pts (2) Use Excel or Lindo to solve for W and P. What are the optimal decisions & revenue? -5pts (3) Which resources are the least critical (FE) from an optimization standpoint? -4pts Gemstone Tool Company (GTC) is a privately held firm that competes in the consumer and industrial market for construction tools. In addition to its main manufacturing fa- cility in Seattle, Washington, GTC operates several other manufacturing plants located in the United States, Canada, and Mexico. These plants produce their entire range of products, including power drills and saws, nail guns, and hand-held tools such as hammers, screwdrivers, wrenches, and pliers. For the sake of simplicity, let us suppose that the Winnipeg, Canada plant only produces wrenches and pliers. Wrenches and pliers are made from steel, and the process involves molding the tools on a molding machine and then assembling the tools on an assembly machine. The amount of steel used in the production of wrenches and pliers and the daily availability of steel is shown in the first line of Table 7.3. On the next two lines are the machine utilization rates needed in the production of wrenches and pliers and the capacity of these ma- chines as well. Finally, the last two rows of the table indicate the daily market demand for these tools and their variable (per unit) contribution to earnings. For example, according to the second column of Table 7.3, each wrench produced by GTC uses 1.5 lbs. of steel, and spends 1.0 hour on the molding machine and 0.3 hour on the assembly machine. The demand for wrenches is 15,000 per day. Every 1,000 wrenches produced (and then sold) contributes $130 to the earnings of GTC. According to the fourth column of Table 7.3, the amount of steel available per day is 27,000 lbs. The amount of molding machine capacity is 21,000 hours per day and the amount of assembly machine capacity is 9,000 hours per day. GTC would like to plan for the daily production of wrenches and pliers at its Winnipeg plant so as to maximize the contribution to earnings. In particular, GTC would like to answer the following questions: Now suppose that GTC is planning for next quarter, and that they would like to de- termine how much steel to contract for with local suppliers for the next quarter. Sup- pose that steel contracts are typically arranged for daily deliveries over the entire quarter, and that the market price for such contracts is $58.00/1,000 lbs. of steel. Let us define the decision variable: S= the amount of steel to contract for, for next quarter, in 1,000 lbs./day. GTC would like to determine the optimal value of S. We suppose that the fol- lowing aspects of the problem are known: • The market price of steel is $58.00/1,000 lbs. • The utilization of steel, assemby machine hours, and molding machine hours in wrenches and pliers is the same as given in the original problem. • The molding machine capacity is the same as in the original problem, namely 21,000 hours/day. • The demand for wrenches and pliers is the same as in the original problem, namely 15,000 wrenches per day and 16,000 pliers per day. . The unit contribution to earnings of production of pliers is the same as in the original problem, namely $100/1,000 units. However, we also suppose that the following aspects of the problem are uncertain: • The assembly machine capacity for next quarter is uncertain. GTC has ordered new assembly machines to replace, as well as to augment, their existing assem- bly machines, but it is not known if these new machines will be delivered in time to be used next quarter. Let us suppose that the assembly machine capacity for next quarter will either be 8,000 hours/day (with probability 0.5) or 10,000 TABLE 7.3 Data for the Gemstone Tool Company Steel (lbs) Molding Machine (houn) Assembly Machine (hours) Demand Limit (tools/day) Contribution to Earnings (5/1,000 units) 3 Wrenches 1.5 1.0 0.3 15,000 $130 Pliers 1.0. 10 05 16,000 $100 Availability 27.300 lbs/day 21,000 hours/day 9,000 hours/day Please define two decision variables W as the number of wrenches to be produced per day (in 1000 units) and P as the number of pliers to be produced per day (in 1000 units). (1) Formulate a mathematical programming model that maximizes revenue per day. Clearly specify the objective function and constraints. -6pts (2) Use Excel or Lindo to solve for W and P. What are the optimal decisions & revenue? -5pts (3) Which resources are the least critical (FE) from an optimization standpoint? -4pts
Expert Answer:
Answer rating: 100% (QA)
Question Solution a W of wrenches produced per day 1... View the full answer
Related Book For
Financial reporting, financial statement analysis and valuation a strategic perspective
ISBN: 978-0324789416
7th Edition
Authors: James M Wahlen, Stephen P Baginskl, Mark T Bradshaw
Posted Date:
Students also viewed these general management questions
-
Flight Training Corporation is a privately held firm that provides fighter pilot training under contracts with the U.S. Air Force and the U.S. Navy. The firm owns approximately 100 Lear jets that it...
-
CJ Equity Partners is a privately held firm that buys small family- owned firms, installs professional managers to run the firms, and then sells them 3 5 years later, often for a substantial profit....
-
Flight Training Corporation is a privately held firm that provides fighter pilot training under contracts with the U.S. Air Force and the U.S. Navy. The firm owns approximately 100 Lear jets that it...
-
Average rates of return on Treasury bills, government bonds, and common stocks, 1900-2020. Average Annual Average Premium (Extra Rate of Return return versus Treasury (8) bills) (%) Portfolio...
-
1. An eight-month investigation by OFHEO concluded that slack standards at Fannie Mae created a corporate culture that emphasized stable earnings at the expense of accurate financial disclosures....
-
Draw both chair conformations of trans-1, 3-dimethyl cyclohexane indicate whether each methyl group is axial or equatorial.
-
Refer to Exhibit 4-4. Give the amounts of the following withrespect to the cost of goods available for sale: (1) Prime costs, (2) Conversion costs, (3) Factory overhead, and (4) Indirect...
-
Two mercury manometers, one open-end and the other sealed-end, are attached to an air duct. The reading on the open-end manometer is 25 mm and that on the sealed-end manometer is 800mm. Determine the...
-
1. Consider the nonlinear shooting method with Newton's algorithm. We are aiming to approximate the solution to the boundary value problem y"=y-yy', 1 < <2, y(1)=1/2, y(2)=1/3, with h 0.5 and to =...
-
1. Here are the densities and redii of planets in our solar system (in grams per cm 3 and km, respectively) How much would you weigh on these different planets? 1 pound is equal to 0.453592 kg. 2....
-
-Current Attempt in Progress At December 31, 2024, Crane Imports reported this information on its balance sheet. Accounts receivable $602,000 Less: Allowance for doubtful accounts 41,000 During 2025,...
-
Casey Anthony Case Casey Anthony Case Study Focus on Evidence in Case Please type the answers below each point. Please let me know if you have any questions with this. Read the article about some of...
-
in 1985, a and his friend, z, created In 1995, a man and his friend created a corporation. The man owned 55% of the stock, and the friend owned 45% of the stock. When the man died in 2005, he left...
-
When a multi-stage booster is fired into space, the mass of the booster changes as the fuel is burned during flight. Discuss how the change in mass influences the acceleration of the booster. When...
-
Last year, the State Board of Education in the State of Jefferson made some changes in the prescribed history curriculum in its public schools. In the "New History Curriculum," all American history...
-
Nissan Company estimated direct labor hours for 2015 to be 117,000 hours with budgeted overhead of P2,340,000. The company applies factory overhead on the basis of direct labor hours. During the...
-
A pension fund holds preferred shares paying $5 dividends per share per year. These dividends are paid in perpetuity. If the market currently requires a 7.83% rate on these preferred shares,...
-
Refrigerant R-12 at 30C, 0.75 MPa enters a steady flow device and exits at 30C, 100 kPa. Assume the process is isothermal and reversible. Find the change in availability of the refrigerant.
-
Not every acquisition results in goodwill reported in the consolidated balance sheet. Describe the valuation procedures followed by the acquiring firms to determine whether any goodwill should be...
-
Effective financial statement analysis requires an understanding of a firms economic characteristics. The relations between various financial statement items provide evidence of many of these...
-
What does a price differential measure? How does a price differential relate to risk?
-
Visit SunGards web site, http://www.sungard.com, and research its recovery services offered for the following classes: High Availability, System Recovery, and End-User Recover. Write a report of your...
-
Micro Systems, a developer of database software packages, is a publicly held company and listed with the SEC. The company has no internal audit function. In complying with SOX, Micro Systems has...
-
Leigh Industries has an internal audit department consisting of a director and four staff auditors. The director of internal audit, Diane Bauer, reports to the corporate controller, who receives...
Study smarter with the SolutionInn App