In: Accounting
Karantika Ltd operates at capacity and makes glass-topped coffee table. At the end of 2019, Karantika Ltd’s management accountant gathered the following data to prepare budgets for the first six months 2020:
Unit sales Price per unit
January 2,700 $400
February 2,600 $400
March 2,800 $550
April 2,600 $550
May 2,650 $500
June 2,600 $500
July 3,000 $500
August 3,000 $550
Sales on November 2019 were 2,500 units and on December 2,400 units at a selling price of $450.
20% of sales are cash sales and 80% are credit sales. From experience, Karantika Ltd collected 40% of credit sales within the month of sale, 30% in the following month and 25% in two months after the month of sale. 5% of credit sales is uncollectable. The bad debt is calculated at the end of six month.
BI (1/1/19) |
EI (end of each month) |
---|---|
Tables:500 (at $210/unit) |
20% of following month estimated sales |
Wood: 1,400 b.m. |
25% b.m. needed for next month’s budgeted production (units) |
Glass 500 sheets |
20% sheets needed for next month’s budgeted production (units) |
Direct materials:
Wood: 2 board meters (b.m.) per table
Glass: 1 sheet per table
Direct manufacturing labour: 4 hours per table
Wood: $16 per b.m.
Glass: $22 per sheet
Direct labour: $25 per labour-hour
January: Loan for $40,000 plus interest payable at 31 December 2019 for $2,000 were paid on 2 January 2020.
End of January: Dividends $100,000
Beginning of May: Purchase of land $200,000
Beginning of June: Purchase of equipment for $300,000. Estimated of useful life 5 year with zero residual value.
ASSETS |
LIABILITIES |
||
---|---|---|---|
Cash |
32,000 | Accounts payable ** | 64,000 |
Accounts receivable * |
700,200 | Interest payable | 2,000 |
Inventory: Wood |
22,400 | Loan payable | 40,000 |
Inventory: Glass |
11,000 | SHAREHOLDER’S EQUITY | |
Inventory: Finished goods |
105,000 | Share capital | 801,600 |
Plant and equipment, net |
450,000 | Retained earnings | 413,000 |
Total assets |
1, 320,600 | Total Liabilities and Shareholder’s equity | 1,320,600 |
*At the beginning of the year there is no allowance of doubtful debt
** Account payable is from the direct material purchase.
Required:
Prepare a monthly master budget for Karantika Ltd’s for the first semester 2020. The following component budgets must be included ( round the number with two decimals):
Note. There is no beginning and ending balance of WIP in each month.