Learning curve calculator spreadsheet

Written Assignment 3 Problem 1 Ensure you have viewed: Learning Curve Calculator (Setting up Excel Spreadsheet for Cumulative Average Model, Formulas) (You Tube). This video demonstrates how to setup a Cumulative Average Model calculator in Excel. Then, complete the tasks for this activity. BACKGROUND INFORMATION In this module, you focus on the concept and principles of learning rates and customer value determination. In this assignment, you will be able to practice and develop your learning rate determination skills. This will help you to become proficient in determining and analyzing learning rates for a variety of scenarios. This activity addresses the following Module Outcome: Differentiate between alternative business processes utilizing the Plan-Do-Check-Act (PDCA) cycle, and various performance measures. (CO#1, CO#4) PROMPT View Learning Curve Calculator. This video demonstrates how to set up a Cumulative Average Model calculator in Excel. Then, complete the tasks for this activity. TASKS 1. Create a Learning Curve Calculator similar to the one shown from the video Learning Curve Calculator. 2. Create a graph of Unit Cost versus Unit Number (displaying Learning Rate) for an initial unit cost of $100 and a production run of 1,000 units. Learning rates should vary from 60% to 100% and should use increments of 5%. Ensure you label the x- and y-axis and provide a graph title. The graph should be in its own worksheet. For help with moving the graph to a new sheet, go to How to Move a Chart onto a New Sheet in Excel. 3. Using the same data from question 2 (above), graph the Cumulative Total Cost versus Unit Number. Select two learning rates (Option A and Option B). Answer the following questions: 4. If each 5% increment of learning rate costs $1000, which option (A or B) would result in a low cost (Cumulative cost for 1,000 unit run added to the learning rate cost)? 5. Does your answer change if your production run is 50 units and the learning rate cost is a one-time cost? Explain why or why not. 6. Explain how you could use the PDCA cycle to reduce the Cumulative Total Cost. What are the tradeoffs to reducing Cumulative Total Costs? Note: Please ensure you submit your answers to the above questions and your MS Excel Learning Curve Calculator with all of your work (each problem should be its own worksheet). You can label each worksheet based on problem number (i.e. – “M2A2 Problem 2”). Please support your written answers and cite in APA format. Problem 2 Utilizing the Exercise Data MS Excel File, answer the questions in the task. BACKGROUND INFORMATION In this module, you focus on the concept and principles of learning rates and customer value determination. In this assignment, you will be able to practice and develop your analysis of an alternative skill set. This activity will allow you to explore new product selection using data. You will have to decide which data should drive your decision and be able to support/justify your choice. This activity addresses the following Module Outcome: Analyze customer value curves and purchase intent surveys to forecast sales for a variety of new products and recommend the best option for a business to pursue.(CO#1) PROMPT Utilizing the Exercise Data MS Excel File, answer the following questions: . TASKS Calculate the Purchase Probability for each of the four phone options (A through D), utilizing the data from the worksheet “Purchase Intent Survey,” located within the Exercise MS Excel file. Record your data in the worksheet. Each problem should be its own worksheet.