Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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:

image text in transcribed

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

?

Data Table Box Printing Supply Balance Sheet March 31, 2016 Assets Current Assets: Cash Accounts Receivable Merchandise Inventory Total Current Assets $ 51,100 13,200 12,600 $ 76,900 Property, Plant, and Equipment: 81,300 Equipment and Fixtures Less: Accumulated Depreciation (12,100) 69,200 Total Assets $ 146,100 Liabilities Current Liabilities Accounts Payable $ 8,000 Stockholders' Equity Common Stock, no par $42,000 Retained Earnings 96,100 Total Stockholders' Equity 138,100 Total Liabilities and Stockholders' Equity $146,100 More Info a. April dividends of $2,000 were declared and paid b. April capital expenditures of $16,500 budgeted for cash purchase of equipment. C. April depreciation expense, $200 d. Cost of goods sold, 40% of sales Desired ending inventory for April is $26,900 April selling and administrative expenses include salaries of $32,000, 25% ofwhich will be paid in cash and the remainder paid next month Additional April selling and administrative expenses also include miscellaneous expenses of 5% of sales, all paid in April April budgeted sales. $87,000, 50% collected in April and 50% in May April cash payments of March 31 liabilities incurred for March purchases of inventory $8,000 April purchases of inventory, $11,500 for cash and $37,600 on account. Half the credit purchases will be paid in April and half in May e. f. g. h. i. j

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Wiley CPAexcel Exam Review April Study Guide Regulation 2017

Authors: Wiley

2nd Edition

1119369436, 978-1119369431

More Books

Students also viewed these Accounting questions

Question

How could an organization's culture be used as a control mechanism?

Answered: 1 week ago