Prepare a cash budget for the months of May.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
Blossom Bakery has budgeted sales revenues as follows:
Credit sales
Cash sales
Total sales
April
$45,900
12,240
$58,140
April $34,680
May
37,740
Past experience indicates that 40% of the credit sales will be collected in the month of sale, and the remaining 60% will be collected in
the following month.
Purchases of inventory are all on credit, and 20% will be paid in the month of purchase with the balance paid in the month following
purchase. Budgeted inventory purchases are:
Other budgeted amounts include: (a) selling and administrative expenses of $25,296 each month and (b) dividends of $8,364 to be
paid in May. Included in the selling and administrative expenses is depreciation expense of $1,938.
Beginning Cash Balance
Add
The company wishes to maintain a minimum cash balance of $4,080 at the end of each month. The company borrows money from the
bank at 4% interest if necessary to maintain the minimum cash balance. Borrowed money is repaid in months when there is an excess
cash balance. The beginning cash balance on May 1 was $4,590. Money is borrowed in $102 increments.
Prepare a cash budget for the months of May.
Less
Total Available Cash
May
$48,960
Collections From Customers
Dividends
$65,280
Purchases
16,320
Receipts
Selling and Administrative Expenses
Total Disbursements
Financing
Borrowings
Disbursements
Ending Cash Balance
Excess (Deficiency) of Available Cash Over Disbursements
eTextbook and Media
BlossomBarker
Cash Budget
For the Months of May
>
>
>
$
$
Transcribed Image Text:Blossom Bakery has budgeted sales revenues as follows: Credit sales Cash sales Total sales April $45,900 12,240 $58,140 April $34,680 May 37,740 Past experience indicates that 40% of the credit sales will be collected in the month of sale, and the remaining 60% will be collected in the following month. Purchases of inventory are all on credit, and 20% will be paid in the month of purchase with the balance paid in the month following purchase. Budgeted inventory purchases are: Other budgeted amounts include: (a) selling and administrative expenses of $25,296 each month and (b) dividends of $8,364 to be paid in May. Included in the selling and administrative expenses is depreciation expense of $1,938. Beginning Cash Balance Add The company wishes to maintain a minimum cash balance of $4,080 at the end of each month. The company borrows money from the bank at 4% interest if necessary to maintain the minimum cash balance. Borrowed money is repaid in months when there is an excess cash balance. The beginning cash balance on May 1 was $4,590. Money is borrowed in $102 increments. Prepare a cash budget for the months of May. Less Total Available Cash May $48,960 Collections From Customers Dividends $65,280 Purchases 16,320 Receipts Selling and Administrative Expenses Total Disbursements Financing Borrowings Disbursements Ending Cash Balance Excess (Deficiency) of Available Cash Over Disbursements eTextbook and Media BlossomBarker Cash Budget For the Months of May > > > $ $
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Budgeting
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education