Chapter 8: Applying Excel
Data
Budgeted unit sales
Selling price per unit
Accounts receivable, beginning balance
Sales collected in the quarter sales are made
Sales collected in the quarter after sales are made
Desired ending finished goods inventory is
Finished goods inventory, beginning
Raw materials required to produce one unit
Desired ending inventory of raw materials is
Raw materials inventory, beginning
Raw material costs
Raw materials purchases are paid
Accounts payable for raw materials, beginning balance
Enter a formula into each of the cells marked with a ? below
Review Problem: Budget Schedules
Construct the sales budget
Budgeted unit sales
Selling price per unit
Total sales
Year 2 Quarter
1
2
3
4
40,000
60,000
100,000
50,000
$8 per unit
$65,000
75%
25%
30% of the budgeted unit sales of the next quarter
12,000 units
5 pounds
10% of the next quarter's production needs
23,000 pounds
$0.80 per pound
60% in the quarter the purchases are made
40% in the quarter following purchase
$81,500
Year 3 Quarter
1
2
70,000
80,000
1
2
3
4
1
2
?