Scribd
Upload
6 views2 pages

Ms Excel Assignment 1anitha

The document provides a detailed sales report including segments, countries, products, discounts, units sold, and financial metrics such as gross sales, discounts, cost of goods sold (COGS), and profit. It highlights various sales performance across different regions and product categories, indicating both positive and negative profit margins. Overall, it serves as a comprehensive overview of sales data for analysis.

Uploaded by

anithaammu448
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 views2 pages

Ms Excel Assignment 1anitha

The document provides a detailed sales report including segments, countries, products, discounts, units sold, and financial metrics such as gross sales, discounts, cost of goods sold (COGS), and profit. It highlights various sales performance across different regions and product categories, indicating both positive and negative profit margins. Overall, it serves as a comprehensive overview of sales data for analysis.

Uploaded by

anithaammu448
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 BUnits Sold ManufacturSale Price Gross Sales Discounts

Small Busi Mexico Paseo None $788.00 $10.00 $300.00 $236,400.00 $0.00
United
States of
Enterprise America Carretera Low $330.00 $3.00 $125.00 $41,250.00 $412.50
United
States of
Small Busi America Montana Low $2,498.00 $5.00 $300.00 $749,400.00 $7,494.00
Small Busi Germany Paseo Medium $1,123.00 $10.00 $300.00 $336,900.00 $23,583.00
Enterprise Germany Amarilla Medium $994.00 $260.00 $125.00 $124,250.00 $8,697.50
Small Busi Canada Montana Medium $1,283.00 $5.00 $300.00 $384,900.00 $30,792.00
Small Busi France Montana Medium $322.00 $5.00 $300.00 $96,600.00 $8,694.00
Enterprise Mexico Amarilla High $947.00 $260.00 $125.00 $118,375.00 $13,021.25
Enterprise Canada Carretera High $2,416.00 $3.00 $125.00 $302,000.00 $36,240.00
Enterprise France Carretera High $1,023.00 $3.00 $125.00 $127,875.00 $17,902.50
Enterprise Canada Montana None $345.00 $5.00 $125.00 $43,125.00 $0.00
Enterprise Canada Velo None $345.00 $120.00 $125.00 $43,125.00 $0.00
Small Busi Mexico Carretera Low $494.00 $3.00 $300.00 $148,200.00 $1,482.00
United
States of
Enterprise America Montana Low $663.00 $5.00 $125.00 $82,875.00 $828.75
United
States of
Enterprise America Velo Low $663.00 $120.00 $125.00 $82,875.00 $828.75
Small Busi Mexico VTT Low $494.00 $250.00 $300.00 $148,200.00 $1,482.00
Small Busi Germany Carretera Low $214.00 $3.00 $300.00 $64,200.00 $1,284.00
Enterprise Germany Paseo Low $809.00 $10.00 $125.00 $101,125.00 $2,022.50
Enterprise Mexico Paseo Low $2,145.00 $10.00 $125.00 $268,125.00 $5,362.50
Enterprise Germany Velo Low $809.00 $120.00 $125.00 $101,125.00 $2,022.50
Enterprise Mexico Velo Low $2,145.00 $120.00 $125.00 $268,125.00 $5,362.50
Sales COGS Profit
$236,400.00 $197,000.00 $39,400.00

$40,837.50 $40,425.00 $39,600.00 $1,237.50

$741,906.00 $624,500.00 $117,406.00


$313,317.00 $280,750.00 $32,567.00
$115,552.50 $119,280.00 -$3,727.50
$354,108.00 $320,750.00 $33,358.00
$87,906.00 $80,500.00 $7,406.00
$105,353.75 $113,640.00 -$8,286.25
$265,760.00 $289,920.00 -$24,160.00
$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
$146,718.00 $123,500.00 $23,218.00

$82,046.25 $79,560.00 $2,486.25

$82,046.25 $79,560.00 $2,486.25


$146,718.00 $123,500.00 $23,218.00
$62,916.00 $53,500.00 $9,416.00
$99,102.50 $97,080.00 $2,022.50
$262,762.50 $257,400.00 $5,362.50
$99,102.50 $97,080.00 $2,022.50
$262,762.50 $257,400.00 $5,362.50

You might also like