Thumbtack's March 31, 2012, budgeted balance sheet follows:
THUMBTACK OFFICE SUPPLY Budgeted Balance Sheet March 31, 2012
Assets		Liabilities
Current assets:		Current liabilities:
Cash	$18,000	Accounts payable	$12,500
Accounts receivable	12,000	Salary and commissions payable	1,400
Inventory	16,000	Total liabilities	$13,900
Prepaid insurance	2,200
Total current assets	$48,200	Stockholder's Equity
Plant assets:		Common stock	16,000
Equipment and fixtures	45,000	Retained earnings	33,300
Less: Accumulated depreciation	30,000	Total stockholders' equity	$49,300
Total plant assets	$15,000
Total assets	$63,200	Total liabilities and stockholders' equity	$63,200
The budget committee of Thumbtack Office Supply has assembled the following data.
a. Sales in April were $40,000. You forecast that monthly sales will increase 2% over April's sales in May. June's sales will increase 4% over April's sales. July's sales will increase 20% over April's sales. Collections are 80% in the month of sales and 20% in the month following sale.
b. Thumbtack maintains inventory of $11,000 plus 2.5% of the COGS budgeted for the following month. COGS = 50% of sales revenue. Purchases are paid 30% in the month of purchase and 70% in the month following the purchase.
c. Monthly salaries amount to $7,000. Sales commissions equal 5% of sales for that month. Salaries and commissions are paid 30% in the month incurred and 70% in the following month.
d. Other monthly expenses are as follows:
Rent expense	$2,400, paid as incurred
Depreciation expense	$200
Insurance expense	$100, expiration of prepaid amount
Income tax	20% of operating income, paid as incurred
Requirements:
1. Prepare Thumbtack's sales budget for April and May, 2012. Round all amounts to the nearest $1.
2. Prepare Thumbtack's inventory, purchases, and cost of goods sold budget for April and May.
3. Prepare Thumbtack's operating expenses budget for April and May.
4. Prepare Thumbtack's budgeted income statement for April and May.
5. Prepare the schedule of budgeted cash collections from customers for April and May.
6. Prepare the schedule of budgeted cash payments for purchases for April and May.
7. Prepare the schedule of budgeted cash payments for operating expenses for April and May.
8. Prepare the cash budget for April and May. Assume no financing took place.
9. Prepare a budgeted balance sheet as of May 31, 2012.
10. Prepare the budgeted statement of cash flows for the two months ended May 31, 2012. (Note: You should omit sections of the cash flows statements where the company has no activity.)
Assume the following changes to the original facts:
a. Collections of receivables are 60% in the month of sale, 38% in the month following the sale, and 2% are never collected. Assume the March receivables balance is net of the allowance for uncollectibles.
b. Minimum required inventory levels are $8,000 plus 30% of next month's COGS.
c. Purchases of inventory will be paid 20% in the month of purchase, 80% in the month following purchase.
d. Salaries and commissions are paid 60% in the month incurred and 40% in the following month.
Requirements:
1. Prepare Thumbtack's revised sales budget for April and May. Round all calculations to the nearest dollar.
2. Prepare Thumbtack's revised inventory, purchases, and cost of goods sold budget for April and May.
3. Prepare Thumbtack's revised operating expenses budget for April and May.
4. Prepare Thumbtack's revised budgeted income statement for April and May.