You are currently employed at a medium-sized financial management firm, Durban & Associates, as a financial analyst. Your boss recently authorized the purchase of a new laptop computer for your use at home and in the office. She asked you to obtain three competitive bids before she approves the purchase. The minimum requirements of the systems you want to buy are as follows:

Processor – w/Intel Core i7 with at least a 15” screen Minimum 8GB of Ram
Minimum 500 GB Hard Drive
Windows 8.1 Professional

Camera Built in Bluetooth Connections

Long Life Battery
DVD recordable device Video card
Full 3-year warranty Carrying case
Shipping

Table 1 shows information for three possible computers based on Web site pricing. The features do not match up exactly, so you need to create a worksheet comparing all three systems and their total prices.

(Note that the models, features and pricing are fictitious and do not constitute advice on any computer purchase)

Table 1 You are

1.

2.

to complete the following:

Create a new workbook named Computer_Purchase_nn.xlsx where nn are your initials. For example, if your name were John Smith, the name of your file would be Computer_Purchase_JS.xlsx.

Create a worksheet that compares the cost of each of the listed items for the three computers. Organize the worksheet so that each component is listed separately. If an item is included in the basic computer price, enter a zero. Be sure to include the following elements:

1. A title formatted in Cambria, size 14, bold, and italic. Merge the center and title above your worksheet and add a light blue fill.
2. Appropriate column and row headings so that your worksheet is easy to understand. If necessary, wrap the text headings into more than one row in the cell
3. Numbers in the first row and in any summation rows formatted with the Accounting Number Format. Format all other dollar values with the Comma Style. Note that zeros will appear as dashes.

Calculate the total cost of each system, assuming all items listed for that system are purchased, and then format the totals with Accounting Number Format. Enter a label for the row of total, right align the label, and use bold italic formatting.

Verify that the totals are accurate even if other values are later substituted for any of the system component costs.

Highlight the cell containing the name of the least expensive computer system in yellow.

You learn from your boss that the corporation is planning to purchase at least 40 similar systems. Because of this volume, the following price reductions are now available:

1. Dell has agreed to a rebate of $150 per machine.
2. Sony has agreed to give an 18% across-the-board discount on everything but shipping, which remains at $46 per system.
3. Lenovo has declined to give any volume purchase discount.

3.

4.

5. 6.

Skip at least two rows at the bottom of your current data. In a separate area, calculate the total cost of a single machine from each competitor sing this new pricing structure. Reference the values you have previously calculated as needed.

1. Just below the calculation for Step 6, calculate the cost of purchasing the 40 machines with this new pricing structure for each option.
2. Highlight the cell containing the lowest final cost for 40 machines in a shade of light green.
3. Submit your solution to Blackboard using the file name Computer_Purchase_nn.xlsx.

1Capstone Project 1You are currently employed at a medium-sized financial management firm, Durban & Associates, as afinancial analyst.Your boss recently authorized the purchase of a new laptop computer for your use athome and in the office.She asked you to obtain three competitive bids before she approves thepurchase.The minimum requirements of the systems you want to buy are as follows:Processor – w/Intel Core i7 with at least a 15” screenLong Life BatteryMinimum 8GB of RamDVD recordable deviceMinimum 500 GB Hard DriveVideo cardWindows 8.1 ProfessionalFull 3-year warrantyCamera Built inCarrying caseBluetooth ConnectionsShippingTable 1 shows information for three possible computers based on Web site pricing.The features do notmatch up exactly, so you need to create a worksheet comparing all three systems and their total prices.(Note that the models, features and pricing are fictitious and do not constitute advice on any computerpurchase)Dell LaptopSony LaptopLenovo LaptopDell Alienware ZBY; 2.2 GHzIntel Core i7-2670QM Quad-Core including 8-GB of DDR3RAM, 500 GB hard drive; DVD-R/W, 18” display, long-lifeBattery, video camera and videocard, Windows 8.1 Professional,Wi-Fi/ Bluetooth/ Broadbandcapable, 3-year warranty,Shipping included…$1749Sony VAIO RMV w/3rdGen IntelCore i7-3612QM (2.10GHz)including 8-GB of RAM, 300 GBhard drive, 15.5” display, videocard, DVD-r/W drive, built-invideo camera, Windows 8 HomeBasic, Wi-fi/ Broadband/Bluetooth capable, carry case,standard 1-yearwarranty…$1449Lenovo ThinkPad D Intel CoreIntel i7-3520M Processor (2.2GHz), 4 GB of RAM, 250 GB harddrive, 15.4” display, Windows8.1 Professional and video card,Wi-fi and broadband capable, 1-year warranty, freeshipping…$1104Additional items:Additional items:Upgrade to 8 GB of RAM $130Carrying case $79.95Hard drive upgrade to 600 GB$59.99Upgrade to 500 GB hard drive7200 rpm $60Upgrade to Windows 8.1Professional $69Built-in video camera $29Long-life battery upgrade $149Bluetooth $303-year warranty $249.99DVD-R/W drive $115Shipping cost $46Long-life battery $703-year warranty $195.30Carrying case $65

• 1494561965-Capstone Project 1.pdf

ComputerScienceExpert

(11)

Status NEW Posted 12 May 2017 03:05 AM My Price 11.00

-----------

Attachments

file 1494561971-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer