0% found this document useful (0 votes)
90 views1 page

Excel Test

This document contains an inventory list and sales breakdown for merchandise from The Cows. It details 9 types of items for sale, listing the number in stock, individual price, and total price for each item. The bottom provides a total number in stock of 344 items and an average total price of $1,063.89. It also includes a pie chart showing the percentage of total sales revenue contributed by each merchandise type, with bobbleheads contributing the largest portion at $4,500.

Uploaded by

api-377427335
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
0% found this document useful (0 votes)
90 views1 page

Excel Test

This document contains an inventory list and sales breakdown for merchandise from The Cows. It details 9 types of items for sale, listing the number in stock, individual price, and total price for each item. The bottom provides a total number in stock of 344 items and an average total price of $1,063.89. It also includes a pie chart showing the percentage of total sales revenue contributed by each merchandise type, with bobbleheads contributing the largest portion at $4,500.

Uploaded by

api-377427335
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 COWS MERCHANDISE

Item Number in Stock Price Total price


Tshirts 20 $ 20.00 $ 400.00
Sweatshirts 34 $ 40.00 $ 1,360.00
Coffee Mugs 40 $ 10.00 $ 400.00
Plastic Cups 20 $ 5.00 $ 100.00
Bobleheads 45 $ 100.00 $ 4,500.00
Stuffed Animals 76 $ 20.00 $ 1,520.00
To Go Cups 54 $ 10.00 $ 540.00
Blankets 32 $ 20.00 $ 640.00
Waterbottles 23 $ 5.00 $ 115.00
TOTAL NUMBER IN STOCK 344 AVERAGE TOTAL PRICE $ 1,063.89

Price of Cow's Merchandise

Waterbottl es ; $115.00 Ts hi rts ; $400.00


Bl ankets ; $640.00Sweats hi rts ; $1,360.00
To Go Cups ; $540.00
Coffee Mugs ; $400.00
Stuffed Ani mal s ; $1,520.00 Pl astic Cups ; $100.00

Bobleheads; $4,500.00

You might also like