Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please assist QUES [25 Marks] The following actual and budgeted figures are available for Mahala Price Wholesalers: Actual Budgeted March April May June July Units
please assist
QUES [25 Marks] The following actual and budgeted figures are available for Mahala Price Wholesalers: Actual Budgeted March April May June July Units sold 60 000 57 000 63 000 ? ? Selling price per unit R6 R6.30 R6.30 R5.70 ? Purchases R108 000 R132 R204 000 ? 000 Overheads R30 000 R96 000 R48 000 R99 000 R45 000 Cash on hand - 31 R12 000 May ADDITIONAL INFORMATION 1. For the month of June, all units will be sold for cash only on a Winter Wonderland Sale at R5.70 each. They expect that this will result in the number of units sold being double the April units sold. For July, units sold are expected to be the average for the months of March, April and May at a selling price of cost plus 40%. 2. 60% of total sales are usually for cash and 40% on credit. 1. Debtors pay as follows: 50% after 30 days. 30% after 60 days. 15% after 90 days. 5% never (to be written off). 4. The sole supplier of goods has kept purchase prices constant at R4.80 per unit for the past three months, and is expected to do so in the future. 5. At the end of May, 105 000 units were in store, but no stock is to be kept on hand in future. Stock on hand will be sold; after which goods will be purchased when customers place an order. 6. Purchases are paid after 30 days. 7. Overheads are paid in cash and include depreciation of R10 740 per month. 1. It is budgeted to purchase a new computer on 30 June for R21 000 cash. Depreciation is to be written off at 20% per annum on cost. 6 Required: 1. Calculate the missing figures (?) on the table above. (4) 2. Calculate total sales for each month. (6) (15) to 3. Prepare a cash budget for June and July. UNISA 2021 QUES [25 Marks] The following actual and budgeted figures are available for Mahala Price Wholesalers: Actual Budgeted March April May June July Units sold 60 000 57 000 63 000 ? ? Selling price per unit R6 R6.30 R6.30 R5.70 ? Purchases R108 000 R132 R204 000 ? 000 Overheads R30 000 R96 000 R48 000 R99 000 R45 000 Cash on hand - 31 R12 000 May ADDITIONAL INFORMATION 1. For the month of June, all units will be sold for cash only on a Winter Wonderland Sale at R5.70 each. They expect that this will result in the number of units sold being double the April units sold. For July, units sold are expected to be the average for the months of March, April and May at a selling price of cost plus 40%. 2. 60% of total sales are usually for cash and 40% on credit. 1. Debtors pay as follows: 50% after 30 days. 30% after 60 days. 15% after 90 days. 5% never (to be written off). 4. The sole supplier of goods has kept purchase prices constant at R4.80 per unit for the past three months, and is expected to do so in the future. 5. At the end of May, 105 000 units were in store, but no stock is to be kept on hand in future. Stock on hand will be sold; after which goods will be purchased when customers place an order. 6. Purchases are paid after 30 days. 7. Overheads are paid in cash and include depreciation of R10 740 per month. 1. It is budgeted to purchase a new computer on 30 June for R21 000 cash. Depreciation is to be written off at 20% per annum on cost. 6 Required: 1. Calculate the missing figures (?) on the table above. (4) 2. Calculate total sales for each month. (6) (15) to 3. Prepare a cash budget for June and July. UNISA 2021
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started