GIVEN THE FOLLOWING DATA, ANSWER THE FOLLOWING QUESTIONS You are the manager of a newly opened network shop. It is essential that at the end of everyday you know the status of your business along with statistical data in order to improve and be able to compete with other shops. This is an Excel spreadsheet that represents some of the data you have in one day. D G H E NETWORK XYZ Total Hours Type of A B 1 2 Type of Hour 3 Work Rate Taxes 4 Internet LL 3000 5 Games LL 1000 20% 6 Time Time 7 Name Start End 8 Rami 6 9 9 Raymond 4 s 10 Elie 9 12 11 Jimmy 8 10 12 Charbel 7 12 13 Tony 7 11 14 15 Total Internet Hours 16 Total Games Hours 17 18 No of customers playing Games 19 20 21 22 Work Internet Games Internet Games Internet Internet 1 3 Amount Due 9000 1000 9000 2000 15000 12000 Discount 900 0 900 0 6000 4800 Total Bill 8730 1200 8730 Taxes 630 200 630 400 1050 840 5 + 10050 8040 15 3 2 Grand Total Gain 39150 Grand Total Cost 23250 Net Gain 15900 Network Status Gaining 1. In cell Ds, what is the formula to calculate the Total Hours worked by Rami? DB: 2. In cell F8, what is the function to calculate the Amount Due, without tages and discount? FS: 3. Insert in cell GS the function that calculates the discount for Rami according to the following Number of Hours 2 No discount 2 Number of Hours 3 Discount = 40% of the Amount Due GB: 4. In cell HS, what is the function to calculate the taxes for Rami? HS: 5. Insert in cell 18 the fomula to calculate the Total Bill after subtracting the discount and adding the taxes: IS: 6. Insert in cell D15 the function to calculate the Total Internet Hours worked: D15: 7. Insert in cell D16 the function to calculate the Total Games Hours worked: D16: 8. Insert in cell D18 the function to calculate the number of customers playing games: D18: 9. Insert in cell 119 the function to calculate the Grand total gain (It is the sum of the total bill for all the customers): 119: 10. Insert in cell 120 the function to calculate the Grand Total Cost (It is the Total Internet Hours worked multiplied by 1500 L L. added to the Total Games Hours worked multiplied by 250 L.L.): 120 11. Insert in cell 121 the function to calculate the Net Gain: 121: 12. Insert in cell 122 the function to calculate the Network status which is either Gaining or Loosing depending on the sign of the Net Gain, 122 13. Insert in cell F14, the function that will find the highest amount due: F14: 14. Insert in cell D14, the function that will find the lowest hours of games: D14: 15. Insert in cell G14, the function that will calculate the average discount: G14
