Question

In: Accounting

Karantika Ltd operates at capacity and makes glass-topped coffee table. At the end of 2019, Karantika...

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: Units sales per quarter and the selling price per unit are estimated as follows: 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. The beginning inventories (BI) on 1 January 2020 and the desired ending inventories (EI) at the end of each month are as follows: 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) Materials and labour requirements Direct materials: Wood: 2 board meters (b.m.) per table Glass: 1 sheet per table Direct manufacturing labour: 4 hours per table Costs of direct materials and labour: Wood: $16 per b.m. Glass: $22 per sheet Direct labour: $25 per labour-hour Direct materials are purchased in the month of production and are paid 60% in the month of purchase and 40% in the following month. Wages and salaries are paid monthly. Variable manufacturing overhead is $25 per direct manufacturing labour-hour. There is also $210,000 in fixed manufacturing overhead costs per month. Fixed costs include $40,000 depreciation of factory equipment. The fixed manufacturing overhead rate is based on the number of units produced budgeted every six months, at the beginning of each semester, calculated dividing the budgeted fixed overhead costs by the budgeted number of units produced for the semester. Variable and fixed costs are paid in the month incurred. Sales commissions are paid monthly at the rate of 10% of month’s sales revenue. There is $160,000 in fixed non-manufacturing costs (administrative expenses) budgeted per month including $20,000 depreciation costs of office equipment. Variable and fixed non-manufacturing costs are paid in the month incurred. Karantika Ltd has estimated the following payments in the first semester 2020: 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. Karantika Ltd maintain a 18% open line of credit for $400,000. Interests are paid at the end of each month. Karantika Ltd maintains a minimum cash balance of $20,000. The company borrows on the first day of the month and repays loans on the last day of the month, both in multiples of $1,000. The income tax is 30%. Karantika Ltd’s balance sheet at 31 December 2019 is as follows: 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): Sales revenue budget Production budget (in units) Direct materials usage and purchases budget for each direct materials and total direct materials (in units and dollars) Direct manufacturing labour budget Manufacturing overhead budget Manufacturing overhead rate for the semester Ending finished goods inventory budget (unit cost and total cost) at June 2020. Selling and administrative expenses budget Cash budget Cost of goods sold at 30 June 2020 Budgeted income statement for the first semester 2020 Budgeted balance sheet as of 30 June 2020 (including separately the two direct materials inventory) Note. There is no beginning and ending balance of WIP in each month. Can you please
do the cash disbursements, cash collections manufacturing overhead
budget, cash budget?

Solutions

Expert Solution


Related Solutions

Karantika Ltd operates at capacity and makes glass-topped coffee table. At the end of 2019, Karantika...
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: Units sales per quarter and the selling price per unit are estimated as follows: 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...
Karantika Ltd operates at capacity and makes glass-topped coffee table. At the end of 2019, Karantika...
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: Units sales per quarter and the selling price per unit are estimated as follows: 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...
Q.2 (Max Marks:90) Bombera Ltd operates at capacity and makes glass-topped dining tables and wooden chairs,...
Q.2 (Max Marks:90) Bombera Ltd operates at capacity and makes glass-topped dining tables and wooden chairs, which are then typically sold as sets of four chairs with one table. However, some customers purchase replacement or extra chairs, and others buy some chairs or a table only, so the sales mix is not exactly 4:1. Bombera Ltd is planning its annual budget for the financial year 2018. Information for 2018 follows: Input prices   Direct materials Wood $5.30 per board metre Glass...
Triumph Trophies makes trophies and plaques and operates at capacity. Triumphdoes large custom​ orders, such as...
Triumph Trophies makes trophies and plaques and operates at capacity. Triumphdoes large custom​ orders, such as the participant trophies for the Minnetonka Little League. The controller has asked you to compare​plant-wide, department, and​ activity-based cost allocation.  Triumph Trophies Budgeted Information for the Year Ended November 30​, 2014 Forming Department Trophies Plaques Total Direct materials $26,000 $23,500 $49,500 Direct manufacturing labor 30,200 13,800 44,000 Overhead costs Set up 21,560 Supervision 20,680 Assembly Department Trophies Plaques Total Direct materials $4,900 $87,150 $92,050...
Exercise 1 The production department of Alpha Ltd. normally operates at a capacity of 5 000...
Exercise 1 The production department of Alpha Ltd. normally operates at a capacity of 5 000 direct labor hours (DLH) per production period. In the coming production period (April-May) orders equivalent to only 3 000 DLH have been received. Even though direct labor is hired/paid on an hourly basis, Alpha Ltd. wants to deploy the available 2 000 DLH and considers two alternatives: First alternative: advancing the production of an anticipated future order that consumes             2 000 DLH (delivery date...
First Cup Ltd., a Canadian coffee retailer and roaster which operates more than 1,000 cafes in...
First Cup Ltd., a Canadian coffee retailer and roaster which operates more than 1,000 cafes in Canada, reported the following balances as at December 31, 2020: 7% Par $100 convertible bonds, issued at par $250,000       3,000 call options, each entitled to purchase 1 common shar Cumulative Preferred shares, 36,000 convertible shares outstanding    $960,000 Common shares, 112,500 shares issued and outstanding $2,880,000 Contributed surplus on repurchase of common shares $31,200 Retained earnings $1,032,000 First Cup Ltd. applies IFRS. The...
Insight Glass Company             Insight Glass makes sliding glass doors for two local construction companies and...
Insight Glass Company             Insight Glass makes sliding glass doors for two local construction companies and wants to prepare a master budget for the next month of operation, June 2014.             The sales department estimates that it can sell 180 doors in June. Each door retails for $1,100. In order to avoid delays in shipping, management wants to maintain ending inventory each month equal to 10% of the estimated unit sales in that month. Beginning inventory of finished doors is...
A firm operates a chain of coffee outlets in the city selling a coffee called “smart...
A firm operates a chain of coffee outlets in the city selling a coffee called “smart coffee”. The firm has estimated a regression model that suggests three variables are significant determinants of demand for “smart coffee”. The results obtained from the regression model is provided below. Q=1000-60P+20DF+1.5A Q: (dependent variable) is number of cups of “smart coffee” sold per week P: is the price in dollars of a cup of “smart coffee” DF: the price in dollars of a cup...
18. On 30 June 2019, the end of the current reporting period, Kirk Ltd made a...
18. On 30 June 2019, the end of the current reporting period, Kirk Ltd made a decision, using the information obtained over the past few years, to revise the useful life of acquired five years earlier on 1 July 2014 for $1 000 000. The useful life was revised from ten years to 15 years. The building was originally depreciated on the straight-line basis over its useful life and it was expected that the building would have no residual value....
Donald's Tables Co. makes a standard coffee table. Donald's has determined the sales and cost values...
Donald's Tables Co. makes a standard coffee table. Donald's has determined the sales and cost values for the month of March that are given below. Find the margin of safety in dollars. Selling Price of a coffee table: $9.30 Variable cost per coffee table: $1.80 Sales Commission (as a percentage of revenues) to be paid by Donald's to its sales people: 0% Fixed cost: $24,000 Tax rate (as a percentage of operating income): 25% Net Income: $11,250
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT