Remerciez-le!

Remerciez @Admin pour avoir partagé cet document gratuitement, de la manière la plus simple, en partageant sur les réseaux sociaux.

Sba guide o T i i fI c x c I n fct n a tio n r'f if fJ Carnival has long been a traditional cultural festival in several Caribbean territories Every year thousands of costumed masqueraders parade through the streets dancing to the pulsating sgunds f steel

o T i i fI c x c I n fct n a tio n r'f if fJ Carnival has long been a traditional cultural festival in several Caribbean territories Every year thousands of costumed masqueraders parade through the streets dancing to the pulsating sgunds f steel band calypso and soca Most of these revellers register to parlicipate in the band of their choice months before the festivities begin Organizers of these bands must utilize management and organizationai skills in order to stage a successful event As a bandleader of one these carnival bands you are required to utilize suitable Word-processing spreadsheet database management as well as a programming application to design and implement computer-based solutions to the tasks involved in the management of your carnival band Spreadsheet The ?nancial records of the band are maintained using a spreadsheet application The names of masqueraders are listed by section Both men as well as women may register to play in each section There are ?ve sections in the band The cost of costumes is quoted in US dollars The cost by section is and respectively Masqueraders are given the option of paying for the costume in three installments or paying the full cost in ne payment Many people utilize the installment option Single full payment attracts a discount of A while payment by installments attracts an interest of lnstallments should be spread over three equal payments Each masquerader pays an'lnclusive'fee A lnclusive fee entiiles the masquerader to food drinks access to portable bathroom facilities and bottled water during the carnival parade through the streets However a payment of entitles the masquerader to portable bathroom facilities and bottled water only Expenditure is incurred in the provision of several amenities for masqueraders during the carnival The bandleader must supply food drinks portable bathroom facilities transpoftation music security pers nnei and artiste fees ln addition the costs of material for the manufacture of costumes as well as labour costs are incurred Because of the anticipated large number of masqueraders the bandleader has decided to manage the rncome and expenditure of each section separately You are required to Design a worksheet s which accepts income and expenditure costs for each section C ? c x c I n fo m c t i o t t r' l' f Your worksheet must record all payments made by masqueraders a few persons have only made ne or two of the required three installment payments on costumes the total amount paid by each person as well as the grand total collected must be calculated Costume payments must be made in US dollars The total payments made by each person however must be converled to the equivalent amount in local currency ln an appropriate row count the number of masqueraders in the section calculate the total payment on costume lnclusive fees and the total overall payment The expenditure incurred for each section must also be calculated Food is per person drink is per person material is and labour