Price Analysis

Index to Reports: Inventory Tab

Displays a calculation of the gross profit, percent margin, and percent markup of your inventory items using either average cost or last cost. This report may be sorted by Item # or Item Name.

Price Analysis

Item #

Item Name

Current Price

Cost Basis

Gross Profit

% Margin

% Markup

_________________________________________________________________________

100-101A5

Widgets

$17.00

$10.177

$6.82

40.1%

67.0%

200-101A5

Gadgets

$33.00

$20.032

$12.97

39.3%

64.7%

300-101B6

Whoosies

$50.00

$30.195

$19.80

39.6%

65.6%

400-101

Whatsits

$67.00

$0.00

$67.00

100.0%

NA

500-101D3

Thingies

$83.00

$50.00

$33.00

39.8%

66.0%

600-101G8

Gizmos

$100.00

$59.162

$40.84

40.8%

69.0%

700-101U7

Thingamabobs

$117.00

$69.983

$47.02

40.2%

67.2%

800-101R9

Whachamacallits

$133.00

$80.00

$53.00

39.8%

66.3%

CON1

Consulting

$125.00

$0.00

$125.00

100.0%

NA