Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2024 and budgeted balance sheet at April 30, 2024. The March 31, 2024, balance sheet follows: As Tune Printing Supply's controller, you have assembled the following additional information: a. April dividends of $6,000 were declared and paid. b. April capital expenditures of $16,200 budgeted for cash purchase of equipment. c. April depreciation expense, $500. d. Cost of goods sold, 45% of sales. e. Desired ending inventory for April is $22,800. f. April selling and administrative expenses include salaries of $32,000, 30% of which will be paid in cash and the remainder paid next month. g. Additional April selling and administrative expenses also include miscellaneous expenses of 15% of sales, all paid in April. h. April budgeted sales, $86,000, 50% collected in April and 50% in May. i. April cash payments of March 31 liabilities incurred for March purchases of inventory, $8,100. j. April purchases of inventory, $12,300 for cash and $37,500 on account. Half the credit purchases will be paid in April and half in May. I'VE ASKED THIS QUESTION A FEW TIMES BUT ONLY GET PART ANSWERS. CAN YOU PLEASE HELP ME WITH REST OF PART 8? 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 for 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, 2024.

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter8: Budgeting

Section: Chapter Questions

Problem 6BE: Cash budget Pasadena Candle Inc. pays 40% of its purchases on account in the month of the purchase...

See similar textbooks

Related questions

Concept explainers

Question

Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for

April

2024

and budgeted balance sheet at

April

30,

2024.

The

March

31,

2024,

balance sheet follows:

Tune

Printing Supply's controller, you have assembled the following additional information:

a.	April dividends of $6,000 were declared and paid.
b.	April capital expenditures of $16,200 budgeted for cash purchase of equipment.
c.	April depreciation expense, $500.
d.	Cost of goods sold, 45% of sales.
e.	Desired ending inventory for April is $22,800.
f.	April selling and administrative expenses include salaries of $32,000, 30% of which will be paid in cash and the remainder paid next month.
g.	Additional April selling and administrative expenses also include miscellaneous expenses of 15% of sales, all paid in April.
h.	April budgeted sales, $86,000, 50% collected in April and 50% in May.
i.	April cash payments of March 31 liabilities incurred for March purchases of inventory, $8,100.
j.	April purchases of inventory, $12,300 for cash and $37,500 on account. Half the credit purchases will be paid in April and half in May.

I'VE ASKED THIS QUESTION A FEW TIMES BUT ONLY GET PART ANSWERS. CAN YOU PLEASE HELP ME WITH REST OF PART 8?

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 for 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, 2024.

Tune Printing Supply
Budgeted Balance Sheet
April 30, 2024
Assets
Current Assets:
Cash
$
24,350
Accounts Receivable
43,000
Merchandise Inventory
22,800
Total Current Assets
$
90,150
Property, Plant, and Equipment:
Equipment and Fixtures
97,100
Less: Accumulated Depreciation
(12,600)
84,500
$
174,650
Total Assets
Liabilities
Current Liabilities:
Accounts Payable
18,600
Salaries Payable
22,400
Total Liabilities
41,000
Stockholders' Equity
Common Stock
40,000
Retained Earnings
93,500
Total Stockholders' Equity
133,500
174,500
Total Liabilities and Stockholders' Equity

Cash budget
For the Month Ended April 30, 2024
Beginning cash balance
$
51,000
57,200
Cash receipts from customers
Cash available
108,200
Cash payments:
Purchases of merchandise inventory
39,150
Selling and administrative expenses
22,500
Capital expenditures
16,200
Payments for dividend
6,000
Total cash payments
83,850
$
24,350
Ending cash balance
Print
Done

Definition Definition Estimate of an organization's cash flow for a future period. A cash budget forecasts future cash receipts and payments from various sources for a fiscal year. A cash budget can be created once a month or once a week to determine the organization's cash position and ensure its performance in relation to the budget. It aids in determining whether the company has enough cash and cash equivalents to meet its operational needs in the future.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 8 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.