I need these questions to be done on excel, please show all work and formulas on excel to receive the answer. If exel is not used then please show all the steps for the solution
3 FE Practice Problems
3-36. Find the average time per unit required to produce the first 30 units, if the slope parameter of the learning rate is 92% and the first unit takes 460 hours.
a. 330.693
b. 305.5404
c. 245
d. 347.3211
3-37. A student is considering the purchase of two alternative cars. Car A initially costs $1,500 more than Car B, but uses 0.05 gallons per mile, versus 0.07 gallons per mile for Car B. Both cars will last for 10 years,
and Bs market value is $800 less than As. Fuel costs $4.00 per gallon. If all else is equal, at how many miles driven per year does Car A become preferable to Car B?
a. 875
b. 1,167
c. 1,723
d. 1,892
3-38. An automatic process controller will eliminate the current manual control operation. Annual cost of the current method is $4,000. If the controller has
a service life of 13 years and an expected market value of 11% of the first cost, what is the maximum economical price for the controller? Ignore interest.
a. 28,869
b. 58,426
c. 26,358
d. 25,694
e. 53,344
3-39. A foreperson supervises A, B, and eight other employees. The foreperson states that he spends twice as much time supervising A and half as much time supervising B,
compared with the average time spent supervising his other subordinates. All employees have the same production rate. On the basis of equal cost per unit production,
what monthly salary is justified for B if the foreperson gets $3,800 per month and A gets $3,000 per month?
a. 3,543
b. 3,800
c. 3,000
d. 2,457
e. 3,400
3-40. A car rental agency is considering a modification in its oil change procedure. Currently, it uses a Type X filter, which costs $5 and must be changed every 7,000 miles along
with the oil (5 quarts). Between each oil change, one quart of oil must be added after each 1,000 miles. The proposed filter (Type Y) has to be replaced every 5,000 miles (along
with 5 quarts of oil) but does not require any additional oil between filter changes. If the oil costs $1.08 per quart, what is the maximum acceptable price for the Type Y filter?
a. 12.56
b. 7.43
c. 11.48
d. 6.66
3-41. A small textile plant was constructed in 2008. The major equipment, costs, and factors are shown below.
Estimate the cost to build a new plant in 2018 if the index for this type of equipment has increased at an average rate of 12% per year for the past 10 years. Select the closest answer. (3.4)
a. 4,618,000
b. 10,623,000
c. 14,342,000
d. 14,891,000
Equipment	Reference Size	Reference Cost	Cost-Capacity Factor	New Design Size
Finishing machine	150 yd/min	$900,000	0.92	200 yd/min
Jet dyer	200 yd/min	$1,125,000	0.87	450 yd/min
Steam dyer	100 yd/min	$750,000	0.79

3-39. A foreperson supervises A. B, and eight other employees. The foreperson states that he spends twice as much time supervising A and half as much time supervising B compared with the average time spent supervising his other subordinates. All employees have the same production rate. On the basis of equal cost per unit productio what monthly salary is justified for B if the foreperson gets $3,800 per month andA gets $3,000 per month? a. 3,543 b. 3,800 c. 3,000 d. 2,457 e. 3,400 3-40. A car rental ageny is considering a modification in its oil change procedure. Currently, it uses a Type filter, which costs $5 and must be changed every 7,000 miles al with the oil (5 quarts). Between each oil change, one quart of oil must be added after each 1000 miles. The proposed filter Type Y) has to be replaced every 5,000 miles (al with 5 quarts of oil but does not require any additional oil between filter changes. If the oil costs $1.08 per quart, what is the maximum acceptable price for the Typefilter? a. 12.56 b. 7.43 c. 11.48 d. 6.66 3-41. A small teile plant was constructed in 2008. The major equipment, costs, and factors are shown below Estimate the cost to build a new plant in 2018 if the index for this type of equipment has increased at an average rate of 12% per year for the past 10 years. Select the closest answer(3.4) a. 4,618,000 b. 10,623,000 c. 14,342,000 d. 14,891,000 Equipment Finishing machine Jet dyer Steam dyer Reference Size Reference Cost Cost-Capacity Fac New Design Size 150 ydmin 200 ydmin 100 ydlmin $900,000 $1,125,000 $750,000 0.92 200 ydmin 0.87 450 ydmin 0.79