Ronstadt Limited’s budget for the four months from January to April includes the following data: 1. Month Sales Materials Wages Overheads $000 $000 $000 $000 January 615 115.0 30 360 February 636 120.0 33 390 March 690 135.0 36 420 April 684 130.0 40 425 2. One-third of sales revenue is received one month after sale and the remainder is received two months after sale. The sales in the previous two months were: November $600 000; December $540 000. 3. One-quarter of purchases of materials are paid for in the month of purchase. The remainder are paid for two months later. Purchases in the previous two months were: November $108 000; December $106 000. 4. Two-thirds of the wages are paid in the month in which they are earned, and the balance is paid in the following month. The wages for the previous December amounted to $30 000. 5. One-half of the overhead expenditure is paid in the month in which it is incurred, and the balance is paid in the following month. The overheads for the previous December were $380 000. 6. Old machinery will be sold for $4000 in April. New machinery will be purchased in March for $90 000 but only one-half of the price will be paid in that month. The balance will be paid in August. 7. Ronstadt Limited has an overdraft of $63 000 at the bank at 31 December. REQUIRED: Prepare Ronstadt Limited’s cash budget for each of the four months from January to April.

Quickbooks Online Accounting
3rd Edition
ISBN:9780357391693
Author:Owen
Publisher:Owen
Chapter8: Budgets And Bank Reconciliations
Section: Chapter Questions
Problem 3.3C
icon
Related questions
Topic Video
Question

BUS 203: INTRODUCTION TO COST AND MANAGEMENT ACCOUNTING PROJECT: CASH BUDGETING ASSOCIATE DEGREE YEAR 2: SEMESTER 1 (2020/21)
Ronstadt Limited’s budget for the four months from January to April includes the following data:
1.
Month
Sales
Materials
Wages
Overheads

$000
$000
$000
$000
January
615
115.0
30
360
February
636
120.0
33
390
March
690
135.0
36
420
April
684
130.0
40
425

2. One-third of sales revenue is received one month after sale and the remainder is received two months after sale. The sales in the previous two months were: November $600 000; December $540 000.
3. One-quarter of purchases of materials are paid for in the month of purchase. The remainder are paid for two months later. Purchases in the previous two months were: November $108 000; December $106 000.
4. Two-thirds of the wages are paid in the month in which they are earned, and the balance is paid in the following month. The wages for the previous December amounted to $30 000.
5. One-half of the overhead expenditure is paid in the month in which it is incurred, and the balance is paid in the following month. The overheads for the previous December were $380 000.
6. Old machinery will be sold for $4000 in April. New machinery will be purchased in March for $90 000 but only one-half of the price will be paid in that month. The balance will be paid in August.
7. Ronstadt Limited has an overdraft of $63 000 at the bank at 31 December.
REQUIRED:
Prepare Ronstadt Limited’s cash budget for each of the four months from January to April.

Expert Solution
steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Knowledge Booster
Performance measurements
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
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