Excel file for Practical Accounting Data Processing (AIN2601)

Music Made Ministry (Pty) Ltd
February - Monthly Report



VAT 15%
Mark-up on Cost 18%


Payment Metrics Table
Interest p.a 12%
Period (years) 3


Model Range Table
Range
0
201

Instrument Name Category Initial Model # Code Grade
DRUMS Percussion
GUITAR Strings
PIANO Keys
TRUMPET Brass
VIOLIN Strings


Cost Price p/u Sell Price p/u Sell Price p/u Discount
Instrument Name Discount %
incl VAT incl VAT excl VAT Value p/u
DRUMS R20,000.00
GUITAR R8,700.00
PIANO R21,000.00
TRUMPET R3,500.00
VIOLIN R14,500.00
Total

Statistics
Lowest cost price p/u Incl VAT
Highest sell price p/u Incl VAT
Average sell price p/u excl VAT
Number of new Instruments
Payment Plan

, Instrument Model Table
Name Model #
DRUMS 204
GUITAR 103
PIANO 178
TRUMPET 196
VIOLIN 380


Model Range Table
Range Grade
200 A
400 B

State Discount %
New
Used
New
New
Used


Units Sold Profit on Sales

20
29
16
40
13

,Date Time Name Gender Area Cust Profession
3/12/2023 8:00 PM Albert Male Cape Town Retired
3/12/2023 10:01 AM Albert Male Cape Town Retired
3/12/2023 10:18 AM Wendy Female Cape Town Self-employed
3/12/2023 10:30 AM Nomalizo Female Cape Town Retired
3/12/2023 10:53 AM Nomalizo Female Cape Town Retired
3/12/2023 11:15 AM Wendy Female Cape Town Self-employed
3/12/2023 11:21 AM Albert Male Cape Town Retired
3/12/2023 11:43 AM Nomalizo Female Cape Town Retired
3/12/2023 11:54 AM Hlabi Female Cape Town Professional
3/12/2023 12:22 PM Fanah Female Cape Town Professional
3/12/2023 12:27 PM Tao Male Cape Town Retired
3/12/2023 12:44 PM Wendy Female Cape Town Self-employed
3/12/2023 12:50 PM Vaughn Male Cape Town Self-employed
3/12/2023 12:55 PM Hlabi Female Cape Town Professional
3/12/2023 1:18 PM Tao Male Cape Town Retired
3/12/2023 1:12 PM Hlabi Female Cape Town Professional
3/12/2023 1:17 PM Nomalizo Female Cape Town Retired
3/12/2023 1:22 PM Ganesh Male Cape Town Salaried
3/12/2023 1:45 PM Harry Male Cape Town Unemployed
3/12/2023 2:29 PM Wendy Female Cape Town Self-employed
3/12/2023 2:34 PM Harry Male Cape Town Unemployed
3/12/2023 2:40 PM Tao Male Cape Town Retired
3/12/2023 2:51 PM Tao Male Cape Town Retired
3/12/2023 3:14 PM Tao Male Cape Town Retired
3/12/2023 3:30 PM Wendy Female Cape Town Self-employed
3/12/2023 3:47 PM Tao Male Cape Town Retired
3/12/2023 4:15 PM Fanah Female Cape Town Professional
3/12/2023 4:53 PM Albert Male Cape Town Retired
3/12/2023 4:58 PM Harry Male Cape Town Unemployed
3/12/2023 5:31 PM Fanah Female Cape Town Professional
3/12/2023 5:37 PM Tao Male Cape Town Retired
3/12/2023 5:42 PM Vaughn Male Cape Town Self-employed
3/12/2023 5:48 PM Tao Male Cape Town Retired
3/12/2023 5:54 PM Vaughn Male Cape Town Self-employed
3/12/2023 6:11 PM Ganesh Male Cape Town Salaried
3/12/2023 6:16 PM Nomalizo Female Cape Town Retired
3/12/2023 6:22 PM Wendy Female Cape Town Self-employed
3/12/2023 6:27 PM Albert Male Cape Town Retired
3/12/2023 6:38 PM Vaughn Male Cape Town Self-employed
3/12/2023 7:18 PM Tao Male Cape Town Retired
3/12/2023 7:18 PM Fanah Female Cape Town Professional
3/12/2023 7:41 PM Fanah Female Cape Town Professional
3/12/2023 8:03 PM Harry Male Cape Town Unemployed
3/13/2023 8:16 PM Wendy Female Cape Town Self-employed
3/13/2023 8:15 PM Hlabi Female Cape Town Professional

, 3/13/2023 8:27 PM Fanah Female Cape Town Professional
3/13/2023 8:32 PM Hlabi Female Cape Town Professional
3/13/2023 10:00 AM Ganesh Male Cape Town Salaried
3/13/2023 10:17 AM Vaughn Male Cape Town Self-employed
3/13/2023 10:22 AM Albert Male Cape Town Retired
3/13/2023 10:39 AM Ganesh Male Cape Town Salaried
3/13/2023 10:45 AM Wendy Female Cape Town Self-employed
3/13/2023 11:18 AM Tao Male Cape Town Retired
3/13/2023 11:23 AM Hlabi Female Cape Town Professional
3/13/2023 11:29 AM Harry Male Cape Town Unemployed
3/13/2023 11:56 AM Harry Male Cape Town Unemployed
3/13/2023 12:18 PM Tao Male Cape Town Retired
3/13/2023 12:23 PM Albert Male Cape Town Retired
3/13/2023 12:29 PM Albert Male Cape Town Retired
3/13/2023 12:40 PM Albert Male Cape Town Retired
3/13/2023 1:13 PM Albert Male Cape Town Retired
3/13/2023 1:24 PM Hlabi Female Cape Town Professional
3/13/2023 1:35 PM Fanah Female Cape Town Professional
3/13/2023 1:41 PM Tao Male Cape Town Retired
3/13/2023 1:46 PM Nomalizo Female Cape Town Retired
3/13/2023 1:51 PM Albert Male Cape Town Retired
3/13/2023 2:03 PM Wendy Female Cape Town Self-employed
3/13/2023 2:19 PM Tao Male Cape Town Retired
3/13/2023 2:25 PM Ganesh Male Cape Town Salaried
3/13/2023 2:37 PM Tao Male Cape Town Retired
3/13/2023 2:42 PM Ganesh Male Cape Town Salaried
3/13/2023 2:48 PM Vaughn Male Cape Town Self-employed
3/13/2023 2:59 PM Albert Male Cape Town Retired
3/13/2023 3:16 PM Wendy Female Cape Town Self-employed
3/13/2023 3:10 PM Ganesh Male Cape Town Salaried
3/13/2023 3:33 PM Wendy Female Cape Town Self-employed
3/13/2023 3:50 PM Harry Male Cape Town Unemployed
3/13/2023 4:01 PM Ganesh Male Cape Town Salaried
3/13/2023 4:18 PM Ganesh Male Cape Town Salaried
3/13/2023 4:12 PM Ganesh Male Cape Town Salaried
3/13/2023 4:17 PM Harry Male Cape Town Unemployed
3/13/2023 4:22 PM Albert Male Cape Town Retired
3/13/2023 4:39 PM Harry Male Cape Town Unemployed
3/13/2023 4:44 PM Fanah Female Cape Town Professional
3/13/2023 5:18 PM Nomalizo Female Cape Town Retired
3/13/2023 5:18 PM Nomalizo Female Cape Town Retired
3/13/2023 5:29 PM Wendy Female Cape Town Self-employed
3/13/2023 5:40 PM Harry Male Cape Town Unemployed
3/13/2023 5:45 PM Tao Male Cape Town Retired
3/13/2023 5:51 PM Hlabi Female Cape Town Professional
3/13/2023 6:02 PM Vaughn Male Cape Town Self-employed
3/13/2023 6:18 PM Wendy Female Cape Town Self-employed