Download from SimNet: CSE $2111$ Pre Lab $3$ Computer CSE $2111$ Pre Lab $3$ Candidates Master.$)$

UST DOWNLOAD YOUR STARTING FILES FROM YOUR SIMNET ED STARTING FILES TO YOUR SIMNET SESSION OR SIMNET W

UYING A COMPUTER

left over in the corporate capital budget and each department has be ould like. The corporation has in mind a budget of $$2,000$ per departm all the corporation is still within budget. In order to determine if this an Excel workbook named CSE $2111$ Pre Lab $3$ Computer Budget Master artment for each of the desired components $-$ monitors, computers, soft mory. In addition you have categorized these costs based on where the ter or CompUSA. The vendors are pre$-$determined based on existing cor use this information to perform an analysis. Follow the steps as describec

file, CSE $2111$ Pre Lab $3$ Computer Budget Master.xIsx

the necessary calculations as follows:

Determine the total costs for each computer system $-$ In Cell C$9,$ determin Group. Copy your formula across the row into cells D$9$:G$9.$

Compare the total cost of acquiring a system to the department's budget $($ C$11,$ which can be copied across the row, to determine how much over or $4$ purchased this system. Write the formula such that if you are over budget do not forget to properly reference cells so that it can be copied across the

Write a formula, in cell B$12,$ to automatically determine how many of the de your budget. $($This formula should work even if any of the input costs are lat

The corporation may decide to only fund either the Engineering Group or the Development$)$ Group. Originally their decision was to fund the Engineering $C$ that they might decide to fund R&D instead. You just know someone will ask how much on a percentage basis. Thus, in Cell B$13,$ write a formula that shov

Search