Trimble produces handheld GPS devices. Due to its popularity, Trimble believes that demand for its latest...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Trimble produces handheld GPS devices. Due to its popularity, Trimble believes that demand for its latest GPS device will be 12,500 units in the next quarter. This is significantly larger than it was in previous quarters and may exhaust Trimble's production capacity. The handheld GPS device consists of three key components: a housing unit, an display unit, and a transistor unit. Trimble is convinced that it will have to outsource some of these units and purchase a number of these components from outside vendors because its internal capacity is limited. The table below shows both the production cost per unit for each component when the handheld GPS device is produced internally and the cost per unit for each component when purchased from an outside vendor: Component Housing Display Transistor Vendor Cost $19.50 $25 $12.10 Component Housing Display Transistor Capacity Trimble's manufacturing facility has three divisions: Assembly, Quality Control (QC), and Logistics. If produced in house, each component requires a certain amount of time (in hours/unit) in each of these three divisions. The following table shows the time needed per unit for each of the components and the final row of the table shows the total number of hours available for GPS device production in the upcoming quarter. Assembly 0.04 0.07 0.08 1650 Internal Cost $14.50 $23 $8.10 a) Define the decision variables. b) Define the objective function. QC 0.06 0.09 0.03 1650 Distribution 0.04 0.07 0.06 1650 Formulate a Linear Program that can help Trimble meet its predicted demand most efficiently. 2. c) Define the constraints. d) To avoid overreliance on outside vendors for an individual component, Trimble also wants to ensure that the number of transistors purchased from an outside vendor is somewhere between 40% and 60% of the total number of components subcontracted. Moreover, Trimble wants to produce at least 65% of its displays internally. Adjust your formulation to incorporate this. Trimble produces handheld GPS devices. Before they shipped, these GPS devices undergo a quick test on one of three machines in Trimble's quality control department. Trimble has five types of GPS devices, and any of the machines can be used to test any of the GPS devices. However, the time required for testing on each machine depends on the GPS device, as shown in the following table: Machine A B с Model 1 3 5 2 Processing time in minutes GPS Device Model 3 4 Model 2 4 3 5 5 3 Model 4 4 3 Model 5 3 5 4 Today, Trimble's QC department has 80 Model 1 devices, 75 Model 2 devices, 80 Model 3 devices, 120 Model 4 devices, and 60 Model 5 devices that need to be checked. Each machine can be used for a maximum of 8 hours per day, and Trimble wants to determine how many of each GPS device type to test on each machine so as to minimize the total time used for testing (leaving as much time as possible for other tasks the department has to perform). a) Formulate a Linear Programming model for this problem. Clearly define the decision variables, the objective function, and the constraints. b) Create a spreadsheet model for this problem and solve it using Solver. What is the optimal solution? c) Suppose now that Trimble's QC department wants to make sure that each machine is used approximately the same amount of time. How will this impact the optimal solution? Trimble produces handheld GPS devices. Due to its popularity, Trimble believes that demand for its latest GPS device will be 12,500 units in the next quarter. This is significantly larger than it was in previous quarters and may exhaust Trimble's production capacity. The handheld GPS device consists of three key components: a housing unit, an display unit, and a transistor unit. Trimble is convinced that it will have to outsource some of these units and purchase a number of these components from outside vendors because its internal capacity is limited. The table below shows both the production cost per unit for each component when the handheld GPS device is produced internally and the cost per unit for each component when purchased from an outside vendor: Component Housing Display Transistor Vendor Cost $19.50 $25 $12.10 Component Housing Display Transistor Capacity Trimble's manufacturing facility has three divisions: Assembly, Quality Control (QC), and Logistics. If produced in house, each component requires a certain amount of time (in hours/unit) in each of these three divisions. The following table shows the time needed per unit for each of the components and the final row of the table shows the total number of hours available for GPS device production in the upcoming quarter. Assembly 0.04 0.07 0.08 1650 Internal Cost $14.50 $23 $8.10 a) Define the decision variables. b) Define the objective function. QC 0.06 0.09 0.03 1650 Distribution 0.04 0.07 0.06 1650 Formulate a Linear Program that can help Trimble meet its predicted demand most efficiently. 2. c) Define the constraints. d) To avoid overreliance on outside vendors for an individual component, Trimble also wants to ensure that the number of transistors purchased from an outside vendor is somewhere between 40% and 60% of the total number of components subcontracted. Moreover, Trimble wants to produce at least 65% of its displays internally. Adjust your formulation to incorporate this. Trimble produces handheld GPS devices. Before they shipped, these GPS devices undergo a quick test on one of three machines in Trimble's quality control department. Trimble has five types of GPS devices, and any of the machines can be used to test any of the GPS devices. However, the time required for testing on each machine depends on the GPS device, as shown in the following table: Machine A B с Model 1 3 5 2 Processing time in minutes GPS Device Model 3 4 Model 2 4 3 5 5 3 Model 4 4 3 Model 5 3 5 4 Today, Trimble's QC department has 80 Model 1 devices, 75 Model 2 devices, 80 Model 3 devices, 120 Model 4 devices, and 60 Model 5 devices that need to be checked. Each machine can be used for a maximum of 8 hours per day, and Trimble wants to determine how many of each GPS device type to test on each machine so as to minimize the total time used for testing (leaving as much time as possible for other tasks the department has to perform). a) Formulate a Linear Programming model for this problem. Clearly define the decision variables, the objective function, and the constraints. b) Create a spreadsheet model for this problem and solve it using Solver. What is the optimal solution? c) Suppose now that Trimble's QC department wants to make sure that each machine is used approximately the same amount of time. How will this impact the optimal solution?
Expert Answer:
Answer rating: 100% (QA)
1 a Decision Variables Let X1 X2 and X3 represent the number of units of the housing display and transistor components to be produced internally respe... View the full answer
Related Book For
Managerial Accounting
ISBN: 978-0697789938
13th Edition
Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Posted Date:
Students also viewed these general management questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Hombran Doughnuts has current assets of $270 million; property, plant, and equipment of $400 million; and other assets totaling $160 million. Current liabilities are $160 million and long-term...
-
Let x0 = 1 and consider the sequence xn given by xn = 1/2xn - 1 + 1 / xn - 1, n = 1, 2, . . Use a graphing utility to compute the first 10 terms of the sequence and make a conjecture about the value...
-
Use Newtons method to find all the solutions of the equation correct to eight decimal places. Start by looking at a graph to find initial approximations. 4x = ex
-
Refer to your answers in E4-28A. In addition to the manufacturing overhead costs, the following data are budgeted for the companys Standard and Deluxe models for next year: Requirements: 1. Compute...
-
Last June, Lacy Dalton had just been appointed CFO of Garland & Wreath when she received some interesting reports about the profitability of the companys three most important product lines. One of...
-
1. 2. 3. 4. 5. At critical condition of temperature and pressure for a real gas, what would be the value of 16 Z? Here, Z is its compressibility factor. of species whose In the following list of...
-
Emily Jackson (Social Security number 765-12-4326) and James Stewart (Social Security number 466-74-9932) are partners in a partnership that owns and operates a barber shop. The partnership's first...
-
I: View this problem scenario A to learn more about Bill and Joes relationship. This scenario provides key information in helping formulate answers for assignments in Phases 1 and 2. You are having a...
-
Chalmers Corporation operates in multiple areas of the globe, and relatively large price changes are common. Presently, the company sells 183,800 units for $50 per unit. The variable production costs...
-
Prove that 1- tan(x) cos(2x) 1 + tan(x)
-
Discuss these two concepts Defensive Medicine and Uncompensated Care. What are their market failures? Discuss why they create market failure. Explain why their identified market failures are so...
-
Discuss strategies to manage groups, especially during the early stages of forming and storming, and what strategies could you use as a Team Leader or Project Manager to transition from storming to...
-
Discuss how advertising can motivate a consumer. What advertisement do you feel "motivated" you in some form. You need to choose a specific ad for a specific company. Post the link to the add (if you...
-
1. 2. A frictionless, insulated piston cylinder contains carbon monoxide, CO, (an ideal gas) 20C and 121 kPa. An internal fan is turned on and the volume increases by 50%. In A, what is the magnitude...
-
In the current year, the City of Omaha donates land worth $500,000 to Ace Corporation to induce it to locate in Omaha and create an estimated 2,000 jobs for its citizens. a. How much income, if any,...
-
You have recently accepted a position with Vitex, Inc., the manufacturer of a popular consumer product. During your first week on the job, the vice president has been favorably impressed with your...
-
Refer to the data for Pavolik Company in Exercise 156. Required: Use the direct method to convert the companys income statement to a cash basis. Sales ... $700 Cost of goods sold.. 400 Gross margin...
-
The situation described below was adapted from a case published by the institute of Management Accountants Committee on Ethics. WIW is a publicly owned corporation that makes various control devices...
-
Working in a small group, collect credit card marketing information or the summary of account information sent to cardholders for three to five different cards. Be sure to protect the identity of the...
-
Interview individuals who represent the three stages of the financial life cycle about their credit card usage. How many cards do they have? What kind or class of cards (rebate, premium, affinity,...
-
Break into two or three groups to research the use of affinity cards. First, develop a list of affinity cards and their sponsors. Does your university sponsor a card? Next, each group should choose a...
Study smarter with the SolutionInn App