12039033 sees 'I 2039033 x + Search Gcogle or type a URL Assignment Description: SmartTally is a start-up organization located in Seattle, Washington. The company currendy has seven employees and is looking to hire sixty new employees in the next month. You are in-charge of purchasing equipmentfor SmartTally's new recruits. Your rst task is to purchase computers for the new employees. Your buggy is 250,000 to buy the best computer systems along with other equipment as listed in the Excel 1 template. Use the web to search and compare prices of various products and calculate the cost of purchasing dilfereht systems using Excel. Feel free to choose any brand of products for the accessories! peripheral equipment, and not necessarily the ones mentioned, to stay within the budget. Instructions: 1. Open the Microsoft Excel 1 Template. 2. Use formulas in your worksheet for analyzing costs. . Choose the appropriate format for quantity. price and other columns. Hint: Common formats are General, Accounting. Currency etc. . Choose the personal computer brand from the rst table and add the total cost of accessories {using formulas in Excel) to arrive at the total estimated expense for purchasing equipment for the new employees at SmanTally. Make sure you stay in budget. X AutoSave Off Excel 1 Template File (2) Search (Alt+Q) Justrite Coppercolours JC X File Home Insert Page Layout Formulas Data Review View Help Comments Share Arial 12 ~ A A" ab Wrap Text General Insert AY O * Delete Paste B Merge & Center $ ~ % " Conditional Format as Cell Sort & Find & Formatting * Table Styles Format D Filter * Select Undo Clipboard Font Alignment Number Styles Cells Editing H5 : XV fx Lenovo A B C D E F G H I J K L M N O Student Name: PC Comparison Dell Inspiron HP Lenovo Computer/components Quantity Unit Total Unit 7 Price Price Price Total Price | Unit Price Total Price Business desktop with Windows 10 - 10GB memory, 1TB hard drive, with 3 year support 60 plan. LD 00 Suitable dual screen monitors 60 Laser color printers (you can choose any 5 10 brand/model) 11 Total Total Total 12 13 14 15 16 Accessories 17 |Quantity |Unit Price Total Price Excel 1 + Ready Accessibility: Investigate + 100%X AutoSave Off Excel 1 Template File (2) Search (Alt+Q) Justrite Coppercolours JC X File Home Insert Page Layout Formulas Data Review View Help Comments Share Arial 12 ~ A A" ab Wrap Text General Insert AY O * Delete Paste B Merge & Center $ ~ % " Conditional Format as Cell Sort & Find & Formatting * Table Styles Format D Filter * Select Undo Clipboard Font Alignment Number Styles Cells Editing H5 : X fx Lenovo A B C D E F G H 1 J K L M N O 16 Accessories 17 Quantity | Unit Price Total Price 18 Document Scanners (you can choose any brand/ 5 19 Wacom Cintiq 16 tablets 30 20 Snowball Black Ice microphones 60 21 Logitech C922 Pro Stream webcams 60 22 Total 23 24 25 Brand Comparison Totals 26 Dell 27 HP 28 Lenovo 79 Which computer and accessories are the best fit 30 for SmartTally? 31 32 33 34 35 Excel 1 + Ready Accessibility: Investigate + 100%