Mzwakhe Pty Ltd has provided you with the following information to assist in the budget preparation. The marketing department has estimated monthly sales as follows:MonthUnitsJuly6 000August7 000September5 000October4 000November3 000 The selling price per unit is R150 per unit. All sales are on credit. Based on the past experience, credit sales are expected to be collected in the following pattern: 40% in the month of sale. 50% in the month following sale. 10% uncollectable.The beginning of accounts receivable balance (excluding uncollectable amounts) on 1 July will be R130 000. The company maintains finished goods inventories equal 10% of the following month’s budgeted sales. The inventory of finished goods on 1 July will be 600 units. Each unit requires two (2) kilograms of Material B on hand at the end of each month equal to 20% of the following month’s production needs. The inventory of Material B on hand in July will be 2 400 kilograms. Material A costs R10 per kilogram. Each unit requires 1,5 hours at R50 per hour.Required:Filli in the missing figures by choosing the correct answer from the options provided:1. Production budget AugustSeptemberBudgeted sales in units7 0005 000Add: Blank 1Blank 2Blank 3Total needs Less: Blank 4Blank 5Blank 6Units to be producedBlank 7Blank 82. Collection from customers JulyAugustAccounts receivableBlank 9 July salesBlank 10Blank 11August sales Blank 12Total cash collectionsBlank 13Blank 143. Material purchases budget for AugustProduction requiredBlank 15X 2 kgBlank 16Total needsBlank 17Add: closing inventoryBlank 18Materials neededBlank 19Less: opening inventoryBlank 20Total material purchasesBlank 21Cost per kgBlank 22Total material costBlank 23
Question
Mzwakhe Pty Ltd has provided you with the following information to assist in the budget preparation. The marketing department has estimated monthly sales as follows:MonthUnitsJuly6 000August7 000September5 000October4 000November3 000 The selling price per unit is R150 per unit. All sales are on credit. Based on the past experience, credit sales are expected to be collected in the following pattern: 40% in the month of sale. 50% in the month following sale. 10% uncollectable.The beginning of accounts receivable balance (excluding uncollectable amounts) on 1 July will be R130 000. The company maintains finished goods inventories equal 10% of the following month’s budgeted sales. The inventory of finished goods on 1 July will be 600 units. Each unit requires two (2) kilograms of Material B on hand at the end of each month equal to 20% of the following month’s production needs. The inventory of Material B on hand in July will be 2 400 kilograms. Material A costs R10 per kilogram. Each unit requires 1,5 hours at R50 per hour.Required:Filli in the missing figures by choosing the correct answer from the options provided:1. Production budget AugustSeptemberBudgeted sales in units7 0005 000Add: Blank 1Blank 2Blank 3Total needs Less: Blank 4Blank 5Blank 6Units to be producedBlank 7Blank 82. Collection from customers JulyAugustAccounts receivableBlank 9 July salesBlank 10Blank 11August sales Blank 12Total cash collectionsBlank 13Blank 143. Material purchases budget for AugustProduction requiredBlank 15X 2 kgBlank 16Total needsBlank 17Add: closing inventoryBlank 18Materials neededBlank 19Less: opening inventoryBlank 20Total material purchasesBlank 21Cost per kgBlank 22Total material costBlank 23
Solution
Sure, let's fill in the missing figures step by step:
-
Production budget August Budgeted sales in units: 7 000 Add: Desired ending inventory (10% of September's budgeted sales): 500 Total needs: 7 500 Less: Beginning inventory (10% of August's budgeted sales): 700 Units to be produced: 6 800
September Budgeted sales in units: 5 000 Add: Desired ending inventory (10% of October's budgeted sales): 400 Total needs: 5 400 Less: Beginning inventory (10% of September's budgeted sales): 500 Units to be produced: 4 900
-
Collection from customers July Accounts receivable: R130 000 July sales (40% of 6 000 units at R150 per unit): R360 000 Total cash collections: R490 000
August July sales (50% of 6 000 units at R150 per unit): R450 000 August sales (40% of 7 000 units at R150 per unit): R420 000 Total cash collections: R870 000
-
Material purchases budget for August Production required: 6 800 units X 2 kg: 13 600 kg Total needs: 13 600 kg Add: closing inventory (20% of September's production needs): 1 960 kg Materials needed: 15 560 kg Less: opening inventory: 2 400 kg Total material purchases: 13 160 kg Cost per kg: R10 Total material cost: R131 600
Similar Questions
Budget Master Ltd is in the process of preparing budgets for the period October toDecember 2018. Thefollowing information has been provided to assist in the budgeting process:(1) Budgeted monthly sales revenue is as follows:GHSOctober 2018 40,000November 2018 70,000December 2018 50,000January 2019 45,000(2) Sales are 20% cash and 80% credit. Credit sales are collected over a three month period: 15%in the month of sale, 70% in the month following sale and 15% in the second month followingsale. Bad debts of 5% are anticipated on all credit sales.(3) Total sales revenue in August 2018 amounts to GHS30,000 and September 2018’s total salesrevenue amounts to GHS36,000.(4) Cost of sales is expected to amount to 60% of sales revenue each month.(5) The business maintains its closing inventory levels at 75% of the following month’s cost ofsales. Inventory at the beginning of October 2018 is expected to amount to GHS18,000.(6) 50% of inventory purchased is paid in the month of purchase. The remaining 50% is paid forin the month following purchase. As at 30 September 2018, amount owed for purchases areGHS11,700.(7) A grant of GHS20,000 is expected to be received in mid-October 2018.(8) A second hand van which cost GHS8,000 three years ago is expected to be sold in December2018 for GHS3,000. At this time the expected net book value of the van is GHS1,800.(9) Equipment costing GHS4,500 will be purchased and paid for in November 2018. Theequipment will be depreciated on a straight line basis over three years.(10) Operating expenses are paid as incurred. These have been estimated as follows:GHSOctober 2018 12,800November 2018 18,900December 2018 14,600The above figures include depreciation on existing assets of GHS2,000 per month.(11) The cash balance on 1 October 2018 is expected to amount to GHS8,000Required:i) Calculate the purchases figure for each month from October 2018 to December 2018.
From the data for Chan Enterprises, calculate the estimated cash received from credit sales for June. Credit sales for April-June are given in the table.MonthCredit salesApril $20,000May$22,000June$25,000Credit sales are normally settled in the pattern: 60% in the month of sale and 40% in the month following the sale.Group of answer choices$25,000$15,000$23,800$22,000
Fill in the Blank QuestionFill in the blank question.A manufacturing company's sales budget indicates the following sales: January: $30,000; February: $20,000; March: $15,000. The company expects 80% of the sales to be on account. Credit sales are collected 30% in the month of the sale and 70% in the month following the sale. The total cash receipts collected during March will be $.
Budgeted sales in Washburn Company over the next four months are given below: September October November DecemberBudgeted sales $ 180,000 $ 240,000 $ 260,000 $ 200,00025% of the company's sales are for cash and 75% are on account. Collections for sales on account follow a stable pattern as follows: 50% of a month's credit sales are collected in the month of sale, 30% are collected in the month following sale, and 15% are collected in the second month following sale. The remainder is uncollectible. Given these data, cash collections for December should be:Multiple Choice$244,000.$210,500.$163,200.$189,000.
Tshiawelo Pty Limited has provided you with the following extract from the financial records for the financial year ended 31 December 2023 RCost of sales2 400 000Gross profit40%Operating expenses800 000Interest expense200 000Income tax expense30%Inventories 800 000Issued capital2 000 000Trade payables500 000Trade receivables600 000Cash and other equivalents200 000Short-term borrowings500 000Long-term borrowings2 000 000Property Plant and equipment1 000 000Required:Calculate the following ratios by choosing the correct answer from the options provided:Revenue from sales Blank 1 Net profit margin Blank 2Current ratio Blank 3Quick ratio Blank 4Debtors’ collection period Blank 5 Return on assets (ROA) Blank 6Days’ sales inventory held Blank 7Times interest earned ratio Blank 8
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.