Calculations

The cost of goods sold (CGS) is the cost of all merchandise sold in a storeroom. It is calculated as follows and is excluded from operating costs for storerooms in the markup calculation:

How to Calculate the Cost of Goods Sold
+	Beginning inventory
+	Purchases for resale (net of purchase discounts and allowances)
+	Freight (if not included in purchase price of items for resale)
-	Items removed because of obsolescence, spoilage, etc.
-	Purchase returns
-	Ending inventory (net of any inventory) Overages (+) or shortages (-)
=	Cost of goods sold

The amount of adjusted fund balance should be compared to the 60-Day Working Capital Reserve limitation to determine if adjustments need be made to avoid an over recovery in excess of specified limits. See "Working Capital Reserve Limitation" section above.

The following is an example of the limitation calculation:

How to Calculate 60-Day Working Capital Reserve Limitation
	FYxx Cash Expenditures per service activity fund per operating ledger (12 months)	$66,000
=	60-Day Working Capital Reserve Limitation (Total YTD expenditures divided by 6); an absolute value	$11,000

The amount of adjusted fund balance should be compared to the 60 Day Working Capital Reserve limitation to determine if adjustments need be made to avoid an over recovery in excess of specified limits. See the "Working Capital Reserve Limitation" section above.

The following is an example of over recovery:

How to Calculate Adjusted Fund Balance and Over Recoveries
	Fund Balance, End of Year (or YTD) has a credit (surplus) balance	($41,200)
+	Net asset value of Fund Type 3E equipment/facilities -- a credit adjustment to fund balance* *For adjustments to Non-Fund Type 3E equipment, contact System Government Costing	($12,000)
=	Adjusted fund balance (surplus)	($53,200)
	Compared to 60-Day Working Capital Reserve Limitation (see above calculation)	$11,000
	Over recovery (surplus)	($42,200)

The ($42,200) surplus balance should be considered in calculating the recharge rate.

The following is an example of under recovery:

How to Calculate Adjusted Fund Balance and Under Recoveries
	Fund Balance, End of Year (or YTD) has a debit (deficit) balance	$20,000
+	Net asset value of Fund Type 3E equipment/facilities -- a credit adjustment to fund balance* *For adjustments to Non-Fund Type 3E equipment, contact System Government Costing	($6,000)
=	Adjusted fund balance / Under recovery (deficit)	$14,000

The $14,000 deficit should be considered in calculating the recharge rate.

User fees are derived by dividing the aggregate total of actual fiscal year operating expenses, equipment depreciation, and prior year over/under recovery by the actual user fee base:

How to Calculate User Fees
Total costs	+	Fiscal year operating expenses
	+	Annual depreciation expense for all equipment assigned and used by the service activity
	+/-	Prior year under/over recovery
	=	Total costs
User Fee Base	=	Number of service units (billed and unbilled); for example, labor hours, machine hours, CPU time, and computer network connect fees
User Fee (or Recharge Rate)	=	Total costs / User Fee Base

The markup percentage is derived by dividing the aggregate total of actual fiscal year operating expenses, equipment depreciation, and prior year over/under recovery by actual cost of goods sold:

How to Calculate Storeroom Markups
Total costs	+	Fiscal year operating expenses
	+	Annual depreciation expense for all equipment assigned and used by the service activity
	+/-	Prior year under/over recovery
	=	Total costs
Markup Percentage		Total Costs excluding cost of goods sold [a]
		Cost of goods sold [b]
	=	Markup percentage [a] /[b] x 100%
Markup for storeroom merchandise	+	Unit cost of merchandise for resale
	x	Markup percentage
	=	Markup
Selling price for storeroom merchandise	+	Unit cost of merchandise for resale
	+	Markup
	=	Selling Price

The following chart shows accounting entries for recording storeroom inventory:

How to Record Storeroom Inventory
Action	Entry	Account Number
To record storeroom purchases as inventory	Debit GL account code Credit OL account code	55000 - Inventories 187100 - Purchase of Goods for Resale
To adjust Banner inventory to physical inventory on the Fact Sheet	If physical inventory is greater than Banner Inventory: Debit GL account code Credit OL account code	55000 - Inventories 187100 – Purchase of Goods for Resale
	If physical inventory is less than Banner inventory: Debit OL account code Credit GL account code	187100 – Purchase of Goods for Resale 55000 - Inventories
To adjust Banner inventory to reflect removal of obsolete inventory	Debit OL account code Credit GL account code	187103 – Obsolete Inventory for Resale 55000 - Inventories