Usiba (Pty) Ltd manufactures cellphone chips. An extract from a company's third quarter sales budget for 2024 is as follows: RJuly1 080 700August870 200September1 055 480 Twenty five percent (25%) of sales are paid for immediately in cash. Of the credit customers, sixty percent (60%) pay in the month of sale and are entitled to a one percent (1%) discount. The remaining customers pay a month after the sale is made. The budgeted sales for June 2024 amount to R995 750.The production budget for cellphone chips for July 2024 to September 2024 is as follows. JulyAugustSeptemberProduction units3 0502 8603 620 Each unit of cellphone chip requires 75 minutes of direct labour. The direct labour rate is R40 per hour. Wages are paid in the month of production. Production units of 2 590 cellphone chips are planned to be produced in June 2024.The budgeted raw material purchases is as follows.JulyAugustSeptemberRRR270 300284 000289 100 Fifty percent (50%) of material purchases are paid for immediately in cash. Credit purchases are paid for in the month following purchase. The raw material purchases with the value of R240 550 are budgeted for the month of June 2024.All other costs are paid as incurred.Required:Calculate the missing data in the following cash budget and choose the correct answer from the options provided. (Round off to the nearest R1, where applicable).JulyAugustSeptember RRROpening balance of cashBlank 1461 185Blank 2Cash inflows: Cash collection from salesBlank 3Blank 4Blank 5Cash outflows: Raw material purchasesBlank 6Blank 7Blank 8Direct labour paymentBlank 9Blank 10Blank 11Payment of other expenses298 000275 000345 200Net cash surplus/(deficit)461 185Blank 12Blank 13
Question
Usiba (Pty) Ltd manufactures cellphone chips. An extract from a company's third quarter sales budget for 2024 is as follows: RJuly1 080 700August870 200September1 055 480 Twenty five percent (25%) of sales are paid for immediately in cash. Of the credit customers, sixty percent (60%) pay in the month of sale and are entitled to a one percent (1%) discount. The remaining customers pay a month after the sale is made. The budgeted sales for June 2024 amount to R995 750.The production budget for cellphone chips for July 2024 to September 2024 is as follows. JulyAugustSeptemberProduction units3 0502 8603 620 Each unit of cellphone chip requires 75 minutes of direct labour. The direct labour rate is R40 per hour. Wages are paid in the month of production. Production units of 2 590 cellphone chips are planned to be produced in June 2024.The budgeted raw material purchases is as follows.JulyAugustSeptemberRRR270 300284 000289 100 Fifty percent (50%) of material purchases are paid for immediately in cash. Credit purchases are paid for in the month following purchase. The raw material purchases with the value of R240 550 are budgeted for the month of June 2024.All other costs are paid as incurred.Required:Calculate the missing data in the following cash budget and choose the correct answer from the options provided. (Round off to the nearest R1, where applicable).JulyAugustSeptember RRROpening balance of cashBlank 1461 185Blank 2Cash inflows: Cash collection from salesBlank 3Blank 4Blank 5Cash outflows: Raw material purchasesBlank 6Blank 7Blank 8Direct labour paymentBlank 9Blank 10Blank 11Payment of other expenses298 000275 000345 200Net cash surplus/(deficit)461 185Blank 12Blank 13
Solution
To solve this problem, we need to calculate the cash inflows and outflows for each month.
- Cash collection from sales:
For July, August, and September, we calculate the cash collection from sales as follows:
- 25% of sales are paid immediately in cash.
- 60% of sales are paid in the month of sale with a 1% discount.
So, for July, the cash collection from sales is: (25% of 1,080,700) + (60% of 1,080,700 * 99%) = R270,175 + R641,616 = R911,791
For August, the cash collection from sales is: (25% of 870,200) + (60% of 870,200 * 99%) = R217,550 + R516,718 = R734,268
For September, the cash collection from sales is: (25% of 1,055,480) + (60% of 1,055,480 * 99%) = R263,870 + R627,884 = R891,754
- Raw material purchases:
50% of material purchases are paid immediately in cash, and the remaining are paid in the following month.
So, for July, the cash outflow for raw material purchases is: 50% of 270,300 (July purchases) + 100% of 240,550 (June purchases) = R135,150 + R240,550 = R375,700
For August, the cash outflow for raw material purchases is: 50% of 284,000 (August purchases) + 50% of 270,300 (July purchases) = R142,000 + R135,150 = R277,150
For September, the cash outflow for raw material purchases is: 50% of 289,100 (September purchases) + 50% of 284,000 (August purchases) = R144,550 + R142,000 = R286,550
- Direct labour payment:
Each unit of cellphone chip requires 75 minutes of direct labour, and the direct labour rate is R40 per hour. Wages are paid in the month of production.
So, for July, the direct labour payment is: (3,050 units * 75 minutes/unit) / 60 minutes/hour * R40/hour = R152,500
For August, the direct labour payment is: (2,860 units * 75 minutes/unit) / 60 minutes/hour * R40/hour = R143,000
For September, the direct labour payment is: (3,620 units * 75 minutes/unit) / 60 minutes/hour * R40/hour = R181,000
- Net cash surplus/(deficit):
For July, the net cash surplus is: Opening balance + Cash inflows - Cash outflows = R461,185 + R911,791 - (R375,700 + R152,500 + R298,000) = R546,776
For August, the net cash surplus is: Opening balance + Cash inflows - Cash outflows = R546,776 + R734,268 - (R277,150 + R143,000 + R275,000) = R585,894
For September, the net cash surplus is: Opening balance + Cash inflows - Cash outflows = R585,894 + R891,754 - (R286,550 + R181,000 + R345,200) = R664,898
So, the missing data in the cash budget are:
Blank 1: R461,185 (Opening balance for July) Blank 2: R585,894 (Opening balance for September) Blank 3: R911,791 (Cash collection from sales for July) Blank 4: R734,268 (Cash collection from sales for August) Blank 5: R891,754 (Cash collection from sales for September) Blank 6: R375,700 (Raw material purchases for July) Blank 7: R277,150 (Raw material purchases for August) Blank 8: R286,550 (Raw material purchases for September) Blank 9: R152,500 (Direct labour payment for July) Blank 10: R143,000 (Direct labour payment for August) Blank 11: R181,000 (Direct labour payment for September) Blank 12: R546,776 (Net cash surplus for August) Blank 13: R664,898 (Net cash surplus for September)
Similar Questions
Umvoti Pty LTD is preparing its budget for the next four (4) months. The following information has been drawn from the budgets prepared in the planning exercise so far: Sales volume November R120 500 December R130 600 January R170 000 February R160 800 Direct material purchases November R13 450 December R13 780 January R12 890 February R13 150 Direct wages amount to R13 150. Majazana sells 10% of its goods for cash. The remainder of customers receive on month’s credit. Payments to material suppliers are made in the month following purchase. Wages are paid as they are incurred. Production overheads are R13 200 per month. Majazana takes one month credit on production overheads. Included in the amount for overheads is depreciation charge of R1 300. Selling, distribution and administrative expenses amount to R10 890 per month. The company plans to purchase a delivery vehicle December for a cash purchase of R60 000. The net balance at the end of November was R5 000. Required: Complete the following cash budgets by choosing the correct answers from the options provided. December January Opening balance Blank 1 Blank 2 Cash sales Blank 3 Blank 4 Credit sales Blank 5 Blank 6 Total receipts Blank 7 Blank 8 Less: payments Blank 9 Blank 10 Material purchases Blank 11 Blank 12 Direct wages Blank 13 Blank 14 Production overheads Blank 15 Blank 16 Selling, distribution and administrative expenses 11 890 11 890 Delivery vehicle 60 000 Closing balance Blank 17 Blank 18
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
The Model Company is to begin operations in April. It has budgeted April sales of $70,000, May sales of $74,000, June sales of $80,000, July sales of $82,000, and August sales of $78,000. Note that 10% of each month's sales is expected to represent cash sales; 75% of the balance is expected to be collected in the month following the sale, 17% the second month, 6% the third month, and the balance is expected to be uncollectible.The Model Company is considering charging 1 1/2% on any balance that is not collected in the month following the month of sale. This charge would also change the collection percentages to 15% cash sales, 80% of the balance collected in the month following the sale, 16% the second month, and 3% the third month. This stricter credit policy will reduce the estimated sales budgets by 7% each month. Under this stricter credit policy, what is the amount of cash to be collected in July?Multiple Choice$77,157$73,216$71,338$79,191
Umngeni (Pty) Ltd uses normal costing. The following data have been taken from the accounting records of Umgeni (Pty) Ltd for the month of April 2024: RSales1 980 000Selling expenses280 000Manufacturing overheads incurred460 000Manufacturing overheads absorbed445 000Direct labour400 000Administrative expenses300 000Direct materials issued to production180 000Finished goods inventory, beginning240 000Finished goods inventory, ending320 000Raw materials inventory, beginning80 000Raw materials inventory, ending140 000Work in process inventory, beginning140 000Work in process inventory, ending100 000Required:Calculate the following items and fill in the missing data by choosing the correct answers from the options provided:(a) Cost of the raw materials purchased during the month of April. RBlank 1140 000Blank 2Blank 3Blank 4Blank 5Blank 6Blank 7Cost of the raw materials purchasedBlank 8 (b) Cost of goods manufactured for the month of April. RBlank 9Blank 10Blank 11180 000Direct labourBlank 12Blank 13Blank 14Blank 15Blank 16Blank 17Blank 18Cost of goods manufacturedBlank 19(c) Cost of goods sold for the month of April. RBlank 20240 000Blank 21Blank 22Blank 23Blank 24Blank 25Blank 26Blank 27Blank 28 Blank 29Blank 30Adjusted cost of goods soldBlank 31
Tiger Pty Ltd prepares quarterly financial statements. The adjusted trial balance on 30 September 2021 is shown below. Using the information provided: Tiger Pty Ltd Adjusted trial balance 30 September 2021 No. Account Name Dr Cr 100 Cash 4,500 110 Accounts receivable 3,200 120 Prepaid insurance 2,300 130 Office equipment 4,000 131 Accumulated depreciation — equipment 1,500 200 Accounts payable 3,600 210 Rent revenue received in advance 1,400 300 Share Capital 3,900 310 Retained earnings 2,000 311 Dividends 500 400 Rent revenue 7,300 410 Service revenue 1,500 500 Salaries expense 3,100 510 Rent expense 2,800 520 Depreciation expense 450 530 Insurance expense 350 $21,200 $21,200 2-(B) Prepare for a statement of financial position for quarter ending 30 September 2021.
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.