Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2-(14 pts.) The direct labor cost of making airplanes decreases with repetition (learning curve). As a result, the cost of manufacturing of airplanes depend on
2-(14 pts.) The direct labor cost of making airplanes decreases with repetition (learning curve). As a result, the cost of manufacturing of airplanes depend on the unit production number (first. fifth, 10. 50th, etc.). The following data shows the direct labor cost for selected production numbers. Airplane # 1 8 16 32 64 130 300 400 500 600 (X) Labor 7300 6500 4900 4500 4200 4000 3700 3500 3200 3100 Time (Y) 200 700 5400 2900 a- Using Excel graphs, find linear, power, exponential, and logarithmic fits for this dataset. Make sure to include equations and R' for each fit. Insert all graphs here and select the best model based on R?. Rank the fits based on the value of R? Which fit is the best? b- If an airplane manufacturer charges $200 per hour for direct labor cost, find the total labor cost if a small airliner orders 10 airplanes (#710 to 719). 3 4 5 6 7 8 9 10 11 12 13 14 Airplane #(X) Labor Time (Y) 1 7300 8 6500 16 5400 32 4900 64 4500 130 4200 200 4000 300 3700 400 3500 500 3200 600 3100 700 2900 15 16 17 18 19 20
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started