re is money left over in the corporate capital budget and each department has been asked to price out a computer em they would like. The corporation has in mind a budget of $2,000 per department - though some may be able to over if overall the corporation is still within budget. In order to determine if this equipment can be purchased, you e created an Excel workbook named CSE 2111 Pre Lab 3 Computer Budget Master.xlsx. This spreadsheet contains the es by department for each of the desired components - monitors, computers, software, jump drives, printers and itional memory. In addition you have categorized these costs based on where these items/services will be acquired: , Microcenter or CompUSA. The vendors are pre-determined based on existing contractual agreements. will now use this information to perform an analysis. Follow the steps as described below. Open the file, CSE 2111 Pre Lab 3 Computer Budget Master.xlsx Perform the necessary calculations as follows: - Determine the total costs for each computer system - In Cell C9, determine the total cost for the Engineering Group. Copy your formula across the row into cells D9:G9. - Compare the total cost of acquiring a system to the department's budget (cell B1). - Write a formula in cell C11, which can be copied across the row, to determine how much over or under budget you would be if you purchased this system. Write the formula such that if you are over budget this value will be negative. (Hint: do not forget to properly reference cells so that it can be copied across the row.) - Write a formula, in cell B12, to automatically determine how many of the department systems are within your budget. (This formula should work even if any of the input costs are later modified) - The corporation may decide to only fund either the Engineering Group or the R\&D (Research and Development) Group. Originally their decision was to fund the Engineering Group only but now you hear that they might decide to fund R\&D instead. You just know someone will ask you who's cost more and by how much on a percentage basis. Thus, in Cell B13, write a formula that shows the percent difference in total costs between the original choice - Engineering, and the alternative option - R\&D's system - Determine the total costs by vendor - Write a formula in cell C16, that can be copied down and across into cells C16:G18, to determine how much of the costs of this department's equipment are paid to this vendor. For example in cell C16 would be the costs for the Engineering Group's system purchased from Microcenter. re is money left over in the corporate capital budget and each department has been asked to price out a computer em they would like. The corporation has in mind a budget of $2,000 per department - though some may be able to over if overall the corporation is still within budget. In order to determine if this equipment can be purchased, you e created an Excel workbook named CSE 2111 Pre Lab 3 Computer Budget Master.xlsx. This spreadsheet contains the es by department for each of the desired components - monitors, computers, software, jump drives, printers and itional memory. In addition you have categorized these costs based on where these items/services will be acquired: , Microcenter or CompUSA. The vendors are pre-determined based on existing contractual agreements. will now use this information to perform an analysis. Follow the steps as described below. Open the file, CSE 2111 Pre Lab 3 Computer Budget Master.xlsx Perform the necessary calculations as follows: - Determine the total costs for each computer system - In Cell C9, determine the total cost for the Engineering Group. Copy your formula across the row into cells D9:G9. - Compare the total cost of acquiring a system to the department's budget (cell B1). - Write a formula in cell C11, which can be copied across the row, to determine how much over or under budget you would be if you purchased this system. Write the formula such that if you are over budget this value will be negative. (Hint: do not forget to properly reference cells so that it can be copied across the row.) - Write a formula, in cell B12, to automatically determine how many of the department systems are within your budget. (This formula should work even if any of the input costs are later modified) - The corporation may decide to only fund either the Engineering Group or the R\&D (Research and Development) Group. Originally their decision was to fund the Engineering Group only but now you hear that they might decide to fund R\&D instead. You just know someone will ask you who's cost more and by how much on a percentage basis. Thus, in Cell B13, write a formula that shows the percent difference in total costs between the original choice - Engineering, and the alternative option - R\&D's system - Determine the total costs by vendor - Write a formula in cell C16, that can be copied down and across into cells C16:G18, to determine how much of the costs of this department's equipment are paid to this vendor. For example in cell C16 would be the costs for the Engineering Group's system purchased from Microcenter