Gudgening: Applying Excet Data Budgeted unt saies - Beling price pet uni - Accounts recehable beginning balance - BNes colected in the ausrer saies are made - Seles colected in the eualer aher sales are made - Desived ending frished goods mientory is - Finshed goods iverriory, tegining - Desied evang insertary of raw materabis - Raxw maberids ieveritary tegnntig - Baw makena couts - Haw maserias purchates are baid and - Accounce poyabie for saw matariah, beprery butirce Enter a for Budgeted unt saies Seling price per unt Totai nales Schedule of Expected Cash Covections Budpet Beginning balance acoounts receivable First-quartar aales Second-quarter anks. Thind-quarter sales Fouth-quater sales Total cash collections Productian Budget Bulgeted unt saees Add desired ending finehed goods inventory Tohil needs Less beginning firshed goods inverhary Requered productan in unis Aaw Mareriais Purchases Dudger Requed productoon (unts) Raw makarials iepired to predus cine wet ipchante] Productisn reests coounds) Aid deered entiry nveribory of taw malenain ipoonta) Folai needs (pounde) Less begineng incertory of raw maleras gocnds RaN mareriais io be purctased ipoundsi Cost of raw malerials per posand Cost of raw maleriak to be purchases Schedule af Expected Caah Dvaburaments Beginning balance account payable Fired-quster prectises Second-quarter purchaser Thire-quarlar purchasis Fourth-quarer punchases Total cash disbursements