Scribd
Upload
112 views2 pages

Excel Test

This document lists merchandise items for sale from The Flying Squirrels, including t-shirts, sweatshirts, coffee mugs, and more. It provides the number of items in stock, price per item, and total price for each item. The bobbleheads have the highest total price at $3,750 while t-shirts have the lowest at $400. In total, there are 325 items in stock with an average total price of $1,186.11.

Uploaded by

api-377258419
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
112 views2 pages

Excel Test

This document lists merchandise items for sale from The Flying Squirrels, including t-shirts, sweatshirts, coffee mugs, and more. It provides the number of items in stock, price per item, and total price for each item. The bobbleheads have the highest total price at $3,750 while t-shirts have the lowest at $400. In total, there are 325 items in stock with an average total price of $1,186.11.

Uploaded by

api-377258419
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

The Flying Squrrirels Merchandise

Item Number in Stock Price Total Price


Tshirts 20 $ 20.00 $ 400.00
Sweatshirts 30 $ 45.00 $ 1,350.00
Coffee Mugs 40 $ 10.00 $ 400.00
Plastic Cups 20 $ 5.00 $ 100.00
Bobbleheads 50 $ 75.00 $ 3,750.00
Stuffed Flying Squirrels 100 $ 20.00 $ 2,000.00
Warm Up Jackets 15 $ 115.00 $ 1,725.00
Blankets 30 $ 25.00 $ 750.00
Waterbottles 20 $ 10.00 $ 200.00
TOTAL NUMBER IN STOCK 325 AVERAGE TOTAL PRICE $ 1,186.11

Prices of Flying Squirrels Merchandise

Waterbottles;
Tshirts; $400.00
$200.00
Blankets; $750.00 Sweatshirts;
Warm Up Jackets; $1,350.00
$1,725.00 Coffee Mugs;
Stuffed Flying $400.00
Squirrels; $2,000.00 Plastic Cups;
$100.00

Bobbleheads;
$3,750.00
Ts hi rts Sweats hi rts Coffee Mugs
Pl astic Cups Bobbl eheads Stuffed Fl yi ng Squi rrel s
Warm Up Ja ckets Bl a nkets Waterbottl es

You might also like