Click on the link to obtain the data required for this question. Assume that you are performing a cost analysis for building a network for a small company. The unit costs for the equipments are shown in cells B4:B8. Each person on the network must have a computer. That is, if there are 3 people in the company, 3 computers will be purchased as shown in cell B15. The company has been given a discount of 10% on the computer unit cost if the number purchased is more than 5. (Provide your answers to 0 decimal place.) 1. In cell D17, provide the formula to calculate total cost which is the summation of D13:D16. What is the total cost if the number of people is 3? 7470 2. If the company has a budget of $12,000, how many people can be supported on the network? (You will need to use the Goal Seek Tool to get the answer.) 3. Use a data table to create different what-if scenarios to examine how the number of people will affect total computer cost and total cost. The set-up for the table is shown G4:110. What formula would you put on cell H4 and cell 14? (Be sure to include = in the formula, for example, if you think it should be B4, you would use =B4) 4. What is the total computer cost if the company has 11 people? 12 A Screenshot 2024-... B C D E F G H | J K L Cost Analysis for Building a Network for a Small Business Total 34565 80 3 Assumptions: Number of people No. People Discount on Computer Number of Computer People Cost Total Cost 5 5 0% 10% 6 Unit Printer Cost $500 7 Unit Server Cost $1,970 Unit NOS Cost $1,000 9 11 35721 9 10 13 11 Cost for building a network 12 Item 13 Server Cost 14 Network OS 15 Computers 16 Printer 17 Total Cost 18 19 Qty Unit Cost Item Cost 1 $1,970 $1,970 1 $1,000 $1,000 5 $800 $4,000 1 $500 $500 $7,470 20 Cost for not building a network 21 Item 22 Computers 23 Printers 24 Total Cost 25 26 Qty Unit Cost Item Cost 5 800 4000 5 500 2500 6500 C https://