Question Five : (15 marks)

The sales collection policy of Amman Factory for Electrical Applications is 60% of sales are collected by the end of the month of sales, 20% in the following month of sale, 15% in the month after that, and 5% of the monthly sales will not be collected (bad debt) the following information relates to the value of the factory sales during the first six months of 2017 as shown below

Required:

1. Create a new work sheet (EX4), and enter previous data in it.
2. Insert necessary equations and functions in related cells to calculate unknown numbers.

G H 1 2 3 4 5 6 7 8 9 B D E F Student Name Student ID EX7 Rate Collected in the Month of Sale 60% Collected in the Following Month of Sale 20% Collected in the Month After 15% Uncollected 5% Collected in the: Month Sales Value Month of Sale Following Month Month After 1 2000 ??? 2 5000 ??? ??? ??? 3 3000 ??? ??? ??? 4 4000 ??? ??? ??? 5 1000 ??? ??? ??? 6 6000 ??? ??? ??? 7 ??? ??? 8 Totals ??? ??? ??? ??? Total Collection Uncollected 10 11 12 13 14 ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? 15 16 17 18 19