a. How many hours per shift is a welder needed if the contractor is indifferent

a. How many hours per shift is a welder needed if the contractor is indifferent between the two welders? Use a break even analysis to calculate the number of hours and show calculations in an excel formula or other spreadsheet means
b. If the site requires a generator for 2.5 hours per shift which welder is preferred and what is the estimated annual cost? Use a break even analysis to calculate the $ cost and show calculations in an excel formula or other spreadsheet means
c. If the site requires a generator for 5.5 hours per shift which welder is preferred and what is its estimated annual cost? Use break even analysis to calculate the $ cost and show calculations in an excel formula or other spreadsheet means.
see attachment for formatted table
A laser welder is needed Apollo Construction. Two alternatives are being considered. Their annual fixed cost and operating and maintenance costs per hour are shown in the table below. The contractor runs 38 hour shifts per day for 250 working days per year.
Welder
Fixed costs ($/year)
O&M ($/hour)
1
$4000
$7.00
2
$8000
$5.50
a. How many hours per shift is a welder needed if the contractor is indifferent between the two welders? Use a break even analysis to calculate the number of hours and show calculations in an excel formula or other spreadsheet means
b. If the site requires a generator for 2.5 hours per shift which welder is preferred and what is the estimated annual cost? Use a break even analysis to calculate the $ cost and show calculations in an excel formula or other spreadsheet means
c. If the site requires a generator for 5.5 hours per shift which welder is preferred and what is its estimated annual cost? Use break even analysis to calculate the $ cost and show calculations in an excel formula or other spreadsheet means.
Attachments: