Help configure the following data onto the excel spread sheet provided.

• Based on the information contained in these financial statement, compute the following 2014 values for each company:
  • Accounts receivable turnover (For VF, use "Net sales" and assume all sales were credit sales)
  • Averagecollectionperiodforaccountsreceivable
  • (Seeattachments)

COLUEIIEIA SPUKIS'WEAR CDh-[FANT CDNSDIJDAI'ED 3'1' A'I'Eh-[ENTS DF OPERATIONS u 1119113311115, cmp share amounts]: YmEhh-ucnb. an: an an: Net EH 5 2,169.55!) 5 1.634.996 5 1,669,565 Cmtuf 311m 1.145.639 941.341 953.169 Emmi": 954.951 343.655 316.394 Selling. annual and Wm expanses 963.363 625.656 596.635 NH aming 511mm 6.956 13.795 13,369 1615615: mop-enigma 193.344 131.794 133.523 161mm m. mt 3.994 5115 339 Mmunmwmmmmmm} (1.1153) WWEW m4: m1) 1mm mime 1mm]: 1:13. 193.521 131.426 133.911? Imam 131me 11} [56.6621 [313131 {349431 Net 1mm 141.359 93.6113 99,359 Net imam lms] math mmmdnginm 4.636 {133} NH imam amilmlihh to Cotumhia Spartan-ear DEEPER? 5 137.173 5 94.341 5 99.359 13311513: [Justina Wm WWW {Nate 1?]: Basic 5 1.9? 5 13'? 5 1.43 [mm 1.94 136 1.46 Weighmd avenge shares mumdjng {Nate 1?}: Basic 69.315? 63.156 61' .6311 151111164 111.631 69.434 63.264 Emancmpanyingmmsmmdllmm autumn w mum'mm Cn-ammnhnm urn: Emu- w unwind-n mm mulbhlu wwmmum mum mum u. mu \"\"6an u. 2m) human W nun-Man: Okra-In . m: mm .1 vall-lnn'" hum\"... an... on"... m: u.- LmAmslwmm Emmy emu-us. mnmemm, a..." pm nmrmw mm p, Wham. mm mm mm, L...\" ammu cnll-nId n.8- sncmm- q\Name Section Date (a) Chapter 8 Comparative Analysis Problem Columbia Sportswear Company vs. VF Corporation Columbia Sportswear VF Corporation (1) Accounts receivable turnover: (2) Average collection period: (b) 475 475 ative Analysis Problem any vs. VF Corporation 475 475 00me snowman comm cmLmAm awn sin-115 411: mm mm Cmmdmmam WWW Mummmns) mm mmmmn) mmumlnmmcmmuum mmnmm m.m,maxmmm,mmmn Wmnaalml) mam-mm\") mummm Tumm mmmsmnawm' mm Amman: mmmmmxm mmwyecmll) Mmmnxmmmll) mmnmlrmms Nmmwcmlzlmmmmm mummmuw mmxmyzbicmmll) Wmuusmm 7mm Wmmoum summ'l'mmv muck mmmmmmmm cmmowwm). 250\"sz 59m mmmmmm 01:31:15) Wm Ammtmdmrmnpmmvnnmmnmml') mmsmmnmnm'm Nmmmummmwmmi) mm rmmmmamamy mummmmmmmm ._..1 1 ms:- 3 nun 212m 91,755 mm mm 354.650 3732; mm mm um mm 1.266;! 12mm 29le mm mm mu sum was run mm x 1.7mm x 1.5mm 1 21:21; x 173,551 mm may: us: 7251 ms w my 3mm 15.72: , 35.535 29:21 us: 12m um was new mm 72.7w 2325 115st \"mi: ma: 3st mm: 12m\" 6 uszu 12mm x Lm2m x Lmsm comm spmuswnm comm consoummz snmvrims or cm mws an mum) can-m... m min: Nnmmn x mm 3 mm : mso mammmmnmmhmm Wm wm sum um um www.mumynnw-n X \"a 1:1 mm m (a!!!) un 7.140 mm um w- W1 mummmnwmm (um) um) (um) man-m Mn mum m mun: mm um um m (mp-a; 341-) L951 mmsmmmm (mm 5.1m runs) 0mm um (0215) um mm mu. um 31.71) mm Ann-inll: mm 122111 15m M... u- m 1.193 5514 (um) 0mm 6va 23545 1,126 mmwmmm mm mzrs mm Cambium-rm Wmmm.muahmud mum 7 7 mummm may (mm mm mumm 112,305 men mw cum-.m (mm mus) (slum) Mamukm-M.Ilxm 71 m m mamlmmgm Gum-I} (nu-6) mm) Cu: alum M m \"mmmm 51,156 my mm W m mm mm (5220:) (mm) (mm!) Mmmmm--wm" 21217 mm mm: mmmmnmmmm 0.1:!) am) am) hummwmn um um Lana W Dim m mm 7 ans) mmmmnmm mm 7 , cmmmWW ma 7 um 7 (hamd (mm (312:!) *mmMm-wm (M550) (ma) \"shimmy-\"mm ("n-n mm m: unmm.y.mmmm mm mm- mm cum-pL's,hlul-lly|- mun mm yum Cm-nqmuktx,ndnlyw : 013551 mm x mm wmuimmm mmmwgmcmhnrmmx : sjysx : mu 3 mos wmimm m mm;mmmmm 7m sws 5:13 Sqmnmmmmmmmzmmmm \fcomma spoxmnm comm-w coKsoLIDATEn snmmms or mum mm' 7......\"me ..._ A . ...7. 2:2:- 7.1:\" . _ .... .. .... 1.. lAuVmumeml mzm ; um ; 1mm\" x w x 7 x mm \"a... 7 7 m 7 7 m mmmmm William-ma 7...\w mum/\"Ian o..,.m..as..__...m.,.u..m 1.\". lube- mam-pel-veimtl-l mu mun-um m... (InJ mm, mm. ,m :- mn-m mu Mm: hmxpmn pm mn y-nmun-l yin-anon!!!\" mm mum... aim m mm: m... Amnhl ulb-'Ipmrv'u ml: 1.. mun-Max an! DUI-Inn rum-J mun-nu m... (InJ m. an. ,m :- mn-m mu lulu-mum: m m mmmcuum hm 2-: :- mn-m m: mum mm. am. Lin)miud-rixy-l u. mun-em m.\" ohm-tum. m an.) D-ydnn mm mm... mun-mm n... w nu.- mIu munu... and...\" munmlkh wen...\" hum-am wulnum! nmu.' mm; 9 gm as 49.30) W5 mum mu 5.115 mu mm on) Jun an! (an m 1 mos; x 55595) xxzmw mm: my man \"a mu was) N\") am mm) Inn man 542 m 75 \"52294 nag-x \"193! nu ma mus") Wu 3.367 mu mm um um) am (a!) w mum _uw n gs; su wmum m. \"mum n. rrl-nm Mmmmummmmmwnpuhlunm bur-mm m... m Iruda- Manhunt. mar-w..-\" mum-m- m..m_n.m Wham-tum mmw. mm mm\"- un mu. Mm... mm.\" emu-u mm. w-nmunmmmmnm mam.\" \"mm.\" \"mm-m. luv-main muc- m... m, Ann-I um. omm...' mum. \" \"Mutual-Irma\" 1...... mm cw...- mmgmauuummonnn-uuna mum-.1. mu m... m. mun m M, 4WMW, 1......\"- yum... 41......\" \"Mum", mm.- mm mmmm-mym mam.\" mmmmotcmmsukawrm-munmmn 7- Ihumwmm- on,\" a. mum Mann-nu Inn \"humy... .n-u-u mum-mum nun... u... um- mm nkmrH-ulyu: u min-lun- s. mnmmmhm mm m...\" x mam 3063:: mm mm mm mm 3 mm run) mm AM: :5. mm) sum mm) \"w u was Mn WE: 020.1\") 4m (mm mm) muss) gun m1 (mum a 5; mm 775,3; LEE sum in mm um am 17.; 11 5.156 mm) mm m; was mam) mm mm an: can own. muss) 153.93) x ' mm m: (loam mm (mm mm mu: man 72115 nun swgn um mm;- mm H.020 mm mu mm mm) mm. um\" (um (nun) um awn mu MM: 7: m mum mum: (mm) mm mm) _m mm mm) mm noun) mm mm mm munm. n mg \"Manon-mink rum. win-mum snw.mu Dim-lumutmummu m...\" lsz-IWW Mmdhmummpu Mud" Imamn. mmhn-umu- munm n mg \"Manon-mink rum. win-mum Shh-dkn-wdm-l Mmmqm.m Mum-mu... mm. 1mm 4mm lamb-rum. Huh-hm: m an... MutuCn-Immnk rum. maximum swamu...- Fur-Apt mqmndmm man-mum- Mum mmu 4mm. min-mu- m... 1).\"... 24m vimmn'nay ommsnuovmm-'lwly "3......\" \"mm mm\"! uSmwT'uEC'm nun)\" : um 1mm) m 7 7 7 7 max! 7 mm m 7 7 mm, 7 am w 2mm 7 rm. 7 7 7 7 7 7 m 7 7 7 w: 7 7 7 7 7 mm) 7 7 7 7 7 um 7 7 _ _ _ 4E} _ mm mm mm mm 'fil : 7 7 7 7 7 mm 7 mm m, 7 7 mm, 7 um 1:85 um! 7 My\": 7 7 7 7 \"w 7 7 7 7 7 mm 7 7 7 7 7 1mm 7 7 _ _ _ _ez _ mumnn mm was mum mama 7 7 1mm : 7 7 7 7 (mm 7 ummm) am 7 7 awn) 7 man mu new 7 (my 7 7 7 7 mun) 7 7 7 7 7 may 7 7 7 7 mm 7 7 u2 m xl zu gmm mm. mm m m- nu o....:..,...... \"1.... cu ollwdnnh Sdh)'. Nmmdmmm gym-u up.\" airmail mammal"... WI-'hl-J mm M... u.- Wu:- mmu... mm; M human-an m. m... m.. mm- m... mmm. n... w mammmn Cnmmmhnmnnnup m..- .mu a woupm In-mum" mm, \"mm..." mama. .. w mmmm.._mmu.. u: mum campusnun." Suntan \"mum mm mm. .. .. ,r... m..- x nJmJSu mgu ugyga xszSIJu mm ugn mum mm; \"(32 mgum 1mm wu um sgu uszm m5\" \"runs :1 as x m m : Inns mum uumz gmgm mun mm mm) 4 92; Dana mgn mum : :qu xv : x m m u'nsu x "mum \\u 95 12173455 \"mm 1.5mm: 9 m 5n mszn um runs) 45 gm mms m 737 mu! w; x lsgw x m w x n757s