3. (TCO 4) You are a Cost Analyst with US Software Exchange. You have been asked to develop a budget and short term plan to create the new "Data Warehouse Software Model." The software is to be upgraded quarterly so a new project is required each quarter. The company reviews all analysis on a quarterly basis.
You are to analyze last year's historical data to identify the quarter with the highest cost to make sure that enough money is budgeted for this year to employ 5 full time engineers. You must predict the times when the program in the coming year will be running at full production and analyze if additional funds will be needed to stay within budget for the project.
Give a step by step explanation of how you will calculate the total cost for each quarter based on the hours worked and the wage per hour in the graphic above and how you will arrange the data to show the highest to the lowest cost per quarter.