0% found this document useful (0 votes)
27 views2 pages

Excel Phase 2 Assignment 2

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)
27 views2 pages

Excel Phase 2 Assignment 2

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

Segment Country Product Discount Band Units Sold Manufacturin r Sale Price Gross Sales

Small Business Mexico Paseo None 788 g P ₹ 10.00 ₹ 300.00 ₹ 236,400.00


Enterprise
United States of Carretera Low 330 ₹ 3.00 ₹ 125.00 ₹ 41,250.00
Small Business
Small Business Canada Montana Low 2498 ₹ 5.00 ₹ 300.00 ₹ 749,400.00
Enterprise Canada Paseo Medium 1123 ₹ 10.00 ₹ 300.00 ₹ 336,900.00
Small Business
Canada Amarilla Medium 994 ₹ 260.00 ₹ 125.00 ₹ 124,250.00
Small Business
Enterprise Canada Montana Medium 1283 ₹ 5.00 ₹ 300.00 ₹ 384,900.00
Enterprise Canada Montana Medium 322 ₹ 5.00 ₹ 300.00 ₹ 96,600.00
Enterprise Canada Amarilla High 947 ₹ 260.00 ₹ 125.00 ₹ 118,375.00
Enterprise
Enterprise Canada Carretera High 2416 ₹ 3.00 ₹ 125.00 ₹ 302,000.00
Small Business France Carretera High 1023 ₹ 3.00 ₹ 125.00 ₹ 127,875.00
Enterprise Canada Montana None 345 ₹ 5.00 ₹ 125.00 ₹ 43,125.00
Enterprise
Small Business Canada Velo None 345 ₹ 120.00 ₹ 125.00 ₹ 43,125.00
Small Business Mexico Carretera Low 494 ₹ 3.00 ₹ 300.00 ₹ 148,200.00
Enterprise United States of Montana Low 663 ₹ 5.00 ₹ 125.00 ₹ 82,875.00
Enterprise
Enterprise United States of Velo Low 663 ₹ 120.00 ₹ 125.00 ₹ 82,875.00
Enterprise Mexico VTT Low 494 ₹ 250.00 ₹ 300.00 ₹ 148,200.00
Germany Carretera Low 214 ₹ 3.00 ₹ 300.00 ₹ 64,200.00
Germany Paseo Low 809 ₹ 10.00 ₹ 125.00 ₹ 101,125.00
Mexico Paseo Low 2145 ₹ 10.00 ₹ 125.00 ₹ 268,125.00
Germany Velo Low 809 ₹ 120.00 ₹ 125.00 ₹ 101,125.00
Mexico Velo Low 2145 ₹ 120.00 ₹ 125.00 ₹ 268,125.00
Discounts Sales COGS Profit
₹- ₹ 236,400.00 ₹ 197,000.00 ₹ 39,400.00
₹ 412.50 ₹ 40,837.50 ₹ 40,425.00 ₹ 39,600.00 ₹ 1,237.50
₹ 7,494.00 ₹ 741,906.00 ₹ 624,500.00 ₹ 117,406.00
₹ 23,583.00 ₹ 313,317.00 ₹ 280,750.00 ₹ 32,567.00
₹ 8,697.50 ₹ 115,552.50 ₹ 119,280.00 ₹ -3,727.50
₹ 30,792.00 ₹ 354,108.00 ₹ 320,750.00 ₹ 33,358.00
₹ 8,694.00 ₹ 87,906.00 ₹ 80,500.00 ₹ 7,406.00
₹ 13,021.25 ₹ 105,353.75 ₹ 113,640.00 ₹ -8,286.25
₹ 36,240.00 ₹ 265,760.00 ₹ 289,920.00 ₹ -24,160.00
₹ 17,902.50 ₹ 109,972.50 ₹ 122,760.00 ₹ -12,787.50
₹- ₹ 43,125.00 ₹ 41,400.00 ₹ 1,725.00
₹- ₹ 43,125.00 ₹ 41,400.00 ₹ 1,725.00
₹ 1,482.00 ₹ 146,718.00 ₹ 123,500.00 ₹ 23,218.00
₹ 828.75 ₹ 82,046.25 ₹ 79,560.00 ₹ 2,486.25
₹ 828.75 ₹ 82,046.25 ₹ 79,560.00 ₹ 2,486.25
₹ 1,482.00 ₹ 146,718.00 ₹ 123,500.00 ₹ 23,218.00
₹ 1,284.00 ₹ 62,916.00 ₹ 53,500.00 ₹ 9,416.00
₹ 2,022.50 ₹ 99,102.50 ₹ 97,080.00 ₹ 2,022.50
₹ 5,362.50 ₹ 262,762.50 ₹ 257,400.00 ₹ 5,362.50
₹ 2,022.50 ₹ 99,102.50 ₹ 97,080.00 ₹ 2,022.50
₹ 5,362.50 ₹ 262,762.50 ₹ 257,400.00 ₹ 5,362.50

You might also like