Question
Please help find the following...Thank you so much! Sales Budget Total budgeted sales: Inventory, Purchases, and Cost of Goods Sold Budget Cost of goods sold:
Please help find the following...Thank you so much!
Sales Budget
Total budgeted sales:
Inventory, Purchases, and Cost of Goods Sold Budget
Cost of goods sold:
Plus: Desired ending merchandise inventory:
Total merchandise inventory required:
Less:Beginning merchandise inventory
Budgeted Purchases:
Selling and Administrative Expense Budget:
Variable expenses:
Miscellaneous expense:
Fixed expenses:
Salaries expense:
Depreciation expense:
Total fixed expenses:
Total selling and administrative expenses:
Budgeted Cash Receipts from Customers
Current month sales, 65%:
Prior month sales, 35%
Total cash receipts:
Budgeted Cash Payments for Selling and Administrative Expenses
Variable expenses:
Miscellaneous expenses:
Fixed expenses:
40% of current month's salaries expense:
Total payments for selling and administrative expenses:
Cash Budget:
Beginning cash balance:
Cash receipts from customers:
Cash available:
Cash payments:
Purchases of merchandise inventory:
Selling and administrative expenses:
Capital expenditures:
Payments for dividend:
Total cash payments:
Ending cash balance:
Budgeted Income Statement
Sales Revenue:
Cost of Goods Sold:
Gross Profit:
Selling and Administrative Expenses:
Miscellaneous Expense:
Salaries Expense:
Depreciation Expense:
Total Selling and Administrative Expenses:
Net income (loss):
Budgeted Balance Sheet | ||
April 30, 2016 | ||
Assets | ||
Current Assets: |
| |
Cash | ? |
|
Accounts Receivable | ? |
|
Merchandise Inventory | ? |
|
Total Current Assets | ? | |
Property, Plant, and Equipment |
|
|
Equipment and Fixtures | ? |
|
Less: Accumulated Depreciation | (?) | ? |
Total Assets | ? |
Liabilities | |||
Current Liabilities: |
|
| |
Accounts Payable | ? |
| |
Salaries Payable | ? |
| |
Total Liabilities |
|
| ? |
Stockholders' Equity | |||
Common Stock | ? |
| |
Retained Earnings | ? |
| |
Total Stockholders' Equity |
| ? | |
Total Liabilities and Stockholders' Equity |
| ? |
Budgeted Statement of Cash Flows | |||
For the Month Ended April 30, 2016 | |||
| Operating Activities: |
|
|
| Cash receipts from customers | ? |
|
| Cash payments for purchases | (?) |
|
| Cash payments for selling and administrative expenses | (?) |
|
| Net cash provided by (used by) operating activities |
| ? |
| Investing Activities: |
|
|
|
|
|
|
| Cash payments for equipment purchases | (?) |
|
| Net cash provided by (used by) investing activities |
| (?) |
| Financing Activities: |
|
|
|
|
|
|
| Cash payment of dividends | (?) |
|
| Net cash provided by (used by) financing activities |
| (?) |
Net increase (decrease) in cash |
| (?) | |
Cash balance, April 1, 2016 |
| ? | |
Cash balance, April 30, 2016 |
| ? |
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