Use the information provided below to prepare the following for Mustang Enterprises for January and February...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Use the information provided below to prepare the following for Mustang Enterprises for January and February 2024. 3.1 Debtors Collection Schedule 3.2 Cash Budget. INFORMATION The following information was supplied by Mustang Enterprises: (4 marks) (16 marks) 1. Mustang Enterprises expects to have an unfavourable bank balance of R40 000 on 31 December 2023 2 The monthly sales were projected as follows: 2023 November December 2024 January February Units 44 000 53 000 Units 47 000 31.000 3. 4. 5. 6. 7. 8. 9. The selling price is R20 per unit (excluding any discounts). All the goods produced each month are expected to be sold in the same month. Sixty percent (60%) of the sales is expected to be on credit and the balance is for cash. Thirty percent (30%) of the cash sales is subject to a discount of 10%. Credit sales are usually collected as follows: 20% in the month of sale, and these debtors receive a 5% discount. 75% in the month after the sale, and the rest is usually written off as bad debts. Manufacturing overheads are paid monthly. The overheads are expected to amount to R65 000 for December 2023, including R5 000 for depreciation. Manufacturing overheads are expected to increase by 5% each month. Labour costs amount to R6 per unit and are paid in the month in which they are incurred. Labour costs per unit are expected to increase by 9% with effect from 01 February 2024. Materials cost R7 per unit (excluding any discounts). All the materials are purchased for cash to take advantage of a discount of 7.5%. R200 000 is expected to be invested in a fixed deposit account on 01 February 2024. Interest at 9% per annum is receivable monthly, commencing February 2024. Selling and administrative costs are paid monthly and are expected to total R56 000 for February 2024, after an increase of 12% takes place on 01 February 2024. Use the information provided below to prepare the following for Mustang Enterprises for January and February 2024. 3.1 Debtors Collection Schedule 3.2 Cash Budget. INFORMATION The following information was supplied by Mustang Enterprises: (4 marks) (16 marks) 1. Mustang Enterprises expects to have an unfavourable bank balance of R40 000 on 31 December 2023 2 The monthly sales were projected as follows: 2023 November December 2024 January February Units 44 000 53 000 Units 47 000 31.000 3. 4. 5. 6. 7. 8. 9. The selling price is R20 per unit (excluding any discounts). All the goods produced each month are expected to be sold in the same month. Sixty percent (60%) of the sales is expected to be on credit and the balance is for cash. Thirty percent (30%) of the cash sales is subject to a discount of 10%. Credit sales are usually collected as follows: 20% in the month of sale, and these debtors receive a 5% discount. 75% in the month after the sale, and the rest is usually written off as bad debts. Manufacturing overheads are paid monthly. The overheads are expected to amount to R65 000 for December 2023, including R5 000 for depreciation. Manufacturing overheads are expected to increase by 5% each month. Labour costs amount to R6 per unit and are paid in the month in which they are incurred. Labour costs per unit are expected to increase by 9% with effect from 01 February 2024. Materials cost R7 per unit (excluding any discounts). All the materials are purchased for cash to take advantage of a discount of 7.5%. R200 000 is expected to be invested in a fixed deposit account on 01 February 2024. Interest at 9% per annum is receivable monthly, commencing February 2024. Selling and administrative costs are paid monthly and are expected to total R56 000 for February 2024, after an increase of 12% takes place on 01 February 2024.
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Consider the hypothetical eutectic phase diagram for metals A and B, which is similar to that for the lead-tin system, Figure 9.8. Assume that (1) and phases exist at the A and B extremities of the...
-
Machine-Tech Inc., a specialized tool manufacturer, uses a job order costing system. The overhead is allocated to jobs on the basis of direct labor hours. The overhead rate is now $1,500 per direct...
-
What are special purpose vehicles (SPVs)? What is the main advantage of SPVs? List a few forms of credit enhancement that are critical to SPVs.
-
Andrea Kent has won \($600,000.00\) in a state lottery. The state will pay her the prize in 30 annual payments of \($20,000.00.\) Instructions: Assuming a 10% rate of return, calculate the present...
-
In its first month of operations, Danielle Company made three purchases of merchandise in the following sequence: (1) 300 units at $6, (2) 400 units at $7, and (3) 200 units at $8. Assuming there are...
-
2. SlamCo is considering a project to develop artificial intelligence for the financial industry. The Al module will search historical patterns through past financial crises to try to avoid the next...
-
The formula changes based on its location. The formula remains unchanged when it is moved. The formula is related to another spreadsheet. What does the term "relative" mean for a formula?
-
A Certificate-of-Need (CON) is required before facilities can implement changes in services provided. What is the purpose of the CON and how does a CON regulate staffing?
-
Perit Industries has $135,000 to invest. The company is trying to decide between two alternative uses of the funds. The alternatives are: Project A Cost of equipment required Working capital...
-
Nonconstant growth 12.00% Normal (constant) growth 4.00% Req. rate of return 13% Last dividend (D0) $1.75 Supernormal period 5 years is this right for the 13%
-
What should do if changes to the operational plan or budget are required?
-
Candid, Inc., is a manufacturer of digital cameras. It has two departments: assembly and testing. In January 2020, the company incurred $800,000 on direct materials and $805,000 on conversion costs,...
-
Beauty Gan is an accountant by profession. In 2019, she recorded a tape on country and sentimental songs as requested by Sing Song Bhd. She received RM12,000 as royalties in respect of the recording...
-
9.Consider the reaction 3NO2(g)+H2O=2HNO3(aq)+NO(g) where Delta H=-137 kJ.How many kilojoules are released when 92.3g of NO2 reacts?
-
The Mann Corporation began operations in 2015. Information relating to the companys purchases of inventory and sales of products for 2015 and 2016 is presented below. Calculate the LIFO cost of goods...
-
The Mann Corporation began operations in 2015.Information relating to the companys purchases of inventory and sales of products for 2015 and 2016 is presented below. Calculate the weighted-average...
-
Presented below is financial data for two companies that are identical yma in every respect except that Company X uses the FIFO method to value its inventory and Company Z uses the LIFO method to...
Study smarter with the SolutionInn App