0% found this document useful (0 votes)
17 views3 pages

Excel Assignment

excel addsignment

Uploaded by

nandagopalmb7
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
0% found this document useful (0 votes)
17 views3 pages

Excel Assignment

excel addsignment

Uploaded by

nandagopalmb7
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

Segment Country Product Discount Band Units Sold Manufacturing Price

Small Business Mexico Paseo None 788 $10.00


United States of
Enterprise America Carretera Low 330 $3.00
United States of
Small Business America Montana Low 2498 $5.00
Small Business Germany Paseo Medium 1123 $10.00
Enterprise Germany Amarilla Medium 994 $260.00
Small Business Canada Montana Medium 1283 $5.00
Small Business France Montana Medium 322 $5.00
Enterprise Mexico Amarilla High 947 $260.00
Enterprise Canada Carretera High 2416 $3.00
Enterprise France Carretera High 1023 $3.00
Enterprise Canada Montana None 345 $5.00
Enterprise Canada Velo None 345 $120.00
Small Business Mexico Carretera Low 494 $3.00
United States of
Enterprise America Montana Low 663 $5.00
United States of
Enterprise America Velo Low 663 $120.00
Small Business Mexico VTT Low 494 $250.00
Small Business Germany Carretera Low 214 $3.00
Enterprise Germany Paseo Low 809 $10.00
Enterprise Mexico Paseo Low 2145 $10.00
Enterprise Germany Velo Low 809 $120.00
Enterprise Mexico Velo Low 2145 $120.00
Sale Price Gross Sales Discounts Sales COGS
$300.00 $2,36,400.00 $0.00 $2,36,400.00 $1,97,000.00

$125.00 $41,250.00 $412.50 $40,837.50 $40,425.00 $39,600.00

$300.00 $7,49,400.00 $7,494.00 $7,41,906.00 $6,24,500.00


$300.00 $3,36,900.00 $23,583.00 $3,13,317.00 $2,80,750.00
$125.00 $1,24,250.00 $8,697.50 $1,15,552.50 $1,19,280.00
$300.00 $3,84,900.00 $30,792.00 $3,54,108.00 $3,20,750.00
$300.00 $96,600.00 $8,694.00 $87,906.00 $80,500.00
$125.00 $1,18,375.00 $13,021.25 $1,05,353.75 $1,13,640.00
$125.00 $3,02,000.00 $36,240.00 $2,65,760.00 $2,89,920.00
$125.00 $1,27,875.00 $17,902.50 $1,09,972.50 $1,22,760.00
$125.00 $43,125.00 $0.00 $43,125.00 $41,400.00
$125.00 $43,125.00 $0.00 $43,125.00 $41,400.00
$300.00 $1,48,200.00 $1,482.00 $1,46,718.00 $1,23,500.00

$125.00 $82,875.00 $828.75 $82,046.25 $79,560.00

$125.00 $82,875.00 $828.75 $82,046.25 $79,560.00


$300.00 $1,48,200.00 $1,482.00 $1,46,718.00 $1,23,500.00
$300.00 $64,200.00 $1,284.00 $62,916.00 $53,500.00
$125.00 $1,01,125.00 $2,022.50 $99,102.50 $97,080.00
$125.00 $2,68,125.00 $5,362.50 $2,62,762.50 $2,57,400.00
$125.00 $1,01,125.00 $2,022.50 $99,102.50 $97,080.00
$125.00 $2,68,125.00 $5,362.50 $2,62,762.50 $2,57,400.00
Profit
$39,400.00 $26,00,400.00

$1,237.50 $81,675.00

$1,17,406.00 $77,48,796.00
$32,567.00 $21,49,422.00
-$3,727.50 -$2,46,015.00
$33,358.00 $22,01,628.00
$7,406.00 $22,01,628.00
-$8,286.25 -$5,46,892.50
-$24,160.00 -$15,94,560.00
-$12,787.50 -$8,43,975.00
$1,725.00 $1,13,850.00
$1,725.00 $1,13,850.00
$23,218.00 $15,32,388.00

$2,486.25 $1,64,092.50

$2,486.25 $1,64,092.50
$23,218.00 $15,32,388.00
$9,416.00 $6,21,456.00
$2,022.50 $1,33,485.00
$5,362.50 $3,53,925.00
$2,022.50 $1,33,485.00
$5,362.50 $3,53,925.00

You might also like