Scribd
Upload
5 views5 pages

XYZ Company Q1 Sales Summary Report

The document provides sales data for XYZ Company in the first quarter. It shows total sales of $1,554,211 with 5 sales transactions. The maximum sale was $1,395,850 while the minimum was $11,000.50. Commission is 5% and sales expenses were $77,710.55.

Uploaded by

Rajan Rai
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
5 views5 pages

XYZ Company Q1 Sales Summary Report

The document provides sales data for XYZ Company in the first quarter. It shows total sales of $1,554,211 with 5 sales transactions. The maximum sale was $1,395,850 while the minimum was $11,000.50. Commission is 5% and sales expenses were $77,710.55.

Uploaded by

Rajan Rai
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

DATE INVOICE NO SALES PERSON AMOUNT OF SALE

1-Jan 333300 RAJAN RAI 11000.5


13-Jan 333300 RAJAN KHANDELWAL 16859.5
14-Jan 21324AA RAJESH LATA 15500.5
15-Jan 3221500 PRAVEEN JAIN 1395850
19-Jan 63213AA PRAVEEN G 115000.5
1554211
REGION
SOUTH
NORTH
NORTH
SOUTH
NORTH
XYZ COMPANY
1ST QUARTER RESULTS
**************************************************************************************************************
TOTAL SLAES= IDR 1,554,211.00
AVERAGE SALES= IDR 310,842.20
NUMBER OF SALES= 5
MAX SALE IDR 1,395,850.00
MIN SALE IDR 11,000.50
COMMISION 5%
SALES EXPENSES= IDR 77,710.55

DATE INVOICE NO SALES PERSON AMOUNT OF SALE REGION


14-Jan 21324AA RAJESH LATA 15500.5 NORTH
19-Jan 63213AA PRAVEEN G 115000.5 NORTH
15-Jan 3221500 PRAVEEN JAIN 1395850 SOUTH
13-Jan 0 RAJAN KHANDELWAL 16859.5 NORTH
1-Jan 333300 RAJAN RAI 11000.5 SOUTH
1554211
Column1 Column2 Column3 sl no.
1 ADD 130501 1
3 SUBTRACT -99500 2
4 MULTIPLY 1782565250.25 3
2 DIVISION 0.134786370494041 4
5 all 0.8 5
product region 1 region2 region 3 status
doll 453 232 231 good
barbie 253 434 411 bad
600
teddy 141 541 233 good
lucy 132 323 334 good
500
region 1
600
400
500
do
do
300
400 bar
ba
region 1 ted
ted
300
200 region2 luc
200 region 3
100
100

00
region 1 lucy
doll barbieteddy region2 region 3
1

doll
doll
barbie
barbie
teddy
teddy
lucy

region 3

You might also like