QUESTION 1 (20) Required: Use the information given below to prepare the following for Altech Limited...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
QUESTION 1 (20) Required: Use the information given below to prepare the following for Altech Limited for July and August 2021: 1.1 Debtors Collection Schedule (4) (16) 1.2 Cash Budget Note: Provide separate monetary columns for each month. Where applicable, round off amounts to the nearest Rand. Information: Extract of Statement of Comprehensive Income for the month ended 30 June 2021 Sales 200 000 Cost of sales 100 000 Rent income 8 000 Advertising Salaries and wages 4 000 10 000 Rates and taxes 1 200 Electricity Other operating expenses 3 000 9 000 Additional information: 1. The business uses a fixed mark-up of 100% on cost. 2. Sales are expected to increase by 10% each month. 3. Thirty percent (30%) of the sales are for cash and the balance is on credit. Collections from credit sales are as follows: 40% in the month of the sale, and these customers are entitled to a 2% discount; 55% one month after the sale. The balance is usually written off as bad debts. 4. Closing Inventories are kept at a constant level. 50% of purchases are for cash. Creditors are paid one month after purchase. 5. In terms of the lease agreement, the rental income will increase by 10% per annum with effect from 01 July 2021. Rent is received monthly. 6. Advertising is paid monthly and is estimated to be the same percentage of sales as for June 2021. 7. Salaries and wages will increase by 10% with effect from 01 July 2021. 8. Rates and taxes will be paid in one instalment for the year during July 2021. Rates to be paid will amount to R6 000. QUESTION 4 (20) Exxarro Llimited is considering pricing and costing for the year ahead. The following data based on expected production and sales of 15 000 units are provided for analysis: Variable manufacturing cost Fixed manufacturing cost R1 185 000 R510 000 Sales commission R5 per unit sold Fixed administration cost R130 000 Sales R210 per unit Study the information provided above and answer the following questions independently: 4.1 Calculate the break-even sales value. (5) 4.2 Calculate the sales volume required to achieve a profit of R 800 000. (5) 4.3 Suppose Exxaro Limited is considering a decrease of 10% per unit in the selling price of the product with the expectation that it would increase sales volume by 10%. Is this a good idea? Motivate your answer with relevant (10) calculations. (20) 5.1 Study the extracts of the Cash Flow Statement of Conlog Limited for the year ended 31 December 2020 and QUESTION 5 answer the following: 5.1.1 What do you understand by "Cash flow from operating activities R 150 000"? 5.1.2 Name three transactions that improve cash flow but do not increase profit. 5.1.3 There is a combination of a positive net cash flow from operating activities and a negative cash flow from investing activities. Is this good for the company? Explain. (4) (6) (5) INFORMATION: Conlog Limited Extracts of Cash Flow Statement for the year ended 31 December 2020 R Cash flow from operating activities 210 000 Cash flow from investing activities (330 000) Additions to plant and machinery (330 000) Cash flow from financing activities 120 000 Increase in long term borrowings 120 000 5.2 Calculate the incremental profit/loss after tax. (5) INFORMATION: Lubners Traders is considering extending credit to some customers who may be at risk of defaulting in payment. Sales will increase by R200 000 if credit is granted to these customers. From the new accounts receivable generated, 8% is expected to be uncollectable. Additional collection costs will be 3% of sales, and the production and selling costs will be 65% of sales. Taxation is 28%. QUESTION 1 (20) Required: Use the information given below to prepare the following for Altech Limited for July and August 2021: 1.1 Debtors Collection Schedule (4) (16) 1.2 Cash Budget Note: Provide separate monetary columns for each month. Where applicable, round off amounts to the nearest Rand. Information: Extract of Statement of Comprehensive Income for the month ended 30 June 2021 Sales 200 000 Cost of sales 100 000 Rent income 8 000 Advertising Salaries and wages 4 000 10 000 Rates and taxes 1 200 Electricity Other operating expenses 3 000 9 000 Additional information: 1. The business uses a fixed mark-up of 100% on cost. 2. Sales are expected to increase by 10% each month. 3. Thirty percent (30%) of the sales are for cash and the balance is on credit. Collections from credit sales are as follows: 40% in the month of the sale, and these customers are entitled to a 2% discount; 55% one month after the sale. The balance is usually written off as bad debts. 4. Closing Inventories are kept at a constant level. 50% of purchases are for cash. Creditors are paid one month after purchase. 5. In terms of the lease agreement, the rental income will increase by 10% per annum with effect from 01 July 2021. Rent is received monthly. 6. Advertising is paid monthly and is estimated to be the same percentage of sales as for June 2021. 7. Salaries and wages will increase by 10% with effect from 01 July 2021. 8. Rates and taxes will be paid in one instalment for the year during July 2021. Rates to be paid will amount to R6 000. QUESTION 4 (20) Exxarro Llimited is considering pricing and costing for the year ahead. The following data based on expected production and sales of 15 000 units are provided for analysis: Variable manufacturing cost Fixed manufacturing cost R1 185 000 R510 000 Sales commission R5 per unit sold Fixed administration cost R130 000 Sales R210 per unit Study the information provided above and answer the following questions independently: 4.1 Calculate the break-even sales value. (5) 4.2 Calculate the sales volume required to achieve a profit of R 800 000. (5) 4.3 Suppose Exxaro Limited is considering a decrease of 10% per unit in the selling price of the product with the expectation that it would increase sales volume by 10%. Is this a good idea? Motivate your answer with relevant (10) calculations. (20) 5.1 Study the extracts of the Cash Flow Statement of Conlog Limited for the year ended 31 December 2020 and QUESTION 5 answer the following: 5.1.1 What do you understand by "Cash flow from operating activities R 150 000"? 5.1.2 Name three transactions that improve cash flow but do not increase profit. 5.1.3 There is a combination of a positive net cash flow from operating activities and a negative cash flow from investing activities. Is this good for the company? Explain. (4) (6) (5) INFORMATION: Conlog Limited Extracts of Cash Flow Statement for the year ended 31 December 2020 R Cash flow from operating activities 210 000 Cash flow from investing activities (330 000) Additions to plant and machinery (330 000) Cash flow from financing activities 120 000 Increase in long term borrowings 120 000 5.2 Calculate the incremental profit/loss after tax. (5) INFORMATION: Lubners Traders is considering extending credit to some customers who may be at risk of defaulting in payment. Sales will increase by R200 000 if credit is granted to these customers. From the new accounts receivable generated, 8% is expected to be uncollectable. Additional collection costs will be 3% of sales, and the production and selling costs will be 65% of sales. Taxation is 28%.
Expert Answer:
Answer rating: 100% (QA)
Answer Answer 4 5 Question1 11 Debtors Collection Schedule July A... View the full answer
Posted Date:
Students also viewed these accounting questions
-
Required Use the VicWest Inc. information given below to prepare a statement of cash flows for the year ended June 30, 2014, using the indirect method. a. A note is retired at carrying value. b. The...
-
For each parabola described, use the information given to find the location of the missing feature. It may help to draw a sketch. a. If the focus is (1, 4), and the directrix is y = - 3, where is the...
-
Pioneers International has just released its management forecasts for 2020 and 2021. Income Statement Revenues COGS Gross Profit G&A Expenses Depreciation Operating Profits Interest Expense EBT Taxes...
-
(CMA, adapted) Roletter Company makes and sells artistic frames for pictures of weddings, graduations, and other special events. Bob Anderson, the controller, is responsible for preparing Roletters...
-
Compare the mean, standard deviation, and variance for the data in Exercise 5.1 with their trimmed and Winsorized counterparts. The data in Exercise 5.1 54 52 51 50 36 55 44 46 57 44 43 52 38 46 55...
-
Name the three inventory methods commonly associated with process costing.
-
In April 2023, an article in the Economist discussed Apples plans to increase the number of iPhones manufactured in India. According to the article, Apple is scrambling to avoid having all its apples...
-
Suppose after submitting your sealed bid in a Vickrey auction you find out that you have lost the auction (you were not the highest bidder); however, you have the opportunity to revise your bid....
-
14.An equi-concave lens of radius of curvature 15 cm and = 1.5 is placed in water (=1.33). If one surface is silvered, then image distance from lens when an object is placed at distance of 14 cm from...
-
Three entrepreneurs were looking to start a new brewpub near Sacramento, California, called Roseville Brewing Company (RBC). Brewpubs provide two products to customersfood from the restaurant segment...
-
An asphalt core was extracted from a paving project. The following measurements were obtained in the field. Weight dry in air = 1298.37 gm. Weight submerged in water = 778.94 gm. Required % asphalt...
-
Who or what are potentially the best brand and message ambassadors? Options: satisfied customers television advertisements viral advertisements the companys employees third-party reviewers Marketing...
-
Requirement 1. Journalize the partners' initial contributions. (Record debits first, then, credits. Select the explanation on the last line of the journal entry table.) Begin by journalizing the...
-
Write the C++ statements that will ccomplete the following C++ program such that the program: a) Prompts the user for three numbers. b) Reads these numbers into three integer variables. c) Prints the...
-
so that Plot -10.5 5 SX = 2) Find the feedback control law of the form U=K,R-KxX . 0 0 0 5 0 0 5 0 -10.5 5 5 -5.5 5 -10.5 0 5 -10.5 0 0 5 0 0 0 Y=[ 0 0 0 0 1 ]X The DC gain is 1.000 and The...
-
What is the x-component (in cm) of the vector of magnitude A shown in the pictu below? Insert your answer with 1 decimal place. y [cm]. 1 0 1 A x [cm]
-
A massless string is wrapped around a 0.539 kg pulley with a radius of 0.034 m and connected to two masses. m, is 2.60 kg and m is 7.34 kg. Everything starts from rest and the masses are released. a)...
-
Record the following selected transactions for March in a two-column journal, identifying each entry by letter: (a) Received $10,000 from Shirley Knowles, owner. (b) Purchased equipment for $35,000,...
-
Consider the quadratic programming problem. min x+x s.t. 1x2 = 4. x1
-
Prove that the dual function of Eq. (16.12) is concave Data From Equation (16.12) 19S See https://www.gams.com/ 20 See http://cvxr.com/
-
Consider the problem min x1+x2 s.t. h(x) = x2 x3 = 0, - - h2(x) = x2 = 0,
Study smarter with the SolutionInn App