Question: Please Help with the excel steps, will upvote SmartTally is a start-up organization located in Seattle, Washington. The company currently has seven employees and is
Please Help with the excel steps, will upvote
SmartTally is a start-up organization located in Seattle, Washington. The company currently has seven employees and is looking to hire sixty new employees in the next month. You are in-charge of purchasing equipment for Smart Tally's new recruits. Your first task is to purchase computers for the new employees. Your budget is $250,000 to buy the best computer systems along with other equipment as listed in table below. Use the web to search and compare prices of various products and calculate the cost of purchasing different systems using Excel. Feel free to choose any brand of products for the accessories/ peripheral equipment, and not necessarily the ones mentioned below, to stay within the budget. PC Price Comparison Computer/components Quantity Dell HP Lenovo Unit Price Total Price Unit Price Total Price Unit Price Total Price 60 Business desktop with Windows 10 - 10GB memory, 1TB hard drive, with 3 year support plan. Suitable dual screen monitors Laser color printers (you can choose any brand/model) 60 5 Total Total Total Accessories Quantity Unit Price Total Price Document Scanners (you can choose any brand/model) 5 30 Wacom Cintiq 16 tablets Snowball Black Ice microphones 60 60 Logitech C922 Pro Stream webcams Total On a separate row below both tables, choose the personal computer brand from the first 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 SmartTally


Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
