Hotel and training centre, Melksham, Wiltshire
High quality accommodation for course delegates, business travellers and the leisure visitor too.

Search for:
Home Accessibility Bedrooms Book Here The Mouth Facebook Resources Find Us About Us Contact
 
20.9.2014 - We have just updated our course layouts and descriptions and added our 2015 schedule.

How many toilet rolls - hotel inventory and useage

Rolls of toliet paperRunning Well House Manor, we buy a lot of hotel supplies - ranging from sheets and towels when they are to be replaced, through guest soaps and toilet rolls, salt, sugar and jams which are ordered from time to time, to weekly or twice weekly orders such as fruit and fresh products and ultimately the daily paper. And we need to keep track of this expenditure and where it all goes. Lisa's been working on a database extension over the last few days to bring these figures closer to our finger tips - to tell us what's worth worrying about, and what is such a small player in the game that it shouldn't be at the top of our attention list.

It turns out that the algorithms are surprisingly complex. Consider the following purchases on file:
  1/3/10 240
  4/4/10 360
  5/6/10 360
  12/8/10 240
  7/9/10 240
  9/10/10 360
At first glance, that's 1800 purchased over a 222 day period - 8.1 units used per day. But hang on a moment ...
• there were probably some in stock on 1st March
• the 360 purchased on 9th October won't be used until .. an indefinite date thereafter
• there will be stock left at the end of the period
So I really don't trust that 8.1 per day figure.

A true algorithm would take the numbers above, add in the number in stock on 1st March, subtract the number in stock today, and then divide by the number of days from 1st March. But that would meaning saving the stock level immediatly prior to all purchases, and also doing a stock count whenever we want o look at the figures. This seems rather a lot of work for a fine adjustment.

The algorithm I've come up with - which should even out over time - assumes that stock levels are [roughly] the same each time an order is placed - so we've used 240 in the 34 days from 1st March to 4th April, and so on. So the running calculation is made by adding up the numbers purchased on each occasion except the last, calculating the number of days from the first to the last order, and dividing one by the other. The results (from this Perl program - see [source]) are like this:

wizard:dec10 graham$ perl toiletrolls.pl
Over 222 days, 1440 were consumed
That's 6.48648648648649 per day
wizard:dec10 graham$


which is rather over-accurate, but much truer to the figures.

(written 2010-12-18, updated 2010-12-20)

 
Associated topics are indexed as below, or enter http://melksh.am/nnnn for individual articles
M300 - Well House Manor - Behind the scenes
  [3961] Well House Staff Party - (2012-12-22)
  [3844] Rooms ready for guests - each time, every time, thanks to good system design - (2012-08-20)
  [3743] Sunday - no longer a day of rest - (2012-05-28)
  [2961] Initial handling of phone calls and walk in visitors - (2010-09-19)
  [2960] The Well House team - September 2010 - (2010-09-19)
  [2916] Testing the robustness of our hotel and training systems - holiday and sickness times - (2010-08-11)
  [2910] Robust - testing the system - (2010-08-09)
  [2396] Easing off in our 50s? - (2009-09-06)
  [2247] A day in the life of a hotelier - (2009-06-18)
  [2125] We have lost a regular business guest - (2009-04-10)
  [1991] Rules for a King - (2009-01-13)
  [1973] Required Request - (2009-01-03)
  [1957] Why are cooks bad tempered? - (2008-12-22)
  [1948] Blame Culture - (2008-12-17)
  [1904] Ruby, Perl, Linux, MySQL - some training notes - (2008-11-23)
  [1900] Table Topics - (2008-11-22)
  [1854] Three Seasonal Pictures - (2008-10-25)
  [1637] Providing exceptional service - and carrying on doing so. - (2008-05-09)
  [1571] Await guests in the early hours - (2008-03-12)
  [1520] Terms and Conditions - Hotel, England - plain English - (2008-01-26)
  [1515] Keeping staff up to date on hotel room status - (2008-01-22)
  [1490] Software to record day to day events and keep an action list - (2007-12-31)
  [1441] On cancellations, rebooking, and pricing schemes - (2007-11-22)
  [1371] Hotel in Melksham at Christmas - (2007-09-29)
  [1369] One business, four different angles! - (2007-09-28)
  [1319] Customer feedback - lifeblood of a business - (2007-08-25)
  [1311] What do people look for on a hotel web site? - (2007-08-20)
  [1285] In the army, or in civvie street? - (2007-07-31)
  [1189] Meet, greet and welcome - (2007-05-16)
  [1179] Sizing sheets and other domestic issues - (2007-05-07)
  [1159] It can take more that one plus one to get two. - (2007-04-22)
  [1105] A week is a long time in the life of a conference centre - (2007-03-10)
  [1083] Behind the scenes - (2007-02-17)
  [1000] One Thousand Posts and still going strong - (2006-12-18)
  [951] What happened at Geekmas - (2006-11-28)
  [939] Swipe cards for hotel rooms - Security issues - (2006-11-23)
  [931] Before and After - Well House Manor - (2006-11-18)
  [927] Hotel door furniture - (2006-11-15)
  [897] Too much for the National Trust - (2006-10-18)
  [868] Smoking, or no - (2006-09-16)
  [813] Monday Morning at Well House Consultants Melksham - (2006-07-24)
  [769] King Edward VII - days of empire - (2006-06-20)
  [742] A visit from the solicitor - (2006-06-03)
  [677] Sympathetic development - (2006-04-09)
  [203] Holes in on line information - (2005-02-05)

P050 - Perl - General
  [4296] Polishing the Perl courses - updated training - (2014-09-17)
  [3911] How well do you know Perl and / or Python? - (2012-11-04)
  [3902] Shell - Grep - Sed - Awk - Perl - Python - which to use when? - (2012-10-22)
  [3823] Know Python or PHP? Want to learn Perl too? - (2012-07-31)
  [3407] Perl - a quick reminder and revision. Test yourself! - (2011-08-26)
  [3332] DNA to Amino Acid - a sample Perl script - (2011-06-24)
  [3322] How much has Perl (and other languages) changed? - (2011-06-10)
  [2971] Should the public sector compete with businesses? and other deep questions - (2010-09-26)
  [2825] Perl course - is it tailored to Linux, or Microsoft Windows? - (2010-06-25)
  [2783] The Perl Survey - (2010-05-27)
  [2736] Perl Course FAQ - (2010-04-23)
  [2504] Learning to program in ... - (2009-11-15)
  [2374] Lead characters on Perl variable names - (2009-08-24)
  [2242] So what is this thing called Perl that I keep harping on about? - (2009-06-15)
  [2228] Where do I start when writing a program? - (2009-06-11)
  [1897] Keeping on an even keel - (2008-11-21)
  [1750] Glorious (?) 12th August - what a Pe(a)rl! - (2008-08-12)
  [743] How to debug a Perl program - (2006-06-04)
  [400] New in the shops - (2005-08-01)
  [116] The next generation of programmer - (2004-11-13)

Q110 - Object Orientation and General technical topics - Programming Algorithms
  [3662] Finding all the unique lines in a file, using Python or Perl - (2012-03-20)
  [3620] Finding the total, average, minimum and maximum in a program - (2012-02-22)
  [3451] Why would you want to use a Perl hash? - (2011-09-20)
  [3102] AND and OR operators - what is the difference between logical and bitwise varieties? - (2010-12-24)
  [3072] Finding elements common to many lists / arrays - (2010-11-26)
  [3042] Least Common Ancestor - what is it, and a Least Common Ancestor algorithm implemented in Perl - (2010-11-11)
  [2993] Arrays v Lists - what is the difference, why use one or the other - (2010-10-10)
  [2951] Lots of way of converting 3 letter month abbreviations to numbers - (2010-09-10)
  [2894] Sorting people by their names - (2010-07-29)
  [2617] Comparing floating point numbers - a word of caution and a solution - (2010-02-01)
  [2586] And and Or illustrated by locks - (2010-01-17)
  [2509] A life lesson from the accuracy of numbers in Excel and Lua - (2009-11-21)
  [2259] Grouping rows for a summary report - MySQL and PHP - (2009-06-27)
  [2189] Matching disparate referencing systems (MediaWiki, PHP, also Tcl) - (2009-05-19)
  [1949] Nuclear Physics comes to our web site - (2008-12-17)
  [1840] Validating Credit Card Numbers - (2008-10-14)
  [1391] Ordnance Survey Grid Reference to Latitude / Longitude - (2007-10-14)
  [1187] Updating a page strictly every minute (PHP, Perl) - (2007-05-14)
  [1157] Speed Networking - a great evening and how we arranged it - (2007-04-21)
  [642] How similar are two words - (2006-03-11)
  [227] Bellringing and Programming and Objects and Perl - (2005-02-25)
  [202] Searching for numbers - (2005-02-04)


Back to
wxPython geometry - BoxSizer example
Previous and next
or
Horse's mouth home
Forward to
Setting your user_agent in PHP - telling back servers who you are
Some other Articles
Making Perl class definitions more conventional and shorter
Contrast in pictures
The Christmas Season has arrived
Setting your user_agent in PHP - telling back servers who you are
How many toilet rolls - hotel inventory and useage
wxPython geometry - BoxSizer example
How do regular expressions work / Regular Expression diagrams
Matching to a string - what if it matches in many possible ways?
Python regular expressions - repeating, splitting, lookahead and lookbehind
Melksham - two many councils?
4291 posts, page by page
Link to page ... 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86 at 50 posts per page


This is a page archived from The Horse's Mouth at http://www.wellho.net/horse/ - the diary and writings of Graham Ellis. Every attempt was made to provide current information at the time the page was written, but things do move forward in our business - new software releases, price changes, new techniques. Please check back via our main site for current courses, prices, versions, etc - any mention of a price in "The Horse's Mouth" cannot be taken as an offer to supply at that price.

Link to Ezine home page (for reading).
Link to Blogging home page (to add comments).

You can Add a comment or ranking to this page
Hello. I'm Graham Ellis. If you have a question about the hotel, please ask me or

 

then book here

© WELL HOUSE CONSULTANTS LTD., 2014: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 899360 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho

PAGE: http://www.wellho.net/mouth/3093_How ... seage.html • PAGE BUILT: Thu Sep 18 15:30:25 2014 • BUILD SYSTEM: WomanWithCat