Scribd
Upload
6 views3 pages

Excel 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
6 views3 pages

Excel 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/ 3

Segment Country Product Discount BanUnits Sold

Small Business Mexico Paseo None 788


United States of
Enterprise America Carretera Low 330
United States of
Small Business America Montana Low 2498
Small Business Germany Paseo Medium 1123
Enterprise Germany Amarilla Medium 994
Small Business Canada Montana Medium 1283
Small Business France Montana Medium 322
Enterprise Mexico Amarilla High 947
Enterprise Canada Carretera High 2416
Enterprise France Carretera High 1023
Enterprise Canada Montana None 345
Enterprise Canada Velo None 345
Small Business Mexico Carretera Low 494
United States of
Enterprise America Montana Low 663
United States of
Enterprise America Velo Low 663
Small Business Mexico VTT Low 494
Small Business Germany Carretera Low 214
Enterprise Germany Paseo Low 809
Enterprise Mexico Paseo Low 2145
Enterprise Germany Velo Low 809
Enterprise Mexico Velo Low 2145

BY HARIPRIYAN. G. K (312312752)
ManufacturingSale Price Gross Sales Discounts Sales
$10.00 $300.00 $236,400.00 $0.00 $236,400.00

$3.00 $125.00 $41,250.00 $412.50 $40,837.50

$5.00 $300.00 $749,400.00 $7,494.00 $741,906.00


$10.00 $300.00 $336,900.00 $23,583.00 $313,317.00
$260.00 $125.00 $124,250.00 $8,697.50 $115,552.50
$5.00 $300.00 $384,900.00 $30,792.00 $354,108.00
$5.00 $300.00 $96,600.00 $8,694.00 $87,906.00
$260.00 $125.00 $118,375.00 $13,021.25 $105,353.75
$3.00 $125.00 $302,000.00 $36,240.00 $265,760.00
$3.00 $125.00 $127,875.00 $17,902.50 $109,972.50
$5.00 $125.00 $43,125.00 $0.00 $43,125.00
$120.00 $125.00 $43,125.00 $0.00 $43,125.00
$3.00 $300.00 $148,200.00 $1,482.00 $146,718.00

$5.00 $125.00 $82,875.00 $828.75 $82,046.25

$120.00 $125.00 $82,875.00 $828.75 $82,046.25


$250.00 $300.00 $148,200.00 $1,482.00 $146,718.00
$3.00 $300.00 $64,200.00 $1,284.00 $62,916.00
$10.00 $125.00 $101,125.00 $2,022.50 $99,102.50
$10.00 $125.00 $268,125.00 $5,362.50 $262,762.50
$120.00 $125.00 $101,125.00 $2,022.50 $99,102.50
$120.00 $125.00 $268,125.00 $5,362.50 $262,762.50
COGS Profit
$197,000.00 $39,400.00

$39,600.00 $1,237.50

$624,500.00 $117,406.00
$280,750.00 $32,567.00
$119,280.00 -$3,727.50
$320,750.00 $33,358.00
$80,500.00 $7,406.00
$113,640.00 -$8,286.25
$289,920.00 -$24,160.00
$122,760.00 -$12,787.50
$41,400.00 $1,725.00
$41,400.00 $1,725.00
$123,500.00 $23,218.00

$79,560.00 $2,486.25

$79,560.00 $2,486.25
$123,500.00 $23,218.00
$53,500.00 $9,416.00
$97,080.00 $2,022.50
$257,400.00 $5,362.50
$97,080.00 $2,022.50
$257,400.00 $5,362.50

You might also like