Page 335 - ANALYSIS.XLS

Inter-Departmental Service Fund

Material Management

Mission Department Summary
Statement: Actual Adj. Budget Estimated Budget

Our mission is to have Expenditure Detail: 18-19 19-20 19-20 20-21
dedicated individuals Personnel Services
who maintain accurate Salaries and Wages $ 107,061 $ 109,017 $ 108,097 $ 109,017
inventory controls while Employee Benefits 34,551 37,332 37,332 36,306
providing prompt and Supplies 1,288 2,750 2,200 2,750
courteous assistance to Other Services and Charges 1,558 3,100 2,560 3,100
the City of McAllen, Maintenance 3,101 5,390 5,150 5,390
McAllen Public Utilities
employees, and Material Operations Subtotal 147,559 157,589 155,339 156,563
Suppliers.
Capital Outlay - 3,600 3,600 40,000
Total Expenditures $ 147,559 $ 161,189 $ 158,939 $ 196,563
PERSONNEL
Exempt 1 1 1 1
Non-Exempt 2 2 2 2
Part-Time - - - -
Total Positions Authorized 3 3 3 3

Resources
Actual Adj. Budget Estimated Budget
18-19 19-20 19-20 20-21
Related Revenue Generated $ 350,688 $ 350,000 $ 350,000 $ 350,000

Contact Us: MAJOR FY 20-21 GOALS
Elvira Alonso 1.) Reduce physical inventory variances below 3%.
Director of Public Works 2.) Obtain an inventory turnover ratio of six (6).
4201 N. Bentsen Rd., 3.) Work with IT to provide City departments with list and pictures of stock inventory items on the
McAllen, TX 78504 Intranet.
(956) 681-4000
4.) Perform product survey study among departments for needs to inventory items of best value.

Description: Performance Measures
Our division, has (1) Actual Goal Estimated Goal
Supervisor, (1) Lead FY 18-19 FY 19-20 FY 19-20 FY 20-21
Warehouse Technician, Inputs:
and (1) Warehouse
Technician that strive to Number of full time employees 3 3 3 3
maintain accurate Department Expenditures $ 147,559 $ 161,189 $ 158,939 $ 196,563
inventory controls. We Number of departments 57 57 57 57
provide prompt and Inventory $ 274,014 $ 275,000 $ 300,000 $ 275,000
courteous assistance as Outputs:
we issue inventory to Number of Issue Slips 12,057 11,000 9,500 11,000
City of McAllen and Number of Issue Slip Transactions 45,084 26,000 20,000 26,000
McAllen Public Utilities Number of Items Issued 108,885 120,000 134,000 120,000
employees. We conduct Total Yearly Sales - "Issue Tickets" $ 2,587,595 $ 2,300,000 $ 1,800,000 $ 1,800,000
inventory (2) times a Effectiveness Measures:
year and replenish Total Yearly Purchases - "Receipts" $ 2,114,414 $ 2,200,000 $ 1,500,000 $ 1,500,000
inventory on an "as Number of Receipts 4,700 4,500 300 350
needed" basis.
Number of Receipts Transaction 9,410 8,500 1,704 2,000
Number of Items Received 113,424 120,000 130,000 120,000
Efficiency Measures:
Number of issuances/receipts per empl 5,586 5,167 3,267 3,783
Number of transactions per 18,165 11,500 7,235 9,333
employee
Number of Items Handled per
employee 74,103 80,000 88,000 80,000
Sales & Receipts per employee
(dollars) $ 1,567,336 $ 1,500,000 $ 1,100,000 $ 1,100,000

-285-