Please answer using excel showing equations.
Homework Answers
![= -100000 - 30000*2.470 – 5000x 2,3079 - 100000 730000 46,4703 +5000 [ x2,3079] x 0,743 -323694094 Y = initial Cost - Annulal](http://img.homeworklib.com/questions/d974d800-c015-11eb-9c92-81f040f16ea3.png?x-oss-process=image/resize,w_560)
pleasc
give me like
Add Answer to:
Please answer using excel showing equations.
Company B must choose one of two methods for its...
5. An environmen tal engineer must recommend one of two methods for monitoring high colony counts...
explain steps and notation. dont do on excel. i rate
5. An environmen tal engineer must recommend one of two methods for monitoring high colony counts of E.coli and other bacteria in watershed area "hot spots". What's the incremental of return (2 decimal places)? which method is more economically justified at 12% MARR. (20 pts, due 4/11, 11:59pm) rate Method B Method A 310,000 -100,000 Initial Cost, S Annual operating cost, S per year -55,000 in year 1, -50,000 in...
Q.#1 Using Excel format: A company is studying two different production methods to produce its product....
Q.#1 Using Excel format: A company is studying two different production methods to produce its product. Both production methods have the same life and the same maintenance and repair record. Production Method 1: costs $120,000 and uses 20 gallons per hours of operation. Production Method 2: costs $175,000 and uses 18 gallons per hours of operation at the same level of production. Both production methods have four-year lives before any major overhaul is required and the 10% of initial its...
A company needs to choose between two replacement alternatives: Machine A and B. Using the corporate...
A company needs to choose between two replacement alternatives: Machine A and B. Using the corporate MARR of 15% per year and the table below, answer the following questions. Machine A Machine B First cost, $ -62,000 -77,000 Annual operating cost, $/year -15,000 -21,000 Salvage value, $ 8,000 10,000 Life, years What is the annual worth of Machine B? Choose the closest value. a) $-80,000 b) $-100,000 c) $-40,000 d) $-25,000
CFAT is Cash Flow After Tax SL- Straight line T.I- Taxable Income Problem 2-20 points Company...
CFAT is Cash Flow After Tax
SL- Straight line
T.I- Taxable Income
Problem 2-20 points Company B wants to compare the investment in three different countries based on the following information. Tax rate is 30% for all three countries. MARR is 9% compounded quarterly. Depreciation method Depreciation recapture Purchase Cost Gross Income Expense Salvage Life in years Actual selling price Country 1 SL with n=5 Not taxed 100,000 26,000 1,000 0 5 20,000 in year 5 Country 2 MACRS with...
2. A company has to choose one of three different assembly methods. Method A will have...
2. A company has to choose one of three different assembly methods. Method A will have a first cost of $30,000, an annual operating cost of $9,000, and a service life of 2 years. Method B will cost $80,000 to buy and will have an annual operating cost of $6,000 over its 4-year service life. Method C will cost $130,000 initially with an annual operating cost of $4000 over its 8-year life. Methods A and B will have no salvage...
Answer Part B using excel and show equations that were used. explain if the problem is...
Answer Part B using excel and show equations that were used.
explain if the problem is suffiecent or not.
You would like to construct an aggregate production plan for four quarters of 2021. Product name: TRX3010 Cost of regular production = 50 $/u Cost of overtime production = 65 $/u Inventory holding cost = 5 $/u/qtr Cost of increasing production = 40 $/u Cost of decreasing production = 45 $/u Previous quarter's regular production = 4200 u Beginning inventory level...
Please show all the steps you've done to reach the final answer. I am trying to...
Please show all the steps you've done to reach the final answer. I am trying to learn, so please show your work. Typing your answer is important. 1) A metal plating company is considering four different methods for recovering by-product heavy metals from a manufacturing site’s liquid waste. The investment costs and annual net incomes associated with each method have been estimated. All methods have an 8-year life; the MARR is 11% per year, and an AW-based ROR analysis is...
I need to the worksheet on (Excel) for all of them. 5.2 NRG Energy plans to...
I need to the worksheet on (Excel) for all of
them.
5.2 NRG Energy plans to construct a giant solar plant in Santa Teresa, NM to supply electricity to 30,000 southern NM and western TX homes. The plant will have 390,000 heliostats to concentrate sunlight onto 32 water towers to generate steam NRG will spend $560 million in constructing the plant and $430,000 per year in operating it. If a salvage value of 20% of the initial cost is assumed,...
Problem 1 (25 points) A manufacturing firm must choose between two mutually exclusive pieces of equipment...
Problem 1 (25 points) A manufacturing firm must choose between two mutually exclusive pieces of equipment for one of its production lines. The company uses an effective tax rate of 34% and an after-tax MARR of 10%. Which option should they select on an after-tax basis? Option 1 Option 2 Initial Cost $100,000 $300,000 Annual Net Revenues $40,000 $100,000 Salvage Value $25,000 $75,000 Depreciation Method MACRS Depreciable life 3 - year GDS Useful life 4 years CFAT EOY Tax CFBT...
Question Set 2. MUSTBE DONE USING EXCEL operation must periodically purchase bulk quantities of b...
Question Set 2. MUSTBE DONE USING EXCEL operation must periodically purchase bulk quantities of bolts. The bolts are purchased in manu boxes of 500 and are consumed at a constant rate. The operation expects to purchase 30,000 boxes over the coming year. Each box costs $150, the annual holding cost per box is $20, and the cost of placing an order is $240 (regardless of the quantity ordered). For the following questions, use the basic economic order quantity model (without...
explain steps and notation. dont do on excel. i rate
5. An environmen tal engineer must recommend one of two methods for monitoring high colony counts of E.coli and other bacteria in watershed area "hot spots". What's the incremental of return (2 decimal places)? which method is more economically justified at 12% MARR. (20 pts, due 4/11, 11:59pm) rate Method B Method A 310,000 -100,000 Initial Cost, S Annual operating cost, S per year -55,000 in year 1, -50,000 in...
A company needs to choose between two replacement alternatives: Machine A and B. Using the corporate MARR of 15% per year and the table below, answer the following questions. Machine A Machine B First cost, $ -62,000 -77,000 Annual operating cost, $/year -15,000 -21,000 Salvage value, $ 8,000 10,000 Life, years What is the annual worth of Machine B? Choose the closest value. a) $-80,000 b) $-100,000 c) $-40,000 d) $-25,000
CFAT is Cash Flow After Tax
SL- Straight line
T.I- Taxable Income
Problem 2-20 points Company B wants to compare the investment in three different countries based on the following information. Tax rate is 30% for all three countries. MARR is 9% compounded quarterly. Depreciation method Depreciation recapture Purchase Cost Gross Income Expense Salvage Life in years Actual selling price Country 1 SL with n=5 Not taxed 100,000 26,000 1,000 0 5 20,000 in year 5 Country 2 MACRS with...
2. A company has to choose one of three different assembly methods. Method A will have a first cost of $30,000, an annual operating cost of $9,000, and a service life of 2 years. Method B will cost $80,000 to buy and will have an annual operating cost of $6,000 over its 4-year service life. Method C will cost $130,000 initially with an annual operating cost of $4000 over its 8-year life. Methods A and B will have no salvage...
Answer Part B using excel and show equations that were used.
explain if the problem is suffiecent or not.
You would like to construct an aggregate production plan for four quarters of 2021. Product name: TRX3010 Cost of regular production = 50 $/u Cost of overtime production = 65 $/u Inventory holding cost = 5 $/u/qtr Cost of increasing production = 40 $/u Cost of decreasing production = 45 $/u Previous quarter's regular production = 4200 u Beginning inventory level...
I need to the worksheet on (Excel) for all of
them.
5.2 NRG Energy plans to construct a giant solar plant in Santa Teresa, NM to supply electricity to 30,000 southern NM and western TX homes. The plant will have 390,000 heliostats to concentrate sunlight onto 32 water towers to generate steam NRG will spend $560 million in constructing the plant and $430,000 per year in operating it. If a salvage value of 20% of the initial cost is assumed,...
Problem 1 (25 points) A manufacturing firm must choose between two mutually exclusive pieces of equipment for one of its production lines. The company uses an effective tax rate of 34% and an after-tax MARR of 10%. Which option should they select on an after-tax basis? Option 1 Option 2 Initial Cost $100,000 $300,000 Annual Net Revenues $40,000 $100,000 Salvage Value $25,000 $75,000 Depreciation Method MACRS Depreciable life 3 - year GDS Useful life 4 years CFAT EOY Tax CFBT...
Question Set 2. MUSTBE DONE USING EXCEL operation must periodically purchase bulk quantities of bolts. The bolts are purchased in manu boxes of 500 and are consumed at a constant rate. The operation expects to purchase 30,000 boxes over the coming year. Each box costs $150, the annual holding cost per box is $20, and the cost of placing an order is $240 (regardless of the quantity ordered). For the following questions, use the basic economic order quantity model (without...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago