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)PROMPTView Learning Curve Calculator. This video demonstrates how to set up a Cumulative Average Model calculator in Excel. Then, complete the tasks for this activity.TASKS1. Create a Learning Curve Calculator similar to the one shown from the video Learning Curve Calculator.2. Create a graph of Unit Cost versus Learning Rate for an initial unit cost of $100 and a production run of 1,000 units. Learning rate should vary from 0 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 Unit Number versus Cumulative Total Cost. Select two learning rates (Option A and Option B). Answer the following questions:a. 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)?b. Does your answer change if you do 50 runs in a year and the learning rate cost is a one-time cost? Explain why or why not.c. 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.
Essay Writing Service Features
Our Experience
No matter how complex your assignment is, we can find the right professional for your specific task. Contact Essay is an essay writing company that hires only the smartest minds to help you with your projects. Our expertise allows us to provide students with high-quality academic writing, editing & proofreading services.Free Features
Free revision policy
$10Free bibliography & reference
$8Free title page
$8Free formatting
$8How Our Essay Writing Service Works
First, you will need to complete an order form. It's not difficult but, in case there is anything you find not to be clear, you may always call us so that we can guide you through it. On the order form, you will need to include some basic information concerning your order: subject, topic, number of pages, etc. We also encourage our clients to upload any relevant information or sources that will help.
Complete the order formOnce we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.
Writer’s assignmentAs soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.
Completing the order and download