Exam (elaborations)
Excel file for Practical Accounting Data Processing (AIN2601)
- Course
- Institution
The document is only the excel sheet used for the exam with all the information in. Buy the package deal to get questions and answers.
[Show more]
Seller
Follow
pietvdw0002
Content preview
Music Made Ministry (Pty) LtdFebruary - 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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller pietvdw0002. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $2.96. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
72349 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now