Question
Clipboard Office Supply's March 31, 2018, balance sheet follows: Clipboard Office Supply Balance Sheet March 31, 2018 Assets Current Assets: Cash $35,000 Accounts Receivable 20,000
Clipboard Office Supply's March 31, 2018, balance sheet follows:
Clipboard Office Supply | ||
Balance Sheet | ||
March 31, 2018 | ||
Assets | ||
Current Assets: |
| |
Cash | $35,000 |
|
Accounts Receivable | 20,000 |
|
Merchandise Inventory | 24,500 |
|
Prepaid Insurance | 2,400 |
|
Total Current Assets | $81,900 | |
Property, Plant, and Equipment: |
|
|
Equipment and Fixtures | 34,000 |
|
Less: Accumulated Depreciation | (18,000) | 16,000 |
Total Assets | $97,900 |
Liabilities | |||
Current Liabilities: |
|
| |
Accounts Payable | $20,000 |
| |
Salaries and Commissions Payable | 8,000 |
| |
Total Liabilities |
|
| $28,000 |
Stockholders' Equity | |||
Common Stock, no par | 12,000 |
| |
Retained Earnings |
| 57,900 |
|
Total Stockholders' Equity |
| 69,900 | |
Total Liabilities and Stockholders' Equity |
| $97,900 |
The budget committee of Clipboard Office Supply has assembled the following data:
a. Sales in April are expected to be $100,000. Clipboard forecasts that monthly sales will increase 2% over April sales in May. June's sales will increase by 4% over April sales. July sales will increase 20% over April Sales.
b. Clipboard maintains inventory of $12,000 plus 25% of the cost of goods sold budgeted for the following month. Cost of good sold equal 50% of sales revenue.
c. Monthly Salaries amount to $10,000. Sales commissions equal 5% of sales for that month.
d. Other monthly expenses are as follows:
1) Rent: $2,200
2) Depreciation: $400
3) Insurance: $200
4) Income tax: $2300
Requirements:
1) Prepare Clipboard's sales budget for April and May 2018. Round all calculations to the nearest dollar.
2) Prepare Clipboard's inventory, purchases, and cost of goods sold budget for April and May.
3) Prepare Clipboard's selling and administrative expense budget for April and May.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started