Lebanon Metal Company (LMC), a manufacturer of various metal parts, must decide whether to enter the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Lebanon Metal Company (LMC), a manufacturer of various metal parts, must decide whether to enter the competition to become the supplier of transmission housings for Gulf Electric, a company that produces the housings in its own in-house manufacturing To compete, LMC must purchase a new forge that will cost $125,000. If LMC gets the order, it may be able to sell as many as 2,000 units per year to Gulf Electric for $50 each, and costs will be $10 per unit. The firm expects that the project will have about five-year product life. The firm also estimates that the amount ordered by Gulf Electric in the first year will be ordered in each of the subsequent four years. The initial investment can be depreciated on a MACRS-GDS basis over a 5-year period, and the tax-rate is expected to remain 40%. At the end of five years, the forge is expected to retain a market value of $40,000 at the end of year 5. LMC's before tax MARR is 15% per year. Problem #2 Part A: Create a spreadsheet to determine. whether LMC should enter the competition to become the supplier of transmission housings for Gulf Electric. Use the present-worth measure of merit Part B: What Makes LMC Managers Worry: LMC's managers are uneasy about this project, because too many uncertain elements have not been considered in the analysis. The managers want to assess the various possible future outcomes before making a final decision. Put yourself in LMC's management position. and perform a sensitivity analysis for each variable (unit price, demand, market value). Graphically investigate the sensitivity of the PW to changes in the above factors. Investigate changes over the interval = 20%. To which variable is the project the most sensitive? Part C: LMC's managers become convinced that the PW is quite sensitive to changes in annual sales volume. Determine the break-even PW as a function of that variable. Problem #2 Investment $125,000 Units sold per yea 2000 units Selling price per ur $50 $10 5 YEAR GDS RATES 1 0.2 Cost per unit 0.32 MV $40000 3 0.192 5 years 5 years Study period 4 0.115 MACRS-GDS 5 0.115 Таx 40% 6 0.058 BTMARR 15% Lebanon Metal Company (LMC), a manufacturer of various metal parts, must decide whether to enter the competition to become the supplier of transmission housings for Gulf Electric, a company that produces the housings in its own in-house manufacturing To compete, LMC must purchase a new forge that will cost $125,000. If LMC gets the order, it may be able to sell as many as 2,000 units per year to Gulf Electric for $50 each, and costs will be $10 per unit. The firm expects that the project will have about five-year product life. The firm also estimates that the amount ordered by Gulf Electric in the first year will be ordered in each of the subsequent four years. The initial investment can be depreciated on a MACRS-GDS basis over a 5-year period, and the tax-rate is expected to remain 40%. At the end of five years, the forge is expected to retain a market value of $40,000 at the end of year 5. LMC's before tax MARR is 15% per year. Problem #2 Part A: Create a spreadsheet to determine. whether LMC should enter the competition to become the supplier of transmission housings for Gulf Electric. Use the present-worth measure of merit Part B: What Makes LMC Managers Worry: LMC's managers are uneasy about this project, because too many uncertain elements have not been considered in the analysis. The managers want to assess the various possible future outcomes before making a final decision. Put yourself in LMC's management position. and perform a sensitivity analysis for each variable (unit price, demand, market value). Graphically investigate the sensitivity of the PW to changes in the above factors. Investigate changes over the interval = 20%. To which variable is the project the most sensitive? Part C: LMC's managers become convinced that the PW is quite sensitive to changes in annual sales volume. Determine the break-even PW as a function of that variable. Problem #2 Investment $125,000 Units sold per yea 2000 units Selling price per ur $50 $10 5 YEAR GDS RATES 1 0.2 Cost per unit 0.32 MV $40000 3 0.192 5 years 5 years Study period 4 0.115 MACRS-GDS 5 0.115 Таx 40% 6 0.058 BTMARR 15% Lebanon Metal Company (LMC), a manufacturer of various metal parts, must decide whether to enter the competition to become the supplier of transmission housings for Gulf Electric, a company that produces the housings in its own in-house manufacturing To compete, LMC must purchase a new forge that will cost $125,000. If LMC gets the order, it may be able to sell as many as 2,000 units per year to Gulf Electric for $50 each, and costs will be $10 per unit. The firm expects that the project will have about five-year product life. The firm also estimates that the amount ordered by Gulf Electric in the first year will be ordered in each of the subsequent four years. The initial investment can be depreciated on a MACRS-GDS basis over a 5-year period, and the tax-rate is expected to remain 40%. At the end of five years, the forge is expected to retain a market value of $40,000 at the end of year 5. LMC's before tax MARR is 15% per year. Problem #2 Part A: Create a spreadsheet to determine. whether LMC should enter the competition to become the supplier of transmission housings for Gulf Electric. Use the present-worth measure of merit Part B: What Makes LMC Managers Worry: LMC's managers are uneasy about this project, because too many uncertain elements have not been considered in the analysis. The managers want to assess the various possible future outcomes before making a final decision. Put yourself in LMC's management position. and perform a sensitivity analysis for each variable (unit price, demand, market value). Graphically investigate the sensitivity of the PW to changes in the above factors. Investigate changes over the interval = 20%. To which variable is the project the most sensitive? Part C: LMC's managers become convinced that the PW is quite sensitive to changes in annual sales volume. Determine the break-even PW as a function of that variable. Problem #2 Investment $125,000 Units sold per yea 2000 units Selling price per ur $50 $10 5 YEAR GDS RATES 1 0.2 Cost per unit 0.32 MV $40000 3 0.192 5 years 5 years Study period 4 0.115 MACRS-GDS 5 0.115 Таx 40% 6 0.058 BTMARR 15% Lebanon Metal Company (LMC), a manufacturer of various metal parts, must decide whether to enter the competition to become the supplier of transmission housings for Gulf Electric, a company that produces the housings in its own in-house manufacturing To compete, LMC must purchase a new forge that will cost $125,000. If LMC gets the order, it may be able to sell as many as 2,000 units per year to Gulf Electric for $50 each, and costs will be $10 per unit. The firm expects that the project will have about five-year product life. The firm also estimates that the amount ordered by Gulf Electric in the first year will be ordered in each of the subsequent four years. The initial investment can be depreciated on a MACRS-GDS basis over a 5-year period, and the tax-rate is expected to remain 40%. At the end of five years, the forge is expected to retain a market value of $40,000 at the end of year 5. LMC's before tax MARR is 15% per year. Problem #2 Part A: Create a spreadsheet to determine. whether LMC should enter the competition to become the supplier of transmission housings for Gulf Electric. Use the present-worth measure of merit Part B: What Makes LMC Managers Worry: LMC's managers are uneasy about this project, because too many uncertain elements have not been considered in the analysis. The managers want to assess the various possible future outcomes before making a final decision. Put yourself in LMC's management position. and perform a sensitivity analysis for each variable (unit price, demand, market value). Graphically investigate the sensitivity of the PW to changes in the above factors. Investigate changes over the interval = 20%. To which variable is the project the most sensitive? Part C: LMC's managers become convinced that the PW is quite sensitive to changes in annual sales volume. Determine the break-even PW as a function of that variable. Problem #2 Investment $125,000 Units sold per yea 2000 units Selling price per ur $50 $10 5 YEAR GDS RATES 1 0.2 Cost per unit 0.32 MV $40000 3 0.192 5 years 5 years Study period 4 0.115 MACRS-GDS 5 0.115 Таx 40% 6 0.058 BTMARR 15% Lebanon Metal Company (LMC), a manufacturer of various metal parts, must decide whether to enter the competition to become the supplier of transmission housings for Gulf Electric, a company that produces the housings in its own in-house manufacturing To compete, LMC must purchase a new forge that will cost $125,000. If LMC gets the order, it may be able to sell as many as 2,000 units per year to Gulf Electric for $50 each, and costs will be $10 per unit. The firm expects that the project will have about five-year product life. The firm also estimates that the amount ordered by Gulf Electric in the first year will be ordered in each of the subsequent four years. The initial investment can be depreciated on a MACRS-GDS basis over a 5-year period, and the tax-rate is expected to remain 40%. At the end of five years, the forge is expected to retain a market value of $40,000 at the end of year 5. LMC's before tax MARR is 15% per year. Problem #2 Part A: Create a spreadsheet to determine. whether LMC should enter the competition to become the supplier of transmission housings for Gulf Electric. Use the present-worth measure of merit Part B: What Makes LMC Managers Worry: LMC's managers are uneasy about this project, because too many uncertain elements have not been considered in the analysis. The managers want to assess the various possible future outcomes before making a final decision. Put yourself in LMC's management position. and perform a sensitivity analysis for each variable (unit price, demand, market value). Graphically investigate the sensitivity of the PW to changes in the above factors. Investigate changes over the interval = 20%. To which variable is the project the most sensitive? Part C: LMC's managers become convinced that the PW is quite sensitive to changes in annual sales volume. Determine the break-even PW as a function of that variable. Problem #2 Investment $125,000 Units sold per yea 2000 units Selling price per ur $50 $10 5 YEAR GDS RATES 1 0.2 Cost per unit 0.32 MV $40000 3 0.192 5 years 5 years Study period 4 0.115 MACRS-GDS 5 0.115 Таx 40% 6 0.058 BTMARR 15% Lebanon Metal Company (LMC), a manufacturer of various metal parts, must decide whether to enter the competition to become the supplier of transmission housings for Gulf Electric, a company that produces the housings in its own in-house manufacturing To compete, LMC must purchase a new forge that will cost $125,000. If LMC gets the order, it may be able to sell as many as 2,000 units per year to Gulf Electric for $50 each, and costs will be $10 per unit. The firm expects that the project will have about five-year product life. The firm also estimates that the amount ordered by Gulf Electric in the first year will be ordered in each of the subsequent four years. The initial investment can be depreciated on a MACRS-GDS basis over a 5-year period, and the tax-rate is expected to remain 40%. At the end of five years, the forge is expected to retain a market value of $40,000 at the end of year 5. LMC's before tax MARR is 15% per year. Problem #2 Part A: Create a spreadsheet to determine. whether LMC should enter the competition to become the supplier of transmission housings for Gulf Electric. Use the present-worth measure of merit Part B: What Makes LMC Managers Worry: LMC's managers are uneasy about this project, because too many uncertain elements have not been considered in the analysis. The managers want to assess the various possible future outcomes before making a final decision. Put yourself in LMC's management position. and perform a sensitivity analysis for each variable (unit price, demand, market value). Graphically investigate the sensitivity of the PW to changes in the above factors. Investigate changes over the interval = 20%. To which variable is the project the most sensitive? Part C: LMC's managers become convinced that the PW is quite sensitive to changes in annual sales volume. Determine the break-even PW as a function of that variable. Problem #2 Investment $125,000 Units sold per yea 2000 units Selling price per ur $50 $10 5 YEAR GDS RATES 1 0.2 Cost per unit 0.32 MV $40000 3 0.192 5 years 5 years Study period 4 0.115 MACRS-GDS 5 0.115 Таx 40% 6 0.058 BTMARR 15% Lebanon Metal Company (LMC), a manufacturer of various metal parts, must decide whether to enter the competition to become the supplier of transmission housings for Gulf Electric, a company that produces the housings in its own in-house manufacturing To compete, LMC must purchase a new forge that will cost $125,000. If LMC gets the order, it may be able to sell as many as 2,000 units per year to Gulf Electric for $50 each, and costs will be $10 per unit. The firm expects that the project will have about five-year product life. The firm also estimates that the amount ordered by Gulf Electric in the first year will be ordered in each of the subsequent four years. The initial investment can be depreciated on a MACRS-GDS basis over a 5-year period, and the tax-rate is expected to remain 40%. At the end of five years, the forge is expected to retain a market value of $40,000 at the end of year 5. LMC's before tax MARR is 15% per year. Problem #2 Part A: Create a spreadsheet to determine. whether LMC should enter the competition to become the supplier of transmission housings for Gulf Electric. Use the present-worth measure of merit Part B: What Makes LMC Managers Worry: LMC's managers are uneasy about this project, because too many uncertain elements have not been considered in the analysis. The managers want to assess the various possible future outcomes before making a final decision. Put yourself in LMC's management position. and perform a sensitivity analysis for each variable (unit price, demand, market value). Graphically investigate the sensitivity of the PW to changes in the above factors. Investigate changes over the interval = 20%. To which variable is the project the most sensitive? Part C: LMC's managers become convinced that the PW is quite sensitive to changes in annual sales volume. Determine the break-even PW as a function of that variable. Problem #2 Investment $125,000 Units sold per yea 2000 units Selling price per ur $50 $10 5 YEAR GDS RATES 1 0.2 Cost per unit 0.32 MV $40000 3 0.192 5 years 5 years Study period 4 0.115 MACRS-GDS 5 0.115 Таx 40% 6 0.058 BTMARR 15% Lebanon Metal Company (LMC), a manufacturer of various metal parts, must decide whether to enter the competition to become the supplier of transmission housings for Gulf Electric, a company that produces the housings in its own in-house manufacturing To compete, LMC must purchase a new forge that will cost $125,000. If LMC gets the order, it may be able to sell as many as 2,000 units per year to Gulf Electric for $50 each, and costs will be $10 per unit. The firm expects that the project will have about five-year product life. The firm also estimates that the amount ordered by Gulf Electric in the first year will be ordered in each of the subsequent four years. The initial investment can be depreciated on a MACRS-GDS basis over a 5-year period, and the tax-rate is expected to remain 40%. At the end of five years, the forge is expected to retain a market value of $40,000 at the end of year 5. LMC's before tax MARR is 15% per year. Problem #2 Part A: Create a spreadsheet to determine. whether LMC should enter the competition to become the supplier of transmission housings for Gulf Electric. Use the present-worth measure of merit Part B: What Makes LMC Managers Worry: LMC's managers are uneasy about this project, because too many uncertain elements have not been considered in the analysis. The managers want to assess the various possible future outcomes before making a final decision. Put yourself in LMC's management position. and perform a sensitivity analysis for each variable (unit price, demand, market value). Graphically investigate the sensitivity of the PW to changes in the above factors. Investigate changes over the interval = 20%. To which variable is the project the most sensitive? Part C: LMC's managers become convinced that the PW is quite sensitive to changes in annual sales volume. Determine the break-even PW as a function of that variable. Problem #2 Investment $125,000 Units sold per yea 2000 units Selling price per ur $50 $10 5 YEAR GDS RATES 1 0.2 Cost per unit 0.32 MV $40000 3 0.192 5 years 5 years Study period 4 0.115 MACRS-GDS 5 0.115 Таx 40% 6 0.058 BTMARR 15%
Expert Answer:
Answer rating: 100% (QA)
Answer A Operating and Maintenance Costs Direct Cost labour Material 30000 30000 30000 30000 30000 F... View the full answer
Related Book For
Consumer Behavior Buying, Having and Being
ISBN: 978-0133450897
11th edition
Authors: Michael R. Solomon
Posted Date:
Students also viewed these economics questions
-
A marketer must decide whether to incorporate rational or emotional appeals in its communications strategy. Describe conditions that are more favorable to using one or the other.
-
A political campaign manager must decide whether to emphasize television advertisements or letters to potential voters in a reelection campaign. Describe the production function for campaign votes....
-
A company must decide whether to provide their salesmen with company-owned automobiles or to pay the salesmen a mileage allowance and have them drive their own automobiles. New automobiles would cost...
-
The gun 25kV In a television tube, a beam of electrons from 0.22mm de ofonmeter; they arrive5.6 x 104 electrons per second. Calculate the magnetic fieldIt isproduced by the beam at a point1.5mm from...
-
What is the shape of the AFC curve and why does it have this shape?
-
What are the potential choices for an entrepreneur to examine as the venture matures?
-
Briefly explain how the following programs would affect the elasticity of demand for labor in the steel industry: a. An increased tariff on steel imports. b. A law making it illegal to lay off...
-
The budget director of Heads Up Athletic Co., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the...
-
Given the Entity Relationship model below. Use it to answer the questions that follow b) Transform the above model into a relational model. Productid Orderld OrderDate ProductDescription Quantity...
-
Jon Fulkerson has also received a credit application from Seether, LLC, a private company. An abbreviated portion of the financial information provided by the company is shown below: Total assets...
-
You are a new teacher and just received a list of the students that will be in your class for the upcoming year. Prior to school starting, what about what you think do you think you should try and...
-
Business deals don't always work out. Please share a story of a merger or acquisition that had a good or bad outcome in biotech? Whether it was a success or failure, please explain why it turned out...
-
Write a C++ program to delete an element of a list of integer's numbers of size N, then shift all the rest of the list toward the deleted element: example: original list 1, 40, 21, 11, 31, 5, 7; if...
-
Your community hospital is exploring the purchase of an EHRS. The chief nursing officer wants you, the informatics nurse, to educate the nurse leaders about potential benefits and detriments of an...
-
Why is residential segregation significant, and what are the advantages and disadvantages of living in divided communities?"
-
The Stewart Company has $822,000 in current assets and $320,580 in current liabilities. Its initial inventory level is $189,060, and it will raise funds as additional notes payable and use them to...
-
50 31- 52 53 Engr. Limpe, an enterprising business person, had the following receipts during the year: 34 Gross receipts in his rent-a-plant business Refund on excess payment of insurance premium...
-
1. Firms may hold financial assets to earn returns. How the firm would classify financial assets? What treatment will such financial assets get in the financial statements in accordance with US GAAP...
-
Define product placement and list three examples of it. How is this practice the same or different from branded entertainment?
-
1. What are the most likely market segments for ASIMO? How could Hondo overcome resistance to the idea of a home robot? 2. What concerns might consumers have regarding FRT? Hondas ASIMO is a robot....
-
What are the influencing factors of CPS?
-
Baggai Enterprises has an ROA of 10 percent, retains 30 percent of earnings, and has an equity multiplier of 1.25. Mondale Enterprises also has an ROA of 10 percent, but it retains two-thirds of...
-
International Business Machines (NYSE: IBM), which currently pays a dividend of \($3.40\) per share, has been the subject of two other examples in this reading. In one example, an analyst estimated...
-
An analyst is preparing a forecast of dividends for Hoshino Distributors for the next five years. He uses a spreadsheet model with the following assumptions: Sales are $100 million in Year 1. They...
Study smarter with the SolutionInn App