{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Template","Calculations"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Template","index":0,"n_rows":61,"n_cols":40,"rows_kept":61,"cut":false,"hidden":false,"merged":[[34,9,34,10],[15,37,19,37],[20,37,24,37],[12,37,14,37],[2,1,2,6],[3,14,3,15],[3,17,3,18],[3,27,3,28],[3,37,11,37]]}
[null,"Pricing Worksheet",null,null," "]
[null,"Instructions:  A.  Complete yellow cells in Project Plan. B.  Enter outside costs and mark-up (if any).  C.  Enter additional IC's (if any).  D. Complete sales commisision box (if applicable). E. Enter Final Sale Price"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outside Costs","Item","Markup"]
[null,"Project Plan Phase","Description","Resource Class","Resource Person","Estimated Hours","Sale Price","Cost",null,"Description or Vendor","Outside Cost ($)","Mark-Up","Cost with Mark Up",null,"Project Summary",null,null,"Resource Class",null,"Hourly Cost","Hourly Rate","MarkUp",null,null,null,null,null,"Personnel Class",null,null,"Resource Lookup",null,"Total","Cost",null,"Mark-Up",null,"Production","Printing",0.17]
[null,"Banners","5 sizes of Display Banners, 2 versions","Sr. Account Manager","Megan",2,{"$f":"F5*IF(AE5=$R$5,$U$5,IF(AE5=$R$6,$U$6,IF(AE5=$R$7,$U$7,IF(AE5=$R$8,$U$8,IF(AE5=$R$9,$U$9,IF(AE5=$R$10,$U$10,IF(AE5=$R$11,$U$11,IF(AE5=$R$12,$U$12,IF(AE5=$R$13,$U$13,IF(AE5=$R$14,$U$14,IF(AE5=$R$15,$U$15,IF(AE5=$R$16,$U$16,IF(AE5=$R$17,$U$17,IF(AE5=$R$18,$U$18,IF(AE5=$R$19,$U$19,IF(AE5=$R$20,$U$20,IF(AE5=$R$21,$U$21,IF(AE5=$R$21,$U$21,IF(AE5=$R$22,$U$22,IF(AE5=$R$23,$U$23,IF(AE5=$R$24,$U$24,IF(AE5=$R$25,$U$25,))))))))))))))))))))))","v":300},{"$f":"F5*IF(AE5=$R$5,$T$5,IF(AE5=$R$6,$T$6,IF(AE5=$R$7,$T$7,IF(AE5=$R$8,$T$8,IF(AE5=$R$9,$T$9,IF(AE5=$R$10,$T$10,IF(AE5=$R$11,$T$11,IF(AE5=$R$12,$T$12,IF(AE5=$R$13,$T$13,IF(AE5=$R$14,$T$14,IF(AE5=$R$15,$T$15,IF(AE5=$R$16,$T$16,IF(AE5=$R$17,$T$17,IF(AE5=$R$18,$T$18,IF(AE5=$R$19,$T$19,IF(AE5=$R$20,$T$20,IF(AE5=$R$21,$T$21,IF(AE5=$R$25,$T$25,))))))))))))))))))","v":144},null,"Sample Vendor",null,null,{"$f":"K5*(1+L5)","v":0},null,"Dept","Hours",null,1.1000000000000001,"Account Coordintor",{"$f":"Calculations!E19","v":47},120,{"$f":"U5/T5","v":2.5531914893617023},null,null,null,null,null,"N/A",{"$f":"R5","v":1.1000000000000001},null,{"$f":"IF(D5=$S$5,$R$5,IF(D5=$S$6,$R$6,IF(D5=$S$7,$R$7,IF(D5=$S$8,$R$8,IF(D5=$S$9,$R$9,IF(D5=$S$10,$R$10,IF(D5=$S$11,$R$11,IF(D5=$S$12,$R$12,IF(D5=$S$13,$R$13,IF(D5=$S$14,$R$14,IF(D5=$S$15,$R$15,IF(D5=$S$16,$R$16,IF(D5=$S$17,$R$17,IF(D5=$S$18,$R$18,IF(D5=$S$19,$R$19,IF(D5=$S$20,$R$20,IF(D5=$S$21,$R$21,IF(D5=$S$22,$R$22,IF(D5=$S$23,$R$23,IF(D5=$S$24,$R$24,IF(D5=$S$25,$R$25,\"\")))))))))))))))))))))","v":1.3},null,{"$f":"R5","v":1.1000000000000001},{"$f":"SUMIF($AE$5:$AE$42,R5,$H$5:$H$57)","v":0},null,0,null,null,"Photographer",0.15]
[null,null,null,null,null,null,{"$f":"F6*IF(AE6=$R$5,$U$5,IF(AE6=$R$6,$U$6,IF(AE6=$R$7,$U$7,IF(AE6=$R$8,$U$8,IF(AE6=$R$9,$U$9,IF(AE6=$R$10,$U$10,IF(AE6=$R$11,$U$11,IF(AE6=$R$12,$U$12,IF(AE6=$R$13,$U$13,IF(AE6=$R$14,$U$14,IF(AE6=$R$15,$U$15,IF(AE6=$R$16,$U$16,IF(AE6=$R$17,$U$17,IF(AE6=$R$18,$U$18,IF(AE6=$R$19,$U$19,IF(AE6=$R$20,$U$20,IF(AE6=$R$21,$U$21,IF(AE6=$R$21,$U$21,IF(AE6=$R$22,$U$22,IF(AE6=$R$23,$U$23,IF(AE6=$R$24,$U$24,IF(AE6=$R$25,$U$25,))))))))))))))))))))))","v":0},0,null,null,null,null,0,null,"AM",{"$f":"SUMIFS($F$5:$F$57,$AE$5:$AE$57,\">1\",$AE$5:$AE$57,\"<2\")","v":2},null,1.2,"Account Manager",{"$f":"Calculations!E11","v":44},140,{"$f":"U6/T6","v":3.1818181818181817},null,null,null,null,null,"Kyle",{"$f":"R5","v":1.1000000000000001},null,{"$f":"IF(D6=$S$5,$R$5,IF(D6=$S$6,$R$6,IF(D6=$S$7,$R$7,IF(D6=$S$8,$R$8,IF(D6=$S$9,$R$9,IF(D6=$S$10,$R$10,IF(D6=$S$11,$R$11,IF(D6=$S$12,$R$12,IF(D6=$S$13,$R$13,IF(D6=$S$14,$R$14,IF(D6=$S$15,$R$15,IF(D6=$S$16,$R$16,IF(D6=$S$17,$R$17,IF(D6=$S$18,$R$18,IF(D6=$S$19,$R$19,IF(D6=$S$20,$R$20,IF(D6=$S$21,$R$21,IF(D6=$S$22,$R$22,IF(D6=$S$23,$R$23,IF(D6=$S$24,$R$24,IF(D6=$S$25,$R$25,\"\")))))))))))))))))))))","v":""},null,1.2,0,null,0.1,null,null,"Videographer",0.15]
[null,null,null,null,null,null,0,0,null,null,null,null,0,null,"PM",{"$f":"SUMIFS($F$5:$F$57,$AE$5:$AE$57,\">2\",$AE$5:$AE$57,\"<3\")","v":0},null,1.3,"Sr. Account Manager",{"$f":"Calculations!E9","v":72},150,2.0833333333333335,null,null,null,null,null,"Leslie",{"$f":"R7","v":1.3},null,"",null,1.3,144,null,0.15,null,null,"Animation",0.15]
[null,null,null,null,null,null,0,0,null,null,null,null,0,null,"Creative",{"$f":"SUMIFS($F$5:$F$57,$AE$5:$AE$57,\">5\",$AE$5:$AE$57,\"<6\")","v":0},null,1.4,"Account Supervisor",{"$f":"Calculations!E9","v":72},175,2.4305555555555554,null," ",null,null,null,"Chloe",{"$f":"R7","v":1.3},null,"",null,1.4,0,null,0.17,null,null,"Sound/Video Editor",0.15]
[null,null,null,null,null,null,0,0,null,null,null,null,0,null,"Paid Digital",{"$f":"SUMIFS($F$5:$F$57,$AE$5:$AE$57,\">4\",$AE$5:$AE$57,\"<5\")","v":0},null,1.5,"Dir. Client Services",{"$f":"Calculations!E10","v":91},200,2.197802197802198,null,null,null,null,null,"N/A",{"$f":"R8","v":1.4},null,"",null,1.5,0,null,0.2,null,null,"Voice-over",0.15]
[null,null,null,null,null,null,0,0,null,null,null,null,0,null,"Digital",{"$f":"SUMIFS($F$5:$F$57,$AE$5:$AE$57,\">3\",$AE$5:$AE$57,\"<4\")","v":0},null,3,"SEO Strategist",{"$f":"Calculations!E15","v":62},110,1.7741935483870968,null,null,null,null,null,"Megan",{"$f":"R8","v":1.4},null,"",null,3,0,null,0.25,null,null,"Stock Photo/Video",0]
[null,null,null,null,null,null,{"$f":"F11*IF(AE11=$R$5,$U$5,IF(AE11=$R$6,$U$6,IF(AE11=$R$7,$U$7,IF(AE11=$R$8,$U$8,IF(AE11=$R$9,$U$9,IF(AE11=$R$10,$U$10,IF(AE11=$R$11,$U$11,IF(AE11=$R$12,$U$12,IF(AE11=$R$13,$U$13,IF(AE11=$R$14,$U$14,IF(AE11=$R$15,$U$15,IF(AE11=$R$16,$U$16,IF(AE11=$R$17,$U$17,IF(AE11=$R$18,$U$18,IF(AE11=$R$19,$U$19,IF(AE11=$R$20,$U$20,IF(AE11=$R$21,$U$21,IF(AE11=$R$21,$U$21,IF(AE11=$R$22,$U$22,IF(AE11=$R$23,$U$23,IF(AE11=$R$24,$U$24,IF(AE11=$R$25,$U$25,))))))))))))))))))))))","v":0},0,null,null,null,null,0,null,"ICs",{"$f":"SUMIFS($F$5:$F$57,$AE$5:$AE$57,\">6\",$AE$5:$AE$57,\"<7\")","v":0},null,3.1,"Developer 1",{"$f":"Calculations!E15","v":62},175,2.8225806451612905,null,null,null,null,null,"Melissa",{"$f":"R9","v":1.5},null,"",null,3.1,0,null,0.5,null,null,"Vanity phone #'s or URLs",0.15]
[null,null,null,null,null,null,0,0,null,"Total",{"$f":"SUM(K5:K11)","v":0},{"$f":"SUM(L5:L11)","v":0},{"$f":"SUM(M5:M11)","v":0},null,"MD/CEO",{"$f":"SUMIFS($F$5:$F$57,$AE$5:$AE$57,\">7\",$AE$5:$AE$57,\"<8\")","v":0},null,3.2,"Digital Accnt Mgr",{"$f":"Calculations!E19","v":47},200,4.2553191489361701,null,null,null,null,null,"N/A",2.1,null,{"$f":"IF(D12=$S$5,$R$5,IF(D12=$S$6,$R$6,IF(D12=$S$7,$R$7,IF(D12=$S$8,$R$8,IF(D12=$S$9,$R$9,IF(D12=$S$10,$R$10,IF(D12=$S$11,$R$11,IF(D12=$S$12,$R$12,IF(D12=$S$13,$R$13,IF(D12=$S$14,$R$14,IF(D12=$S$15,$R$15,IF(D12=$S$16,$R$16,IF(D12=$S$17,$R$17,IF(D12=$S$18,$R$18,IF(D12=$S$19,$R$19,IF(D12=$S$20,$R$20,IF(D12=$S$21,$R$21,IF(D12=$S$22,$R$22,IF(D12=$S$23,$R$23,IF(D12=$S$24,$R$24,IF(D12=$S$25,$R$25,\"\")))))))))))))))))))))","v":""},null,3.2,0,null,1,null,null,"Station Produced Spots",0.15]
[null,null,null,null,null,null,0,0,null,null,null,null,null,null,"Total",{"$f":"SUM(P6:P12)","v":2},null,3.3,"Dir, Digital Accounts",{"$f":"Calculations!E7","v":98},200,2.0408163265306123,null,null,null,null,null,"Celeste",2.1,null,"",null,3.3,0,null,null,null,"T&E","Travel",0]
[null,null,null,null,null,null,0,0,null,null,"Name/Vendor","Hourly Cost","Hourly To Client",null,null,null,null,4.2,"Paid Digital",{"$f":"Calculations!E6","v":73},185,2.5342465753424657,null,null,null,null,null,"Eddie",{"$f":"R11","v":3.1},null,"",null,4.2,0,null,null,null,null,"Meals",0]
[null,null,null,null,null,null,0,0,null,"Other IC 1",null,null,null,null,null,null,null,5.0999999999999996,"Exec. Creative Director",{"$f":"Calculations!E13","v":98},200,2.0408163265306123,null,null,null,null,null,"Jon",{"$f":"R12","v":3.2},null,"",null,5.0999999999999996,0,null,null,null,null,"Hotels",0]
[null,null,null,null,null,null,0,0,null,"Other IC 2",null,null,null,null,null,null,null,6.1,"IC Anne",85,175,2.0588235294117645,null,null,null,null,null,"Garrick",{"$f":"R14","v":4.2},null,"",null,6.1,0,null,null,null,"Market Research","Research - Moderator",0.15]
[null,null,null,null,null,null,0,0,null,"Other IC 3",null,null,null,null,null,null,null,6.2,"IC Cat",50,125,2.5,null,null,null,null,null,"N/A",{"$f":"R13","v":3.3},null,"",null,6.2,0,null,null,null,null,"Research - Honorarium",0]
[null,null,null,null,null,null,0,0,null,"Other IC 4",null," ",null,null,null,null,null,6.3,"IC Julia",72,150,2.0833333333333335,null,null,null,null,null,"Raheim",{"$f":"R14","v":4.2},null,"",null,6.3,0,null,null,null,null,"Research - Facilities",0]
[null,null,null,null,null,null,0,0,null,"Other IC 5",null,null,null,null,null,null,null,6.4,"IC LeeAnn",55,125,2.2727272727272729,null,null,null,null,null,"Dana",5.0999999999999996,null,"",null,6.4,0,null,null,null,null,"Research - Recruiting",0.15]
[null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,6.5,"IC Other 1",{"$f":"IF(L15=\"\",0,L15)","v":0},0,{"$error":"#DIV/0!"},null,null,null,null,null,"Anne",6.1,null,"",null,6.5,0,null,null,null,null,"Platforms (e.g. MailChimp)",0.15]
[null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,6.6,"IC Other 2",0,0,{"$error":"#DIV/0!"},null,null,null,null,null,"Naghmeh",4.3,null,"",null,6.6,0,null,null,null,"Other","Shipping",0]
[null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,6.7,"IC Other 3",0,0,{"$f":"U22/T22","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Charlie",6.3,null,"",null,{"$f":"R22","v":6.7},0,null,null,null,null,"Postage",0]
[null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,6.8,"IC Other 4",{"$f":"IF(L18=\"\",0,L18)","v":" "},0,{"$error":"#VALUE!"},null,null,null,null,null,"Darlene",6.4,null,"",null,6.8,0,null,null,null,null,"Software",0]
[null,null,null,null,null,null,0,0,null,"Prelim Pricing",null,null,"FINAL Pricing",null,null,null,null,6.9,"IC Other 5",{"$f":"IF(L19=\"\",0,L19)","v":0},{"$f":"IF(M19=\"\",0,M19)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,"Robert",{"$f":"R25","v":7.1},null,"",null,6.9,0,null,null,null,null,"TBD - 0%",0]
[null,null,null,null,null,null,0,0,null,"Prelim Pricing",{"$f":"G58+M12","v":300},null,"Final Sale Price",2500,null,null,null,7.1,"MD/CEO",{"$f":"Calculations!E22","v":149},275,{"$f":"U25/T25","v":1.8456375838926173},null,null,null,null,null,"Stewart",{"$f":"R25","v":7.1},null,{"$f":"IF(D25=$S$5,$R$5,IF(D25=$S$6,$R$6,IF(D25=$S$7,$R$7,IF(D25=$S$8,$R$8,IF(D25=$S$9,$R$9,IF(D25=$S$10,$R$10,IF(D25=$S$11,$R$11,IF(D25=$S$12,$R$12,IF(D25=$S$13,$R$13,IF(D25=$S$14,$R$14,IF(D25=$S$15,$R$15,IF(D25=$S$16,$R$16,IF(D25=$S$17,$R$17,IF(D25=$S$18,$R$18,IF(D25=$S$19,$R$19,IF(D25=$S$20,$R$20,IF(D25=$S$21,$R$21,IF(D25=$S$22,$R$22,IF(D25=$S$23,$R$23,IF(D25=$S$24,$R$24,IF(D25=$S$25,$R$25,\"\")))))))))))))))))))))","v":""},null,{"$f":"R25","v":7.1},0,null,null,null,null,"TBD - 15%",0.15]
[null,null,null,null,null,null,{"$f":"F26*IF(AE26=$R$5,$U$5,IF(AE26=$R$6,$U$6,IF(AE26=$R$7,$U$7,IF(AE26=$R$8,$U$8,IF(AE26=$R$9,$U$9,IF(AE26=$R$10,$U$10,IF(AE26=$R$11,$U$11,IF(AE26=$R$12,$U$12,IF(AE26=$R$13,$U$13,IF(AE26=$R$14,$U$14,IF(AE26=$R$15,$U$15,IF(AE26=$R$16,$U$16,IF(AE26=$R$17,$U$17,IF(AE26=$R$18,$U$18,IF(AE26=$R$19,$U$19,IF(AE26=$R$20,$U$20,IF(AE26=$R$21,$U$21,IF(AE26=$R$21,$U$21,IF(AE26=$R$22,$U$22,IF(AE26=$R$23,$U$23,IF(AE26=$R$24,$U$24,IF(AE26=$R$25,$U$25,))))))))))))))))))))))","v":0},{"$f":"F26*IF(AE26=$R$5,$T$5,IF(AE26=$R$6,$T$6,IF(AE26=$R$7,$T$7,IF(AE26=$R$8,$T$8,IF(AE26=$R$9,$T$9,IF(AE26=$R$10,$T$10,IF(AE26=$R$11,$T$11,IF(AE26=$R$12,$T$12,IF(AE26=$R$13,$T$13,IF(AE26=$R$14,$T$14,IF(AE26=$R$15,$T$15,IF(AE26=$R$16,$T$16,IF(AE26=$R$17,$T$17,IF(AE26=$R$18,$T$18,IF(AE26=$R$19,$T$19,IF(AE26=$R$20,$T$20,IF(AE26=$R$21,$T$21,IF(AE26=$R$25,$T$25,))))))))))))))))))","v":0},null,"Costs",null,null,"Costs",{"$f":"K26","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"Internal Labor",{"$f":"SUM(AH5:AH5:AH15)+AH25","v":144},null,"Internal Labor",144,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"External Labor",{"$f":"SUM(AH16:AH21)","v":0},null,"External Labor",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"Outside Costs",{"$f":"M12","v":0},null,"Outside Costs",0,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"Total Costs",{"$f":"SUM(K27:K29)","v":144},null,"Total Costs",{"$f":"SUM(N27:N29)","v":144},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"Profit",{"$f":"K25-K30","v":156},null,"Profit",{"$f":"N25-N30","v":2356},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"Profit Margin",{"$f":"K31/K25","v":0.52},null,"Profit Margin",{"$f":"N31/N25","v":0.94240000000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"Profit Ratio",{"$f":"K25/K30","v":2.0833333333333335},null,"Profit Ratio",{"$f":"N25/N30","v":17.361111111111111},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"\"3:1\" Price Scenario *",null,null,null,"Approval","Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"Sale Price",{"$f":"(K38*3)+(K39*3)+K40","v":432},null,"Jeff",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"Costs",null,null,"Robert",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"Internal Labor",{"$f":"K27","v":144},null,"Stewart",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"External Labor",{"$f":"K28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,0,null,"Outside Costs",{"$f":"K29","v":0},null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,null,null,"Total Costs",{"$f":"K30","v":144},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,null,null,"Profit",{"$f":"K36-K41","v":288},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,null,null,"Profit Margin",{"$f":"K42/K36","v":0.66666666666666663},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D43=$S$5,$R$5,IF(D43=$S$6,$R$6,IF(D43=$S$7,$R$7,IF(D43=$S$8,$R$8,IF(D43=$S$9,$R$9,IF(D43=$S$10,$R$10,IF(D43=$S$11,$R$11,IF(D43=$S$12,$R$12,IF(D43=$S$13,$R$13,IF(D43=$S$14,$R$14,IF(D43=$S$15,$R$15,IF(D43=$S$16,$R$16,IF(D43=$S$17,$R$17,IF(D43=$S$18,$R$18,IF(D43=$S$19,$R$19,IF(D43=$S$20,$R$20,IF(D43=$S$21,$R$21,IF(D43=$S$22,$R$22,IF(D43=$S$23,$R$23,IF(D43=$S$24,$R$24,IF(D43=$S$25,$R$25,\"\")))))))))))))))))))))","v":""}]
[null,null,null,null,null,null,{"$f":"F44*IF(AE44=$R$5,$U$5,IF(AE44=$R$6,$U$6,IF(AE44=$R$7,$U$7,IF(AE44=$R$8,$U$8,IF(AE44=$R$9,$U$9,IF(AE44=$R$10,$U$10,IF(AE44=$R$11,$U$11,IF(AE44=$R$12,$U$12,IF(AE44=$R$13,$U$13,IF(AE44=$R$14,$U$14,IF(AE44=$R$15,$U$15,IF(AE44=$R$16,$U$16,IF(AE44=$R$17,$U$17,IF(AE44=$R$18,$U$18,IF(AE44=$R$19,$U$19,IF(AE44=$R$20,$U$20,IF(AE44=$R$21,$U$21,IF(AE44=$R$21,$U$21,IF(AE44=$R$22,$U$22,IF(AE44=$R$23,$U$23,IF(AE44=$R$24,$U$24,IF(AE44=$R$25,$U$25,))))))))))))))))))))))","v":0},null,null,"Profit Ratio",{"$f":"K36/K41","v":3},null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D44=$S$5,$R$5,IF(D44=$S$6,$R$6,IF(D44=$S$7,$R$7,IF(D44=$S$8,$R$8,IF(D44=$S$9,$R$9,IF(D44=$S$10,$R$10,IF(D44=$S$11,$R$11,IF(D44=$S$12,$R$12,IF(D44=$S$13,$R$13,IF(D44=$S$14,$R$14,IF(D44=$S$15,$R$15,IF(D44=$S$16,$R$16,IF(D44=$S$17,$R$17,IF(D44=$S$18,$R$18,IF(D44=$S$19,$R$19,IF(D44=$S$20,$R$20,IF(D44=$S$21,$R$21,IF(D44=$S$22,$R$22,IF(D44=$S$23,$R$23,IF(D44=$S$24,$R$24,IF(D44=$S$25,$R$25,\"\")))))))))))))))))))))","v":""}]
[null,null,null,null,null,null,0,null,null,"*Excludes 3:1 markup on Outside Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D45=$S$5,$R$5,IF(D45=$S$6,$R$6,IF(D45=$S$7,$R$7,IF(D45=$S$8,$R$8,IF(D45=$S$9,$R$9,IF(D45=$S$10,$R$10,IF(D45=$S$11,$R$11,IF(D45=$S$12,$R$12,IF(D45=$S$13,$R$13,IF(D45=$S$14,$R$14,IF(D45=$S$15,$R$15,IF(D45=$S$16,$R$16,IF(D45=$S$17,$R$17,IF(D45=$S$18,$R$18,IF(D45=$S$19,$R$19,IF(D45=$S$20,$R$20,IF(D45=$S$21,$R$21,IF(D45=$S$22,$R$22,IF(D45=$S$23,$R$23,IF(D45=$S$24,$R$24,IF(D45=$S$25,$R$25,\"\")))))))))))))))))))))","v":""}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,{"$f":"F56*IF(AE41=$R$5,$T$5,IF(AE41=$R$6,$T$6,IF(AE41=$R$7,$T$7,IF(AE41=$R$8,$T$8,IF(AE41=$R$9,$T$9,IF(AE41=$R$10,$T$10,IF(AE41=$R$11,$T$11,IF(AE41=$R$12,$T$12,IF(AE41=$R$13,$T$13,IF(AE41=$R$14,$T$14,IF(AE41=$R$15,$T$15,IF(AE41=$R$16,$T$16,IF(AE41=$R$17,$T$17,IF(AE41=$R$18,$T$18,IF(AE41=$R$19,$T$19,IF(AE41=$R$20,$T$20,IF(AE41=$R$21,$T$21,IF(AE41=$R$25,$T$25,))))))))))))))))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,0,{"$f":"F57*IF(AE42=$R$5,$T$5,IF(AE42=$R$6,$T$6,IF(AE42=$R$7,$T$7,IF(AE42=$R$8,$T$8,IF(AE42=$R$9,$T$9,IF(AE42=$R$10,$T$10,IF(AE42=$R$11,$T$11,IF(AE42=$R$12,$T$12,IF(AE42=$R$13,$T$13,IF(AE42=$R$14,$T$14,IF(AE42=$R$15,$T$15,IF(AE42=$R$16,$T$16,IF(AE42=$R$17,$T$17,IF(AE42=$R$18,$T$18,IF(AE42=$R$19,$T$19,IF(AE42=$R$20,$T$20,IF(AE42=$R$21,$T$21,IF(AE42=$R$25,$T$25,))))))))))))))))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null," ",null,"Total Hours",{"$f":"SUM(F5:F57)","v":2},{"$f":"SUM(G5:G57)","v":300},{"$f":"SUM(H5:H57)","v":144},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null," "]

{"sheet":"Calculations","index":1,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Dept/Employee","Total"]
[]
[null,"Salary","Sal + Benefits","Hourly Cost","Hourly Cost (Rounded)"]
["    Director Digital Marketing - Raheim Bundle",112500,{"$f":"B6*1.3","v":146250},{"$f":"C6/2000","v":73.125},{"$f":"ROUND(D6,0)","v":73}]
["    Digital Account Director - Jon Silver",150000,{"$f":"B7*1.3","v":195000},97.5,98]
["    Digital Account Supervisor - Garrick Gaffney",92500,120250,60.125,60]
["     Account Supervisor - Megan",110000.00000000001,143000.00000000003,71.500000000000014,72]
["     Acct Director - Melissa Martinez",140000,182000,91,91]
["     Account Manager  - Leslie Hines",67999.999999999985,88399.999999999985,44.199999999999996,44]
["     Account Coordinator  - Chloé Ribotsky",52083,67707.900000000009,33.853950000000005,34]
["     Creative Director - Dana",150000,195000,97.5,98,null," "]
["     Web Programmer - Eddie Olivas",87125,113262.5,56.631250000000001,57]
["Naghmeh Jafarzadeh - Digital Strategist",95000,123500,61.75,62]
["     Project Manager - Tamila Kahng",85000,110500,55.25,55]
["     Associate Project Mgr/Media Coordinator - Celeste Ethington",50749.999999999993,65975,32.987499999999997,33]
["    Business Dev - Kathy Gaughran",0,0,0,0]
["Andrew Ta - Digital Account Manager",73000,94900,47.45,47]
["     Marketing & Office Administrator - Kyle Hojem",37187,48343.1,24.17155,24]
["     CEO - Stewart Gandolf",300000,390000,195,195]
["     Managing Director - TBD",229166,297915.8,148.9579,149]
["     CFO - Jeff Mancino",205000.00000000003,266500.00000000006,133.25000000000003,133]
["     Sr. Accountant - Elisa Negrete",72000,93600,46.8,47]