{"id":117116,"date":"2018-09-25T06:00:10","date_gmt":"2018-09-25T14:00:10","guid":{"rendered":"http:\/\/edubusinesssolutions.com\/?p=117116"},"modified":"2018-11-15T13:59:37","modified_gmt":"2018-11-15T21:59:37","slug":"sept18-news-data","status":"publish","type":"post","link":"https:\/\/edubusinesssolutions.com\/sept18-news-data\/","title":{"rendered":"The Power of Data by Gordon Rivera"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;3.14&#8243; custom_padding=&#8221;0|0px|53px|0px|false|false&#8221;][et_pb_row custom_padding=&#8221;36px|0px|26px|0px|false|false&#8221; _builder_version=&#8221;3.14&#8243;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.14&#8243; parallax=&#8221;off&#8221; parallax_method=&#8221;on&#8221;][et_pb_text _builder_version=&#8221;3.14&#8243;]No one ever said, I wish we did <em>not <\/em>collect all that data\u2026<\/p>\n<p>Last year we went from a partial chargeback process to a 100% chargeback process and the transition was daunting, to say the least. First I had to price all of our products based on materials-only (we do not charge for labor) and gauge print allocations for our 33 institutional departments. Pricing was relatively easy to determine as a dollar amount that covers our fixed and variable operational costs, but print budget allocations were a nightmare. We previously had one set account that was to be used by all 33 departments and shared by over 1,000 faculty and staff members. It was a huge undertaking to come up with a reliable guesstimate of how many impressions were ordered by each site (department). In order for the print budgets to be allocated, the college was relying on me to provide accurate numbers so departments would not run out of print money throughout the year, or be provided too much of a budget.<\/p>\n<p>After running hundreds of pages of click summary reports, and some good advice from Chuck Bailey of edu, I was pretty confident that the numbers we came up with would be a reliable forecast of print consumption by the 33 institutional departments for the upcoming year. After the allocations were determined, department print budgets could be developed by multiplying the cost per impression by the forecasted number of impressions. A lot was riding on the numbers that I provided. If I underestimated then I would run out of operational funding and would have to raid my retail account to make up the difference. If I overestimated then the integrity of my Print Shop Pro\u00ae (PSP) reports and my competence would be in question. Needless to say, I was anxious when examining the monthly PSP Sales-by-Account-Number report that I gave to each department that detailed their chargebacks for the prior month.<\/p>\n<p>All this happened in June of last year, so I am happy to report to you the results from what I predicted aligned closely with what actually happened. The total college chargeback amount based on the data described above was $200,000 for 2017\/18. At the end of the year, Campus Graphics billed over $230,000 in chargebacks, which is 14% higher than budgeted. Campus Graphics can now <em>prove<\/em> it recoups its operational costs by charging an appropriate dollar amount for its products.<\/p>\n<p>What is amazing is that despite PSP not being set up for chargebacks for our clients originally, the data it did provide allowed us to successfully design and implement a system that has proven to work. The moral of this story is to over-engineer your data collection in PSP, gather more than you need because you will never know when you may need it.<\/p>\n<p>Next month I will go over the 25% decrease of our toner-based products and our 35% increase in wide format sales\u2026<br \/>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>No one ever said, I wish we did not collect all that data\u2026 Last year we went from a partial chargeback process to a 100% chargeback process and the transition was daunting, to say the least. First I had to price all of our products based on materials-only (we do not charge for labor) and [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":117133,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[40,44],"tags":[32,29,28],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.8.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>The Power of Data by Gordon Rivera - edu Business Solutions<\/title>\n<meta name=\"description\" content=\"Gordon Rivera, guest contributor from Allan Hancock College, explains how data collection in Print Shop Pro\u00ae justifies operational costs of in-plants.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/edubusinesssolutions.com\/sept18-news-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Power of Data by Gordon Rivera - edu Business Solutions\" \/>\n<meta property=\"og:description\" content=\"Gordon Rivera, guest contributor from Allan Hancock College, explains how data collection in Print Shop Pro\u00ae justifies operational costs of in-plants.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/edubusinesssolutions.com\/sept18-news-data\/\" \/>\n<meta property=\"og:site_name\" content=\"edu Business Solutions\" \/>\n<meta property=\"article:published_time\" content=\"2018-09-25T14:00:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-15T21:59:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/edubusinesssolutions.com\/wp-content\/uploads\/2018\/09\/data-illustration.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"384\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Leeann Raymond\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Leeann Raymond\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/edubusinesssolutions.com\/sept18-news-data\/\",\"url\":\"https:\/\/edubusinesssolutions.com\/sept18-news-data\/\",\"name\":\"The Power of Data by Gordon Rivera - edu Business Solutions\",\"isPartOf\":{\"@id\":\"https:\/\/edubusinesssolutions.com\/#website\"},\"datePublished\":\"2018-09-25T14:00:10+00:00\",\"dateModified\":\"2018-11-15T21:59:37+00:00\",\"author\":{\"@id\":\"https:\/\/edubusinesssolutions.com\/#\/schema\/person\/b9220984960b7e5c6a59a28046301ec8\"},\"description\":\"Gordon Rivera, guest contributor from Allan Hancock College, explains how data collection in Print Shop Pro\u00ae justifies operational costs of in-plants.\",\"breadcrumb\":{\"@id\":\"https:\/\/edubusinesssolutions.com\/sept18-news-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/edubusinesssolutions.com\/sept18-news-data\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/edubusinesssolutions.com\/sept18-news-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/edubusinesssolutions.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Power of Data by Gordon Rivera\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/edubusinesssolutions.com\/#website\",\"url\":\"https:\/\/edubusinesssolutions.com\/\",\"name\":\"edu Business Solutions\",\"description\":\"Maximizing your resources with simple and reliable software\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/edubusinesssolutions.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/edubusinesssolutions.com\/#\/schema\/person\/b9220984960b7e5c6a59a28046301ec8\",\"name\":\"Leeann Raymond\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/edubusinesssolutions.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/daca114e0f5600dd0d180f315d01022d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/daca114e0f5600dd0d180f315d01022d?s=96&d=mm&r=g\",\"caption\":\"Leeann Raymond\"},\"url\":\"https:\/\/edubusinesssolutions.com\/author\/leeann\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The Power of Data by Gordon Rivera - edu Business Solutions","description":"Gordon Rivera, guest contributor from Allan Hancock College, explains how data collection in Print Shop Pro\u00ae justifies operational costs of in-plants.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/edubusinesssolutions.com\/sept18-news-data\/","og_locale":"en_US","og_type":"article","og_title":"The Power of Data by Gordon Rivera - edu Business Solutions","og_description":"Gordon Rivera, guest contributor from Allan Hancock College, explains how data collection in Print Shop Pro\u00ae justifies operational costs of in-plants.","og_url":"https:\/\/edubusinesssolutions.com\/sept18-news-data\/","og_site_name":"edu Business Solutions","article_published_time":"2018-09-25T14:00:10+00:00","article_modified_time":"2018-11-15T21:59:37+00:00","og_image":[{"width":1024,"height":384,"url":"https:\/\/edubusinesssolutions.com\/wp-content\/uploads\/2018\/09\/data-illustration.jpg","type":"image\/jpeg"}],"author":"Leeann Raymond","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Leeann Raymond","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/edubusinesssolutions.com\/sept18-news-data\/","url":"https:\/\/edubusinesssolutions.com\/sept18-news-data\/","name":"The Power of Data by Gordon Rivera - edu Business Solutions","isPartOf":{"@id":"https:\/\/edubusinesssolutions.com\/#website"},"datePublished":"2018-09-25T14:00:10+00:00","dateModified":"2018-11-15T21:59:37+00:00","author":{"@id":"https:\/\/edubusinesssolutions.com\/#\/schema\/person\/b9220984960b7e5c6a59a28046301ec8"},"description":"Gordon Rivera, guest contributor from Allan Hancock College, explains how data collection in Print Shop Pro\u00ae justifies operational costs of in-plants.","breadcrumb":{"@id":"https:\/\/edubusinesssolutions.com\/sept18-news-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/edubusinesssolutions.com\/sept18-news-data\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/edubusinesssolutions.com\/sept18-news-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/edubusinesssolutions.com\/"},{"@type":"ListItem","position":2,"name":"The Power of Data by Gordon Rivera"}]},{"@type":"WebSite","@id":"https:\/\/edubusinesssolutions.com\/#website","url":"https:\/\/edubusinesssolutions.com\/","name":"edu Business Solutions","description":"Maximizing your resources with simple and reliable software","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/edubusinesssolutions.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/edubusinesssolutions.com\/#\/schema\/person\/b9220984960b7e5c6a59a28046301ec8","name":"Leeann Raymond","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/edubusinesssolutions.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/daca114e0f5600dd0d180f315d01022d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/daca114e0f5600dd0d180f315d01022d?s=96&d=mm&r=g","caption":"Leeann Raymond"},"url":"https:\/\/edubusinesssolutions.com\/author\/leeann\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/edubusinesssolutions.com\/wp-content\/uploads\/2018\/09\/data-illustration.jpg","_links":{"self":[{"href":"https:\/\/edubusinesssolutions.com\/wp-json\/wp\/v2\/posts\/117116"}],"collection":[{"href":"https:\/\/edubusinesssolutions.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/edubusinesssolutions.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/edubusinesssolutions.com\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/edubusinesssolutions.com\/wp-json\/wp\/v2\/comments?post=117116"}],"version-history":[{"count":0,"href":"https:\/\/edubusinesssolutions.com\/wp-json\/wp\/v2\/posts\/117116\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/edubusinesssolutions.com\/wp-json\/wp\/v2\/media\/117133"}],"wp:attachment":[{"href":"https:\/\/edubusinesssolutions.com\/wp-json\/wp\/v2\/media?parent=117116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/edubusinesssolutions.com\/wp-json\/wp\/v2\/categories?post=117116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/edubusinesssolutions.com\/wp-json\/wp\/v2\/tags?post=117116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}