Scribd
Upload
22 views1 page

Excel Adv Assignment

Excel Assignment for beginners

Uploaded by

spartangamingkingyt
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
22 views1 page

Excel Adv Assignment

Excel Assignment for beginners

Uploaded by

spartangamingkingyt
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

Enterprise United States of America

Carretera None 788 ₹ 3.00 ₹ 125.00 ₹ 41,250.00 ₹ 412.50 ₹ 40,837.50 ₹ 40,425.00 ₹ 39,600.00 ₹ 1,237.50
Enterprise United States of America
Montana None 345 ₹ 5.00 ₹ 125.00 ₹ 82,875.00 ₹ 828.75 ₹ 82,046.25 ₹ 79,560.00 ₹ 2,486.25
Enterprise United States of America
Velo None 345 ₹ 120.00 ₹ 125.00 ₹ 82,875.00 ₹ 828.75 ₹ 82,046.25 ₹ 79,560.00 ₹ 2,486.25
Small Business United States of America
Montana Medium 1123 ₹ 260.00 ₹ 125.00 ₹ 7,49,400.00 ₹ 7,494.00 ₹ 7,41,906.00 ₹ 6,24,500.00 ₹ 1,17,406.00
Enterprise Mexico Amarilla Medium 322 ₹ 10.00 ₹ 125.00 ₹ 1,18,375.00 ₹ 13,021.25 ₹ 1,05,353.75 ₹ 1,13,640.00 ₹ -8,286.25
Enterprise Mexico Paseo Medium 1283 ₹ 120.00 ₹ 125.00 ₹ 2,68,125.00 ₹ 5,362.50 ₹ 2,62,762.50 ₹ 2,57,400.00 ₹ 5,362.50
Enterprise Mexico Velo Medium 2498 ₹ 260.00 ₹ 125.00 ₹ 2,68,125.00 ₹ 5,362.50 ₹ 2,62,762.50 ₹ 2,57,400.00 ₹ 5,362.50
Small Business Mexico Paseo Low 2145 ₹ 10.00 ₹ 125.00 ₹ 2,36,400.00 ₹ - ₹ 2,36,400.00 ₹ 1,97,000.00 ₹ 39,400.00
Small Business Mexico Carretera Low 2145 ₹ 120.00 ₹ 125.00 ₹ 1,48,200.00 ₹ 1,482.00 ₹ 1,46,718.00 ₹ 1,23,500.00 ₹ 23,218.00
Small Business Mexico VTT Low 809 ₹ 3.00 ₹ 125.00 ₹ 1,48,200.00 ₹ 1,482.00 ₹ 1,46,718.00 ₹ 1,23,500.00 ₹ 23,218.00
Enterprise Germany Amarilla Low 947 ₹ 3.00 ₹ 125.00 ₹ 1,24,250.00 ₹ 8,697.50 ₹ 1,15,552.50 ₹ 1,19,280.00 ₹ -3,727.50
Enterprise Germany Paseo Low 1023 ₹ 5.00 ₹ 125.00 ₹ 1,01,125.00 ₹ 2,022.50 ₹ 99,102.50 ₹ 97,080.00 ₹ 2,022.50
Enterprise Germany Velo Low 2416 ₹ 120.00 ₹ 125.00 ₹ 1,01,125.00 ₹ 2,022.50 ₹ 99,102.50 ₹ 97,080.00 ₹ 2,022.50
Small Business Germany Paseo Low 994 ₹ 5.00 ₹ 300.00 ₹ 3,36,900.00 ₹ 23,583.00 ₹ 3,13,317.00 ₹ 2,80,750.00 ₹ 32,567.00
Small Business Germany Carretera Low 330 ₹ 10.00 ₹ 300.00 ₹ 64,200.00 ₹ 1,284.00 ₹ 62,916.00 ₹ 53,500.00 ₹ 9,416.00
Enterprise France Carretera Low 663 ₹ 3.00 ₹ 300.00 ₹ 1,27,875.00 ₹ 17,902.50 ₹ 1,09,972.50 ₹ 1,22,760.00 ₹ -12,787.50
Small Business France Montana Low 663 ₹ 250.00 ₹ 300.00 ₹ 96,600.00 ₹ 8,694.00 ₹ 87,906.00 ₹ 80,500.00 ₹ 7,406.00
Segment Country Product Low 494 ₹ 10.00 ₹ 300.00 Gross Sales Discounts Sales COGS Profit
Enterprise Canada Carretera High 494 ₹ 3.00 ₹ 300.00 ₹ 3,02,000.00 ₹ 36,240.00 ₹ 2,65,760.00 ₹ 2,89,920.00 ₹ -24,160.00
Enterprise Canada Montana High 809 ₹ 5.00 ₹ 300.00 ₹ 43,125.00 ₹ - ₹ 43,125.00 ₹ 41,400.00 ₹ 1,725.00
Enterprise Canada Velo High Units Sold ₹ 5.00 ₹ 300.00 ₹ 43,125.00 ₹ - ₹ 43,125.00 ₹ 41,400.00 ₹ 1,725.00

Manufacturing
Small Business Canada Montana Discount Band 214 Price Sale Price ₹ 3,84,900.00 ₹ 30,792.00 ₹ 3,54,108.00 ₹ 3,20,750.00 ₹ 33,358.00

You might also like