Scribd
Upload
8 views1 page

CPT Xls Practice Set

The document presents sales data for four products (Laptop, Mouse, Keyboard, Monitor) over three months, detailing total sales, average sales, profit, and target status. It includes calculations for total and average sales, profit percentages, and bonus eligibility based on target achievement. Additionally, it suggests the inclusion of various charts to visualize sales trends and profit contributions by product.

Uploaded by

subhamchattaraj2
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
8 views1 page

CPT Xls Practice Set

The document presents sales data for four products (Laptop, Mouse, Keyboard, Monitor) over three months, detailing total sales, average sales, profit, and target status. It includes calculations for total and average sales, profit percentages, and bonus eligibility based on target achievement. Additionally, it suggests the inclusion of various charts to visualize sales trends and profit contributions by product.

Uploaded by

subhamchattaraj2
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

** Page A4, Mirgins 0 sll side.

Product Total Average Profit


January February March Target Status Bonus orientatation - Landscape.
Name Sale Sell
** Caculate Total.
Laptop ₹ 5,000 ₹ 6,000 ₹ 5,800 ₹ 18,000 ₹ 16,800 ₹ 5,600 ₹ 2,520 Under Review ₹ - ** Calculate Average sell.
Mouse ₹ 1,200 ₹ 1,500 ₹ 1,300 ₹ 4,000 ₹ 4,000 ₹ 1,333 ₹ 600 Achieved ₹ 12 ** Profit = 15% of Total sell
Keyboard ₹ 2,000 ₹ 1,800 ₹ 2,200 ₹ 5,500 ₹ 6,000 ₹ 2,000 ₹ 900 Achieved ₹ 45 ** Status, if Target is less than
Monitor ₹ 8,000 ₹ 7,000 ₹ 8,500 ₹ 23,000 ₹ 23,500 ₹ 7,833 ₹ 3,525 Achieved ₹ 176 Total Sale,"Under Review" ,if
*N.B : Insert Extra Colum in that Table is not permitted Greater then or equal ,
"Achieved".
** Bonus, if Target overcome then
5% , if not Achieved Target then 0/-
, other 2% of Profit.
** Insert 2D PIE CHART
** Insert CLUSTERED COLUMN CHART(Target & **Insert a LINE GRAPH
For Contribution of Profit with Product
Total Sell) For Trend of sell of Product in Diff. Months

Comparison of Target & Sell Contributin of Profit Trend of sell in different Months
₹ 25,000 ₹ 10,000
Laptop Mouse Keyboard Monitor
₹ 20,000
₹ 8,000
₹ 15,000
In Rupees

₹ 6,000
₹ 10,000 Target
₹ 5,000 ₹ 4,000
33%
Total 47%
₹- ₹ 2,000
Sale
₹-
8% January February March
12%
Product Name Laptop Mouse Keyboard Monitor

You might also like