0% found this document useful (0 votes)
30 views12 pages

Excel 1 - 1 - Worked

Uploaded by

hc90316
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
0% found this document useful (0 votes)
30 views12 pages

Excel 1 - 1 - Worked

Uploaded by

hc90316
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
You are on page 1/ 12

Manufac

Discount Units turing Sale


Segment Country Product Band Sold Price Price
Small
Business Mexico Paseo None 788 ₹ 10.00 ₹ 300.00
United
States of
Enterprise America Carretera Low 330 ₹ 3.00 ₹ 125.00
United
Small States of
Business America Montana Low 2498 ₹ 5.00 ₹ 300.00
Small
Business Germany Paseo Medium 1123 ₹ 10.00 ₹ 300.00

Enterprise Germany Amarilla Medium 994 ₹ 260.00 ₹ 125.00


Small
Business Canada Montana Medium 1283 ₹ 5.00 ₹ 300.00
Small
Business France Montana Medium 322 ₹ 5.00 ₹ 300.00

Enterprise Mexico Amarilla High 947 ₹ 260.00 ₹ 125.00

Enterprise Canada Carretera High 2416 ₹ 3.00 ₹ 125.00

Enterprise France Carretera High 1023 ₹ 3.00 ₹ 125.00

Enterprise Canada Montana None 345 ₹ 5.00 ₹ 125.00

Enterprise Canada Velo None 345 ₹ 120.00 ₹ 125.00


Small
Business Mexico Carretera Low 494 ₹ 3.00 ₹ 300.00
United
States of
Enterprise America Montana Low 663 ₹ 5.00 ₹ 125.00
United
States of
Enterprise America Velo Low 663 ₹ 120.00 ₹ 125.00
Small
Business Mexico VTT Low 494 ₹ 250.00 ₹ 300.00
Small
Business Germany Carretera Low 214 ₹ 3.00 ₹ 300.00

Enterprise Germany Paseo Low 809 ₹ 10.00 ₹ 125.00

Enterprise Mexico Paseo Low 2145 ₹ 10.00 ₹ 125.00


Enterprise Germany Velo Low 809 ₹ 120.00 ₹ 125.00

Enterprise Mexico Velo Low 2145 ₹ 120.00 ₹ 125.00

BY HARIPRIYAN. G. K (312312752)
Gross Sales Discounts Sales COGS Profit

₹ 236,400.00 ₹ - ₹ 236,400.00 ₹ 197,000.00 ₹ 39,400.00

₹ 41,250.00 ₹ 412.50 ₹ 40,837.50 ₹ 39,600.00 ₹ 1,237.50

₹ 749,400.00 ₹ 7,494.00 ₹ 741,906.00 ₹ 624,500.00 ₹ 117,406.00

₹ 336,900.00 ₹ 23,583.00 ₹ 313,317.00 ₹ 280,750.00 ₹ 32,567.00

₹ 124,250.00 ₹ 8,697.50 ₹ 115,552.50 ₹ 119,280.00 ₹ -3,727.50

₹ 384,900.00 ₹ 30,792.00 ₹ 354,108.00 ₹ 320,750.00 ₹ 33,358.00

₹ 96,600.00 ₹ 8,694.00 ₹ 87,906.00 ₹ 80,500.00 ₹ 7,406.00

₹ 118,375.00 ₹ 13,021.25 ₹ 105,353.75 ₹ 113,640.00 ₹ -8,286.25

₹ 302,000.00 ₹ 36,240.00 ₹ 265,760.00 ₹ 289,920.00 ₹ -24,160.00

₹ 127,875.00 ₹ 17,902.50 ₹ 109,972.50 ₹ 122,760.00 ₹ -12,787.50

₹ 43,125.00 ₹ - ₹ 43,125.00 ₹ 41,400.00 ₹ 1,725.00

₹ 43,125.00 ₹ - ₹ 43,125.00 ₹ 41,400.00 ₹ 1,725.00

₹ 148,200.00 ₹ 1,482.00 ₹ 146,718.00 ₹ 123,500.00 ₹ 23,218.00

₹ 82,875.00 ₹ 828.75 ₹ 82,046.25 ₹ 79,560.00 ₹ 2,486.25

₹ 82,875.00 ₹ 828.75 ₹ 82,046.25 ₹ 79,560.00 ₹ 2,486.25

₹ 148,200.00 ₹ 1,482.00 ₹ 146,718.00 ₹ 123,500.00 ₹ 23,218.00

₹ 64,200.00 ₹ 1,284.00 ₹ 62,916.00 ₹ 53,500.00 ₹ 9,416.00

₹ 101,125.00 ₹ 2,022.50 ₹ 99,102.50 ₹ 97,080.00 ₹ 2,022.50

₹ 268,125.00 ₹ 5,362.50 ₹ 262,762.50 ₹ 257,400.00 ₹ 5,362.50


₹ 101,125.00 ₹ 2,022.50 ₹ 99,102.50 ₹ 97,080.00 ₹ 2,022.50

₹ 268,125.00 ₹ 5,362.50 ₹ 262,762.50 ₹ 257,400.00 ₹ 5,362.50


Product Country Segment Discount Band
Amarilla
Germany
Enterprise
Medium
Mexico
Enterprise
High
Carretera
Canada
Enterprise
High
France
Enterprise
High
Germany
Small Business
Low
Mexico
Small Business
Low
United States of America
Enterprise
Low
Montana
Canada
Enterprise
None
Small Business
Medium
France
Small Business
Medium
United States of America
Enterprise
Low
Small Business
Low
Paseo
Germany
Enterprise
Low
Small Business
Medium
Mexico
Enterprise
Low
Small Business
None
Velo
Canada
Enterprise
None
Germany
Enterprise
Low
Mexico
Enterprise
Low
United States of America
Enterprise
Low
VTT
Mexico
Small Business
Low
Total Result
Data
Sum of Profit Sum of Sales Sum of Gross Sales Sum of Sale Price
₹ -12,013.75 ₹ 220,906.25 ₹ 242,625.00 ₹ 250.00
₹ -3,727.50 ₹ 115,552.50 ₹ 124,250.00 ₹ 125.00
₹ -3,727.50 ₹ 115,552.50 ₹ 124,250.00 ₹ 125.00
₹ -3,727.50 ₹ 115,552.50 ₹ 124,250.00 ₹ 125.00
₹ -8,286.25 ₹ 105,353.75 ₹ 118,375.00 ₹ 125.00
₹ -8,286.25 ₹ 105,353.75 ₹ 118,375.00 ₹ 125.00
₹ -8,286.25 ₹ 105,353.75 ₹ 118,375.00 ₹ 125.00
₹ -3,076.00 ₹ 626,204.00 ₹ 683,525.00 ₹ 975.00
₹ -24,160.00 ₹ 265,760.00 ₹ 302,000.00 ₹ 125.00
₹ -24,160.00 ₹ 265,760.00 ₹ 302,000.00 ₹ 125.00
₹ -24,160.00 ₹ 265,760.00 ₹ 302,000.00 ₹ 125.00
₹ -12,787.50 ₹ 109,972.50 ₹ 127,875.00 ₹ 125.00
₹ -12,787.50 ₹ 109,972.50 ₹ 127,875.00 ₹ 125.00
₹ -12,787.50 ₹ 109,972.50 ₹ 127,875.00 ₹ 125.00
₹ 9,416.00 ₹ 62,916.00 ₹ 64,200.00 ₹ 300.00
₹ 9,416.00 ₹ 62,916.00 ₹ 64,200.00 ₹ 300.00
₹ 9,416.00 ₹ 62,916.00 ₹ 64,200.00 ₹ 300.00
₹ 23,218.00 ₹ 146,718.00 ₹ 148,200.00 ₹ 300.00
₹ 23,218.00 ₹ 146,718.00 ₹ 148,200.00 ₹ 300.00
₹ 23,218.00 ₹ 146,718.00 ₹ 148,200.00 ₹ 300.00
₹ 1,237.50 ₹ 40,837.50 ₹ 41,250.00 ₹ 125.00
₹ 1,237.50 ₹ 40,837.50 ₹ 41,250.00 ₹ 125.00
₹ 1,237.50 ₹ 40,837.50 ₹ 41,250.00 ₹ 125.00
₹ 162,381.25 ₹ 1,309,091.25 ₹ 1,356,900.00 ₹ 1,150.00
₹ 35,083.00 ₹ 397,233.00 ₹ 428,025.00 ₹ 425.00
₹ 1,725.00 ₹ 43,125.00 ₹ 43,125.00 ₹ 125.00
₹ 1,725.00 ₹ 43,125.00 ₹ 43,125.00 ₹ 125.00
₹ 33,358.00 ₹ 354,108.00 ₹ 384,900.00 ₹ 300.00
₹ 33,358.00 ₹ 354,108.00 ₹ 384,900.00 ₹ 300.00
₹ 7,406.00 ₹ 87,906.00 ₹ 96,600.00 ₹ 300.00
₹ 7,406.00 ₹ 87,906.00 ₹ 96,600.00 ₹ 300.00
₹ 7,406.00 ₹ 87,906.00 ₹ 96,600.00 ₹ 300.00
₹ 119,892.25 ₹ 823,952.25 ₹ 832,275.00 ₹ 425.00
₹ 2,486.25 ₹ 82,046.25 ₹ 82,875.00 ₹ 125.00
₹ 2,486.25 ₹ 82,046.25 ₹ 82,875.00 ₹ 125.00
₹ 117,406.00 ₹ 741,906.00 ₹ 749,400.00 ₹ 300.00
₹ 117,406.00 ₹ 741,906.00 ₹ 749,400.00 ₹ 300.00
₹ 79,352.00 ₹ 911,582.00 ₹ 942,550.00 ₹ 850.00
₹ 34,589.50 ₹ 412,419.50 ₹ 438,025.00 ₹ 425.00
₹ 2,022.50 ₹ 99,102.50 ₹ 101,125.00 ₹ 125.00
₹ 2,022.50 ₹ 99,102.50 ₹ 101,125.00 ₹ 125.00
₹ 32,567.00 ₹ 313,317.00 ₹ 336,900.00 ₹ 300.00
₹ 32,567.00 ₹ 313,317.00 ₹ 336,900.00 ₹ 300.00
₹ 44,762.50 ₹ 499,162.50 ₹ 504,525.00 ₹ 425.00
₹ 5,362.50 ₹ 262,762.50 ₹ 268,125.00 ₹ 125.00
₹ 5,362.50 ₹ 262,762.50 ₹ 268,125.00 ₹ 125.00
₹ 39,400.00 ₹ 236,400.00 ₹ 236,400.00 ₹ 300.00
₹ 39,400.00 ₹ 236,400.00 ₹ 236,400.00 ₹ 300.00
₹ 11,596.25 ₹ 487,036.25 ₹ 495,250.00 ₹ 500.00
₹ 1,725.00 ₹ 43,125.00 ₹ 43,125.00 ₹ 125.00
₹ 1,725.00 ₹ 43,125.00 ₹ 43,125.00 ₹ 125.00
₹ 1,725.00 ₹ 43,125.00 ₹ 43,125.00 ₹ 125.00
₹ 2,022.50 ₹ 99,102.50 ₹ 101,125.00 ₹ 125.00
₹ 2,022.50 ₹ 99,102.50 ₹ 101,125.00 ₹ 125.00
₹ 2,022.50 ₹ 99,102.50 ₹ 101,125.00 ₹ 125.00
₹ 5,362.50 ₹ 262,762.50 ₹ 268,125.00 ₹ 125.00
₹ 5,362.50 ₹ 262,762.50 ₹ 268,125.00 ₹ 125.00
₹ 5,362.50 ₹ 262,762.50 ₹ 268,125.00 ₹ 125.00
₹ 2,486.25 ₹ 82,046.25 ₹ 82,875.00 ₹ 125.00
₹ 2,486.25 ₹ 82,046.25 ₹ 82,875.00 ₹ 125.00
₹ 2,486.25 ₹ 82,046.25 ₹ 82,875.00 ₹ 125.00
₹ 23,218.00 ₹ 146,718.00 ₹ 148,200.00 ₹ 300.00
₹ 23,218.00 ₹ 146,718.00 ₹ 148,200.00 ₹ 300.00
₹ 23,218.00 ₹ 146,718.00 ₹ 148,200.00 ₹ 300.00
₹ 23,218.00 ₹ 146,718.00 ₹ 148,200.00 ₹ 300.00
₹ 261,457.75 ₹ 3,701,537.75 ₹ 3,869,050.00 ₹ 4,025.00
Sum of UnitSum of Man Sum of Discounts
1941 ₹ 520.00 ###
1600000
994 ₹ 260.00 ###
994 ₹ 260.00 ###
994 ₹ 260.00 ###
947 ₹ 260.00
1400000 ###
947 ₹ 260.00 ###
947 ₹ 260.00 ###
4477 ₹ 15.00
1200000 ###
2416 ₹ 3.00 ###
2416 ₹ 3.00 ###
2416 ₹ 1000000
3.00 ###
1023 ₹ 3.00 ###
1023 ₹ 3.00 ###
1023 ₹ 3.00
800000
###
214 ₹ 3.00 ###
214 ₹ 3.00 ###
214 ₹ 3.00 ###
600000
494 ₹ 3.00 ###
494 ₹ 3.00 ###
494 ₹ 3.00 ###
400000
330 ₹ 3.00 ₹ 412.50
330 ₹ 3.00 ₹ 412.50
330 ₹ 3.00 ₹ 412.50
200000
5111 ₹ 25.00 ###
1628 ₹ 10.00 ###
345 ₹ 5.00 ₹ -
345 ₹ 5.00 0₹ -
c t ra a
1283 ₹ 5.00 du ### te t an
o e P
1283 ₹ 5.00Pr ### rr on
Ca M
322 ₹ -200000
5.00 ###
322 ₹ 5.00 ###
322 ₹ 5.00 ###
3161 ₹ 10.00 ###
663 ₹ 5.00 ₹ 828.75
663 ₹ 5.00 ₹ 828.75
2498 ₹ 5.00 ###
2498 ₹ 5.00 ###
4865 ₹ 40.00 ###
1932 ₹ 20.00 ###
809 ₹ 10.00 ###
809 ₹ 10.00 ###
1123 ₹ 10.00 ###
1123 ₹ 10.00 ###
2933 ₹ 20.00 ###
2145 ₹ 10.00 ###
2145 ₹ 10.00 ###
788 ₹ 10.00 ₹ -
788 ₹ 10.00 ₹ -
3962 ₹ 480.00 ###
345 ₹ 120.00 ₹ -
345 ₹ 120.00 ₹ -
345 ₹ 120.00 ₹ -
809 ₹ 120.00 ###
809 ₹ 120.00 ###
809 ₹ 120.00 ###
2145 ₹ 120.00 ###
2145 ₹ 120.00 ###
2145 ₹ 120.00 ###
663 ₹ 120.00 ₹ 828.75
663 ₹ 120.00 ₹ 828.75
663 ₹ 120.00 ₹ 828.75
494 ₹ 250.00 ###
494 ₹ 250.00 ###
494 ₹ 250.00 ###
494 ₹ 250.00 ###
20850 ### ###
Column B
Column C
Column D
Data
Column F
Column G
Column H

o T
ase VT
P
Column B
Column C
Column D
Data
Column F
Column G
Column H

You might also like