Your task is to complete the spreadsheet model for the cost/benefit analysis and interpret the results. In your submission of the assignment you should include your spreadsheet with all functions as well as a brief report (~300 words) that addresses the questions below. The grading rubric for this assignment is displayed in the syllabus and the deadline for submitting your excel file and report is 10/9/2022 by 11:30 pm CST.
Questions.
Using the data from the spreadsheet, answer the following questions in a separate document.
1. What do the net results indicate about the training program?
2. Based on the cost/benefit analysis should Opticity Power continue the training program? Briefly explain.
3. The Training Specialists in charge of the training program think that the estimated productivity increases resulting from training are too high. They are more comfortable with 10% increases. Change each of the entries in the range C43:G43 to reflect 10% increases for all five years. Should the training program be continued considering the new productivity figures? Explain.
4. Using the same assumptions as Question 2, what if the productive contribution per employee was $3,000 instead of $4,500. Enter $900,000 ($6000 times 300 trainees) in cell B41. Should the training program be continued? Explain.
As with any of the functions used in this assignment, Microsoft and YouTube have excellent tutorials that can assist you in using them. In addition, your professor has recorded videos that demonstrates how to execute the procedures described below (with a different set of data) that can be accessed via the links below.
Part 1: https://www.youtube.com/watch?v=e3y4PneWbwo
Part 2: https://www.youtube.com/watch?v=CqICGn24br0
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|