Scribd
Upload
6 views4 pages

Office Supplies Pricing and Discounts

The document contains a list of products with their respective quantities, unit prices, subtotals, discounts, and VAT calculations. It also includes discount thresholds and VAT rates. Additionally, there is a summary of total costs for various items categorized as hardware and accessories, along with their delivery statuses.

Uploaded by

simplybyfiona
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 views4 pages

Office Supplies Pricing and Discounts

The document contains a list of products with their respective quantities, unit prices, subtotals, discounts, and VAT calculations. It also includes discount thresholds and VAT rates. Additionally, there is a summary of total costs for various items categorized as hardware and accessories, along with their delivery statuses.

Uploaded by

simplybyfiona
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

A (ProductB ID)

(Product Name)
C (Quantity)D (Unit Price) E (Subtotal) F (Discount) G (VAT 12%)
P001 Office Chair 3 1500 =C2*D$2 #VALUE! 540
P002 Desk Lamp 5 850 4250 425 510
P003 Filing Cabinet 2 3200 6400 640 768
P004 Whiteboard 4 1100 4400 440 528
P005 Office Table 1 5500 5500 550 660

Cell Label Value


Discount
c10 1000
Threshold
Discount
c11 0.1
High
Discount
c12 0.05
Low
c13 VAT Rate 0.12

price quantitity
1 1500 3
2 850 5
3 3200 2
4 1100 4
5 5500 1
H (Total Cost)
#VALUE!
4335
6528
4488
5610
Item Produ Quanti Total Trimmed Characte
Unit Price Category Status
Code ct ty Cost Product r Count
P001 Mouse 10 250 Hardware Delivered 2500 Mouse 4
Keybo
P002 8 500 Hardware Pending 4000 Keyboard 4
ard
Monit
P003 4 4500 Hardware Delivered 18000 Monitor 4
or
USB USB
P004 20 100 Accessory Cancelled 2000 4
Cable
Printer Cable
Printer
P005 5 850 Accessory Delivered 4250 4
Ink
Headp Ink
Headpho
P006 7 1200 Accessory Pending 8400 4
hones nes
20 1233.333 3 3 39150 24
4
VLOOKUP

250
500
250
100
850
1200

You might also like