Question

QUESTION 2 (70 points) Acme Batteries is introducing a new line of battery packs for electric vehicles. The cost of fabricating the first battery pack is $3,200 with a learning rate of 0.7. a) What is the cost of the 100$^{th}$ battery pack to the nearest cent? Provide an explanation. b) Create an Excel spreadsheet based on the above, change the number of units and compute the cost per battery pack repeatedly to experimentally determine at what number of units of production the cost comes down to exactly $50 per battery pack. Copy and paste a screenshot of the spreadsheet below (do not submit an Excel file). Provide an explanation.

          QUESTION 2 (70 points)
Acme Batteries is introducing a new line of battery packs for electric vehicles. The cost of fabricating the
first battery pack is $3,200 with a learning rate of 0.7.
a) What is the cost of the 100$^{th}$ battery pack to the nearest cent? Provide an explanation.
b) Create an Excel spreadsheet based on the above, change the number of units and compute the cost
per battery pack repeatedly to experimentally determine at what number of units of production the
cost comes down to exactly $50 per battery pack. Copy and paste a screenshot of the spreadsheet
below (do not submit an Excel file). Provide an explanation.

Show more…

QUESTION 2 (70 points)
Acme Batteries is introducing a new line of battery packs for electric vehicles. The cost of fabricating the
first battery pack is 3,200 with a learning rate of 0.7.
a) What is the cost of the 100^thbattery pack to the nearest cent? Provide an explanation.
b) Create an Excel spreadsheet based on the above, change the number of units and compute the cost
per battery pack repeatedly to experimentally determine at what number of units of production the
cost comes down to exactly50 per battery pack. Copy and paste a screenshot of the spreadsheet
below (do not submit an Excel file). Provide an explanation.

Added by John J.

Elementary Statistics a Step by Step Approach

Allan G. Bluman 9th Edition

Instant Answer

Solved by Expert Akash M

08/18/2023

Step 1

Step 1: The cost of the 100th battery pack can be calculated using the learning curve formula: $$C_n = C_1 * n^b$$ where: * $C_n$ is the cost of the nth unit * $C_1$ is the cost of the first unit * n is the number of units * b is the learning rate exponent, Show more…

Show all steps

lock

Thanks for your feedback!

QUESTION 2 (70 points) Acme Batteries is introducing a new line of battery packs for electric vehicles. The cost of fabricating the first battery pack is $3,200 with a learning rate of 0.7. a) What is the cost of the 100th battery pack to the nearest cent? Provide an explanation. b) Create an Excel spreadsheet based on the above, change the number of units and compute the cost per battery pack repeatedly to experimentally determine at what number of units of production the cost comes down to exactly $50 per battery pack. Copy and paste a screenshot of the spreadsheet below (do not submit an Excel file). Provide an explanation.

Play audio

Feedback

Powered by NumerAI

Akash M and 94 other subject Intro Stats / AP Statistics educators are ready to help you.

Ask a new question

Labs

Want to see this concept in action?

NEW

Explore this concept interactively to see how it behaves as you change inputs.

View Labs

Key Concepts

Recommended Videos

Recommended Textbooks

Transcript

Ace is your personal tutor. It breaks down any question with clear steps so you can learn.

Start Using Ace

Continue solving this problem

Create a free account to:

View full step-by-step solution
Ask follow-up questions with Ace AI
Save progress and study later