AmBen Ltd., an owner-managed company is preparing budget for the forthcoming year and has presented the following information.

As the companys accountant management has requested that you prepare the following budgets for the six months ended 31 December 2020 to help them plan for the year ahead.

1. Production budget
2. Raw materials purchase budget
3. Direct wages (labour cost) budget
4. Variable production cost budget
5. Cash budget

a. Opening cash balance (including bank) balance $ 2,200 July 2020

b. Production in units: March 2,140, 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 2021 1,260, Feb, 1,250.

c. Raw materials used in production cost $13 per unit. Of this 60% is paid in the month of production and 40% in the month after production.

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

e. Variable production cost are $5 per unit, payable 75% in the same month as production and 25% in the month following production.

Sales at $37 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

f. All goods are sold on credit. Seventy (70%) percent of the value of credit sales is received one month after sale, 20% two months after sale and 8% three months after sale. The balance is written off as bad debt.

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

h. Amben ltd. has placed an order for three new forklift trucks that will cost $25,000 each. The scheduled payment date is in October.

i. Cash from a loan secured on the land and buildings of $90,000 at an interest rate of 7.5% is due to be received on 1 August.

j. Depreciation on the forklift is $2,000 per annum.

k. An interim dividend and tax thereon, $34,000 to be paid in November.

l. An old forklift will be sold in July for $5,000.

20. Calculate the production budget for August, September, and October

(A) $31,680; $32,400; $32,160

(B) $$32,400; $32,880; $32,160

(C) $33,120; $32,880; $32,400

(D) $32,400; $32,880; $33,120

21. Calculate the sales budget for October, November, and December

(A) $51,800; $48,100; $51,800

(B) $51,800; $51,430; $51,800

(C) $48,100; $47,730; $51,800

(D) $47,730; $48,100; $51,800

22. Calculate the raw materials budget for July, August, and September.

(A) $17,056; $17394; $17,706

(B)$17,160; $17,706; 17,550

(C) $17,160; $17,550; $17,810

(D) $17,810; $17,394; $17,056

23. Calculate the direct labour cost budget for September, October, and November.

(A) $8,220; $8,280; $8,040

(B) $7,800; $7,860; $8,100

(C) $8,100; $8,280; $8,220

(D) $8,040; $7,860; $7,800

24. Calculate the Variable cost budget for August, September, and October.

(A) $6,550; $6,600; $6,500

(B) $6,900; $6,850; $6,750

(C) $6,850; $6,750; $6,900

(D) $6,750; $6,850; $6,900

25. Calculate the total cash receipts for July, September, and November

(A) $51,731; $47,848; $50,098

(B) $50,098; $32,607; $33,151

(C) $32,607; $33,151; $32,034

(D) $47,848; $50,098; $51,731

26. Calculate total cash payments for August, September, and December

(A) $84,054; $32,034; $32,607

(B) $32,607; $33,151; $32,034

(C) $51,731; $47,848; $50,098

(D) $50,098; $32,607; $33,151

27. Calculate the ending cash balance for September, October, and December.

(A) $50,098; $32,607; $33,151

(B) $51,731; $47,848; $50,098

(C) $85,661; $143,784; $51,731

(D) $143,784; $84,054; $85,661