Exp19_Excel_Ch01_HOEAssessment_OKOS

September

OK Office Systems Pricing Information
9/1/21
Product	Code	Cost	Markup	Retail Price	Percent Off	Sale Price	Profit Margin
Electronics
Computer System	2021-09-100	$ 400	$ 299.95	$ 699.95	15.0%	$ 594.96	32.8%
Color Laser Printer	2021-09-101	$ 300	$ 99.95	$ 399.95	18.5%	$ 325.96	8.0%
32" Curved Monitor	2021-09-105	$ 120	$ 145.00	$ 265.00	10.0%	$ 238.50	49.7%
Furniture
Adjustable Computer Stand	2021-09-103	$ 80	$ 144.97	$ 224.97	15.0%	$ 191.22	58.2%
Solid Oak Computer Desk	2021-09-104	$ 700	$ 795.00	$ 1,495.00	25.5%	$ 1,113.78	37.2%

Exploring Series &A &F

Formulas

OK Office Systems Pricing Information
9/1/21
Product	Code	Cost	Markup	Retail Price	Percent Off	Sale Price	Profit Margin
Electronics
Computer System	2021-09-100	$ 400	$ 299.95	$ 699.95	15.0%	$ 594.96	32.8%
Color Laser Printer	2021-09-101	$ 300	$ 99.95	$ 399.95	18.5%	$ 325.96	8.0%
32" Curved Monitor	2021-09-105	$ 120	$ 145.00	$ 265.00	10.0%	$ 238.50	49.7%
Furniture
Adjustable Computer Stand	2021-09-103	$ 80	$ 144.97	$ 224.97	15.0%	$ 191.22	58.2%
Solid Oak Computer Desk	2021-09-104	$ 700	$ 795.00	$ 1,495.00	25.5%	$ 1,113.78	37.2%

Exploring Series &A &F