1. Explain the term payroll ?Why is it important in accounting ?
2. Given the following information from Kakira sugar works for the month of July 2018;

EMPLOYEE NUMBER	NAME	HOURS WORKED/month
,0001	Okello James	240
,0002	Abdisamad Hassan	210
,0003	Niyomwungeri Diane	200
,0004	Daphine Kate	240
,0005	Aharimpisya Anitah	236
,0006	Nyakato  Doreen	233
,0007	Nyamal Frank	228
,0008	Martha Robert	198
,0009	Ruboneza James	180
,0010	Ainembabazi Liz	214

 

Additional information;

1. Rate per hour is shs.15,000=
2. All workers qualify for lunch fee of shs.2,500=
3. NSSF and PAYE are Compulsory Using statutory rates.
4. All workers contribute shs.600= to workers Union
5. All workers are entitled medical treatment using organizational medical card.

Required;

 

1. Prepare Kakira sugar works payroll for the months of july.2018, using if function?                                                                                         
2. Advise the company if the budgeted wage bill is shs, 200,000,000=per month?