Sheet1
Actual
Sales Sales
Value- Value-
Purchase Selling Number (Purchase (Selling Profit on
Description Price Price Sold Price) Price) Sales
IT Text book 100.0 117.5 104 10400.00 12168.00 1768.00
Geography
Textbook 102.5 125.0 94 9588.00 11750.00 2162.00
Maths Text
Book 125.5 140.0 180 22500.00 25200.00 2700.00
English Text
Book 92.5 107.5 190 17480.00 20330.00 2850.00
Science Text
Book 140.0 165.0 130 18200.00 21450.00 3250.00
Total Sales 559 654 698 78168 90898 12730
Page 1
Sheet1
90000
80000
70000
60000
50000
Column D
40000
Column E
30000
20000
10000
0
IT Text book Geography Maths Text English Text Science Text Total Sales
Textbook Book Book Book
Page 2
Sheet1
Column D
Column E
Total Sales
Page 3
Sheet2
Quarterly Sales Analysis
Salesmen Q1 Q2 Q3 Q4
January 343.00 233.00 342.00 453.00 453
February 344.00 324.00 344.00 433.00 433
March 345.00 532.00 322.00 432.00 -87
April 346.00 493.00 93.00 329.00 675
May 347.00 493.00 493.00 949.00
2075.5 1594.5 2596.5 1474.5 0
1725 2075.5 1594.5 2596.5 1474.5
Page 4
Sheet2
Page 5
Sheet3
Performance Report
Maeks Analysis for Term End Exam
Name Term 1 Term 2 Percentage
Sani 90 83 86.50%
Parv 89 58 73.50%
Ranbir 39 42 40.50%
Aniket 43 95 69.00%
Aaira 94 93 93.50%
Yashvi 92 90 91.00%
Total 447 461
173
Page 6