Year 3 Quarter Year 4 Quarter

1 2 3 4 1 2

Budgeted Unit Sales 80,000 120,000 200,000 100,000 140,000 160,000

Selling price per unit = $16

Accounts Receivable, beginning balance =$130,000

Sales collected in the quarter sales are made =75%

Sales collected in the quarter after sales are made =25%

Desired ending finished goods inventory is =30% of the budgeted unit sales of the next quarter

Finished goods inventory, beginning =24,000 units

Raw materials required to produce one unit =10 pounds

Desired ending inventory of raw material is =20% of the next quarter's production needs

Raw materials inventory, beginning =46,000 pounds

Raw materials costs =$1.60 per pound

Raw materials purchases are paid =60% in the quarter the purchased are made

and 40% in the quarter following purchase

Accounts payable for the raw materials, beginning =$163,000

Enter a formula into each of the cells marked with? On the tabs that follow this tab.

A. sales budget B. cash collections C. production budget D.material budget E.cash payments