Costing in Pharmaceutical & Consumable Procurement

Quick Reference Guide for Accountants

Section Inputs (User-Entered) Calculated Values Notes / Rules
Bill Level • Bill Discount
• Bill Tax
• Bill Expenses (Included)
• Bill Expenses (Not Included)
• Gross Total = Σ Line Net Totals
• Net Total = Gross Total + Tax + Included Expenses – Discount
Bill-level values allocated proportionally to items. Do not re-sum to avoid circular dependency.
Item Level (AMP / AMPP) • Quantity (Qty)
• Free Quantity
• Purchase Rate (PR)
• Line Discount Rate
• Line Tax Rate
• Line Expense Rate
• Retail Rate (RSR)
• Wholesale Rate (WSR)
• Line Gross Rate = PR
• Line Net Rate = PR + Tax – Discount
• Line Cost Rate = Net ÷ Qty (always per unit)
• Line Gross Total = PR × Qty
• Line Discount = DR × Qty
• Line Tax = TR × Qty
• Line Expense = ER × Qty
• Line Net Total = Gross + Tax + Expense – Discount
Pack rates converted to unit basis for cost rate. Free qty included in cost rate (dilutes cost).
Allocation of Bill Values — • Bill Discount Value
• Bill Expense Value
• Bill Tax Value
• Bill Net Value
Allocated proportionally to Line Net Total. Free quantities excluded.
Final Item Totals — • Gross Total = Line Gross Total
• Total Discount = Line Discount + Bill Discount
• Total Tax = Line Tax + Bill Tax
• Total Expense = Line Expense + Bill Expense
• Net Total = Line Net Total + Bill Net Value
Per-unit rates derived by dividing totals by Qty.
Stock Valuation — • Cost Rate = Paid Value ÷ (Qty + Free Qty)
• Value at Retail = RSR × (Qty + Free Qty)
• Value at Wholesale = WSR × (Qty + Free Qty)
• Value at Purchase = PR × (Qty + Free Qty)
• Value at Cost = Cost Rate × (Qty + Free Qty)
Stock always valued at Cost Rate, not PR × Stock.
Sign Conventions — • Stock Inflow = +Qty
• Stock Outflow = –Qty
• Expenditure = Negative Value
• Income = Positive Value
Ensures ledger reconciliation.