Draw up a cash budget for Red Ltd showing the balance at the end of each month from the following information for the six months ended 31 December 2016

a. Opening cash balance (including bank) balance $12,100

b. Production in units: April 1,240, May 1,270, June 1,300, July 1,320, August 1,350, Sep 1,370, Oct 1,380, Nov 1,340, Dec 1,310, Jan 2017, 1,260, Feb, 1,250.

c. Raw materials used in production cost $5 per unit. Of this 80% is paid in the month of production and 20% in the month after production.

d. Direct labour costs of $8 per unit are payable in the month of production.

e. Variable expenses are $2 per unit, payable one-half in the same month as production and one-half in the month following production.

f. Sales at $40 per unit:

Mar 1,260, Apr 1,200, May 1,320, Jun 1,290, Jul 1,400, Aug 1,300, Sep 1,350, Oct 1,400 Nov 1,390 Dec 1,400

Debtors to pay their accounts three months after the month in which sales are made.

g. Fixed expenses of $400 per month payable each month.

h. Machinery costing $2,000 to be paid for in October 2016

i. Will receive a legacy of $2,500 in December 2016

j. Drawings to be $300 per month.

Draw up a cash budget for Amben Ltd showing the balance at the end of each month from the following information for the six months ended 31 December 2016

a. Opening cash balance (including bank) balance $12,100

b. Production in units: April 1,240, May 1,270, June 1,300, July 1,320, August 1,350, Sep 1,370, Oct 1,380, Nov 1,340, Dec 1,310, Jan 2017, 1,260, Feb, 1,250.

c. Raw materials used in production cost $5 per unit. Of this 80% is paid in the month of production and 20% in the month after production.

d. Direct labour costs of $8 per unit are payable in the month of production.

e. Variable expenses are $2 per unit, payable one-half in the same month as production and one-half in the month following production.

f. Sales at $40 per unit:

Mar 1,260, Apr 1,200, May 1,320, Jun 1,290, Jul 1,400, Aug 1,300, Sep 1,350, Oct 1,400 Nov 1,390 Dec 1,400

Debtors to pay their accounts three months after the month in which sales are made.

g. Fixed expenses of $400 per month payable each month.

h. Machinery costing $2,000 to be paid for in October 2016

i. Will receive a legacy of $2,500 in December 2016

j. Drawings to be $300 per month.