ALLIANCE PRINTING SUPPLY Balance Sheet March 31, 2018 Assets Current Assets: Cash $ 50,700 Accounts Receivable 15,500 Merchandise Inventory 12,000 Total Current Assets $ 78,200 Property. Plant, and Equipment: Equipment and Fixtures 80,500 Less: Accumulated Depreciation (12,900) 67,600 Total Assets $ 145,800 Liabilities Current Liabilities: Accounts Payable $ 8,600 Stockholders' Equity Common Stock, no par $ 38,000 Retained Earnings 99,200 Total Stockholders' Equity 137,200 Total Liabilities and Stockholders' Equity $ 145,800

Question

Completing a comprehensive budgeting problem—merchandising Company

Alliance Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2018 and a balance sheet at April 30, 2018. The March 31, 2018, balance sheet follows:

As Alliance Printing Supply’s controller, you have assembled the following additional information:

  • April dividends of $7,000 were declared and paid.
  • April capital expenditures of $16,300 budgeted for cash purchase of equipment.
  • April depreciation expense, $1,000.
  • Cost of goods sold, 40% of sales.
  • Desired ending inventory for April is $22,400.
  • April selling and administrative expenses include salaries of $37,000, 30% of which will be paid in cash and the remainder paid next month.
  • Additional April selling and administrative expenses also include miscellaneous expenses of 10% of sales, all paid in April.
  • April budgeted sales, $89,000, 80% collected in April and 20°/0 in May.
  • April cash payments of March 31 liabilities incurred for March purchases of inventory, $8,600.
  • April purchases of inventory, $8,600 for cash and $37,400 on account. Half the credit purchases will be paid in April and half in May.

Requirements

  1. Prepare the sales budget for April.
  2. Prepare the inventory, purchases, and cost of goods sold budget for April.
  3. Prepare the selling and administrative expense budget for April.
  4. Prepare the schedule of cash receipts from customers for April.
  5. Prepare the schedule of cash Payments of Selling and administrative expenses for April.
  6. Prepare the cash budget for April. Assume the company does not use short-term financing to maintain a minimum cash balance.
  7. Prepare the budgeted income statement for April.
  8. Prepare the budgeted balance sheet at April 30, 2018
ALLIANCE PRINTING SUPPLY
Balance Sheet
March 31, 2018
Assets
Current Assets:
Cash
$ 50,700
Accounts Receivable
15,500
Merchandise Inventory
12,000
Total Current Assets
$ 78,200
Property. Plant, and Equipment:
Equipment and Fixtures
80,500
Less: Accumulated Depreciation
(12,900)
67,600
Total Assets
$ 145,800
Liabilities
Current Liabilities:
Accounts Payable
$ 8,600
Stockholders' Equity
Common Stock, no par
$ 38,000
Retained Earnings
99,200
Total Stockholders' Equity
137,200
Total Liabilities and Stockholders' Equity
$ 145,800

Image Transcription

ALLIANCE PRINTING SUPPLY Balance Sheet March 31, 2018 Assets Current Assets: Cash $ 50,700 Accounts Receivable 15,500 Merchandise Inventory 12,000 Total Current Assets $ 78,200 Property. Plant, and Equipment: Equipment and Fixtures 80,500 Less: Accumulated Depreciation (12,900) 67,600 Total Assets $ 145,800 Liabilities Current Liabilities: Accounts Payable $ 8,600 Stockholders' Equity Common Stock, no par $ 38,000 Retained Earnings 99,200 Total Stockholders' Equity 137,200 Total Liabilities and Stockholders' Equity $ 145,800

Expert Answer

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Business
Accounting

Cost Analysis

Other

Cost Accounting

Final Accounts

Control of Overhead Cost

Accounting For Decision Making

Cost Management

Cost allocation and revenues

Related Accounting Q&A

Find answers to questions asked by students like you.

Q: Classique Household Furnishings & Appliances is a family-owned furniture store. You are the mana...

A: Prepare the statement showing cash received during the months as follows:

Q: On a CVP graph, the total cost line intersects the vertical (dollars) axis at a. the origin. b. the ...

A: Definition:   Cost-volume profit analysis: CVP analysis is a tool of cost accounting that measures t...

Q: Classifying quality costs Darrel & Co. makes electronic components. Chris Darrel, the president,...

A: Classify the given item as a prevention cost, an appraisal cost, an internal failure cost, or an ext...

Q: Cash Payback Period for a Service Company

A: Capital Budgeting is a technique to identify avenues for investments by a company and measure them a...

Q: The Best Appliances had the following revenue over the past five Wars, To predict revenues for 2018,...

A: Definition:   Margin of safety: The number of units sold or the income earned in excess of the break...

Q: A firm has consistently adjusted its allowance account at the end of the fiscal year by adding a fix...

A: Definition:   Percentage of sales method: Credit sales are recorded by debiting (increasing) accoun...

Q: Net Present Value Method

A: Net present value of investment is computed by subtracting the initial investment from present value...

Q: What is the margin of safety? What are the three ways it can be expressed?

A: Margin of safety refers to the extent by which the actual or the projected sales of an organization ...

Q: 4. Waran Co. has accounts receivable of $500,000 and an allowance for doubtful accounts of $20,000 a...

A: Click to see the answer