[go: up one dir, main page]
Scribd
Upload
188 views2 pages

Excel Chapter 2 - Lab Test A

Uploaded by

Furqan Ali Khan

The document analyzes third quarter sales data from six of Caitlin's Cogs store locations. It shows the sales, returns, net sales, sales quota, and difference from sales quota for each store. In total, the stores exceeded their combined sales quota by $171,586.

Copyright:

© All Rights Reserved
Download as XLSX, PDF, TXT or read online from Scribd
Download as xlsx, pdf, or txt

Excel Chapter 2 - Lab Test A

Uploaded by

Furqan Ali Khan
188 views2 pages
The document analyzes third quarter sales data from six of Caitlin's Cogs store locations. It shows the sales, returns, net sales, sales quota, and difference from sales quota for each store. In total, the stores exceeded their combined sales quota by $171,586.

Original Title

Excel Chapter 2 – Lab Test A.xlsx

Copyright

© © All Rights Reserved

Available Formats

XLSX, PDF, TXT or read online from Scribd

Did you find this document useful?

Is this content inappropriate?

The document analyzes third quarter sales data from six of Caitlin's Cogs store locations. It shows the sales, returns, net sales, sales quota, and difference from sales quota for each store. In total, the stores exceeded their combined sales quota by $171,586.

Copyright:

© All Rights Reserved
Download as XLSX, PDF, TXT or read online from Scribd
Download as xlsx, pdf, or txt
188 views2 pages

Excel Chapter 2 - Lab Test A

Uploaded by

Furqan Ali Khan
The document analyzes third quarter sales data from six of Caitlin's Cogs store locations. It shows the sales, returns, net sales, sales quota, and difference from sales quota for each store. In total, the stores exceeded their combined sales quota by $171,586.

Copyright:

© All Rights Reserved
Download as XLSX, PDF, TXT or read online from Scribd
Download as xlsx, pdf, or txt
You are on page 1/ 2

Caitlin’s Cogs

Third Quarter Sales Analysis


Store Location Sales Returns Net Sales Sales Quota
Twin Rivers $591,518.00 $12,638.00 $578,880.00 $765,130.00
The Loop $901,052.00 $12,015.00 $889,037.00 $776,381.00
Tuskawilla $716,502.00 $18,141.00 $698,361.00 $733,309.00
City Center $700,265.00 $10,220.00 $690,045.00 $566,940.00
Legends $802,525.00 $11,138.00 $791,387.00 $712,222.00
Millenia $874,639.00 $18,721.00 $855,918.00 $778,060.00
Total $4,586,501.00 $82,873.00 $4,503,628.00 $4,332,042.00

Average $764,416.83 $13,812.17 $750,604.67 $722,007.00


Highest $901,052.00 $18,721.00 $889,037.00 $778,060.00
Lowest $591,518.00 $10,220.00 $578,880.00 $566,940.00
sis
Above Quota
-$186,250.00
$112,656.00
-$34,948.00
$123,105.00
$79,165.00
$77,858.00
$171,586.00

$28,597.67
$123,105.00
-$186,250.00

You might also like