Assignment
Thumbtack's March 31, 2012, budgeted balance sheet follows:
THUMBTACK OFFICE SUPPLY
Budgeted balance Sheet
March 31, 2012
Assets Liabilities
Current: Current:
Cash $ 18,000 Accounts due $ 12,500
Accounts receivable 12,000 Salary and commissions due 1,400
Stock 16,000 Total present debts $ 13,900
Prepaid insurance 2,200
Total present assets $ 48,200 Shareholders' Equity
Factory assets: Ordinary shares $ 16,000
Machines and fixtures 45000 Retained earings 33,300
Less: Accmulated Depreciation 30,000 Total shareholders' equity 49,300
Total factory assets 15,000 Total debts and
Total assets $63,200 shareholders' equity $ 63,200
The budget committee of Thumbtack Office Supply has collected the following data.
1. Sales in April were $40,000. You predict that per month sales will enhance 2% over April's sales in May. June's sales will enhance 4% over April's sales. July's sales will enhance 20% over April's sales.
Collections are 80% during the month of sale and 20% during the month after sale.
2. Thumbtack keeps stock of $11,000 plus 25% of the COGS budgeted for the next month. COGS = 50% of sales income. Purchases are paid 30% during the month of purchase and 70% in the month after the purchase.
3. Monthly wages add up to $7,000. Sales commissions equal 5% of sales for that month. Wages and commissions are paid 30% in the month incurred and 70% in the next month.
4. Other monthly expenditures are listed below:
Rent expenditure $2,400 paid as accrued
Depreciation expenditure $ 200
Insurance expenditure $100, expiration of prepaid sum
Income tax 20% of operating revenue, paid as incurred.
Requirements
A. Prepare Thumbtack's sales budget for April and May, 2012. Round all amounts to the nearest $1.
B. Prepare Thumbtack's inventory, purchases, and cost of goods sold budget for April and May.
C. Prepare Thumbtack's operating expenses budget for April and May.
D. Prepare Thumbtack's budgeted income statement for April and May.
Format your assignment according to the give formatting requirements:
1. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the course title, the student's name, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.