As a production engineer working for an auto maker, you have been tasked with determining the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
As a production engineer working for an auto maker, you have been tasked with determining the best way to acquire the plastic instrument panel of the most recent vehicle model. Specifically, you must advise upper management as to whether it is best to produce the panel in-house or to outsource its fabrication to a supplier. The instrument panel is to be manufactured by injection molding. Although there is sufficient expertise in your company to produce the panel in-house, an injection molding machine would need to be purchased and a manufacturing area setup specifically for thispurpose at a total cost (purchase and installation) of $400,000. In addition, the machine would entail monthly_operating and maintenance costs of $1,000. Based on your estimates, the total cost of materials and labour to produce the instrument panel for one vehicle in-house would be $60. The production process would inevitably lead to defective panels being produced and needing to be thrown away (at a cost of $60 each). Based on information acquired from the injection moldingindustry, the rate of occurrence of defects can be expected to behave as a normal distribution withan average of 3% standard deviation of 0.5%. If the instrument panels are outsourced, the only expenditures are the purchase cost per panel as provided by prospective suppliers. Based on received quotes, these costs would vary with the production level as indicated in Table 3. Table 3 – Cost per outsourced instrument panel based on production level. Production level per month (units) Cost per panel 1 to 24 $150 25 to 49 $140 50 to 99 $125 100 to 249 $115 250 to 499 $105 500 to 999 $85 1,000 to 1,999 $75 2,000 and 2,999 $70 3,000 and over $50 Based on sales projections for the vehicle, you estimate that the monthly production level willbe at least 300 units, at most 5,500 units and most likely 2,800 units. Your company's MARR is 10% compounded monthly_and your analysis is to be based on a 5 years study period. To simplify your analysis, you may assume that all costs occur at the end of their respective months. All calculations must be performed in MS Excel. III.Based on a nominal production level of 2,800 units, determine the cost per instrument panel based on outsourcing the production. Your worksheet should usea lookup table to obtain the appropriate cost from the data in Table 3 (i.e., the cost per panel should change automatically according to the specified nominal production level). (2 points) As a production engineer working for an auto maker, you have been tasked with determining the best way to acquire the plastic instrument panel of the most recent vehicle model. Specifically, you must advise upper management as to whether it is best to produce the panel in-house or to outsource its fabrication to a supplier. The instrument panel is to be manufactured by injection molding. Although there is sufficient expertise in your company to produce the panel in-house, an injection molding machine would need to be purchased and a manufacturing area setup specifically for thispurpose at a total cost (purchase and installation) of $400,000. In addition, the machine would entail monthly_operating and maintenance costs of $1,000. Based on your estimates, the total cost of materials and labour to produce the instrument panel for one vehicle in-house would be $60. The production process would inevitably lead to defective panels being produced and needing to be thrown away (at a cost of $60 each). Based on information acquired from the injection moldingindustry, the rate of occurrence of defects can be expected to behave as a normal distribution withan average of 3% standard deviation of 0.5%. If the instrument panels are outsourced, the only expenditures are the purchase cost per panel as provided by prospective suppliers. Based on received quotes, these costs would vary with the production level as indicated in Table 3. Table 3 – Cost per outsourced instrument panel based on production level. Production level per month (units) Cost per panel 1 to 24 $150 25 to 49 $140 50 to 99 $125 100 to 249 $115 250 to 499 $105 500 to 999 $85 1,000 to 1,999 $75 2,000 and 2,999 $70 3,000 and over $50 Based on sales projections for the vehicle, you estimate that the monthly production level willbe at least 300 units, at most 5,500 units and most likely 2,800 units. Your company's MARR is 10% compounded monthly_and your analysis is to be based on a 5 years study period. To simplify your analysis, you may assume that all costs occur at the end of their respective months. All calculations must be performed in MS Excel. III.Based on a nominal production level of 2,800 units, determine the cost per instrument panel based on outsourcing the production. Your worksheet should usea lookup table to obtain the appropriate cost from the data in Table 3 (i.e., the cost per panel should change automatically according to the specified nominal production level). (2 points)
Expert Answer:
Answer rating: 100% (QA)
page1 Accerchha to ata Material management stated geauand Employee cont... View the full answer
Posted Date:
Students also viewed these corporate finance questions
-
In this Assignment, you will create an audiovisual presentation to verbally market a product to another business rather than to consumers. According to Lamb et al. (2014), business marketing differs...
-
A friend tells you that the best way to assess solvency is by comparing total debt to total assets. Another friend says that solvency is measured by comparing total debt to total stockholders equity....
-
Is their current strategy the best way to build Lakota Hills?
-
At December 31, 2016, Pioneer Corporation reported the stockholders' equity accounts shown here (with dollar amounts in millions, except per-share amounts). Common stock $3.00 par value per share, 22...
-
The American Express Retail Index provides information on budget amounts for home improvements. The following table displays the budgets, in dollars, of 45 randomly sampled home improvement jobs in...
-
Genenco is developing a new drug that will slow the aging process. In order to succeed, two breakthroughs are needed: one to increase the potency of the drug, and the second to eliminate toxic side...
-
Recall that the density of a gamma distribution with shape parameter \(\alpha\) and scale parameter \(\theta\) has a density given by \(\mathrm{f}(y)=\) \(\left[\theta^{\alpha} \Gamma(\alpha)...
-
Dulce Company produces a popular candy bar called Rico. The candy is produced in Costa Rica and exported to the United States. Recently, the company adopted the following standards for one 5-ounce...
-
Ingrid has configured one of the network segments to use a DHCP server to dynamically assign IP addresses. She knows that DHCP can also tell the clients the address of the server that they should use...
-
In the Bombadier Company, Division A has a product that can be sold either to outside customers or to Division B. Information about these divisions is given below: Case 1 Case 2 Division A: Capacity...
-
Calculate the pH of 1.0 L of the original buffer in Example upon addition of 0.010 mol of solid NaOH EXAMPLE Using the HendersonHasselbalch Equation to Calculate the pH of a Buffer Solution Composed...
-
True Or False Subrogation is always allowed with respect to collision, comprehensive, and UIM coverage.
-
How is bad faith committed?
-
True Or False None of the states that have adopted no-fault have a pure no-fault system.
-
Equal consideration is a standard in what type of bad faith action?
-
Comprehensive insurance coverage a. does not apply to the shattering of a windshield or to the theft of valuables. b. must always be part of any standard automobile contract. c. often requires proof...
-
At the beginning of the 2 0 2 3 , 2 0 2 3 , JK , , Inc. had total assets of $ 5 1 0 , 0 0 0 , 5 1 0 , 0 0 0 , total liabilities of $ 2 1 0 , 0 0 0 , 2 1 0 , 0 0 0 , and common stock of $ 1 9 2 , 0 0...
-
The slopes of the tangents at the points where the curve y = x2 - 4x intersects the X-axis is 1) 1 2) +2 3) +3 4) +4
-
Give a specific example of a process that has the energy changes and transfers described. (For example, if the question states " \(\Delta E_{\mathrm{th}}>0, W=0\)," you are to describe a process that...
-
Give a specific example of a process that has the energy changes and transfers described. (For example, if the question states " \(\Delta E_{\mathrm{th}}>0, W=0\)," you are to describe a process that...
-
Give a specific example of a process that has the energy changes and transfers described. (For example, if the question states " \(\Delta E_{\mathrm{th}}>0, W=0\)," you are to describe a process that...
Study smarter with the SolutionInn App