Accounting Excel Problems- Reports & Budgeting

rrylt-ttA 0-oQI, r) Prrp*tg tn oF*?tb|g h$p* tg nhl The budger commiaee of Ctipboard Offie Supply h* assmblod dre following dtra. As tic b'usinesr man4ger' you rnuff pepare thc buftcted irrome steemena for May and Junc tr011'

ksrbt|rd|t

r. $alm io Agil rw $J&000. Yw fueest dut trudly ula *tll ireerc 2.0% in Mayud 2.4% ilJw,

b. Clipbsrd uin:oinr iamuy of $9'000 plu 25y" of ti€ sl6 lw bud*ecd l*tbe fo$owiqsq@tlL MsAhpucbds aroagc $0",{ of slsrwmia &a?sFMab. Aed imtrI on April 30 is 113,000, S.l€5 budgEbd tur Juty c Se5'000,

a Moodrly nlricr aruut o f,3,frF. sdc wi*iw cqml 'l% of sals for &at sq6, Cmbre raluics ad wiaiw fuco r rit*le frguc.

d, Ot&e ombly erprc r * hllowr

l. Prepare Clipboard Office $lpb's budgpted inome stasm€trts fc May and

]uae Slrov coct of goods $dd conrptf,tkxls. Rouad all amwna ro the ncarest Sl{X}. {Round alrouils enditrg it $J0 or more upwar4 and emounts erding in b*c t.hm $50 downward.! For example, bnfurred May selc are $51'000 ($50,000 x 1.02)' eidJune siles are t52i00 {$51,tX)0 x 1'024)

Note: ?rcblew 21-21A nxst bc cmplded hefwc atenptiag h&lc& LI-nL

Ptt-&!A (LOQI. 4) F€FnrhO a fmmfd hdgrt P nter! Re{er to P21-21A. Clipboaid Officc Srpplyrs selcr .rc 757o caeh and 25% crdir. {Uec rhc ronrdcd seles valucs.} Crcdit sglcs arc collcctcd in rte rmnth afur galc. Iavertory purchaeee arc paid 25% in Se moeuh of pureheer .rd 75sh the folbrrhg marth. Sshris and seks commicciwrs ac also pid helf in dre rnoath earrd and half thc rcxt mondr. bcorne ex b pekl at the ad of *rc ycar,

Tbe Apd 3q zfl 1, behr* shet showed thc ftilorring bsh$ce*

x5,000 53,060 2,500

nrqrtrnratr 1. Peere sfrGduh of {a} hrrdgped cash colbctirns, (b} @eed cash Fayrn€srs

for prchascr, and (c) bu*ced caslr payments for operaring ergerues. Show 4mounts for eacft morrh *d totak for May end Juoe, Ro**d yirur compute- tions to dtc ncarcst doflar,

2. Preprre a cash budget *inilar ur Er$ibit 21-14. I{ no fireacing actirity mok plece, whatir the buSetedcashbelence onJum 3O;2011?