Docstoc

Pharmacy Thermal Printer ROI-Costs Calculator

Document Sample
Pharmacy Thermal Printer ROI-Costs Calculator Powered By Docstoc
					                                            Pharmacy NAME                                                             Input Data
                        Capital Budgeting - Return on Investment (ROI) Analysis                                       Calculated Data
                                                 DATE

                                                               Project Overview
    Project Name:                        All Thermal

    Project Sponsor(s):                  Pharmacy, CarePoint Software, Cognitive Thermal Printers, Pharmacy Automation Labels
    Date of Request:                     6/1/2007
    Project Description:
    Replace two Lexmark laser printers with two Cognitive CRx thermal printers for printing both the pill bottle, log, signature, and receipt
    labels, and the patient monographs. Currently the monograph prints everytime and is not needed on refills creating wasted label forms.
    Additionally the monograph runs over to two pages and creates additional waste. The laser often requires service and recently an
    additional printer was added for redundancy backup. The Cognitive monograph printer would only print monographs if requested and
    on new prescriptions at the patient pickup area.




                                                          Prescription Filling Data
    Enter the data related to the normal prescription filling process.
                                                                                                     Value                     UoM
    # Stores                                                                                                 10000    each
    # Prescriptions/store/day                                                                                  250    each
    # Refills/Store/day                                                                                         40    each
    # Hours/Business Day                                                                                        10    hours
    # Business Days/Year                                                                                       308    days
    # Prescriptions/Year/store                                                                               77000    each
    # Prescriptions/Month/store                                                                               6417    each
    # New Prescriptions/Month/store                                                                           5390    each
    # Refills/Month/store                                                                                     1027    each

                                        Laser Hardware and Materials Cost Data (per store)
    Input the costs of the installed laser equipment and consumables used in the filling process per store.
    Laser Printers                                                                                   Value                     UoM
      Printer Cost                                                                            $           1,100.00    $
      # Printers                                                                                                  2   each
      Shipping                                                                                $              75.00    $
      Printer Upgrades (Ethernet, duplexer, trays,…)                                          $             250.00    $
      # Upgrades                                                                                                  2   each
      Warrantied Life                                                                                             1   Years
      Estimated Life                                                                                              4   Years
    Laser Printing Materials
      Label Forms (1K)                                                                        $              65.00    $
      Bond Paper (1K)                                                                         $              25.00    $
      Toner                                                                                   $             145.00    $/Cartridge
      Pages/Toner Cartridge                                                                                  10000    Each
    Laser Printer Service
      Annual Service                                                                          $              1,080     $
      Extended Warranty (2 Year)                                                              $                400    $
    Laser Printer Power
      Rated Power                                                                                            1,100    Watts
      Energy Cost                                                                             $             0.0760    $/KWH




Confidential for Customer Use Only                                   1 of 17                                                         5/18/2012
                                                  Laser Printing Costs (per store)
    This section calculates how much it costs each pharmacy to print using their current laser hardware and consumables.
    Hardware (Ammortized over expected life)                                                      Value                      UoM
      Printer                                                                             $                45.83   $/month
      Shipping                                                                            $                 3.13   $/month
      Upgrades                                                                            $                10.42   $/month
        Total Hardware                                                                    $                59.38   $/month

    Consumables
      Label Forms                                                                         $               417.08   $/month
      Bond Paper                                                                          $               160.42   $/month
      Toner                                                                               $                93.04   $/month
        Total Consumables                                                                 $               670.54   $/month

    Service
      Annual Service                                                                      $                90.00 $/month
      Extended Warranty (2 Year)                                                          $                16.67 $/month
        Total Service                                                                     $               106.67 $/month

    Energy
      Energy Usage                                                                        $                25.08 $/month
        Total Energy                                                                      $                25.08 $/month


                                                   Laser Printing Monthly Costs
                        Total Energy,                                                 Total Hardware,
                        $250,800.00                                                    $593,750.00


                                                                                                            Total Hardware
                    Total Service,                                                                          Total Consumables
                    $1,066,666.67
                                                                                                            Total Service
                                                                                                            Total Energy




                                                                                          Total Consumables,
                                                                                            $6,705,416.67


                                          Summarized Laser Printing Costs (all stores)
    Total Hardware                                                                        $         593,750.00     $/month
    Total Consumables                                                                     $       6,705,416.67     $/month
    Total Service                                                                         $       1,066,666.67     $/month
    Total Energy                                                                          $         250,800.00     $/month
      TOTAL Monthly Costs                                                                 $       8,616,633.33     $/month




Confidential for Customer Use Only                              2 of 17                                                            5/18/2012
                                     Thermal Hardware and Materials Cost Data (per store)
    Input costs of the thermal equipment and consumables used in the filling process per store.
    CRx Printers                                                                                   Value                    UoM
      Printer Cost                                                                          $          1,049.00    $
      # Printers                                                                                               2   each
      Shipping                                                                              $             40.00    $
      Estimated Life                                                                                          6    Years
    Thermal Printing Materials
      Labels (1K)                                                                           $               55.00 $
      Monograph Paper (1K)                                                                  $               35.00 $
    Thermal Printer Service
      Annual Service Contract                                                               $              360.00 $
      Annual Repair Costs                                                                   $               65.00 $
    Thermal Printer Power
      Rated Power                                                                                             150 Watts
      Energy Cost                                                                           $              0.0760 $/KWH



                                                 Thermal Printing Costs (per store)
    This section calculates how much it costs the pharmacy to print using thermal hardware and consumables for all the stores.

    Hardware (Ammortized over expected life)                                                       Value                    UoM
      Printer                                                                               $               29.14 $/month
      Shipping                                                                              $                1.11 $/month
        Total Hardware                                                                      $               30.25 $/month

    Consumables
      Labels (1K)                                                                           $              352.92 $/month
      Monograph Paper (1K)                                                                  $              224.58 $/month
        Total Consumables                                                                   $              577.50 $/month

    Service
      Annual Service Contract                                                               $               30.00 $/month
      Annual Repair Costs                                                                   $                2.71 $/month
        Total Service                                                                       $               32.71 $/month

    Energy
      Energy Usage                                                                          $                3.42 $/month
        Total Energy                                                                        $                3.42 $/month




Confidential for Customer Use Only                               3 of 17                                                          5/18/2012
                                               Thermal Printing Monthly Costs
                                     Total Energy,
                                      $34,200.00
                                                                                Total Hardware,
                    Total Service,                                               $302,500.00
                    $327,083.33                                                                   Total Hardware
                                                                                                  Total Consumables
                                                                                                  Total Service
                                                                                                  Total Energy




                                                                                Total Consumables,
                                                                                  $5,775,000.00



                                       Summarized Thermal Printing Costs (all stores)
    Total Hardware                                                                $        302,500.00   $/month
    Total Consumables                                                             $      5,775,000.00   $/month
    Total Service                                                                 $        327,083.33   $/month
    Total Energy                                                                  $         34,200.00   $/month
      TOTAL Monthly Costs                                                         $      6,438,783.33   $/month




Confidential for Customer Use Only                          4 of 17                                                   5/18/2012
                                    Technology Comparison Summary (Annual Expenses All Stores)
                      $90,000,000

                      $80,000,000
                                                                                              Thermal
                      $70,000,000
                                                                                              Laser
                      $60,000,000
      Dollars/Month




                      $50,000,000

                      $40,000,000

                      $30,000,000

                      $20,000,000

                      $10,000,000

                              $0
                                         Hardware -          Consumables     Service              Energy
                                      Ammortized over
                                     expected printer life

                                     Technology Comparison Summary (Monthly Expenses All Stores)
    Printing Technology                                                                Thermal              Laser
    Hardware - Ammortized over expected printer life                             $        302,500.00   $       593,750.00
    Consumables                                                                  $      5,775,000.00   $     6,705,416.67
    Service                                                                      $        327,083.33   $     1,066,666.67
    Energy                                                                       $         34,200.00   $       250,800.00
      Total Monthly Costs                                                        $      6,438,783.33   $     8,616,633.33

                                     Technology Comparison Summary (Annual Expenses All Stores)
    Printing Technology                                                                Thermal              Laser
    Hardware - Ammortized over expected printer life                             $      3,630,000.00   $     7,125,000.00
    Consumables                                                                  $     69,300,000.00   $    80,465,000.00
    Service                                                                      $      3,925,000.00   $    12,800,000.00
    Energy                                                                       $        410,400.00   $     3,009,600.00
      Total Annual Costs                                                         $     77,265,400.00   $   103,399,600.00




Confidential for Customer Use Only                                5 of 17                                        5/18/2012
                                              Return on Investment         Months
                                                                          8.0
                                          Laser to Thermal Printing Technology Change
                 $180,000,000

                                              Laser
                 $160,000,000
                                              Thermal
                                                                                                      y = 9E+06x + 6E-08
                                              Laser
                 $140,000,000
                                              Thermal

                 $120,000,000

                                                                                                               y = 6E+06x + 2E+07
                 $100,000,000
       Dollars




                  $80,000,000


                  $60,000,000


                  $40,000,000


                  $20,000,000


                          $-
                                1    2    3    4      5   6     7      8      9   10       11   12   13   14    15     16   17      18
                                                                           Month Counter


                                                      Return on Investment Summary
    Thermal Printer H/W Investment                                                              $     20,980,080.00    $
    Monthly Consumables -Thermal                                                                $      5,775,000.00    $/month
    Monthly Service - Thermal                                                                   $        327,083.33    $/month
    Monthly Energy - Thermal                                                                    $         34,200.00    $/month
    Total Monthly Costs - Thermal                                                               $      6,136,283.33    $/month
    Estimated ROI                                                                                                8.0   months

                                                              Investment/ROI Summary
                                         Annual Savings (Dollars)                               $     26,134,200.00
                                         Annual Savings (%)                                                   25.3%
                                         Hardware Investment                                    $     20,980,080.00
                                         Return on Investment (months)                                           8.0




Confidential for Customer Use Only                                  6 of 17                                                              5/18/2012
Confidential for Customer Use Only   7 of 17   5/18/2012
                                                310   day
                                                250   scripts/day
                                             0.0065   $/script
                                              10000   stores
                                     $ 5,037,500.00




Confidential for Customer Use Only                                  8 of 17   5/18/2012
Confidential for Customer Use Only   9 of 17   5/18/2012
                                     1   1     1        1   1   1   1   1        0




Confidential for Customer Use Only           10 of 17                       5/18/2012
                         ######## $   16,019,380 $ 13,539,030    #######   #######   #######   #######   #######   #######
Month                           1               2            3         4         5         6         7         8         9
Laser                    ######## $   17,233,267 $ 25,849,900    #######   #######   #######   #######   #######   #######
Thermal                  ######## $   33,252,647 $ 39,388,930    #######   #######   #######   #######   #######   #######
ROI




Confidential for Customer Use Only                        11 of 17                                                 5/18/2012
Confidential for Customer Use Only   12 of 17   5/18/2012
Confidential for Customer Use Only   13 of 17   5/18/2012
Confidential for Customer Use Only   14 of 17   5/18/2012
Confidential for Customer Use Only   15 of 17   5/18/2012
         0          0          0     0   0   0          0   0   0   8




Confidential for Customer Use Only           16 of 17                   5/18/2012
 #######    #######     #######      #######   #######   #######   #######   #######   #######
      10         11          12           13        14        15        16        17        18
 #######    #######     #######      #######   #######   #######   #######   #######   #######
 #######    #######     #######      #######   #######   #######   #######   #######   #######




Confidential for Customer Use Only                            17 of 17                           5/18/2012

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:5/18/2012
language:
pages:17
fanzhongqing fanzhongqing http://
About