Fill in all the information below using cell refrences in the excel sheet

B c E H 1 Chapter 8: Applying Excel \begin{tabular}{l|l} 3 & Data \\ 4 & \\ 5 & Budgeted unit sales \end{tabular} \begin{tabular}{llccc} Year 2Quarter \\ 1 & 2 & 3 \\ 40,000 & 60,000 & 100,000 & 4 & \multicolumn{2}{l}{ Year 3 Quarter } \\ 1 & 1 & 2 \\ 40,000 & 70,000 & 80,000 \end{tabular} - Selling price per unit $8 per unit - Accounts receivable, beginning balance $65,000 - Sales collected in the quarter sales are made - Sales collected in the quarter after sales are made 75% 11 - Desired ending finished goods inventory is 30% of the budgeted unit sales of the next quarter 12 . Finished goods inventory, beginning 12,000 units 13 . Raw materials reguired to produce one unit 5 pounds 14. Desired ending inventory of raw materials is 10% of the next quarter's production needs 15. Raw materials inventory, beginning 23,000 pounds 16 . Raw material costs $0.80 per pound 17 - Raw materials purchases are paid 18 and 19 - Accounts payable foc raw materials, begining balance 20 21 Enter a formula indo each or the celis markod with a 2 bolow 22 Review Problem: Budget Schedules 22 Review Problem: Budget Schedules 24 Construct the sales budget 30 Construct the schedule of expected cash collections 32 Accounts receivable, beginning balance 33 First-quarter sales 34 Second-quarter sales 35 Third-quarter sales 36 Fourth-quarter sales 37. Total cash collections 39 Construct the production budget 40 41 Budgeted unit sales 42 Add desired finished goods inventory 43 Total needs 43. Total needs Construct the raw materials purchases budget