Print it Green, Inc. is a manufacturer of recycled printing supplies.The company began operations on 10/1/2008 and is dedicated to producing sustainable green printing products. Print it Green, Inc. provides recycled laser toner cartridges, recycled ink jet cartridges as well as cases of recycled copy paper to a variety of customers across the United States. |
|
|
|
|
Upper management created several detailed sales forecasts for FY 2010.Now that Print it Green, Inc. is beginning the final quarter of their year, management has requested that a detailed analysis be performed as to whether the company is expected to achieve the forecasted results. |
|
|
|
|
Print it Green's Sales Manager has pulled together the detailed sales forecasts for FY 2010 as well as the inception-to-date sales data from their accounting system (see the additional tabs below).She has requested that an Excel Dashboard be created to illustrate on a detailed basis whether or not the company is expected to achieve total forecasted sales of $1,006,000 for FY 2010. |
|
|
|
|
|
Using at least three of the Excel functions and/or capabilities that we have learned in class, create an Excel Dashboard that will address the Sales Manager's request for Print it Green, Inc. |
|
|
Sales Forecasts FY 2010 Sales Forecast by Month JanFebMarAprMayJunJulAugSepOctNovDecFY 2010 Total Sales$ 82,28082,88083,63083,90083,70083,80083,58083,68083,80084,00085,10085,650$ 1,006,000 FY 2010 Product Sales Forecast by Customer Type Customer TypeProduct JanFebMarAprMayJunJulAugSepOctNovDecFY 2010 CorporateCopy Paper$ 9,670$ 9,750$ 9,840$ 9,880$ 9,850$ 9,870$ 9,840$ 9,850$ 9,870$ 9,890$ 10,030$ 10,100$ 118,440 Ink Jet Cartridges9,94010,01010,10010,13010,11010,12010,09010,11010,12010,15010,28010,340121,500 Toner Cartridges7,6207,6807,7507,8007,7507,7607,7407,7507,7607,7807,8807,93093,200 EducationalCopy Paper9,8009,8509,9309,9409,9409,9509,9509,9409,9509,96010,09010,160119,460 Ink Jet Cartridges8,3408,4008,4808,5108,4908,5008,4708,4808,5008,5208,6308,680102,000 Toner Cartridges6,5006,5506,6106,6306,6106,6206,6006,6206,6206,6406,7306,77079,500 GovernmentalCopy Paper10,97011,05011,15011,18011,16011,17011,14011,15011,17011,20011,34011,420134,100 Ink Jet Cartridges9,3609,4309,5209,5509,5309,5409,5109,5209,5409,5609,6909,750114,500 Toner Cartridges10,08010,16010,25010,28010,26010,27010,24010,26010,27010,30010,43010,500123,300 Total Sales$ 82,280$ 82,880$ 83,630$ 83,900$ 83,700$ 83,800$ 83,580$ 83,680$ 83,800$ 84,000$ 85,100$ 85,650$ 1,006,000 FY 2010 Sales Forecast by Sales Representative Sales RepresentativeForecasted FY 2010 Sales Karen Winthrop$ 236,700 Nathan Clark244,700 Rachel Smith272,600 Walter Jones252,000 Total$ 1,006,000 Sales Data RegionProductCustomer TypeSales Representative31-Oct-0830-Nov-0831-Dec-0831-Jan-0928-Feb-0931-Mar-0930-Apr-0931-May-0930-Jun-0931-Jul-0931-Aug-0930-Sep-0931-Oct-0930-Nov-0931-Dec-0931-Jan-1028-Feb-1031-Mar-1030-Apr-1031-May-1030-Jun-1031-Jul-1031-Aug-1030-Sep-1031-Oct-1030-Nov-1031-Dec-10 EastToner CartridgesCorporateNathan Clark$ 697$ 711$ 713$ 710$ 710$ 724$ 732$ 735$ 742$ 738$ 732$ 749$ 748$ 755$ 755$ 827$ 825$ 826$ 827$ 830$ 830$ 852$ 877$ 884 EastToner CartridgesCorporateRachel Smith356362360358361365368373379382380382387386387463467465470467468469466464 EastToner CartridgesCorporateKaren Winthrop101100101101100101103105105105106106107107106186185186185186188188187190 EastToner CartridgesCorporateWalter Jones104105104105105104105105104104103104103104105186187186185185184185185185 EastToner CartridgesEducationalNathan Clark336338336342339344344345350348350352356353356337334331337341340341342346 EastToner CartridgesEducationalRachel Smith310313310312322322319318320325323322320325327313313315313311317314316313 EastToner CartridgesEducationalKaren Winthrop727733736743745753760756752759759757775775768749759768777782800800824823 EastToner CartridgesEducationalWalter Jones466476473484493494496496506515510505513511506490495494491495495491506508 EastToner CartridgesGovernmentalNathan Clark192191193193195197197197199198201200198199200199201204205203203205207209 EastToner CartridgesGovernmentalRachel Smith784792795812810815822819839844849842838842841845845838832839831848847843 EastToner CartridgesGovernmentalKaren Winthrop764766768770771767764774777787801800797798800812818813811818829835829829 EastToner CartridgesGovernmentalWalter Jones676679676686690690698707705704701697696710703713712722718729746751758760 EastInk Jet CartridgesCorporateNathan Clark725732730739745742735731734751753762755762765739732732733733732745740746 EastInk Jet CartridgesCorporateRachel Smith254254254254259257256264266266267265263265263227227230237241240243241239 EastInk Jet CartridgesCorporateKaren Winthrop872877885891886884886882878894891896905903903861862854852851850849858881 EastInk Jet CartridgesCorporateWalter Jones321324327324327324325327325327334331339347352316317326330331337341350358 EastInk Jet CartridgesEducationalNathan Clark735746745766764760774784791794800817843847847879878872879885896896900903 EastInk Jet CartridgesEducationalRachel Smith472472476482487497500500495499503514525531532562563559559561558557553556 EastInk Jet CartridgesEducationalKaren Winthrop115117117116116118119119121121120120121120120155154153153152152152154157 EastInk Jet CartridgesEducationalWalter Jones460464466475474473469469472472473473473483483522525526522520519516518521 EastInk Jet CartridgesGovernmentalNathan Clark114113115116116118118117120119121122121123123161162161160162162161161160 EastInk Jet CartridgesGovernmentalRachel Smith801798796806798804800801797802803795806803813870886884887888905906899891 EastInk Jet CartridgesGovernmentalKaren Winthrop9129249329399549589539449449419469429459389511,0111,0101,0051,0011,0059971,0019951,010 EastInk Jet CartridgesGovernmentalWalter Jones847855848844838857852852860865880878879881874905923927926932940932939940 EastCopy PaperCorporateNathan Clark645652651650646645651660665663657653654652647644656652655654661665662659 EastCopy PaperCorporateRachel Smith8998929029149399539569699639549579519649639709739771,0019981,0061,0161,0441,0411,033 EastCopy PaperCorporateKaren Winthrop914918929921917921921914928950941941935933926931949940936937945946967970 EastCopy PaperCorporateWalter Jones125126125125124123127126126125126127130131130132132136135135134133135134 EastCopy PaperEducationalNathan Clark9559729649639859851,0091,0231,0341,0471,0431,0561,0701,0781,0849959941,0231,0141,0151,0301,0301,0351,039 EastCopy PaperEducationalRachel Smith704709716709704699701713719727740739737742741647642654649645647645641642 EastCopy PaperEducationalKaren Winthrop233237241241243243246252253255258261262267265174172173178177178177176176 EastCopy PaperEducationalWalter Jones858855854853873868870869891884876887881890909819810810813814816811803803 EastCopy PaperGovernmentalNathan Clark713710722718720713724723720721731744752745760774776772768768765762784785 EastCopy PaperGovernmentalRachel Smith9579779749841,0009971,0051,0091,0061,0091,0161,0351,0431,0491,0451,0481,0491,0701,0861,0991,0941,0841,0971,103 EastCopy PaperGovernmentalKaren Winthrop9871,0061,0251,0351,0471,0481,0521,0601,0641,0601,0781,0781,0841,1001,1051,1051,1041,1051,1261,1291,1531,1421,1441,146 EastCopy PaperGovernmentalWalter Jones535532528530531542547543553551546559570567562557557552551548555551550555 NorthToner CartridgesCorporateNathan Clark475483481478481494492497506509504503514511506584592590585588585589604604 NorthToner CartridgesCorporateRachel Smith989999100100999999101100100100102101100179181180180180181181182181 NorthToner CartridgesCorporateKaren Winthrop820833829850846861857850873869869863863862873948943939955951948942944949 NorthToner CartridgesCorporateWalter Jones568581595596602606607604607605604624618616618698693693698709708711712714 NorthToner CartridgesEducationalNathan Clark304304302302302301304301298299300301303305310299299300308318316316319324 NorthToner CartridgesEducationalRachel Smith166168167167169172174174175176176177177179184167170170174175179180182184 NorthToner CartridgesEducationalKaren Winthrop653652651657651657655651645639637632627625623602604622624628623630625624 NorthToner CartridgesEducationalWalter Jones399404407406406402400397397397395394396397397390399399398394392395400401 NorthToner CartridgesGovernmentalNathan Clark853855857862861867867865866876873890883891898895921934936938944935944966 NorthToner CartridgesGovernmentalRachel Smith803800795789791801815817810817811811818816823825836853848844836848852854 NorthToner CartridgesGovernmentalKaren Winthrop535534533531531538542545553553556551551559554553553549544540547544556551 NorthToner CartridgesGovernmentalWalter Jones206211214212213216214218222221219217216215220225223229228230228226228229 NorthInk Jet CartridgesCorporateNathan Clark640635635638652646648642639660659669676691700661656657654669682675683687 NorthInk Jet CartridgesCorporateRachel Smith408408406406404402399405405404405412410414410381384396397396395394403401 NorthInk Jet CartridgesCorporateKaren Winthrop450460459458459455455453449445453456453461474435432429431428439436439439 NorthInk Jet CartridgesCorporateWalter Jones376375372371369367372380384386389391392393390354356356354351357355364362 NorthInk Jet CartridgesEducationalNathan Clark298303304306303306305304307306304307306313317361359357356354356354356361 NorthInk Jet CartridgesEducationalRachel Smith394394395397399400397399399397399407403404401439440449448447447445449445 NorthInk Jet CartridgesEducationalKaren Winthrop547560560569579587595607608602598603608610617653652646647642647662663668 NorthInk Jet CartridgesEducationalWalter Jones152153153152151153157158158157160160160161160194198199199200200201201200 NorthInk Jet CartridgesGovernmentalNathan Clark749742738749771778781786790790790792804809810848859866862866873876875886 NorthInk Jet CartridgesGovernmentalRachel Smith257259265265266266266266267266267274272270269308309313313314312316317316 NorthInk Jet CartridgesGovernmentalKaren Winthrop114117117117119121121121120119119121120119119156158157157156158160159162 NorthInk Jet CartridgesGovernmentalWalter Jones725735736735732732742741749749764773774791787821830825827822821815830831 NorthCopy PaperCorporateNathan Clark613625626628634652655658664679677677695695698718722738740742757765788805 NorthCopy PaperCorporateRachel Smith221219221219219219220219223225225224229233233236236235234239238244242243 NorthCopy PaperCorporateKaren Winthrop187188189188188187188188188189189192191192191192196196195196195198198198 NorthCopy PaperCorporateWalter Jones9499499569629719911,0141,0361,0481,0421,0611,0861,0961,1141,1081,1151,1281,1391,1301,1211,1111,1071,0971,098 NorthCopy PaperEducationalNathan Clark257263267266270271279283288287286286286291291199206209206212212217218218 NorthCopy PaperEducationalRachel Smith148147146149150154157158160160161162163164166707373747474757474 NorthCopy PaperEducationalKaren Winthrop801794787805805800798794791812820828831828833740750757768777793786782790 NorthCopy PaperEducationalWalter Jones689702712706701702697709717721721717722728731638644646645644647654658660 NorthCopy PaperGovernmentalNathan Clark364372377385392395404403409416420424425422426423427429432432430438439440 NorthCopy PaperGovernmentalRachel Smith740742741748752747759758756754756778787784790806804805803820830835828831 NorthCopy PaperGovernmentalKaren Winthrop773772774775776771768764764761760756756753755761766777781784805808803802 NorthCopy PaperGovernmentalWalter Jones754749757750751756762759757759759764768762768765772767766762781802807811 SouthToner CartridgesCorporateNathan Clark524525527540548548551563559566566573585595601682685693697697714712709703 SouthToner CartridgesCorporateRachel Smith8728738678758768858879069029149249259209179129901,0021,0059991,0051,0171,0261,0291,031 SouthToner CartridgesCorporateKaren Winthrop496492497501496494490487483481485485484486486569566563564563564563571581 SouthToner CartridgesCorporateWalter Jones574576580595603620635636633631626625645660658737748750759769767761772786 SouthToner CartridgesEducationalNathan Clark877885904913917936945940958951949942950946962946943935944935942937951944 SouthToner CartridgesEducationalRachel Smith100100101101102104104103105106105105104104103868586868685878788 SouthToner CartridgesEducationalKaren Winthrop466471471469470469476475478476479484482485482463465462461468466478475474 SouthToner CartridgesEducationalWalter Jones391396404401401401402407406409408411423432430412422424423423423424424420 SouthToner CartridgesGovernmentalNathan Clark679674681678681689685693705703702702717721722718721719721714724730742742 SouthToner CartridgesGovernmentalRachel Smith9499579539539809919851,0001,0071,0041,0031,0021,0071,0051,0001,0049959999991,0181,0161,0081,0051,004 SouthToner CartridgesGovernmentalKaren Winthrop699696691690698705701698703709712725724732725722735731738744740747745740 SouthToner CartridgesGovernmentalWalter Jones548547552560556567566571588589584584587595601601604618619632641641638636 SouthInk Jet CartridgesCorporateNathan Clark412409407403400408414415411420426422423427431389393392389385386386383386 SouthInk Jet CartridgesCorporateRachel Smith869888885880875868860878881894919912920912903872895926939963958951950970 SouthInk Jet CartridgesCorporateKaren Winthrop414414410406404402405409411413419419420418424388385387384382390391388388 SouthInk Jet CartridgesCorporateWalter Jones9849869919899819859829759921,0081,0131,0261,0251,0341,0309879949949889951,0161,0161,0191,009 SouthInk Jet CartridgesEducationalNathan Clark666669687696696706709705708706708701697695691727721729733748757764761759 SouthInk Jet CartridgesEducationalRachel Smith313316318316313311313310312314318315312309313346343343340342343341338339 SouthInk Jet CartridgesEducationalKaren Winthrop772767762780787782780781788790787784781774780831844844864866867867875878 SouthInk Jet CartridgesEducationalWalter Jones9379309299299489489419359419369439439409339379659609599649849789721,0011,001 SouthInk Jet CartridgesGovernmentalNathan Clark478487487486490490493492488487490492497505504542549549557555561556552553 SouthInk Jet CartridgesGovernmentalRachel Smith9559589679779839849769679859921,0059971,0241,0141,0241,0611,0541,0491,0651,0601,0561,0481,0381,034 SouthInk Jet CartridgesGovernmentalKaren Winthrop167168171173172173172172176178180184185184186228227232232232232234238244 SouthInk Jet CartridgesGovernmentalWalter Jones9829749769749831,0091,0009979929881,0121,0391,0561,0651,0611,1061,1141,1091,1131,1091,1011,1041,1101,131 SouthCopy PaperCorporateNathan Clark9269199169249169379389619889881,0001,0131,0111,0141,0171,0341,0311,0261,0291,0481,0461,0451,0481,052 SouthCopy PaperCorporateRachel Smith891896896895913916917921919923915913918920927920925923931941961972973982 SouthCopy PaperCorporateKaren Winthrop306312315316313318316314320320317314323320317314318317319317316315320319 SouthCopy PaperCorporateWalter Jones864866870874871888894897899894888885881901928938958953958963984984978975 SouthCopy PaperEducationalNathan Clark197198200198197200202203206206207211209212212121120121120119118116118120 SouthCopy PaperEducationalRachel Smith585584596597604603602599605605606600615615612518514520517516516518528529 SouthCopy PaperEducationalKaren Winthrop263263267275282280283286291299304303307307308212209209215220217218221225 SouthCopy PaperEducationalWalter Jones420421418416416428431429426426423424423422426333332331329329329332335332 SouthCopy PaperGovernmentalNathan Clark9929939909931,0161,0101,0161,0101,0151,0101,0111,0071,0111,0151,0131,0351,0361,0291,0241,0271,0171,0211,0251,034 SouthCopy PaperGovernmentalRachel Smith9569539569479779789749889791,0009939921,0041,0061,0111,0021,0011,0061,0231,0311,0411,0491,0651,069 SouthCopy PaperGovernmentalKaren Winthrop944949943935928943954954948941937928931928930933940933930928927926919912 SouthCopy PaperGovernmentalWalter Jones10310210210110110110099999910099100999910010099999999100100100 WestToner CartridgesCorporateNathan Clark685689688687685695691685698696698697691686688766762780795804799803805817 WestToner CartridgesCorporateRachel Smith366363363366364368369367368368366366363363361439436434436439439436434438 WestToner CartridgesCorporateKaren Winthrop192196199199198200198199199199200199198200205285283282281280280278277280 WestToner CartridgesCorporateWalter Jones135135134133132133132132133134134137138138140220222224226227226226227229 WestToner CartridgesEducationalNathan Clark177176177179181181183182181180183183185189188173173172174180179181181181 WestToner CartridgesEducationalRachel Smith213215217218224230230236236239237237239237238226224225223221221221222225 WestToner CartridgesEducationalKaren Winthrop162161162162162163166166170170170171170171173162161161161161160163164163 WestToner CartridgesEducationalWalter Jones288292293294292297297298301300297302300306304289294298301302299301300302 WestToner CartridgesGovernmentalNathan Clark160159159158159158160159162164164164164165168169168167166167166168167168 WestToner CartridgesGovernmentalRachel Smith559561558553553554560572574587582592591591592600595599606612615619627626 WestToner CartridgesGovernmentalKaren Winthrop8928989099058988919069009249409409409459519619869909899949929949961,0011,012 WestToner CartridgesGovernmentalWalter Jones101103103106105105106107107110111111111113112111112111111111110109109110 WestInk Jet CartridgesCorporateNathan Clark437433439440442441440437443444455456457455452414421428433436436440442439 WestInk Jet CartridgesCorporateRachel Smith919923924932939951954951943944939930923945970942946960952954961961952981 WestInk Jet CartridgesCorporateKaren Winthrop358358355357360359356363367378376374380380380345344344346349349358355363 WestInk Jet CartridgesCorporateWalter Jones9891,0021,0019929849859829879941,0051,0071,0091,0041,0051,0099769809859949849931,0111,0041,000 WestInk Jet CartridgesEducationalNathan Clark674676673678692687690692686697704711712716709764780780773771771783778783 WestInk Jet CartridgesEducationalRachel Smith815807805812815815822824818818824825817815820853863864865884881887881888 WestInk Jet CartridgesEducationalKaren Winthrop205203202202200201206205209209208210213214213246246249254260258260259259 WestInk Jet CartridgesEducationalWalter Jones248250252257256255255254253254257257256257258296297296296298296295296303 WestInk Jet CartridgesGovernmentalNathan Clark162163166168171174173176178180183184185188188225228227226225225225225228 WestInk Jet CartridgesGovernmentalRachel Smith436436439439447446444446448451448453461458460497494490498503504500500500 WestInk Jet CartridgesGovernmentalKaren Winthrop126126127127130131132132131130130129129132134172172171171173175175178178 WestInk Jet CartridgesGovernmentalWalter Jones9029008999078998968989129309219169189339329529911,0061,0121,0091,0191,0191,0101,0151,015 WestCopy PaperCorporateNathan Clark273272276275276280285285285285283283287288289288289294293292293294296295 WestCopy PaperCorporateRachel Smith9619599539559729729739739719719799849869941,0141,0161,0351,0341,0271,0301,0201,0101,0241,031 WestCopy PaperCorporateKaren Winthrop482478481477477485492496502499499504502506504511514511506507511516513523 WestCopy PaperCorporateWalter Jones516515515526528530530528523529526530528529530540547551557566572570572569 WestCopy PaperEducationalNathan Clark169168170169170174174176175174175176176175174828284848788878889 WestCopy PaperEducationalRachel Smith683679681682679678683680683686690685679675685593611626639638638649663662 WestCopy PaperEducationalKaren Winthrop527522522520523524523521532534542540546556562469473478477473473472479488 WestCopy PaperEducationalWalter Jones881878872887883899919917922914906922921914907836830836829833835845850848 WestCopy PaperGovernmentalNathan Clark362364368370369369375375376377378390392389390393393391400400410412421424 WestCopy PaperGovernmentalRachel Smith736734741742738734727729722718714719717718728730735737738755757771781778 WestCopy PaperGovernmentalKaren Winthrop245243243242248247251250254258261261262265266268268269267266267269269271 WestCopy PaperGovernmentalWalter Jones223221223221222224228230234232235235240242246248249249253253255255259262 Instructions EXCEL DASHBOARD ASSIGNMENT Print it Green, Inc. is a manufacturer of recycled printing supplies. The company began operations on 10/1/2008 and is dedicated to producing sustainable green printing products. Print it Green, Inc. provides recycled laser toner cartridges, recycled ink jet cartridges as well as cases of recycled copy paper to a variety of customers across the United States. Upper management created several detailed sales forecasts for FY 2010. Now that Print it Green, Inc. is beginning the final quarter of their year, management has requested that a detailed analysis be performed as to whether the company is expected to achieve the forecasted results. Print it Green's Sales Manager has pulled together the detailed sales forecasts for FY 2010 as well as the inception-to-date sales data from their accounting system (see the additional tabs below). She has requested that an Excel Dashboard be created to illustrate on a detailed basis whether or not the company is expected to achieve total forecasted sales of $1,006,000 for FY 2010. Using at least three of the Excel functions and/or capabilities that we have learned in class, create an Excel Dashboard that will address the Sales Manager's request for Print it Green, Inc.