Answer to Question #215836 in Accounting for zuby

Question

Draw up a cash budget for D. Sithole showing the balance at the end of each month, from the following information provided by her for the six months ended 31 December 19X2.

a) Opening Cash $ 1,200.

19X2 19X3

Sales at $20 per unit

JAN 260

Feb 250

MAR 260

APR 270

MAY 320

JUN 290

JUL 400

AUG 300

SEP 350

OCT 400

NOV 390

DEC 400

Cash is received for sales after 3 months following the sales.

c) Production in units: 240 270 300 320 350 370 380 340 310 260 250

d) Raw materials cost $5/unit. Of this 80% is paid in the month of production and 20% after production.

e) Direct labour costs of $8/unit are payable in the month of production.

f) Variable expenses are $2/unit. Of this 50% is paid in the same month as production and 50% in the month following production.

g) Fixed expenses are $400/month payable each month.

h) Machinery costing $2,000 to be paid for in October 19X2.

i) Will receive a legacy of $ 2,500 in December 19X2.

j) Drawings to be $300/month.

Answer 1

The answer to your question is provided in the image: