chapter 8

I need the formulas for each of the cells

Chapter&:Applying Excel 3 Data Year 2 Quarfer Year 3 Quarter unit sales 40,00060,000 100,00050,000 70,00080,000 -Selling price per unit Accounts receable, beginning balance 9 Sales collected in the quarter sales are made S8 per unit 75% 25% 30% of the budgeted unit sales of the next quater Sales collected in the quarter after sales are made 11Desired ending finished goods inventory is 2 Finished goods inventory, beginning 12,000 unts Raw materials required to produce one un 4-Desired ending inventory of raw materialsi S Raw mteials imventiory, beginning 6Raw material costs 1Raw matealis purchases are paid 18 and 5 pounds 10% of the next quarter's production needs 23,000 pounds $0 80 per pound 60% in the quarter the purchases we made 40% in the quarter following puchase Accounts payable for raw materials, beginning balance $81,500 Enter a formula into each of the cells marked with a ? below Review Problem: Budget Schedules 24 Construct the sales budger Year 2 Quarter Vear 3 Quarfer 26 Budgeted unt sales Seling price per unt Construct the schedule of expected cash collections Year 2 Quarter Accounts recevable, beginning balance st quater sales Second-quarter sales Thed-quarler sales Chapter 8 GHKL B N