Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

***CAN YOU PLEASE SHOW STEP-BY-STEP IN AN EXCEL SPREADSHEET and show the Excel formulas , THANK YOU :)*** The direct labor cost of making airplanes

***CAN YOU PLEASE SHOW STEP-BY-STEP IN AN EXCEL SPREADSHEET and show the Excel formulas, THANK YOU :)***

The direct labor cost of making airplanes decreases with repetition (learning curve). As a result, the cost of manufacturing airplanes depends on the unit production number (first, fifth, 10th, 50th, etc.). The following data shows the direct labor cost for selected production numbers.

Airplane # (X) 1 8 16 32 64 130 200 300 400 500 600
Labor Time (Y) 7300 6500 5400 5000 4500 4200 4100 3500 3200 3000 2800

Using Excel graphs, find linear, power, exponential, and logarithmic fits for this dataset. Make sure to include equations and R2 for each fit. Insert all graphs here and select the best model based on R2. Rank the models based on the value of R2. Which model fit is the best?

If an airplane manufacturer charges $150 per hour for direct labor cost, find the total labor hours and labor cost if a small airliner orders 10 airplanes (#700 to 709).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quantitative Methods For Business

Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey Cam

12th Edition

840062338, 840062346, 9780840062338, 978-0840062345

More Books

Students also viewed these General Management questions

Question

=+a. Define a key term or concept in your field.

Answered: 1 week ago