{"id":12680,"date":"2008-02-27T07:03:51","date_gmt":"2008-02-27T14:03:51","guid":{"rendered":"http:\/\/hill-kleerup.org\/blog\/wp\/2008\/02\/27\/earned-my-pay-for-the-week.html"},"modified":"2008-02-27T07:03:51","modified_gmt":"2008-02-27T14:03:51","slug":"earned_my_pay_for_the_wee","status":"publish","type":"post","link":"https:\/\/hill-kleerup.org\/blog\/2008\/02\/27\/earned_my_pay_for_the_wee.html","title":{"rendered":"Earned my pay for the week"},"content":{"rendered":"
\"\"<\/div>\n

So, as I periodically scribe here, whenever I delve into the depths of budgets and forecasts and actuals and so forth, I usually end up with a huge migraine, because the data is scattered about, largely in the hands of an internal IT accounting group that is sometimes very responsible, other times not so much. <\/p>\n

Not infrequently, I discover something that it looks like they’ve done wrong. It might be they have obsolete pay rates for people, or are being inconsistent in a certain fringe burden, or something tweaky and individual like that. About half the time, it turns out I’m right, about half the time it turns out I don’t know what I’m talking about (though that, more often than not, is because I am not privy to the Sooper Sekrit Spreadsheets That Explain All).<\/p>\n

So my boss has been pulling out his hair trying to find out why they’ve been telling him that he’s a half million dollars over his labor budget. Given that none of his directs could account for more than a fraction of that didn’t make the Boss’s life any easier. (For the record, I’m probably one of the two of the Boss’s directs most diligent at hammering this stuff out, based on feedback I’ve gotten.) But, as part of that, he managed to pry loose the current Sooper Sekrit Spreadsheet That Explains All (SSSTEA), or from which the IT accounting people were doing their forecasts.<\/p>\n

So I started comparing its numbers to my numbers.  The raw figures seemed right, the fringes good, etc. My numbers and their numbers pretty much matched on the front end, but they were showing higher final labor costs across the board. <\/p>\n

Poked and prodded some more, and discovered something I couldn’t quite believe was right, even when I confirmed it two or three different ways. We operate on a 1 October fiscal year, but a 1 January review\/raise cycle. Since the going-forward forecasting they were doing was as of February, they’d jiggered various numbers in their overly complex SSSTEA to reflect the salaries with various increases for the new year.<\/p>\n

But … as far as I could tell … they still had the calculations in there to give everyone an average X% merit increase on 1 January, too, in addition to having factored the actual increases into the raw numbers. And, lo and behold, all their numbers were X% over what I thought they should be.<\/p>\n

As I said, I tried to figure this out about three different ways (including looking at an actual live person’s salary, drawn from the HR system). I sent a very politely phrased note to the IT accounting people, attaching a couple of spreadsheets (including the SSSTEA), and spelling out (with cell references) what I thought was happening (“or am I missing something obvious?”).<\/p>\n

Silence.<\/p>\n

I also CCed my boss about this, who was quite interested (obviously) in what the response was.<\/p>\n

Silence.<\/p>\n

Then, last evening, on my Blackberry:<\/p>\n

From: [My boss]
Subject: I’ve got a secret<\/p>\n

It appears that you are right about the X% oops on the merit increase. News at 7 and congrats!<\/p><\/blockquote>\n

 <\/p>\n

I tried to hit him on for a finders fee, but he wasn’t feeling that <\/em>congratulatory.<\/p>\n

I think I just paid for all those hours I’ve banged against those numbers.<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

So, as I periodically scribe here, whenever I delve into the depths of budgets and forecasts and actuals and so forth, I usually end up with a huge migraine,…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","_seopress_analysis_target_kw":"","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[21],"tags":[],"class_list":["post-12680","post","type-post","status-publish","format-standard","hentry","category-job-jollies"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":5271,"url":"https:\/\/hill-kleerup.org\/blog\/2004\/04\/14\/hang_up.html","url_meta":{"origin":12680,"position":0},"title":"Hang-up","author":"***Dave","date":"Wed 14-Apr-04 3:30pm","format":false,"excerpt":"Someone did a study of why mobile phone usage around you is irritating. There are the obvious noise and attention reasons -- but another big irritation seems to be only...","rel":"","context":"In "Hi-Tech"","block_context":{"text":"Hi-Tech","link":"https:\/\/hill-kleerup.org\/blog\/category\/hi-tech"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":24052,"url":"https:\/\/hill-kleerup.org\/blog\/2011\/11\/26\/inmates-running-for-management-of-the-asylum.html","url_meta":{"origin":12680,"position":1},"title":"Inmates running for management of the asylum","author":"***Dave","date":"Sat 26-Nov-11 7:38pm","format":false,"excerpt":"Sure, it seems highly unlikely at present that any of these zanies would actually get the GOP nomination -- except for Gingrich, for the moment -- but that they've gotten so much publicity (and all spent their turns with relatively high polling results) still gives me the willies. #ddtb Embedded\u2026","rel":"","context":"In "~PlusPosts"","block_context":{"text":"~PlusPosts","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging\/plusposts"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":22953,"url":"https:\/\/hill-kleerup.org\/blog\/2011\/10\/03\/unblogged-bits-mon-3-oct-11-1730-2.html","url_meta":{"origin":12680,"position":2},"title":"Unblogged Bits (Mon. 3-Oct-11 1730)","author":"***Dave","date":"Mon 3-Oct-11 5:30pm","format":false,"excerpt":"Links (most recent first) that caught my eye, but did not warrant full-blown blog entries .... New Study Shows the Extent of GOP Voter-Disenfranchisment | People For the American Way Blog Futurity.org \u2013 One-dose contraceptive for cats - Primarily useful for feral cat populations. Cool. Opponents Of Colorado Ballot Initiative\u2026","rel":"","context":"In "Potpourri"","block_context":{"text":"Potpourri","link":"https:\/\/hill-kleerup.org\/blog\/category\/potpourri"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":12802,"url":"https:\/\/hill-kleerup.org\/blog\/2008\/09\/24\/landscaping_day_8.html","url_meta":{"origin":12680,"position":3},"title":"Landscaping – Day 8","author":"***Dave","date":"Wed 24-Sep-08 4:14pm","format":false,"excerpt":"Not much visible progress, buit the walls on the right were redone (muich better) and they've set about half the stones on the patio....","rel":"","context":"In "Home Improvement"","block_context":{"text":"Home Improvement","link":"https:\/\/hill-kleerup.org\/blog\/category\/home-improvement"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/farm4.static.flickr.com\/3014\/2886255396_cd2e412926.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":137679,"url":"https:\/\/hill-kleerup.org\/blog\/2019\/01\/16\/as-the-shutdown-slowly-turns-into-indentured-servitude.html","url_meta":{"origin":12680,"position":4},"title":"As the shutdown slowly turns into indentured servitude","author":"***Dave","date":"Wed 16-Jan-19 8:36pm","format":false,"excerpt":"The Trump Administration keeps coming up with more and more \"critical\" federal workers who need to be dragged back to work without pay.I mean, sure, it's easy to reduce the cost of government if you kinda-sorta paper over the most dire needs with an all-\"volunteer\" army of workers. Of course,\u2026","rel":"","context":"In "~PlusPosts"","block_context":{"text":"~PlusPosts","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging\/plusposts"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4387,"url":"https:\/\/hill-kleerup.org\/blog\/2003\/09\/12\/syncing_feeling.html","url_meta":{"origin":12680,"position":5},"title":"Syncing feeling","author":"***Dave","date":"Fri 12-Sep-03 7:02am","format":false,"excerpt":"I use SyncIt on my PC and on Margie's. It's an incredibly cool service that keeps a synchronized copy of your IE Favorites online, where they not only serve as...","rel":"","context":"In "Blogging & Internet"","block_context":{"text":"Blogging & Internet","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/posts\/12680","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/comments?post=12680"}],"version-history":[{"count":0,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/posts\/12680\/revisions"}],"wp:attachment":[{"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/media?parent=12680"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/categories?post=12680"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/tags?post=12680"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}