Upon receipt of the budget (attached below), the team manager, June Jackson, has now informed you that, in keeping with industry players, the management of Pelican Merchandising have indicated an industry requirement to maintain a minimum cash balance of $185,000 each month. She has also noted that management is very keen on keeping the gearing ratio of the business as low as possible and would therefore prefer to cushion any gaps internally using equity financing. Based on the budget prepared (attached below), will the business be achieving this desired target? Suggest three (3) internal strategies that may be employed by management to improve the organization’s monthly cash flow and militate against or reduce any possible shortfall reflected in the budget prepared

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...
icon
Related questions
icon
Concept explainers
Question

Upon receipt of the budget (attached below), the team manager, June Jackson, has now informed you that, in keeping with industry players, the management of Pelican Merchandising have indicated an industry requirement to maintain a minimum cash balance of $185,000 each month. She has also noted that management is very keen on keeping the gearing ratio of the business as low as possible and would therefore prefer to cushion any gaps internally using equity financing.

Based on the budget prepared (attached below), will the business be achieving this desired target? Suggest three (3) internal strategies that may be employed by management to improve the organization’s monthly cash flow and militate against or reduce any possible shortfall reflected in the budget prepared. 

田
Pelican Merchandising and More
Cash Budget
For the quarter ending March 31, 2022
JANUARY
FEBRUARY
MARCH
ТОTAL
Beginning Cash Balance
Accounts Receivables:
(131,993)
(152,500)
(215,900)
(131,993)
Cash Sales
170,975
135,740
226,420
533,135
Collections for Trade Receivables
591,600
645,100
719,400
1,956,100
Rental Deposit
46,000
46,000
Rental Income
46,000
46,000
52,000
92,000
Sale of Old Motor Van
156,000
208,000
Liquidation of Investment
450,000
450,000
Interest Income
18,743
18,743
Total Accounts Receivables
1,231,318
1,028,840
1,043,820
3,303,978
Accounts Payables:
Cash Purchases
Disbursements for Accounts Payables
44,625
30,400
55,100
130,125
390,200
459,840
521,820
1,371,860
Payment for Furniture
Fixed Operating Expenses
Other Operating Expenses
Compensation Expense
Wages & Salaries
Total Accounts Payables
182,000
140,000
132,000
42,000
132,000
132,000
396,000
58,000
58,000
58,000
174,000
355,000
355,000
272,000
272,000
272,000
816,000
1,251,825
1,092,240
1,080,920
3,424,985
Ending Cash Balance
(152,500)
(215,900)
(253,000)
(253,000)
Transcribed Image Text:田 Pelican Merchandising and More Cash Budget For the quarter ending March 31, 2022 JANUARY FEBRUARY MARCH ТОTAL Beginning Cash Balance Accounts Receivables: (131,993) (152,500) (215,900) (131,993) Cash Sales 170,975 135,740 226,420 533,135 Collections for Trade Receivables 591,600 645,100 719,400 1,956,100 Rental Deposit 46,000 46,000 Rental Income 46,000 46,000 52,000 92,000 Sale of Old Motor Van 156,000 208,000 Liquidation of Investment 450,000 450,000 Interest Income 18,743 18,743 Total Accounts Receivables 1,231,318 1,028,840 1,043,820 3,303,978 Accounts Payables: Cash Purchases Disbursements for Accounts Payables 44,625 30,400 55,100 130,125 390,200 459,840 521,820 1,371,860 Payment for Furniture Fixed Operating Expenses Other Operating Expenses Compensation Expense Wages & Salaries Total Accounts Payables 182,000 140,000 132,000 42,000 132,000 132,000 396,000 58,000 58,000 58,000 174,000 355,000 355,000 272,000 272,000 272,000 816,000 1,251,825 1,092,240 1,080,920 3,424,985 Ending Cash Balance (152,500) (215,900) (253,000) (253,000)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

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
Recommended textbooks for you
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Financial & Managerial Accounting
Financial & Managerial Accounting
Accounting
ISBN:
9781337119207
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,