Scribd
Upload
58 views10 pages

BCA File 4

Sorry Sir

Uploaded by

rl6895501
Copyright
© © All Rights Reserved
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
58 views10 pages

BCA File 4

Sorry Sir

Uploaded by

rl6895501
Copyright
© © All Rights Reserved
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

Product Category Department Purchase Price Sale Price

Dry Tissues Cleaning Supplies Household 60 72


Clear Refresher Soft Drinks Grocery 165 198
Dried Grits Salty Snacks Grocery 180 216
Paper Towels Cleaning Supplies Household 90 108
Athletic Drink Soft Drinks Grocery 75 90
Wet Wipes Cleaning Supplies Household 120 144
Chicken Dinner Frozen Foods Grocery 80 96
Extra Nougat Candy Grocery 145 174
Stew Frozen Foods Grocery 80 96
Jerky Salty Snacks Grocery 160 192
Dry Tissues Cleaning Supplies Household 60 72
Clear Refresher Soft Drinks Grocery 165 198
Dried Grits Salty Snacks Grocery 180 216
Paper Towels Cleaning Supplies Household 90 108
Athletic Drink Soft Drinks Grocery 75 90
Wet Wipes Cleaning Supplies Household 120 144
Chicken Dinner Frozen Foods Grocery 80 96
Extra Nougat Candy Grocery 145 174
Stew Frozen Foods Grocery 80 96
Jerky Salty Snacks Grocery 160 192
Dry Tissues Cleaning Supplies Household 60 72
Clear Refresher Soft Drinks Grocery 165 198
Dried Grits Salty Snacks Grocery 180 216
Paper Towels Cleaning Supplies Household 90 108
Athletic Drink Soft Drinks Grocery 75 90
Wet Wipes Cleaning Supplies Household 120 144
Chicken Dinner Frozen Foods Grocery 80 96
Extra Nougat Candy Grocery 145 174
Stew Frozen Foods Grocery 80 96
Jerky Salty Snacks Grocery 160 192
Dry Tissues Cleaning Supplies Household 60 72
Clear Refresher Soft Drinks Grocery 165 198
Dried Grits Salty Snacks Grocery 180 216
Paper Towels Cleaning Supplies Household 90 108
Athletic Drink Soft Drinks Grocery 75 90
Wet Wipes Cleaning Supplies Household 120 144
Chicken Dinner Frozen Foods Grocery 80 96
Extra Nougat Candy Grocery 145 174
Stew Frozen Foods Grocery 80 96
Jerky Salty Snacks Grocery 160 192
Dry Tissues Cleaning Supplies Household 60 72
Clear Refresher Soft Drinks Grocery 165 198
Dried Grits Salty Snacks Grocery 180 216
Paper Towels Cleaning Supplies Household 90 108
Athletic Drink Soft Drinks Grocery 75 90
Wet Wipes Cleaning Supplies Household 120 144
Chicken Dinner Frozen Foods Grocery 80 96
Extra Nougat Candy Grocery 145 174
Stew Frozen Foods Grocery 80 96
Jerky Salty Snacks Grocery 160 192
Dry Tissues Cleaning Supplies Household 60 72
Clear Refresher Soft Drinks Grocery 165 198
Dried Grits Salty Snacks Grocery 180 216
Paper Towels Cleaning Supplies Household 90 108
Athletic Drink Soft Drinks Grocery 75 90
Wet Wipes Cleaning Supplies Household 120 144
Chicken Dinner Frozen Foods Grocery 80 96
Extra Nougat Candy Grocery 145 174
Stew Frozen Foods Grocery 80 96
Jerky Salty Snacks Grocery 160 192
Dry Tissues Cleaning Supplies Household 60 72
Clear Refresher Soft Drinks Grocery 165 198
Dried Grits Salty Snacks Grocery 180 216
Paper Towels Cleaning Supplies Household 90 108
Athletic Drink Soft Drinks Grocery 75 90
Wet Wipes Cleaning Supplies Household 120 144
Chicken Dinner Frozen Foods Grocery 80 96
Extra Nougat Candy Grocery 145 174
Stew Frozen Foods Grocery 80 96
Jerky Salty Snacks Grocery 160 192
Dry Tissues Cleaning Supplies Household 60 72
Clear Refresher Soft Drinks Grocery 165 198
Dried Grits Salty Snacks Grocery 180 216
Paper Towels Cleaning Supplies Household 90 108
Athletic Drink Soft Drinks Grocery 75 90
Wet Wipes Cleaning Supplies Household 120 144
Chicken Dinner Frozen Foods Grocery 80 96
Extra Nougat Candy Grocery 145 174
Stew Frozen Foods Grocery 80 96
Jerky Salty Snacks Grocery 160 192
Dry Tissues Cleaning Supplies Household 60 72
Clear Refresher Soft Drinks Grocery 165 198
Dried Grits Salty Snacks Grocery 180 216
Paper Towels Cleaning Supplies Household 90 108
Athletic Drink Soft Drinks Grocery 75 90
Wet Wipes Cleaning Supplies Household 120 144
Chicken Dinner Frozen Foods Grocery 80 96
Extra Nougat Candy Grocery 145 174
Stew Frozen Foods Grocery 80 96
Jerky Salty Snacks Grocery 160 192
Dry Tissues Cleaning Supplies Household 60 72
Clear Refresher Soft Drinks Grocery 165 198
Dried Grits Salty Snacks Grocery 180 216
Paper Towels Cleaning Supplies Household 90 108
Athletic Drink Soft Drinks Grocery 75 90
Wet Wipes Cleaning Supplies Household 120 144
Chicken Dinner Frozen Foods Grocery 80 96
Extra Nougat Candy Grocery 145 174
Stew Frozen Foods Grocery 80 96
Jerky Salty Snacks Grocery 160 192
Shipping Cost Net Sale Price Sale Price Shipping Cost
100 172 0 100
20 218 80 80
20 236 120 60
80 188 150 40
80 170 195 20
60 204
80 176
40 214 Row Labels Sum of Net Sale Price
80 176 Candy 2140
40 232 Cleaning Supplies 1720
100 172 Soft Drinks 3880
20 218 Grand Total 7740
20 236
80 188
80 170 Categary Wise Net Price
60 204 14%
80 176
40 214
80 176
40 232 11%

100 172 50%


20 218
20 236 25%
80 188
80 170
60 204
80 176
40 214
80 176
40 232
100 172 Category
20 218 Salty Snacks
20 236 Frozen Foods
80 188
80 170 Product Category
60 204 Dried Grits Salty Snacks
80 176 Chicken Dinner Frozen Foods
40 214 Stew Frozen Foods
80 176 Jerky Salty Snacks
40 232 Dried Grits Salty Snacks
100 172 Chicken Dinner Frozen Foods
20 218 Stew Frozen Foods
20 236 Jerky Salty Snacks
80 188 Dried Grits Salty Snacks
80 170 Chicken Dinner Frozen Foods
60 204 Stew Frozen Foods
80 176 Jerky Salty Snacks
40 214 Dried Grits Salty Snacks
80 176 Chicken Dinner Frozen Foods
40 232 Stew Frozen Foods
100 172 Jerky Salty Snacks
20 218 Dried Grits Salty Snacks
20 236 Chicken Dinner Frozen Foods
80 188 Stew Frozen Foods
80 170 Jerky Salty Snacks
60 204 Dried Grits Salty Snacks
80 176 Chicken Dinner Frozen Foods
40 214 Stew Frozen Foods
80 176 Jerky Salty Snacks
40 232 Dried Grits Salty Snacks
100 172 Chicken Dinner Frozen Foods
20 218 Stew Frozen Foods
20 236 Jerky Salty Snacks
80 188 Dried Grits Salty Snacks
80 170 Chicken Dinner Frozen Foods
60 204 Stew Frozen Foods
80 176 Jerky Salty Snacks
40 214 Dried Grits Salty Snacks
80 176 Chicken Dinner Frozen Foods
40 232 Stew Frozen Foods
100 172 Jerky Salty Snacks
20 218 Dried Grits Salty Snacks
20 236 Chicken Dinner Frozen Foods
80 188 Stew Frozen Foods
80 170 Jerky Salty Snacks
60 204
80 176
40 214
80 176
40 232
100 172
20 218
20 236
80 188
80 170
60 204
80 176
40 214
80 176
40 232
100 172
20 218
20 236
80 188
80 170
60 204
80 176
40 214
80 176
40 232
Category Net Sale Price
Candy 2140

This shape represents a slicer.


Wise Net Price Slicers are supported in Excel
2010 or later.
14%
If the shape was modified in an
earlier version of Excel, or if
the workbook was saved in
Candy Excel 2003 or earlier, the slicer
11% Cleaning Supplies
cannot be used.
Soft Drinks
Grand Total

Department Purchase Price Sale Price Shipping Cost


Grocery 180 216 20
Grocery 80 96 80
Grocery 80 96 80
Grocery 160 192 40
Grocery 180 216 20
Grocery 80 96 80
Grocery 80 96 80
Grocery 160 192 40
Grocery 180 216 20
Grocery 80 96 80
Grocery 80 96 80
Grocery 160 192 40
Grocery 180 216 20
Grocery 80 96 80
Grocery 80 96 80
Grocery 160 192 40
Grocery 180 216 20
Grocery 80 96 80
Grocery 80 96 80
Grocery 160 192 40
Grocery 180 216 20
Grocery 80 96 80
Grocery 80 96 80
Grocery 160 192 40
Grocery 180 216 20
Grocery 80 96 80
Grocery 80 96 80
Grocery 160 192 40
Grocery 180 216 20
Grocery 80 96 80
Grocery 80 96 80
Grocery 160 192 40
Grocery 180 216 20
Grocery 80 96 80
Grocery 80 96 80
Grocery 160 192 40
Grocery 180 216 20
Grocery 80 96 80
Grocery 80 96 80
Grocery 160 192 40
Net Sale Price
236
176
176
232
236
176
176
232
236
176
176
232
236
176
176
232
236
176
176
232
236
176
176
232
236
176
176
232
236
176
176
232
236
176
176
232
236
176
176
232

You might also like