Due September 26, 2020 This assignment uses the Learning Curve Excel 'tool.' See the ML70x micro-lessons before starting. Your company is considering developing and building a new electric passenger car. Average variable costs of production are expected fall as in Wright's learning curve model. You have the following information: Total research, development, testing, and evaluation (RDT&E) costs (fixed): $30 million The following costs are variable costs (they don't include the $30 million) Expected average cumulative cost of the first 100 cars: Expected average cumulative cost of the first 300 cars: $149 thousand $114 thousand From this information, report the learning rate and complete the following table (use millions of dollars as your units). Learning rate Average Fixed Average Variable Costs Cost Average Total Cost Total RDT&E Marginal Cost Total # of cars 1 2 4 8 16 32 64 128 256 512 1,024 2,048 4,096 8,192 16,384 32,768 65,536 131,072 8 9 Due September 26, 2020 This assignment uses the Learning Curve Excel 'tool.' See the ML70x micro-lessons before starting. Your company is considering developing and building a new electric passenger car. Average variable costs of production are expected fall as in Wright's learning curve model. You have the following information: Total research, development, testing, and evaluation (RDT&E) costs (fixed): $30 million The following costs are variable costs (they don't include the $30 million) Expected average cumulative cost of the first 100 cars: Expected average cumulative cost of the first 300 cars: $149 thousand $114 thousand From this information, report the learning rate and complete the following table (use millions of dollars as your units). Learning rate Average Fixed Average Variable Costs Cost Average Total Cost Total RDT&E Marginal Cost Total # of cars 1 2 4 8 16 32 64 128 256 512 1,024 2,048 4,096 8,192 16,384 32,768 65,536 131,072 8 9