2 Excel File Edit View Insert Format Tools Data Window Help Brewer 7e.Ch 07 Student Home Insert Draw Page Layout Formulas DataReviewl View gl e2 wrap Text Merge & Center v -1 10.KA" General b Copy $ v % paste Format AS : x fr Budgeted unit sales 1 Chapter 7: Applying Excel 3 Data Quantar Year 3 Qu arfer 40,000 60,000| 100,000 so,000 70,000 80,000 7 -Seling prce per unit $8 per unt Accounts receivable, beginning balance $65,000 Sales colected in the quarter saes are made 0Sales collected in the quarter after sales are made 11 Desred endng finished goods mantery 2 Finished goods inventory, beginning 3Raw matefials equired to poduce one unit 14 Desned ending invemory of raw materials is 15 Raw materials inventory, beginning 16 .Raw matenal costs 30% of the budgeted unit sales of te next quarter 12.000 unks 5 pounds 23,000 pounds 0.80 per pound 7Raw mater ials purchases are paid 18 and 40% inme quarter lolo ng purchase 81.500 Review Problem: Budget Schedules 4 Construct the sales budget 26 Budgeted unit saes Year 3 27 Seling price per unt Construet the schedule of expected cesh collecons 32 Accounts recelivable, beginning balance Frstquaser ter saies 35 Thrd-quater sales Fourh-quarter sales Total cash collections Construet the produc5om budget Budgsted unit saies 2 Add desired frished goods invenory 43 Total Required production Construct the row materials purcheses budget Year Chapter 7 Form + Excel File Edit View Insert Format Tools Data Window Help Brewer 7e_Ch 07 StudentP Home Insert Draw Page Layout Formulas Data Review View L' FormatB A5 fx Budgeted unit sales Year 3 Year Add desred finished goods inventory 3 Total needs 4 Less beginning inventory Year 53 Total needs (pounds) 5 Raw materials to be purchased 6 Cost of raw materials per pound 66 Total cash disbusements Chapter 7 Form