Excel Assessment Attached is the excel assessment workbook. Each sheet represents a vendor and the jobs that we expect to complete in a particular year. Most jobs have a program name, item description, job id, quantity, unit cost, setup, freight, associated costs, and a forecast. In the excel sheet please do the following: 1) There are 3 missing headers in the Evergreen spreadsheet, please enter the correct description for the headers. 2) The forecast column in the Evergreen spreadsheet is used to forecast out costs for potential jobs. The forecast is the Total cost of the job including setup and freight. Please use a formula to calculate the cost for each job. 3) In the Vanguard spreadsheet, please calculate the total forecasted costs, excluding all "FULFILLMENT" in cell F2. Please use a formula to calculate the cell. 4) Create a new sheet named "Combined" and incorporate both the Evergreen and Vanguard data. Do your best to keep all the column data in the combined sheet. The combined sheet should have both Evergreen and Vanguard data in the same table so that it can be easily filtered or arranged. 5) Using the "Combined" sheet, create a pivot table in a new sheet titled "Summary" that summarizes the combined data. The pivot table should be able to answer the following questions just by looking at that the data presented: a. How much did Vanguard spend on "Commercial Carryout Bag Law" program? b. What is the average and total forecasted cost for both Evergreen and Vanguard and its associated programs? $1,721,559.04 Totals not including "Fulfillment" Associated Costs PROGRAM DESCRIPTION QUANTITY $ UNIT COST Forecast FULFILLMENT JULY 62 $78.00 AUGUST 21 $94.00 FULFILLMENT FULFILLMENT SEPTEMBER 77 $61.00 $19,832.00 $16,440.84 $16,653.65 $19,375.75 $22,149.05 FULFILLMENT 44 $8.00 FULFILLMENT 9 OCTOBER NOVEMBER DECEMBER JANUARY $16.00 $14.00 FULFILLMENT 82 15 $94.00 FULFILLMENT FULFILLMENT FEBRUARY 85 $83.00 FULFILLMENT 75 $22.00 FULFILLMENT MARCH APRIL IMAY JUNE 79 50 $100.00 $16.00 $15,265.20 $20,034.51 $25,834.96 $23,371.55 $28,947.31 $20,803.38 $22,104.35 $3,879.15 $7,368.97 FULFILLMENT 70 FULFILLMENT Digital Print Orders Digital Print Orders $14,996.00 $14,466.84 $11,956.65 $19,023.75 $22,005.05 $14.117.20 $18,624.51 $18,779.96 $21,721.55 $21,047.31 $20,003.38 $21,334.35 $519.15 $2,238.97 $1,770.26 $1,037.99 $568.58 $1,595.75 $1,266.46 $1.582.78 $1,368.96 $1,043.88 $1,004.64 $11.00 $35.00 $ JULY 96 57 $90.00 73 $76.00 AUGUST SEPTEMBER OCTOBER NOVEMBER 4 $31.00 67 $75.00 DECEMBER 44 $78.00 6 $47.00 Digital Print Orders Digital Print Orders Digital Print Orders Digital Print Orders Digital Print Orders Digital Print Orders Digital Print Orders Digital Print Orders Digital Print Orders Creative Services 15 $29.00 JANUARY FEBRUARY MARCH APRIL + MAY 43 $31.00 $7,318.26 $1,161.99 $5,593.58 $5,027.75 $1,548.46 $2,017.78 $2,701.96 $6,439.88 $1,494.64 $7,050.00 $1,050.00 $3.750.00 $525.00 76 $71.00 JUNE 14 $35.00 $75.00 94 Creative Services 14 $75.00 50 6 25 53 organics illustrations recycling illustrations website title translations donate flyer-Chinese tranisation (1hr art) trash only bin sign-13 translations 5hr art) recycling area sign-15 translations (25hr art) how to recycle - Arabic translation OCP bin flyer translations-Span Chinese (75hr art) recycling illustrations print & mail - July print & mail - Aug print & mail - Sept +6x9 env (5308.14/M x 2 = $616.28) print & mail - Oct print & mail - Nov (actually sent 7) $75.00 $75.00 $75.00 $75.00 $75.00 $75.00 $75.00 $75.00 $37.50 $18.751 $0.00 $56.25 27 Creative Services Creative Services Creative Services Creative Services Creative Services Creative Services Creative Services Digital Print, Collection Bin Decal & Letter Digital Print, Collection Bin Decal & Letter Digital Print, Collection Bin Decal & Letter Digital Print, Collection Bin Decal & Letter Digital Print, Collection Bin Decal & Letter Evergreen Vanguard 45 29 $1,912.50 $3,993.75 $2,025.00 $3,431.25 $2,175.00 $725.88 $574.93 $296.34 586.87 56 $5.76 $403.32 $27.73 95 49 $14.10 $5.76 $5.76 $5.76 $5.76 15 S0.47 $2.791 46 $267.75 + PROGRAM DESCRIPTION QUANTITY $ UNIT COST Associated Costs Forecast print & mail-Dec 41 $5.76 $245.93 $19.36 2 $9.77 $7.84 $0.49 $5.76 32 $5.76 $184.81 print & mail - Jan print & mail - Feb print & mail - May JULY AUGUST 91 $5.76 $3.43 27 $60.00 53 $60.00 SEPTEMBER 35 $60.00 OCTOBER 63 $60.00 NOVEMBER 54 $60.00 DECEMBER 34 $60.00 JANUARY 23 $60.00 FEBRUARY 86 $60.00 MARCH 65 $60.00 APRIL 99 $60.00 MAY 63 $60.00 $527.59 $1,620.00) $3,180.00 $2,100.00 $3,780.00 $3,240.00 $2,040.00 $1,380.00 $5,160.00 $3,900.00 $5,940.00 $3,780.00 $1,560.00 $5,670.84 $5,333.29 $691.98 $2,027.68 $6,278.43 $2,312.44 $768.00 $5,051.41 $3,569.60 $2,295.34 JUNE 26 $60.00 84 $67.51 79 $67.51 $36.42 19 58 Digital Print, Collection Bin Decal & Letter Digital Print, Collection Bin Decal & Letter Digital Print, Collection Bin Decal & Letter Digital Print, Collection Bin Decal & Letter Dedicated Web Hosting Dedicated Web Hosting Dedicated Web Hosting Dedicated Web Hosting Dedicated Web Hosting Dedicated Web Hosting Dedicated Web Hosting Dedicated Web Hosting Dedicated Web Hosting Dedicated Web Hosting Dedicated Web Hosting Dedicated Web Hosting SAFE Disposal Events Mailer-Fall SAFE Disposal Events Mailer-Fall SAFE Disposal Events Mailer-Fall SAFE Disposal Events Mailer-Fall SAFE Disposal Events Mailer-Fall SAFE Disposal Events Mailer-Fall SAFE Disposal Events Mailer-Fall SAFE Disposal Events Mailer-Fall SAFE Disposal Events Mailer-Fall SAFE Disposal Events Mailer-Fall SAFE Disposal Events Mailer-Spring SAFE Disposal Events Mailer-Spring SAFE Disposal Events Mailer-Spring SAFE Disposal Events Mailer-Spring SAFE Disposal Events Mailer-Spring SAFE Disposal Events Mailer-Spring SAFE Disposal Events Mailer-Spring SAFE Disposal Events Mailer-Spring SAFE Disposal Events Mailer-Spring SAFE Disposal Events Mailer-Spring SAFE Disposal Events pdf-Spring Agency Safe Handling portal HHW Brochure: English SAFE PopUps $34.96 93 $67.51 64 $34.96 $75.00 64 91 $12.00 $55.51 $44.62 $55.51 80 34 Bronx summer - list and lettershop Brooklyn summer - print 678.25, list and lettershop 644.010 Brooklyn summer - print 678.25, list and lettershop 644.011 Manhattan summer/fall - print Manhattan summer/fall - map, list, lettershop Queens summer/fall - print Queens summer/fall - list Queens summer/fall - lettershop Sl summer/fall - print, list, lettershop Si summer/fall-print, list, lettershop Brooklyn - print Brooklyn - list, lettershop Manhattan - print Manhattan - list, lettershop Staten Island - print Staten Island - list, lettershop Bronx - print Bronx - list, lettershop Queens - print Queens - list, lettershop translate pdfs, spring (7 languages) 5 $408.00 $487.50 $648.00 $662.30 $34.96 $53.25 $38.23 54 15 $0.00 81 $53.25 29 $44.62 16 $53.25 $38.23 $972.01 $0.00 $191.98 $243.75 $444.00 66 37 $53.25 $3,523.50 $573.45 $5,285.26 $1.293.98 $1,043.98 $2,766.93 $2,414.25 $1,465.62 $6,263.99 $2,550.00 $540.00 $35,263.80 $337.501 $0.00 39 96 $1,151.99 $37.58 $53.25 $75.00 $60.00 34 $0.00 rebrand 9 99 $356.20 reprint translate flyer / Spanish 4 $75.00 $37.50 27 $831.200 55 $0.00 96 $1,614.00 $1,133.19 $0.24 $62.75 59 $525.00 $506.84 $225.00 $112.51 $75.00 $1,600.00 $75.00 $75.00 $22,967,401 $506.84 $155,169.00 $66,970.72 $91.80 $4,612.00 70 48 23 $3.00 $144.00 98 $1.00 95 $0.52 $0.00 37 $144.53 $168.75 $173.00 $49.40 $5,516.36 $ $31,185.01 $35.50 $142.75 50 $623.70 $0.01 71 $0.00 981 $93.75 19 $0.50 $0.50 $156.00 $0.37 $684.00 97 $0.00 $2,495.60 $112.50 77 $398.20 14 12 61 $190.00 14 $1.00 $1.00 96 Schools, Zero Waste Guide Schools, Zero Waste Guide mailing Schools, Zero Waste Posters Schools, ZW Cafeteria Posters Schools, Zero Waste Bin Signs Schools, Zero Waste kits Schools, Zero Waste welcome letter Schools, Zero Waste kit labels Schools, Zero Waste launch card Schools, Zero Waste launch card Schools, Zero Waste launch poster Schools, ZW website: label Schools, ZW website: letter Schools, ZW website: envelope Schools, ZW website: mailing Schools food bin decal Schools coloring books Schools food text decal Compost-distribution label Compost-distribution label Compost-distribution receipt Compost giveback mailers Compost giveback mailing Compost giveback mailing Compost giveback signage Compost giveback signage Organics & Recycling removable sticker Organics & Recycling removable sticker OCP Fall hi-rise mailing OCP Fall general mailer OCP Fall general mailer OCP ZW pledge cards OCP ZW pledge cards OCP ZW pledge thank you cards OCP info pkts envelope OCP info pkts OCP Fall translations OCP Fall translations OCP postcard 1 - BK10 OCP postcard 2 - Q5 bulk Evergreen Vanguard print, translate, creative lettershop & mail: 3 titles all schools print & laminate 4 posters, 3 hr creative print & laminate 5 posters print 3 signs, 1 hr creative assemble, label packets, lettershop + ship print 11x17" print 4x6" print 5x7" digital #80 print 5x7" revise & offset print print print + creative preflight blank 9x12.5 assemble, insert chipboard, lettershop + postage print decals 12.5 X 6" reprint as is print 4" x 1.25" decals print + creative reprint 3-part form? print (OCP dists) list lettershop windmaster posters - 10 designs windmaster arrows (3+6) print 8.5x5.5" spring OCP-print 8.5x5.5" print 650 letter, 350 envelope lettershop, mail 313 print self-mailer w/perf, translation lettershop print redesign, print (coated) design, print (coated) print assemble 75M (mailer,coupon, pledge,sticker) translations into 5 languages, artwork pdf print 5500 x 3 print 38.5M postcard, lettershop 18.728 print postcard 42M, lettershop 39.047 $37.50 $56.25 $0.00 $0.00 $2,964.00 $2,531,490 $52,780.50 $4,778.40 $11,627.50 $70.25 $96.00 $51.00 $1,370.58 $696.00 $1,306.50 $2,952.50 $252.00 51 $1.00 33 $75.00 58 $39.26 $12.00 $33.50 39 71 $40.00 $112.50 14 $18.00 64 $37.50 45 $170.00 $125.40 $1.20 $93.25 3 29 $93.75 $1,187.94 $381.25 $0.00 $112.50 $168.75 2 $102.00 48 $60.96 $30.42 81 $10,917.50 $5,736.75 $1,191.54 $3,085.50 $204.00 $3,038.58 $2,632.77 $896.00 $4,133.28 $1,564.00 $1,256.25 $6,760.00 $2.919.49 $4,098.66 32 $28.00 $0.00 78 $52.51 $37.50 46 $0.00 $34.00 $75.00 13 $281.25 S0.00 52 $130.00 30 $946.69 $65.76 $42.54 32 $2,737.38 + : D E F 74 SO $136.20 $56.25 $10,135.05 1 $93.00 $93.00 84 27 $187.50 67 $0.55 $89.00 $82.00 $332.67 $5.66 $33.39 77 96 $93.75 $37.50 $243.75 95 80 $12.00 $0.00 42 $53.25 $0.00 69 $3.00 $37.50 $162.50 69 $1.36 40 $444.60 $403.10 5 61 $250.20 $112.50 $75.00 $4,203.33 $3,777.50 $562.51 46 $222.40 $45.39 64 37 $75.00 $80.92 74 21 $49.83 B OCP postcard 04 - BK 104 Yiddish - print, mail print postcard 5.5x8.5" OCP postcard 04 - BK 104 Yiddish mailing list, lettershop (quant) OCP packets 04 - BK 104 Yiddish assemble OCP service update postcard 06 BKS7 1x/wk print postcard #M, creative OCP service update postcard 06 BKS7 1x/wk list, lettershop (quant) OCP retailer posters print 1500 ea 2 posters 8.2x14 OCP early setout sticker print, pads of 50 sheets, ream=10 pads (500sheets) Fall Leaf Collection mailer: creative, translation, print Fall Leaf Collection mailer: list and mapping Fall Leaf Collection mailer: lettershop Fall Leaf Collection free bags poster 11x17 laminate Fall Leaf Collection truck poster OCP yard waste decals yard waste only decal OCP yard waste decal reprint decal (9.5x7", 4C+2pms) OCP bin decal print decals OCP bin decal reprint reprint decals OCP Instructions brochure print OCP Instructions pdf translations pdf translations & creative, 10 languages OCP Instructions translations print print 15 languages OCP Instructions brochure reprint reprint OCP bldg mgr 04 BK1&16 letter print OCP bldg mgr 04 BK1816 envelope print OCP bldg mgr mailing list 04 BK1&16 list compilation OCP bldg mgr mailing 04 BK1&16 assemble + lettershop OCP enrollment letter print OCP enrollment letter creative OCP enrollment envelope print OCP enrollment lists BK 360.032 OCP enrollment lists Bx 163.583 OCP enrollment lists Qn 337.817 OCP bldg mgr mailing 05 BK2,7,11,12,13,15 assemble + lettershop OCP enrollment postcard 10+ print print 6x9 OCP enrollment postcard lettershop 10+ lettershop OCP postcard#1 print 04 BK1, BK16 print oversized postcard 04 OCP postcard #1 lettershop 04 BK1, BK16 lettershop 04 OCP service update 04 BK1, BK16 print 04 OCP packet envelope 04 BK1, BK16 print 04 OCP packet assemble 04 BK1, BK16 assemble 04 OCP postcard #2 printing 04 BK1, BK16 print 8.5x11" postcard 04 OCP postcard #2 list 04 BK1, BK16 List 04 Evergreen Vanguard + $93.75 $0.00 $168.75 $0.00 17 $640.00 $46.20 $2.590.50 $5,494.00 $25,709.34 $580.86 $3,415.80 $960.00 $2,236.50 $244.50 $256.34 $17,896.50 $2,090.50 $19,465.53 $14,007.90 $3,467.47 $2,775.00 $6,081.83 $1,046.43 $11,048.75 $21,873.60 $120.00 $7.488.00 $9,922.00 $4,125.00 $5,316.50 $588.00 $1,008.00 $516.00 $10,248.00 $1,475.56 $2.590.00 $6,584.45 $350.00 $1,902.16 $6,300.12 $3,220.00 $9.794.64 $1,140.00 72 $303.80 10 $12.00 36 3 $208.00 $242.00 41 55 35 $75.00 $151.90 $12.00 49 84 $12.00 43 $12.00 84 $122.00 31 $42.76 $150.00 37 $70.00 56 $88.45 $1,631.25 5 59 $0.00 74 $37.50 $70.00 $32.24 $84.63 $35.00 $115.71 $12.00 92 84 $75.00 95 B C D E F 42 $62.32 15 $84.97 $375.00) 95 $12.00 26 $70.00 $26.81 23 $131.25 1 $60.76 $93.75 95 $35.00 9 $56.25 $2,617.44 $1,649.55 $1,140.00 $1,820.00 $747.88 $154.51 $3,325.00 $935.37 $694.56 $350.00 $2.756.251 $2,466.51 $3,325.00 $2,280.81 $258.00 $460.00 $97.68 $12.00 $70.00 68 $121.44 5 100 $27.00 $56.25 $18.75 47 $52.08 95 $35.00 23 $96.72 $56.25 $ 86 $3.00 46 $10.00 44 $12.00 47 $70.00 $32.24 41 $131.25 $131.25 49 $84.63 A OCP postcard #2 lettershop 04 BK1, BK16 lettershop 04 OCP postcard#1 05 BKNO2, BKS13, BKS15 print postcard 05 OCP postcard #1 mailing list 05 list compilation, mapping 05 OCP postcard #1 lettershop 05 lettershop 05 OCP service update 05 print 05 OCP packet envelope 05 print 05 OCP packet assemble 05 assemble 05 OCP postcard#1 06 BKS7, 11, 12 print oversized postcard 06 OCP postcard #1 mailing list 06 list compilation, mapping 06 OCP postcard #1 lettershop 06 lettershop 06 (in homes 5/19?) OCP service update 06 BKS11, BKS12, BKS07 print 06 OCP packet envelope 06 print 06 OCP Spring packet assemble 06 assemble 06 OCP postcard#1 07 BX 10 & 11 print oversized postcard 07 8.5x11" OCP postcard #1 mailing list 07 list compilation OCP postcard #1 mailing list 07 list suppression OCP postcard #1 mailing list 07 list compilation, mapping OCP postcard #1 lettershop 07 lettershop OCP service update 07 print 07 OCP packet envelope 07 print 07 OCP packet assemble 07 Jassemble 07 What To Recycle flyer - Russian translate, creative, print Building Sign - Russian translate, creative, print Bin Signs - Blue and Green reprint 60m green, 55m blue Bin Signs E/C - Blue print 16M blue Indoor Decals - Blue and Green reprint 72m ea Indoor Decals - Blue and Green rebrand, reprint 72m ea Text Decals - Blue and Green reprint 30m ea Text Decals - Blue and Green reprint 30m ea How To Recycle flyer - Korean translate, creative, print How To Recycle flyer - Spanish reprint How To Recycle flyer - Spanish rebrand and reprint Zero Waste Bookmarks rebrand and print Zero Waste Bookmarks rebrand and print Area Decal redesign & print 11.5 x 3" Text Decals - Trash Only reprint 30m ea 11.5 x 3" Outdoor Decals - Blue and Green reprint 150M green, 142.8M blue Recycling Checklist Removable Sticker redesign & print Sticker rolls (500/roll) 40M X3 lots: Ox30, Recycling, Organics E-waste illegal setout sticker rebrand, reprint Evergreen Vanguard + 63 $35.00 $120.00 20 $207.20 $487.50 88 $592.00 $225.00 85 $0.00 $528.00 $3,290.00 $1,453.09 $4,278.12 $2,325.00 $4,631.50 $52,321.00 $4,195.60 $5,218.56 $7,298.40 $15,036.72 $5,089.93 $4,744.85 $8,700.50 $3,313.90 98 $150.00 $0.00 $49.36 $51.72 $364.92 $364.92 $86.27 S86.27 20 41 $75.00 59 $0.00 55 $0.00 40 $207.20 $412.50 62 $53.45 $0.00 8 $51.75 $262.50 $676.50 86 $131.25 $2,504.85 30 $655.80 25 16 $27.60 $21.86 $145.23 $98.97 $353.40 $164.82 $8.23 $440.10 24 $56.25 $75.00 $93.75 $56.25 $0.00 $43.75 $3,687.00 $1,658.52 $8,575.35 $15,878.97| $781.85 $5,324.95 96 95 12 QUANTITY 99 71 $ UNIT COST $75.00 $190.00 $684.00 $419.00 $265.51 43 Forecast $7,437.50 $15,162.50 $29,767.00 $18,860.00 $9,021.32 $278.84 $487.50 45 32 29 $0.25 $90.00 5 Associated Costs $12.50 $1,672.50 $355.00 $5.00 $525.00 $271.59 $37.50 $350.00 $268.63 $268.53 $37.50 $125.00 $75.00 98 $0.40 93 PROGRAM e-cycleNYC resident flyer - Russian E-waste collection pilot SI E-waste truck decal donateNYC Partner Brochure donateNYC Program Brochure donateNYC vendor postcard mailing donateNYC marathon posters Pumpkin Smash posters & flyers Leaf Crunch posters & flyers Compost Project business cards Compost Project business cards Compost Project business cards NYCCP Brochure Tip Sheets Tip Sheets Master Composter Manual Outdoor Composting brochure Indoor Worm Composting brochure Compost Distribution Info Card NYCzero waste e-news $1.00 DESCRIPTION translate, artwork (pdf only) card 5x7 (6@190>trash,3M@.30ea3@ 22 ea) 8.5x11" reprint 24 page) redesign, print (8 page) creative, print 3M, mail 2295 digital print, mount on foamcore print print (4 lots 105@1, 3 lots 365@.40) print 17 lots print additional lots print 13 additional lots (11 versions) rebrand & print reprint 5 lots reprint 1 lot revise, print & assemble reprint rebrand & print print 27 $50.00 23 $100.00 19 $70.00 1 $91.38 97 $0.00 80 $0.00 33 $90.70 $98.44 $44.87 $296.36 $335.83 $119.00 $0.011) $431.25 $0.00 2 $389.20 $361.63 $1,618.53 $2,337.50 $1,455.00 $166.38 $8,797.90 $7,875.20 $1,911.96 $592.72 $3,022.47 $4,778.75 $300.22 $2,520.00 $724.03 $300.63 $300.92 $723.00 $722.70 9 $0.00 40 $18.75 $300.00 JULY-AUGUST-Zw summer 20 FULFILLMENT 36 $70.00 89 $4.764 $0.011 57 $300.00 $300.00 $300.00 84 78 $300.00 6 $0.011 $5.423 $70.450 $6.698 $0.011 $300.00 63 $300.00 $722.00 24 $300.00 90 S0.011 $300.01 65 $0.011 lettershop 07 SEPTEMBER - NYC Organics Collection OCTOBER - give goods find goods NOVEMBER - Fall Leaf Collection Returns DECEMBER - Have a Zero Waste Holiday JANUARY - Take the Zero Waste Pledge FEBRUARY - Carry Reusable Bags MARCH - Organics Curbside Collection APRIL-MAY-Get Free Compost JUNE - Organics Curbside Collection JAN FEB print lettershop edit & reprint print postcard (875@.60) lettershop (828@.91) reprint print mailer, translate lettershop, postage 11 S0.011 NYCzerowaste e-news NYCzero waste e-news NYCzerowaste e-news NYCzerowaste e-news NYCzero waste e-news NYCzero waste e-news NYCzerowaste e-news NYCzerowaste e-news NYCzerowaste e-news Hi-Rise Organics Collection newsletter re-fashionNYC newsletter Commercial Recycling Notice 2 Commercial Recycling Notice 2 Commercial Recycling Notice 3 Commercial Organics Notice 2 Commercial Organics Notice 2 Commercial Organics Notice 1 Commercial Organics Notice 3 Commercial Organics Notice 3 Evergreen Vanguard $276.05 $298.50 $298.44 $0.00 39 99 90 77 $300.26 $301.00 $276.77 $298.62 $298.87 $4,167.90 $3,926.70 $6,321.51 $53.40 $35.49 $8,313.60 $11.938.51 $45.50 S0.011 $42.10 $43.63 $80.88 $0.60 $0.91 $692.80 $644.50 S0.91 $0.00 $93.75 $0.00 89 39 $0.00 12 $0.00 18 $337.51 50 QUANTITY $ UNIT COST Associated Costs 29 $97.58 100 $75.00 $2,250.72 $0.00 $506.25 Forecast $5,080.54 $7,500.00 $5,839.95 $4,591.35 46 $115.95 95 27 $272.63 $63.11 $1.47 67 $521.39 22 $866.25 1 $48.33 $7.76 $7.76 $29.93 $2.57 $618.66 $6.72 $230.00 $230.00 $485.40 80 $1,088.36 $112.50 681 43 DESCRIPTION lettershop & mail 30.781M pdf translations & creative, 10 languages print mailer, translate translations & creative print decal w/registration # print decal w/registration # card 5.5x8.5 w/translations 200M print label + letter, assemble, mail translate print,mail (2503) print 22x28" posters list compilation, june (+merge/purge 13.722@$15/M) list compilation, july (+merge/purge 11.543@$15/M) list compilation, august (+merge/purge 14.561@$15/M) list compilation, september (+merge/purge 13.125@$15/M ) list compilation, october (+merge/purge 12.618@$15/M) list compilation, november (+merge/purge 11,220@$15/M) lettershop, june lettershop, july lettershop, august lettershop, september lettershop, october lettershop, november creative only 21 89 $230.00 $205.83 $173.15 $218.42 $196.88 $189.27 $168.30 16 $230.00 60 $230.00 $1,524.71 $487.97 $50.581.161 $569.46 $10,095.83| $5,003.15 $20,688.42 $3,876.88 $13,989.27 $21,328.30 $2.928.00 $8,540.00 $10,248.00 $1,220.00 $4,514.00 $1,586.00 $1,500.00 92 $230.00 24 $122.00 $0.00 70 $122.00 $0.00 84 $122.00 $0.00 10 $122.00 PROGRAM Commercial Carryout Bag Law Commercial Carryout Bag Law Commercial Carryout Bag Notice 2 Commercial Carryout Bag Notice 2 Commercial Organics Processing decal Commercial Organics Processing decal Carryout Bag Inserts NYCHA FHA mailing NYCHA privately managed HARL PM WCS Truck posters DSNY Guide to Zero mailing list DSNY Guide to Zero mailing list DSNY Guide to Zero mailing list DSNY Guide to Zero mailing list DSNY Guide to Zero mailing list DSNY Guide to Zero mailing list DSNY Guide to Zero mailing DSNY Guide to Zero mailing DSNY Guide to Zero mailing DSNY Guide to Zero mailing DSNY Guide to Zero mailing DSNY Guide to Zero mailing DSNY Annual Report Organics - Puns Organics - Puns Organics - Behind the Bin #1 Organics - Behind the Bin #2 Organics - Behind the Bin #3 Organics - Behind the Bin Organics - Secret Shopper Reward Pkts Organics - Secret Shopper Reward Pkts Organics Participant Thank You Cards Organics - Secret Shopper Reward Pkts Organics - Secret Shopper Reward Pkts Organics - Share My Bin mailers Bulk Collection DSNY Avoiding Common Violations DSNY Avoiding Common Violations DSNY 2017 Desk Calendar DSNY Keep Neighb Clean Evergreen Vanguard $0.00 37 $122.00 $0.00 131 $122.00 $0.00 13 20 $0.00 bus shelter posters + AA 11 $105.00 S429.507 $75.00 $29.50 $14.75 $29.50 88 $0.00 27 $105.00 66 $29.50 $300.00 61 $29.50 $300.00 50 $75.00 361 $0.80 $100.00 56 $0.95 $1,298.00 $901.501 $2,247.00 $2,099.50 $3,750.00 $128.80 $53.20 $4,327.32 $67.20 $74.40 $15,637.76 $5,294.04 $1,125.00 71 $60.42 phone kiosk posters bus shelter posters #1 bus shelter posters #2 bus shelter posters #3 bus shelter posters BK2-15-13-1-15 (creative only) assemble bag + 2 pieces assemble bag + 3 pieces 3x3" cards. hole punch assemble bag + 3 pieces assemble bag + 4 pieces print & mail 23 host flyer, sticker, envelope, insert, mail; print & mail 17.7M postcard, list, lettershop print 15M english, translations 2M ea sp&chin translation for website reprint proofread & digital proof ONLY Yiddish translation, artwork $37.50 84 $0.80 93 $0.80 $0.00 88 $15,637.76 72 $62.07 $825.00 15 $75.00 $0.00 5 $387.20 $77.44 $75.00 $75.00 $0.00 $0.00 4 $300.000 $2,925.00 39 + QUANTITY $ UNIT COST Associated Costs 29 $97.58 100 $75.00 $2,250.72 $0.00 $506.25 Forecast $5,080.54 $7,500.00 $5,839.95 $4,591.35 46 $115.95 95 27 $272.63 $63.11 $1.47 67 $521.39 22 $866.25 1 $48.33 $7.76 $7.76 $29.93 $2.57 $618.66 $6.72 $230.00 $230.00 $485.40 80 $1,088.36 $112.50 681 43 DESCRIPTION lettershop & mail 30.781M pdf translations & creative, 10 languages print mailer, translate translations & creative print decal w/registration # print decal w/registration # card 5.5x8.5 w/translations 200M print label + letter, assemble, mail translate print,mail (2503) print 22x28" posters list compilation, june (+merge/purge 13.722@$15/M) list compilation, july (+merge/purge 11.543@$15/M) list compilation, august (+merge/purge 14.561@$15/M) list compilation, september (+merge/purge 13.125@$15/M ) list compilation, october (+merge/purge 12.618@$15/M) list compilation, november (+merge/purge 11,220@$15/M) lettershop, june lettershop, july lettershop, august lettershop, september lettershop, october lettershop, november creative only 21 89 $230.00 $205.83 $173.15 $218.42 $196.88 $189.27 $168.30 16 $230.00 60 $230.00 $1,524.71 $487.97 $50.581.161 $569.46 $10,095.83| $5,003.15 $20,688.42 $3,876.88 $13,989.27 $21,328.30 $2.928.00 $8,540.00 $10,248.00 $1,220.00 $4,514.00 $1,586.00 $1,500.00 92 $230.00 24 $122.00 $0.00 70 $122.00 $0.00 84 $122.00 $0.00 10 $122.00 PROGRAM Commercial Carryout Bag Law Commercial Carryout Bag Law Commercial Carryout Bag Notice 2 Commercial Carryout Bag Notice 2 Commercial Organics Processing decal Commercial Organics Processing decal Carryout Bag Inserts NYCHA FHA mailing NYCHA privately managed HARL PM WCS Truck posters DSNY Guide to Zero mailing list DSNY Guide to Zero mailing list DSNY Guide to Zero mailing list DSNY Guide to Zero mailing list DSNY Guide to Zero mailing list DSNY Guide to Zero mailing list DSNY Guide to Zero mailing DSNY Guide to Zero mailing DSNY Guide to Zero mailing DSNY Guide to Zero mailing DSNY Guide to Zero mailing DSNY Guide to Zero mailing DSNY Annual Report Organics - Puns Organics - Puns Organics - Behind the Bin #1 Organics - Behind the Bin #2 Organics - Behind the Bin #3 Organics - Behind the Bin Organics - Secret Shopper Reward Pkts Organics - Secret Shopper Reward Pkts Organics Participant Thank You Cards Organics - Secret Shopper Reward Pkts Organics - Secret Shopper Reward Pkts Organics - Share My Bin mailers Bulk Collection DSNY Avoiding Common Violations DSNY Avoiding Common Violations DSNY 2017 Desk Calendar DSNY Keep Neighb Clean Evergreen Vanguard $0.00 37 $122.00 $0.00 131 $122.00 $0.00 13 20 $0.00 bus shelter posters + AA 11 $105.00 S429.507 $75.00 $29.50 $14.75 $29.50 88 $0.00 27 $105.00 66 $29.50 $300.00 61 $29.50 $300.00 50 $75.00 361 $0.80 $100.00 56 $0.95 $1,298.00 $901.501 $2,247.00 $2,099.50 $3,750.00 $128.80 $53.20 $4,327.32 $67.20 $74.40 $15,637.76 $5,294.04 $1,125.00 71 $60.42 phone kiosk posters bus shelter posters #1 bus shelter posters #2 bus shelter posters #3 bus shelter posters BK2-15-13-1-15 (creative only) assemble bag + 2 pieces assemble bag + 3 pieces 3x3" cards. hole punch assemble bag + 3 pieces assemble bag + 4 pieces print & mail 23 host flyer, sticker, envelope, insert, mail; print & mail 17.7M postcard, list, lettershop print 15M english, translations 2M ea sp&chin translation for website reprint proofread & digital proof ONLY Yiddish translation, artwork $37.50 84 $0.80 93 $0.80 $0.00 88 $15,637.76 72 $62.07 $825.00 15 $75.00 $0.00 5 $387.20 $77.44 $75.00 $75.00 $0.00 $0.00 4 $300.000 $2,925.00 39 + DESCRIPTION QUANTITY $ UNIT COST Associated Costs Forecast 67 $620.43 $168.75 PROGRAM DSNY App Truck Posters DSNY - Talk Trash DSNY - Talk Trash DSNY - Water Bottle Labels 37 $29.80 $562.50 printing 22x28 bus shelter posters #5 banners 2'x10 2 lots of 6700 $41,737.56 $1,665.10 $8,798.00 $213.251 83 $106.00 $0.00 53 $0.25 $200.00 $0.00 $0.001 $0.001 $0.00 $0.00 S0.00 $0.00 $0.00 $0.00 $0.00 $0.00 S0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.001 $0.00 S0.00 $0.00 $0.00 $0.00 $0.001 $0.001 $0.00 S0.00 $0.00 $0.00 $0.00 Evergreen Vanguard $79,075.90 $0.00 Column1 Column2 Column3 QUANTITY SETUP FREIGHT FORECAST 95 397527-70 397527-70 $48,726.55 $ UNIT COST $1.55 $1.55 S0.75 $15.00 $15.00 $0.00 $0.00 30 397527-25 17 $68.00 Outreach: bags Outreach: bags Outreach Outreach: characters Outreach: characters Outreach: characters $85.00 397527-50 146 164 397527-50 397527-82 154 $200.00 $0.00 Little Berry 190t Shopper Tote - 200k Little Berry 190t Shopper Tote-reprint Business Card Holders Costumes: storage 6 month Jul-Dec Costumes: storage 6 month Jan-Jun Costume appearance: Bk Cyclones Costume appearance: Summer Sts Costume appearance: SAFE Bk Costume appearance: Q SAFE Costume appearance: Bk St Tree Costume appearance: Big Reuse $1,740.00 $2,065.00 397527-87 Outreach: characters 191 $1,897.00 $0.00 397527-90 Outreach: characters 170 $0.00 397527-91 150 $35.00 $54.00 $54.00 Outreach: characters Outreach: characters $1,215.00 $1,695.00 $660.00 $0.00 397527-92 199 $0.00 397527-93 Outreach: characters 109 $548.00 $1,695.00 $0.00 397527-94 Outreach: characters Costume appearance: M SAFE 148 $120.00 $1,695.00 $0.00 397527-96 149 $21.00 $0.00 397527-97 30 $0.00 $21.00 $100.00 397527-98 86 $0.00 397527-99 Outreach: characters Outreach: characters Outreach: characters Outreach: characters Outreach: characters Outreach: characters Outreach: characters 50 $215.00 $0.00 397527-102 81 $15.00 $660.00 $1,720.00 $1,160.00 $270.00 $660.00 $780.00 $302.50 $1,695.00 $2,153.00 $0.00 397527-111 176 $0.00 397527-112 13 $1,533.00 $1,330.00 $1,300.00 $0.00 397527-113 Outreach: characters 199 $0.00 397527-114 Outreach: characters 54 $315.00 397527-115 Outreach: characters 147 $351.00 $1,160.00 $1,270.00 397527-116 Outreach: characters 77 $348.00 397527-117 Outreach: characters 53 $765.00 $3,848.00 $335.00 397527-118 Costume appearance: Q5 St Tree Costume appearance: ZWS Launch Costume appearance: PumpSmash Costume appearance: OCP Q11 Costume appearance: Q11 St Tree Costume appearance: M FIT Costume appearance: Bk Org Expansion Costume appearance: BK SAFE Costume appearance: M Earth Day Union Sq Costume appearance: M Mad SqPk Earth Day Costume appearance: M Car Free Eday Costume appearance: Mckinley Pk/NeighbScil Costume appearance: M SAFE Costume appearance: MNO8 St Tree Costume appearance: BKN1 St Tree Costume appearance: BKS13 St Tree Costume appearance: BK Kindergarten WS Costume appearance: Sl Compost Giveback Costume appearance: MN DOE Sust Showcas Costume appearance: BKNO2 St Tree Costume appearance: ZWS Videoshoot Costume appearance: UN Green Fair Costume appearance: Go Green Bklyn Costume appearance: MN UN Green Fair Outreach: characters 174 $1,415.00 $575.00 397527-129 Outreach: characters 133 $3,215.00 397527-130 Outreach: characters 115 $954.00 $930.00 397527-131 Outreach: characters 36 $79.00 $575.00 397527-132 Outreach: characters 44 $237.50 397527-133 Outreach: characters 193 $2,317.00 $2,313.00 $918.00 $1,390.00 $270.00 397527-134 Outreach: characters 13 397527-135 Outreach: characters 126 $640.00 397527-136 Outreach: characters 16 $270.00 397527-tba Outreach: characters 177 $1,925.00 $1,163.00 $2,616.00 $2,111.00 $1,741.00 $1,187.50 397527-tba Outreach: characters 158 $1,640.00 $740.00 397527-tba Outreach: characters 169 NSOLLAR Evergreen Vanguard $79,075.90 $0.00 $48,726.55 S UNIT COST Column1 Column2 Column3 QUANTITY SETUP FREIGHT FORECAST 397527-tba Outreach: characters 61 $2,965.00 $2.991.00 397527-tba Outreach: characters 125 $385.00 $1,720.00 $1,917.50 397527-tba Outreach: characters 108 $733.00 397527-tba 102 $770.00 Outreach: characters 40 $237.50 397527-tba 397527-19R 34 397527-19R Outreach: characters 199 $1,816.00 $467.00 $1,497.00 $1,324.00 $1,722.00 $7.50 $10.751 397527-19R Outreach: characters 183 $0.00 397527-67 83 $335.00 SO-50021-1 55 $347.50 $347.50 SO-50021-1 38 $10.75 $343.75 SO-49728-1 116 $8.75 $20.00 $85.00 397527-39 185 $9.55 $55.00 397527-39 94 $10.75 $25.00 397527-39 108 $10.75 397527-26 $90.00 148 42 62 397527-26 $35.00 $275.00 $0.00 $55.00 $36.00 $50.00 $48.00 $18.95 397527-71r 397527-710 151 Costume appearance:NYCHA Event Costume appearance: BK ZWS Awards Costume appearance: BK Mermaid Parade Outreach: characters Costume appearance: QN DSNY at Citi Field Costume appearance: ZWS K721 Bklyn OTC Outreach: characters Costumes: brown bin Costumes: leaf bag Costumes: maintenance NYC Compost Project NYCCP tshirts NYC Compost Project NYCCP tshirts reprint + NYC Compost Project NYCCP Master Composter tshirts NYC Compost Project NYCCP aprons - reprint NYC Compost Project NYCCP caps - reprint Outreach - Apparel BRS Staff Caps - reprint Outreach - Apparel BRS Staff Caps - reprint 2 Schools - Zero Waste Schools Zero Waste Schools Banners Schools - Zero Waste Schools Zero Waste Schools Banners - sample Organics Vehicle magnets Organics Vehicle magnets DSNY Vehicle magnets for OAU Organics Cutting Board Schools - Zero Waste Schools Zero Waste Schools T-shirts Schools - Zero Waste Schools Zero Waste Schools T-shirts Schools - Zero Waste Schools Zero Waste Schools T-shirts Schools - Zero Waste Schools ZeroWaste Schools T-shirts reprint Schools - Zero Waste Schools Zero Waste Schools T-shirts reprint Schools - Zero Waste Schools ZeroWaste Schools T-shirts reprint Organics - Apparel ponchos Organics - Apparel ponchos - reorder Organics - Compost Givebacks Windmaster 1004 V4 curb sign frame Organics - Compost Givebacks Windmaster acrylic overlays Organics - Compost Givebacks Windmaster 1004 V4 curb sign frame Organics - Compost Givebacks Windmaster acrylic overlays Schools - ZWS Trophies Trophy 14.5" cup, engraved Organics - Compost Distributid A-frame signs for Street Tree Care events Outreach - Apparel BRS Rain Ponchos Outreach - Apparel Outreach - Apparel BRS Staff 3-in-1 jackets Outreach - Apparel Blue Oxford & Green Polo shirts 397527-71r 121 $18.95 $20.00 397527-83 71 $75.00 $1,800.00 $875.00 397527-85 $1.18 $3.95 $3.80 15 130 397527-85 397527-85 138 $5.80 397527-126 397527-126 169 166 90 $715.00 397527-126 397527-110 $4.10 $3.95 $5.95 $9.80 $9.80 60 SO 50614-1rev 175 $120.00 $75.00 $455.00 397527-109 106 $250.00 397527-109 128 $25.00 397527-109 11 $250.00 $455.00 397527-109 7 $25.00 397527-119 $6.00 $20.00 26 182 S0-50461-1 SO-50079-1 $55.00 $208.00 $32.00 $185.00 $25.00 $475.00 $85.00 107 SO-49862-1 BRS Intern t-shirts 26 $1.00 $10,194.30 $127.00 SO-49712-1 64 $110.00 $175.00 SO-49895-1 103 $2.00 $20,588.00 $625.00 Evergreen Vanguard $79,075.90 $0.00 $48,726.55 $ UNIT COST Column1 Column2 Column3 QUANTITY SETUP FREIGHT FORECAST 397527-143 Outreach Tablecloth bags 167 $5.95 $55.00 20 $1,257.00 $135.00 397527-146 Outreach SO-50132-1/397527-146 Outreach 397527-149 Outreach $1.00 $395.00 38 Tablecloths - fitted Tablecloths - loose Tent - 8x8', back & side walls, carry bags, weights Safety Shirts - orange Messenger bags 187 $1,221.00 $2,820.00 $175.00 S0-50031-1 Outreach 16 $19.50 $80.00 $35.00 397527-137 Outreach 28 $21.00 $25.00 $75.00 Tshirts 22 $250.00 $4,911.35 $275.00 SO-49863-1 Organics 397527-147/S0-50110- Schools - ZWS Plaques (S0-30111-1=20M) Commercial 37 $23.50 $0.00 $75.00 blank plaques B2P pens 24 $1.72 $520.00 Evergreen Vanguard + Excel Assessment Attached is the excel assessment workbook. Each sheet represents a vendor and the jobs that we expect to complete in a particular year. Most jobs have a program name, item description, job id, quantity, unit cost, setup, freight, associated costs, and a forecast. In the excel sheet please do the following: 1) There are 3 missing headers in the Evergreen spreadsheet, please enter the correct description for the headers. 2) The forecast column in the Evergreen spreadsheet is used to forecast out costs for potential jobs. The forecast is the Total cost of the job including setup and freight. Please use a formula to calculate the cost for each job. 3) In the Vanguard spreadsheet, please calculate the total forecasted costs, excluding all "FULFILLMENT" in cell F2. Please use a formula to calculate the cell. 4) Create a new sheet named "Combined" and incorporate both the Evergreen and Vanguard data. Do your best to keep all the column data in the combined sheet. The combined sheet should have both Evergreen and Vanguard data in the same table so that it can be easily filtered or arranged. 5) Using the "Combined" sheet, create a pivot table in a new sheet titled "Summary" that summarizes the combined data. The pivot table should be able to answer the following questions just by looking at that the data presented: a. How much did Vanguard spend on "Commercial Carryout Bag Law" program? b. What is the average and total forecasted cost for both Evergreen and Vanguard and its associated programs? $1,721,559.04 Totals not including "Fulfillment" Associated Costs PROGRAM DESCRIPTION QUANTITY $ UNIT COST Forecast FULFILLMENT JULY 62 $78.00 AUGUST 21 $94.00 FULFILLMENT FULFILLMENT SEPTEMBER 77 $61.00 $19,832.00 $16,440.84 $16,653.65 $19,375.75 $22,149.05 FULFILLMENT 44 $8.00 FULFILLMENT 9 OCTOBER NOVEMBER DECEMBER JANUARY $16.00 $14.00 FULFILLMENT 82 15 $94.00 FULFILLMENT FULFILLMENT FEBRUARY 85 $83.00 FULFILLMENT 75 $22.00 FULFILLMENT MARCH APRIL IMAY JUNE 79 50 $100.00 $16.00 $15,265.20 $20,034.51 $25,834.96 $23,371.55 $28,947.31 $20,803.38 $22,104.35 $3,879.15 $7,368.97 FULFILLMENT 70 FULFILLMENT Digital Print Orders Digital Print Orders $14,996.00 $14,466.84 $11,956.65 $19,023.75 $22,005.05 $14.117.20 $18,624.51 $18,779.96 $21,721.55 $21,047.31 $20,003.38 $21,334.35 $519.15 $2,238.97 $1,770.26 $1,037.99 $568.58 $1,595.75 $1,266.46 $1.582.78 $1,368.96 $1,043.88 $1,004.64 $11.00 $35.00 $ JULY 96 57 $90.00 73 $76.00 AUGUST SEPTEMBER OCTOBER NOVEMBER 4 $31.00 67 $75.00 DECEMBER 44 $78.00 6 $47.00 Digital Print Orders Digital Print Orders Digital Print Orders Digital Print Orders Digital Print Orders Digital Print Orders Digital Print Orders Digital Print Orders Digital Print Orders Creative Services 15 $29.00 JANUARY FEBRUARY MARCH APRIL + MAY 43 $31.00 $7,318.26 $1,161.99 $5,593.58 $5,027.75 $1,548.46 $2,017.78 $2,701.96 $6,439.88 $1,494.64 $7,050.00 $1,050.00 $3.750.00 $525.00 76 $71.00 JUNE 14 $35.00 $75.00 94 Creative Services 14 $75.00 50 6 25 53 organics illustrations recycling illustrations website title translations donate flyer-Chinese tranisation (1hr art) trash only bin sign-13 translations 5hr art) recycling area sign-15 translations (25hr art) how to recycle - Arabic translation OCP bin flyer translations-Span Chinese (75hr art) recycling illustrations print & mail - July print & mail - Aug print & mail - Sept +6x9 env (5308.14/M x 2 = $616.28) print & mail - Oct print & mail - Nov (actually sent 7) $75.00 $75.00 $75.00 $75.00 $75.00 $75.00 $75.00 $75.00 $37.50 $18.751 $0.00 $56.25 27 Creative Services Creative Services Creative Services Creative Services Creative Services Creative Services Creative Services Digital Print, Collection Bin Decal & Letter Digital Print, Collection Bin Decal & Letter Digital Print, Collection Bin Decal & Letter Digital Print, Collection Bin Decal & Letter Digital Print, Collection Bin Decal & Letter Evergreen Vanguard 45 29 $1,912.50 $3,993.75 $2,025.00 $3,431.25 $2,175.00 $725.88 $574.93 $296.34 586.87 56 $5.76 $403.32 $27.73 95 49 $14.10 $5.76 $5.76 $5.76 $5.76 15 S0.47 $2.791 46 $267.75 + PROGRAM DESCRIPTION QUANTITY $ UNIT COST Associated Costs Forecast print & mail-Dec 41 $5.76 $245.93 $19.36 2 $9.77 $7.84 $0.49 $5.76 32 $5.76 $184.81 print & mail - Jan print & mail - Feb print & mail - May JULY AUGUST 91 $5.76 $3.43 27 $60.00 53 $60.00 SEPTEMBER 35 $60.00 OCTOBER 63 $60.00 NOVEMBER 54 $60.00 DECEMBER 34 $60.00 JANUARY 23 $60.00 FEBRUARY 86 $60.00 MARCH 65 $60.00 APRIL 99 $60.00 MAY 63 $60.00 $527.59 $1,620.00) $3,180.00 $2,100.00 $3,780.00 $3,240.00 $2,040.00 $1,380.00 $5,160.00 $3,900.00 $5,940.00 $3,780.00 $1,560.00 $5,670.84 $5,333.29 $691.98 $2,027.68 $6,278.43 $2,312.44 $768.00 $5,051.41 $3,569.60 $2,295.34 JUNE 26 $60.00 84 $67.51 79 $67.51 $36.42 19 58 Digital Print, Collection Bin Decal & Letter Digital Print, Collection Bin Decal & Letter Digital Print, Collection Bin Decal & Letter Digital Print, Collection Bin Decal & Letter Dedicated Web Hosting Dedicated Web Hosting Dedicated Web Hosting Dedicated Web Hosting Dedicated Web Hosting Dedicated Web Hosting Dedicated Web Hosting Dedicated Web Hosting Dedicated Web Hosting Dedicated Web Hosting Dedicated Web Hosting Dedicated Web Hosting SAFE Disposal Events Mailer-Fall SAFE Disposal Events Mailer-Fall SAFE Disposal Events Mailer-Fall SAFE Disposal Events Mailer-Fall SAFE Disposal Events Mailer-Fall SAFE Disposal Events Mailer-Fall SAFE Disposal Events Mailer-Fall SAFE Disposal Events Mailer-Fall SAFE Disposal Events Mailer-Fall SAFE Disposal Events Mailer-Fall SAFE Disposal Events Mailer-Spring SAFE Disposal Events Mailer-Spring SAFE Disposal Events Mailer-Spring SAFE Disposal Events Mailer-Spring SAFE Disposal Events Mailer-Spring SAFE Disposal Events Mailer-Spring SAFE Disposal Events Mailer-Spring SAFE Disposal Events Mailer-Spring SAFE Disposal Events Mailer-Spring SAFE Disposal Events Mailer-Spring SAFE Disposal Events pdf-Spring Agency Safe Handling portal HHW Brochure: English SAFE PopUps $34.96 93 $67.51 64 $34.96 $75.00 64 91 $12.00 $55.51 $44.62 $55.51 80 34 Bronx summer - list and lettershop Brooklyn summer - print 678.25, list and lettershop 644.010 Brooklyn summer - print 678.25, list and lettershop 644.011 Manhattan summer/fall - print Manhattan summer/fall - map, list, lettershop Queens summer/fall - print Queens summer/fall - list Queens summer/fall - lettershop Sl summer/fall - print, list, lettershop Si summer/fall-print, list, lettershop Brooklyn - print Brooklyn - list, lettershop Manhattan - print Manhattan - list, lettershop Staten Island - print Staten Island - list, lettershop Bronx - print Bronx - list, lettershop Queens - print Queens - list, lettershop translate pdfs, spring (7 languages) 5 $408.00 $487.50 $648.00 $662.30 $34.96 $53.25 $38.23 54 15 $0.00 81 $53.25 29 $44.62 16 $53.25 $38.23 $972.01 $0.00 $191.98 $243.75 $444.00 66 37 $53.25 $3,523.50 $573.45 $5,285.26 $1.293.98 $1,043.98 $2,766.93 $2,414.25 $1,465.62 $6,263.99 $2,550.00 $540.00 $35,263.80 $337.501 $0.00 39 96 $1,151.99 $37.58 $53.25 $75.00 $60.00 34 $0.00 rebrand 9 99 $356.20 reprint translate flyer / Spanish 4 $75.00 $37.50 27 $831.200 55 $0.00 96 $1,614.00 $1,133.19 $0.24 $62.75 59 $525.00 $506.84 $225.00 $112.51 $75.00 $1,600.00 $75.00 $75.00 $22,967,401 $506.84 $155,169.00 $66,970.72 $91.80 $4,612.00 70 48 23 $3.00 $144.00 98 $1.00 95 $0.52 $0.00 37 $144.53 $168.75 $173.00 $49.40 $5,516.36 $ $31,185.01 $35.50 $142.75 50 $623.70 $0.01 71 $0.00 981 $93.75 19 $0.50 $0.50 $156.00 $0.37 $684.00 97 $0.00 $2,495.60 $112.50 77 $398.20 14 12 61 $190.00 14 $1.00 $1.00 96 Schools, Zero Waste Guide Schools, Zero Waste Guide mailing Schools, Zero Waste Posters Schools, ZW Cafeteria Posters Schools, Zero Waste Bin Signs Schools, Zero Waste kits Schools, Zero Waste welcome letter Schools, Zero Waste kit labels Schools, Zero Waste launch card Schools, Zero Waste launch card Schools, Zero Waste launch poster Schools, ZW website: label Schools, ZW website: letter Schools, ZW website: envelope Schools, ZW website: mailing Schools food bin decal Schools coloring books Schools food text decal Compost-distribution label Compost-distribution label Compost-distribution receipt Compost giveback mailers Compost giveback mailing Compost giveback mailing Compost giveback signage Compost giveback signage Organics & Recycling removable sticker Organics & Recycling removable sticker OCP Fall hi-rise mailing OCP Fall general mailer OCP Fall general mailer OCP ZW pledge cards OCP ZW pledge cards OCP ZW pledge thank you cards OCP info pkts envelope OCP info pkts OCP Fall translations OCP Fall translations OCP postcard 1 - BK10 OCP postcard 2 - Q5 bulk Evergreen Vanguard print, translate, creative lettershop & mail: 3 titles all schools print & laminate 4 posters, 3 hr creative print & laminate 5 posters print 3 signs, 1 hr creative assemble, label packets, lettershop + ship print 11x17" print 4x6" print 5x7" digital #80 print 5x7" revise & offset print print print + creative preflight blank 9x12.5 assemble, insert chipboard, lettershop + postage print decals 12.5 X 6" reprint as is print 4" x 1.25" decals print + creative reprint 3-part form? print (OCP dists) list lettershop windmaster posters - 10 designs windmaster arrows (3+6) print 8.5x5.5" spring OCP-print 8.5x5.5" print 650 letter, 350 envelope lettershop, mail 313 print self-mailer w/perf, translation lettershop print redesign, print (coated) design, print (coated) print assemble 75M (mailer,coupon, pledge,sticker) translations into 5 languages, artwork pdf print 5500 x 3 print 38.5M postcard, lettershop 18.728 print postcard 42M, lettershop 39.047 $37.50 $56.25 $0.00 $0.00 $2,964.00 $2,531,490 $52,780.50 $4,778.40 $11,627.50 $70.25 $96.00 $51.00 $1,370.58 $696.00 $1,306.50 $2,952.50 $252.00 51 $1.00 33 $75.00 58 $39.26 $12.00 $33.50 39 71 $40.00 $112.50 14 $18.00 64 $37.50 45 $170.00 $125.40 $1.20 $93.25 3 29 $93.75 $1,187.94 $381.25 $0.00 $112.50 $168.75 2 $102.00 48 $60.96 $30.42 81 $10,917.50 $5,736.75 $1,191.54 $3,085.50 $204.00 $3,038.58 $2,632.77 $896.00 $4,133.28 $1,564.00 $1,256.25 $6,760.00 $2.919.49 $4,098.66 32 $28.00 $0.00 78 $52.51 $37.50 46 $0.00 $34.00 $75.00 13 $281.25 S0.00 52 $130.00 30 $946.69 $65.76 $42.54 32 $2,737.38 + : D E F 74 SO $136.20 $56.25 $10,135.05 1 $93.00 $93.00 84 27 $187.50 67 $0.55 $89.00 $82.00 $332.67 $5.66 $33.39 77 96 $93.75 $37.50 $243.75 95 80 $12.00 $0.00 42 $53.25 $0.00 69 $3.00 $37.50 $162.50 69 $1.36 40 $444.60 $403.10 5 61 $250.20 $112.50 $75.00 $4,203.33 $3,777.50 $562.51 46 $222.40 $45.39 64 37 $75.00 $80.92 74 21 $49.83 B OCP postcard 04 - BK 104 Yiddish - print, mail print postcard 5.5x8.5" OCP postcard 04 - BK 104 Yiddish mailing list, lettershop (quant) OCP packets 04 - BK 104 Yiddish assemble OCP service update postcard 06 BKS7 1x/wk print postcard #M, creative OCP service update postcard 06 BKS7 1x/wk list, lettershop (quant) OCP retailer posters print 1500 ea 2 posters 8.2x14 OCP early setout sticker print, pads of 50 sheets, ream=10 pads (500sheets) Fall Leaf Collection mailer: creative, translation, print Fall Leaf Collection mailer: list and mapping Fall Leaf Collection mailer: lettershop Fall Leaf Collection free bags poster 11x17 laminate Fall Leaf Collection truck poster OCP yard waste decals yard waste only decal OCP yard waste decal reprint decal (9.5x7", 4C+2pms) OCP bin decal print decals OCP bin decal reprint reprint decals OCP Instructions brochure print OCP Instructions pdf translations pdf translations & creative, 10 languages OCP Instructions translations print print 15 languages OCP Instructions brochure reprint reprint OCP bldg mgr 04 BK1&16 letter print OCP bldg mgr 04 BK1816 envelope print OCP bldg mgr mailing list 04 BK1&16 list compilation OCP bldg mgr mailing 04 BK1&16 assemble + lettershop OCP enrollment letter print OCP enrollment letter creative OCP enrollment envelope print OCP enrollment lists BK 360.032 OCP enrollment lists Bx 163.583 OCP enrollment lists Qn 337.817 OCP bldg mgr mailing 05 BK2,7,11,12,13,15 assemble + lettershop OCP enrollment postcard 10+ print print 6x9 OCP enrollment postcard lettershop 10+ lettershop OCP postcard#1 print 04 BK1, BK16 print oversized postcard 04 OCP postcard #1 lettershop 04 BK1, BK16 lettershop 04 OCP service update 04 BK1, BK16 print 04 OCP packet envelope 04 BK1, BK16 print 04 OCP packet assemble 04 BK1, BK16 assemble 04 OCP postcard #2 printing 04 BK1, BK16 print 8.5x11" postcard 04 OCP postcard #2 list 04 BK1, BK16 List 04 Evergreen Vanguard + $93.75 $0.00 $168.75 $0.00 17 $640.00 $46.20 $2.590.50 $5,494.00 $25,709.34 $580.86 $3,415.80 $960.00 $2,236.50 $244.50 $256.34 $17,896.50 $2,090.50 $19,465.53 $14,007.90 $3,467.47 $2,775.00 $6,081.83 $1,046.43 $11,048.75 $21,873.60 $120.00 $7.488.00 $9,922.00 $4,125.00 $5,316.50 $588.00 $1,008.00 $516.00 $10,248.00 $1,475.56 $2.590.00 $6,584.45 $350.00 $1,902.16 $6,300.12 $3,220.00 $9.794.64 $1,140.00 72 $303.80 10 $12.00 36 3 $208.00 $242.00 41 55 35 $75.00 $151.90 $12.00 49 84 $12.00 43 $12.00 84 $122.00 31 $42.76 $150.00 37 $70.00 56 $88.45 $1,631.25 5 59 $0.00 74 $37.50 $70.00 $32.24 $84.63 $35.00 $115.71 $12.00 92 84 $75.00 95 B C D E F 42 $62.32 15 $84.97 $375.00) 95 $12.00 26 $70.00 $26.81 23 $131.25 1 $60.76 $93.75 95 $35.00 9 $56.25 $2,617.44 $1,649.55 $1,140.00 $1,820.00 $747.88 $154.51 $3,325.00 $935.37 $694.56 $350.00 $2.756.251 $2,466.51 $3,325.00 $2,280.81 $258.00 $460.00 $97.68 $12.00 $70.00 68 $121.44 5 100 $27.00 $56.25 $18.75 47 $52.08 95 $35.00 23 $96.72 $56.25 $ 86 $3.00 46 $10.00 44 $12.00 47 $70.00 $32.24 41 $131.25 $131.25 49 $84.63 A OCP postcard #2 lettershop 04 BK1, BK16 lettershop 04 OCP postcard#1 05 BKNO2, BKS13, BKS15 print postcard 05 OCP postcard #1 mailing list 05 list compilation, mapping 05 OCP postcard #1 lettershop 05 lettershop 05 OCP service update 05 print 05 OCP packet envelope 05 print 05 OCP packet assemble 05 assemble 05 OCP postcard#1 06 BKS7, 11, 12 print oversized postcard 06 OCP postcard #1 mailing list 06 list compilation, mapping 06 OCP postcard #1 lettershop 06 lettershop 06 (in homes 5/19?) OCP service update 06 BKS11, BKS12, BKS07 print 06 OCP packet envelope 06 print 06 OCP Spring packet assemble 06 assemble 06 OCP postcard#1 07 BX 10 & 11 print oversized postcard 07 8.5x11" OCP postcard #1 mailing list 07 list compilation OCP postcard #1 mailing list 07 list suppression OCP postcard #1 mailing list 07 list compilation, mapping OCP postcard #1 lettershop 07 lettershop OCP service update 07 print 07 OCP packet envelope 07 print 07 OCP packet assemble 07 Jassemble 07 What To Recycle flyer - Russian translate, creative, print Building Sign - Russian translate, creative, print Bin Signs - Blue and Green reprint 60m green, 55m blue Bin Signs E/C - Blue print 16M blue Indoor Decals - Blue and Green reprint 72m ea Indoor Decals - Blue and Green rebrand, reprint 72m ea Text Decals - Blue and Green reprint 30m ea Text Decals - Blue and Green reprint 30m ea How To Recycle flyer - Korean translate, creative, print How To Recycle flyer - Spanish reprint How To Recycle flyer - Spanish rebrand and reprint Zero Waste Bookmarks rebrand and print Zero Waste Bookmarks rebrand and print Area Decal redesign & print 11.5 x 3" Text Decals - Trash Only reprint 30m ea 11.5 x 3" Outdoor Decals - Blue and Green reprint 150M green, 142.8M blue Recycling Checklist Removable Sticker redesign & print Sticker rolls (500/roll) 40M X3 lots: Ox30, Recycling, Organics E-waste illegal setout sticker rebrand, reprint Evergreen Vanguard + 63 $35.00 $120.00 20 $207.20 $487.50 88 $592.00 $225.00 85 $0.00 $528.00 $3,290.00 $1,453.09 $4,278.12 $2,325.00 $4,631.50 $52,321.00 $4,195.60 $5,218.56 $7,298.40 $15,036.72 $5,089.93 $4,744.85 $8,700.50 $3,313.90 98 $150.00 $0.00 $49.36 $51.72 $364.92 $364.92 $86.27 S86.27 20 41 $75.00 59 $0.00 55 $0.00 40 $207.20 $412.50 62 $53.45 $0.00 8 $51.75 $262.50 $676.50 86 $131.25 $2,504.85 30 $655.80 25 16 $27.60 $21.86 $145.23 $98.97 $353.40 $164.82 $8.23 $440.10 24 $56.25 $75.00 $93.75 $56.25 $0.00 $43.75 $3,687.00 $1,658.52 $8,575.35 $15,878.97| $781.85 $5,324.95 96 95 12 QUANTITY 99 71 $ UNIT COST $75.00 $190.00 $684.00 $419.00 $265.51 43 Forecast $7,437.50 $15,162.50 $29,767.00 $18,860.00 $9,021.32 $278.84 $487.50 45 32 29 $0.25 $90.00 5 Associated Costs $12.50 $1,672.50 $355.00 $5.00 $525.00 $271.59 $37.50 $350.00 $268.63 $268.53 $37.50 $125.00 $75.00 98 $0.40 93 PROGRAM e-cycleNYC resident flyer - Russian E-waste collection pilot SI E-waste truck decal donateNYC Partner Brochure donateNYC Program Brochure donateNYC vendor postcard mailing donateNYC marathon posters Pumpkin Smash posters & flyers Leaf Crunch posters & flyers Compost Project business cards Compost Project business cards Compost Project business cards NYCCP Brochure Tip Sheets Tip Sheets Master Composter Manual Outdoor Composting brochure Indoor Worm Composting brochure Compost Distribution Info Card NYCzero waste e-news $1.00 DESCRIPTION translate, artwork (pdf only) card 5x7 (6@190>trash,3M@.30ea3@ 22 ea) 8.5x11" reprint 24 page) redesign, print (8 page) creative, print 3M, mail 2295 digital print, mount on foamcore print print (4 lots 105@1, 3 lots 365@.40) print 17 lots print additional lots print 13 additional lots (11 versions) rebrand & print reprint 5 lots reprint 1 lot revise, print & assemble reprint rebrand & print print 27 $50.00 23 $100.00 19 $70.00 1 $91.38 97 $0.00 80 $0.00 33 $90.70 $98.44 $44.87 $296.36 $335.83 $119.00 $0.011) $431.25 $0.00 2 $389.20 $361.63 $1,618.53 $2,337.50 $1,455.00 $166.38 $8,797.90 $7,875.20 $1,911.96 $592.72 $3,022.47 $4,778.75 $300.22 $2,520.00 $724.03 $300.63 $300.92 $723.00 $722.70 9 $0.00 40 $18.75 $300.00 JULY-AUGUST-Zw summer 20 FULFILLMENT 36 $70.00 89 $4.764 $0.011 57 $300.00 $300.00 $300.00 84 78 $300.00 6 $0.011 $5.423 $70.450 $6.698 $0.011 $300.00 63 $300.00 $722.00 24 $300.00 90 S0.011 $300.01 65 $0.011 lettershop 07 SEPTEMBER - NYC Organics Collection OCTOBER - give goods find goods NOVEMBER - Fall Leaf Collection Returns DECEMBER - Have a Zero Waste Holiday JANUARY - Take the Zero Waste Pledge FEBRUARY - Carry Reusable Bags MARCH - Organics Curbside Collection APRIL-MAY-Get Free Compost JUNE - Organics Curbside Collection JAN FEB print lettershop edit & reprint print postcard (875@.60) lettershop (828@.91) reprint print mailer, translate lettershop, postage 11 S0.011 NYCzerowaste e-news NYCzero waste e-news NYCzerowaste e-news NYCzerowaste e-news NYCzero waste e-news NYCzero waste e-news NYCzerowaste e-news NYCzerowaste e-news NYCzerowaste e-news Hi-Rise Organics Collection newsletter re-fashionNYC newsletter Commercial Recycling Notice 2 Commercial Recycling Notice 2 Commercial Recycling Notice 3 Commercial Organics Notice 2 Commercial Organics Notice 2 Commercial Organics Notice 1 Commercial Organics Notice 3 Commercial Organics Notice 3 Evergreen Vanguard $276.05 $298.50 $298.44 $0.00 39 99 90 77 $300.26 $301.00 $276.77 $298.62 $298.87 $4,167.90 $3,926.70 $6,321.51 $53.40 $35.49 $8,313.60 $11.938.51 $45.50 S0.011 $42.10 $43.63 $80.88 $0.60 $0.91 $692.80 $644.50 S0.91 $0.00 $93.75 $0.00 89 39 $0.00 12 $0.00 18 $337.51 50 QUANTITY $ UNIT COST Associated Costs 29 $97.58 100 $75.00 $2,250.72 $0.00 $506.25 Forecast $5,080.54 $7,500.00 $5,839.95 $4,591.35 46 $115.95 95 27 $272.63 $63.11 $1.47 67 $521.39 22 $866.25 1 $48.33 $7.76 $7.76 $29.93 $2.57 $618.66 $6.72 $230.00 $230.00 $485.40 80 $1,088.36 $112.50 681 43 DESCRIPTION lettershop & mail 30.781M pdf translations & creative, 10 languages print mailer, translate translations & creative print decal w/registration # print decal w/registration # card 5.5x8.5 w/translations 200M print label + letter, assemble, mail translate print,mail (2503) print 22x28" posters list compilation, june (+merge/purge 13.722@$15/M) list compilation, july (+merge/purge 11.543@$15/M) list compilation, august (+merge/purge 14.561@$15/M) list compilation, september (+merge/purge 13.125@$15/M ) list compilation, october (+merge/purge 12.618@$15/M) list compilation, november (+merge/purge 11,220@$15/M) lettershop, june lettershop, july lettershop, august lettershop, september lettershop, october lettershop, november creative only 21 89 $230.00 $205.83 $173.15 $218.42 $196.88 $189.27 $168.30 16 $230.00 60 $230.00 $1,524.71 $487.97 $50.581.161 $569.46 $10,095.83| $5,003.15 $20,688.42 $3,876.88 $13,989.27 $21,328.30 $2.928.00 $8,540.00 $10,248.00 $1,220.00 $4,514.00 $1,586.00 $1,500.00 92 $230.00 24 $122.00 $0.00 70 $122.00 $0.00 84 $122.00 $0.00 10 $122.00 PROGRAM Commercial Carryout Bag Law Commercial Carryout Bag Law Commercial Carryout Bag Notice 2 Commercial Carryout Bag Notice 2 Commercial Organics Processing decal Commercial Organics Processing decal Carryout Bag Inserts NYCHA FHA mailing NYCHA privately managed HARL PM WCS Truck posters DSNY Guide to Zero mailing list DSNY Guide to Zero mailing list DSNY Guide to Zero mailing list DSNY Guide to Zero mailing list DSNY Guide to Zero mailing list DSNY Guide to Zero mailing list DSNY Guide to Zero mailing DSNY Guide to Zero mailing DSNY Guide to Zero mailing DSNY Guide to Zero mailing DSNY Guide to Zero mailing DSNY Guide to Zero mailing DSNY Annual Report Organics - Puns Organics - Puns Organics - Behind the Bin #1 Organics - Behind the Bin #2 Organics - Behind the Bin #3 Organics - Behind the Bin Organics - Secret Shopper Reward Pkts Organics - Secret Shopper Reward Pkts Organics Participant Thank You Cards Organics - Secret Shopper Reward Pkts Organics - Secret Shopper Reward Pkts Organics - Share My Bin mailers Bulk Collection DSNY Avoiding Common Violations DSNY Avoiding Common Violations DSNY 2017 Desk Calendar DSNY Keep Neighb Clean Evergreen Vanguard $0.00 37 $122.00 $0.00 131 $122.00 $0.00 13 20 $0.00 bus shelter posters + AA 11 $105.00 S429.507 $75.00 $29.50 $14.75 $29.50 88 $0.00 27 $105.00 66 $29.50 $300.00 61 $29.50 $300.00 50 $75.00 361 $0.80 $100.00 56 $0.95 $1,298.00 $901.501 $2,247.00 $2,099.50 $3,750.00 $128.80 $53.20 $4,327.32 $67.20 $74.40 $15,637.76 $5,294.04 $1,125.00 71 $60.42 phone kiosk posters bus shelter posters #1 bus shelter posters #2 bus shelter posters #3 bus shelter posters BK2-15-13-1-15 (creative only) assemble bag + 2 pieces assemble bag + 3 pieces 3x3" cards. hole punch assemble bag + 3 pieces assemble bag + 4 pieces print & mail 23 host flyer, sticker, envelope, insert, mail; print & mail 17.7M postcard, list, lettershop print 15M english, translations 2M ea sp&chin translation for website reprint proofread & digital proof ONLY Yiddish translation, artwork $37.50 84 $0.80 93 $0.80 $0.00 88 $15,637.76 72 $62.07 $825.00 15 $75.00 $0.00 5 $387.20 $77.44 $75.00 $75.00 $0.00 $0.00 4 $300.000 $2,925.00 39 + QUANTITY $ UNIT COST Associated Costs 29 $97.58 100 $75.00 $2,250.72 $0.00 $506.25 Forecast $5,080.54 $7,500.00 $5,839.95 $4,591.35 46 $115.95 95 27 $272.63 $63.11 $1.47 67 $521.39 22 $866.25 1 $48.33 $7.76 $7.76 $29.93 $2.57 $618.66 $6.72 $230.00 $230.00 $485.40 80 $1,088.36 $112.50 681 43 DESCRIPTION lettershop & mail 30.781M pdf translations & creative, 10 languages print mailer, translate translations & creative print decal w/registration # print decal w/registration # card 5.5x8.5 w/translations 200M print label + letter, assemble, mail translate print,mail (2503) print 22x28" posters list compilation, june (+merge/purge 13.722@$15/M) list compilation, july (+merge/purge 11.543@$15/M) list compilation, august (+merge/purge 14.561@$15/M) list compilation, september (+merge/purge 13.125@$15/M ) list compilation, october (+merge/purge 12.618@$15/M) list compilation, november (+merge/purge 11,220@$15/M) lettershop, june lettershop, july lettershop, august lettershop, september lettershop, october lettershop, november creative only 21 89 $230.00 $205.83 $173.15 $218.42 $196.88 $189.27 $168.30 16 $230.00 60 $230.00 $1,524.71 $487.97 $50.581.161 $569.46 $10,095.83| $5,003.15 $20,688.42 $3,876.88 $13,989.27 $21,328.30 $2.928.00 $8,540.00 $10,248.00 $1,220.00 $4,514.00 $1,586.00 $1,500.00 92 $230.00 24 $122.00 $0.00 70 $122.00 $0.00 84 $122.00 $0.00 10 $122.00 PROGRAM Commercial Carryout Bag Law Commercial Carryout Bag Law Commercial Carryout Bag Notice 2 Commercial Carryout Bag Notice 2 Commercial Organics Processing decal Commercial Organics Processing decal Carryout Bag Inserts NYCHA FHA mailing NYCHA privately managed HARL PM WCS Truck posters DSNY Guide to Zero mailing list DSNY Guide to Zero mailing list DSNY Guide to Zero mailing list DSNY Guide to Zero mailing list DSNY Guide to Zero mailing list DSNY Guide to Zero mailing list DSNY Guide to Zero mailing DSNY Guide to Zero mailing DSNY Guide to Zero mailing DSNY Guide to Zero mailing DSNY Guide to Zero mailing DSNY Guide to Zero mailing DSNY Annual Report Organics - Puns Organics - Puns Organics - Behind the Bin #1 Organics - Behind the Bin #2 Organics - Behind the Bin #3 Organics - Behind the Bin Organics - Secret Shopper Reward Pkts Organics - Secret Shopper Reward Pkts Organics Participant Thank You Cards Organics - Secret Shopper Reward Pkts Organics - Secret Shopper Reward Pkts Organics - Share My Bin mailers Bulk Collection DSNY Avoiding Common Violations DSNY Avoiding Common Violations DSNY 2017 Desk Calendar DSNY Keep Neighb Clean Evergreen Vanguard $0.00 37 $122.00 $0.00 131 $122.00 $0.00 13 20 $0.00 bus shelter posters + AA 11 $105.00 S429.507 $75.00 $29.50 $14.75 $29.50 88 $0.00 27 $105.00 66 $29.50 $300.00 61 $29.50 $300.00 50 $75.00 361 $0.80 $100.00 56 $0.95 $1,298.00 $901.501 $2,247.00 $2,099.50 $3,750.00 $128.80 $53.20 $4,327.32 $67.20 $74.40 $15,637.76 $5,294.04 $1,125.00 71 $60.42 phone kiosk posters bus shelter posters #1 bus shelter posters #2 bus shelter posters #3 bus shelter posters BK2-15-13-1-15 (creative only) assemble bag + 2 pieces assemble bag + 3 pieces 3x3" cards. hole punch assemble bag + 3 pieces assemble bag + 4 pieces print & mail 23 host flyer, sticker, envelope, insert, mail; print & mail 17.7M postcard, list, lettershop print 15M english, translations 2M ea sp&chin translation for website reprint proofread & digital proof ONLY Yiddish translation, artwork $37.50 84 $0.80 93 $0.80 $0.00 88 $15,637.76 72 $62.07 $825.00 15 $75.00 $0.00 5 $387.20 $77.44 $75.00 $75.00 $0.00 $0.00 4 $300.000 $2,925.00 39 + DESCRIPTION QUANTITY $ UNIT COST Associated Costs Forecast 67 $620.43 $168.75 PROGRAM DSNY App Truck Posters DSNY - Talk Trash DSNY - Talk Trash DSNY - Water Bottle Labels 37 $29.80 $562.50 printing 22x28 bus shelter posters #5 banners 2'x10 2 lots of 6700 $41,737.56 $1,665.10 $8,798.00 $213.251 83 $106.00 $0.00 53 $0.25 $200.00 $0.00 $0.001 $0.001 $0.00 $0.00 S0.00 $0.00 $0.00 $0.00 $0.00 $0.00 S0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.001 $0.00 S0.00 $0.00 $0.00 $0.00 $0.001 $0.001 $0.00 S0.00 $0.00 $0.00 $0.00 Evergreen Vanguard $79,075.90 $0.00 Column1 Column2 Column3 QUANTITY SETUP FREIGHT FORECAST 95 397527-70 397527-70 $48,726.55 $ UNIT COST $1.55 $1.55 S0.75 $15.00 $15.00 $0.00 $0.00 30 397527-25 17 $68.00 Outreach: bags Outreach: bags Outreach Outreach: characters Outreach: characters Outreach: characters $85.00 397527-50 146 164 397527-50 397527-82 154 $200.00 $0.00 Little Berry 190t Shopper Tote - 200k Little Berry 190t Shopper Tote-reprint Business Card Holders Costumes: storage 6 month Jul-Dec Costumes: storage 6 month Jan-Jun Costume appearance: Bk Cyclones Costume appearance: Summer Sts Costume appearance: SAFE Bk Costume appearance: Q SAFE Costume appearance: Bk St Tree Costume appearance: Big Reuse $1,740.00 $2,065.00 397527-87 Outreach: characters 191 $1,897.00 $0.00 397527-90 Outreach: characters 170 $0.00 397527-91 150 $35.00 $54.00 $54.00 Outreach: characters Outreach: characters $1,215.00 $1,695.00 $660.00 $0.00 397527-92 199 $0.00 397527-93 Outreach: characters 109 $548.00 $1,695.00 $0.00 397527-94 Outreach: characters Costume appearance: M SAFE 148 $120.00 $1,695.00 $0.00 397527-96 149 $21.00 $0.00 397527-97 30 $0.00 $21.00 $100.00 397527-98 86 $0.00 397527-99 Outreach: characters Outreach: characters Outreach: characters Outreach: characters Outreach: characters Outreach: characters Outreach: characters 50 $215.00 $0.00 397527-102 81 $15.00 $660.00 $1,720.00 $1,160.00 $270.00 $660.00 $780.00 $302.50 $1,695.00 $2,153.00 $0.00 397527-111 176 $0.00 397527-112 13 $1,533.00 $1,330.00 $1,300.00 $0.00 397527-113 Outreach: characters 199 $0.00 397527-114 Outreach: characters 54 $315.00 397527-115 Outreach: characters 147 $351.00 $1,160.00 $1,270.00 397527-116 Outreach: characters 77 $348.00 397527-117 Outreach: characters 53 $765.00 $3,848.00 $335.00 397527-118 Costume appearance: Q5 St Tree Costume appearance: ZWS Launch Costume appearance: PumpSmash Costume appearance: OCP Q11 Costume appearance: Q11 St Tree Costume appearance: M FIT Costume appearance: Bk Org Expansion Costume appearance: BK SAFE Costume appearance: M Earth Day Union Sq Costume appearance: M Mad SqPk Earth Day Costume appearance: M Car Free Eday Costume appearance: Mckinley Pk/NeighbScil Costume appearance: M SAFE Costume appearance: MNO8 St Tree Costume appearance: BKN1 St Tree Costume appearance: BKS13 St Tree Costume appearance: BK Kindergarten WS Costume appearance: Sl Compost Giveback Costume a