Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following information relates to Rebel a retail business sport equipment. The table below provides the sales and purchases for the company: Actual Sales Actual

The following information relates to Rebel a retail business sport equipment.

The table below provides the sales and purchases for the company:

Actual Sales

Actual Purchases

October 2019

$38,000

$20,000

November 2019

$41,000

$24,000

December 2019

$48,500

$29,800

Budgeted Sales

Budgeted Purchases

January 2020

$54,000

$32,000

Additional information includes:

  • Cash sales are 20% each month.
  • Credit sales are expected to be collected 60% one month after sale, 20% two months after the sale and 15% 3 months after the month of sale.
  • Accounts Payable is settled 40% one month after purchase and the balance is paid two months after purchase. All purchases are on credit.
  • Cash payments for expenses are 10% of each months sales.
  • Depreciation on the machines for January 2020 is estimated to be $2,000.
  • The cash balance on 31 December 2019 is $5,400.
  • The company wishes to maintain a monthly minimum balance of 10,000 and has a line of credit arrangement with Greater Bank.

Required:

(a) Prepare the Cash Budget for the month of January 2020. (b) Explain any two key changes you would make to the Cash Budget to ensure better cash management in the company.

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

Essentials Of Xbrl Financial Reporting In The 21st Century

Authors: Bryan Bergeron

1st Edition

0471220779, 978-0471220770

More Books

Students also viewed these Accounting questions

Question

Identify three types of physicians and their roles in health care.

Answered: 1 week ago

Question

Compare the types of managed care organizations (MCOs).

Answered: 1 week ago