Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following budget estimates are available for Ashton Ltd., manufacturer of a single product: Actual and projected sales: Cash Credit R R January (actual) 70

The following budget estimates are available for Ashton Ltd., manufacturer of a single product:

Actual and projected sales:

Cash

Credit

R

R

January (actual)

70 800

283 200

February (actual)

72 000

288 000

March (actual)

71 400

285 600

April (budget)

68 400

273 600

May (budget)

70 800

283 200

June (budget)

72 000

288 000

Debtors on average settle their accounts as follows:

50% pay during the month following the month of sale, and are allowed a discount of 5%,

47% pay during the second month following the month of sale, and

3% prove uncollectable.

Required production is as follows:

Month

Units

March

17 900

April

17 400

May

17 850

The inventory policy of the company is to maintain closing stock of raw material at 80% of the following month's production requirements. The company uses 5 kg of raw material at a cost of R1,50 per kg, to manufacture one unit. Raw material stock at March 01, equals 72 000 kg. Sixty percent of all raw material purchases are paid within the month of purchase, and the other forty percent are paid during the month following the month of purchase. Total material purchases for February amounted to R122 440.

Wages are R4 per unit, and factory overhead R3 per unit. Factory overhead include a monthly depreciation charge of R8 000. Fixed selling and administrative expenses amount to R45 000 per month, including a depreciation charge of R3 000. Monthly variable selling and administrative expenses equal 5% of total sales for the month. Wages, factory overhead, and selling and administrative expenses are all paid during the month incurred.

Computers with a book value of R12 000 will be sold for cash during March, at a loss of R2 000. New computers will be acquired at a cost of R100 000 and would be paid for in five equal monthly instalments commencing in March.

The bank balance at March 01 amounted to R18 750.

Required:

Draw up a cash budget for the months of March and April.

(b) Calculate proceeds from sale of comptures for March

(c) Calculate total recipts for March

(d) Calculate creditors payment for March

(e) Calculate total payments

(f) Calculate surplus/(deficit) for March

(g) Calculate balance at end of March

(h) Calculate collections from debtors for April

(i) Calculate total receipts for April

(j) Calculate creditors payments for April

(k) Calculate total payments for April

(l) Calculate surplus/(deficit) for April

(m)Calculate balance at the end of April

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

Accounting And Financial System Reform In Eastern Europe And Asia

Authors: Robert W. McGee, Galina G. Preobragenskaya

2nd Edition

0387257098, 9780387257099

More Books

Students also viewed these Accounting questions