Teleshop Namibia Ltd (TeiNam) is a Namibian based company that manufactures a component required in the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Teleshop Namibia Ltd (TeiNam) is a Namibian based company that manufactures a component required in the telecommunications industry. The company prepares budgets on a quarterly basis. You have recently joined the company as a management accounting intern and have been tasked to assist the company in the preparation of their cash budget for the forthcoming period. You have thus been presented with the following information 1. The company's bank account will be having a debit balance of NS100 000 by end of December 2021. 2. Each quarter is expected to generate sales units as follows Sales units Quarter 1 Quarter 2 Quarter 3 Quarter 4 4 000 4 100 4 600 5 500 The projected selling price is NS120 per unit. 7Ox of the customers will pay cash, and of these customers. 30% qualily for a cash discount of 5%. The rest of the customers are on credit and they settle their accounts in the same quarter as the sale. Bad debts are estimated to be 5% per quarter. 3. The production schedule for 2021 is as follows: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Units 4 600 5 500 5 700 6 200 4. The direct labour per each component is 0.6 hours paid at NS20 per hour in cash. 5. Direct materials will be purchased as follows NS Quarter 1 Quarter 2 Quarter 3 230 000 250 000 260 000 290 000 Quarter 4 60% of the materials are on credit and the balance on cash. The payment of credit purchases materials is done as follows: 75% in the quarter 25% in the following quarter. The purchases for the fourth quarter of 2020 are expected to be NS340 00. 6. Fixed manufacturing overheads will be paid in the quarter in which they are incurred. TelNam has budgeted for faxed costs at NS200 000 for each quarter. Depreciation at a rate of $20 000 per quarter is included in this amount. 7. The variable manufacturing overheads will NS5 per direct labour hour and are paid for in the quarter in which they incurred. It is anticipated that they will increase by 10% on 1 October 2020. 8. Fixed selling and administrative expenses will amount to NS50 000 per quarter and will be paid for in the quarter in which they occurred. 9. Variable seling and administrative expenses will be NS6 per unit. 10. A dividend of NS0.07 per share will be paid at the end of the second quarter. The issued share capital on 31 December 2021 will be NS800 000 and wil be made up as follows: 250 000 ordinary shares issued at NS2 each 1 July 2010; and • 100 000 ordinary shares to be issued at NS3 each on 01 July 2020. Requirement Marks Showing all the necessary workings, prepare the cash budget for TelNam for 1.1 35 the year 2021 1.2 Identify ways in which TelNam can improve their cash flow N.B. Where applicable show all workings. Total 38 3. Teleshop Namibia Ltd (TeiNam) is a Namibian based company that manufactures a component required in the telecommunications industry. The company prepares budgets on a quarterly basis. You have recently joined the company as a management accounting intern and have been tasked to assist the company in the preparation of their cash budget for the forthcoming period. You have thus been presented with the following information 1. The company's bank account will be having a debit balance of NS100 000 by end of December 2021. 2. Each quarter is expected to generate sales units as follows Sales units Quarter 1 Quarter 2 Quarter 3 Quarter 4 4 000 4 100 4 600 5 500 The projected selling price is NS120 per unit. 7Ox of the customers will pay cash, and of these customers. 30% qualily for a cash discount of 5%. The rest of the customers are on credit and they settle their accounts in the same quarter as the sale. Bad debts are estimated to be 5% per quarter. 3. The production schedule for 2021 is as follows: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Units 4 600 5 500 5 700 6 200 4. The direct labour per each component is 0.6 hours paid at NS20 per hour in cash. 5. Direct materials will be purchased as follows NS Quarter 1 Quarter 2 Quarter 3 230 000 250 000 260 000 290 000 Quarter 4 60% of the materials are on credit and the balance on cash. The payment of credit purchases materials is done as follows: 75% in the quarter 25% in the following quarter. The purchases for the fourth quarter of 2020 are expected to be NS340 00. 6. Fixed manufacturing overheads will be paid in the quarter in which they are incurred. TelNam has budgeted for faxed costs at NS200 000 for each quarter. Depreciation at a rate of $20 000 per quarter is included in this amount. 7. The variable manufacturing overheads will NS5 per direct labour hour and are paid for in the quarter in which they incurred. It is anticipated that they will increase by 10% on 1 October 2020. 8. Fixed selling and administrative expenses will amount to NS50 000 per quarter and will be paid for in the quarter in which they occurred. 9. Variable seling and administrative expenses will be NS6 per unit. 10. A dividend of NS0.07 per share will be paid at the end of the second quarter. The issued share capital on 31 December 2021 will be NS800 000 and wil be made up as follows: 250 000 ordinary shares issued at NS2 each 1 July 2010; and • 100 000 ordinary shares to be issued at NS3 each on 01 July 2020. Requirement Marks Showing all the necessary workings, prepare the cash budget for TelNam for 1.1 35 the year 2021 1.2 Identify ways in which TelNam can improve their cash flow N.B. Where applicable show all workings. Total 38 3.
Expert Answer:
Answer rating: 100% (QA)
Answer to 11 Cash Budget of TelNam Particulars Amount in N Quarter 1 Quarter 2 Quarter 3 Quarter 4 Opening cash balance a 209538 185278 154424 59810 C... View the full answer
Related Book For
Statistics for Business and Economics
ISBN: 978-0132930192
8th edition
Authors: Paul Newbold, William Carlson, Betty Thorne
Posted Date:
Students also viewed these accounting questions
-
Closwa Biltong is a Namibian based biltong manufacturer and retailer. The company is famous for its tasty biltong snack packets which are sold at lower prices than that of competitors. Closwa Biltong...
-
Busiswa Gqulu aged 31, born in Mthatha, Eastern Cape, South Africa, is a South African singer-songwriter and poet. She has been in the house-production industry for several years and one of the...
-
Sean has taken over his fathers home loans business, Auzzie Loans Pty Ltd. There are three directors (Sean and his parents), who are also members of the company. When the global financial crisis hit,...
-
a. Over a two year time horizon an investor experiences the following net cash flows: Year 0 1 2 Cash flow -$8,000 $5,280 $5,320 What is the internal rate of return for the investor? Demonstrate that...
-
Why is virtual machine migration important? Under what circumstances might it be useful?
-
You have a credit card balance of $4,300 and are able to make payments of $125 per month. Assume the credit card company charges an annual interest rate of 22%. How many months will it take to pay...
-
Find the z-score that corresponds to each percentile. 1. P 5 2. P 50 3. P 90
-
Dewitt Industries has adopted the following production budget for the first 4 months of 2012. Each unit requires 3 pounds of raw materials costing $2 per pound. On December 31, 2011, the ending raw...
-
Frasier is giving a speech and the power of his sound is 3 . 5 8 mW . What is the sound intensity level 4 . 5 9 m away from Frasier?
-
A supplier in the country of Whiteland has current output of 10 Million units priced at $1.10 per unit. Factor prices rise and costs increase to $1.30 per unit. Uh-oh... now not earning profit and...
-
The following information provides the amount of cost incurred in March for the cost items indicated. During March, 8,100 units of the firm's single product were manufactured. Raw materials Factory...
-
The demand for labor in Occupation A is L D = 20 -W, where LD = number of workers demanded for that occupation, in thousands. The supply of labor for Occupation A is L A = -1.25 + .5W. For Occupation...
-
You are involved in an investigation of charges that a large university in a small town is discriminating against female employees. You find that the salaries for professors in the nearly all-female...
-
Assume that a state government currently provides no child-care subsidies to working single parents, but it now wants to adopt a plan that will encourage labor force participation among single...
-
A study shows that for American high school dropouts, obtaining a General Equivalency Degree (GED) by part-time study after high school has very little payoff. It also shows, however, that for...
-
The concept of compensating wage premiums for dangerous work does not apply to industries like the coal industry, where the union has forced all wages and other compensation items to be the same....
-
MV Corporation has debt with market value of $97 million, common equity with a book value of $95 million, and preferred stock worth $23 million outstanding. Its common equity trades at $51 per share,...
-
The Heese Restaurant Group manufactures the bags of frozen French fries used at its franchised restaurants. Last week, Heeses purchased and used 101,000 pounds of potatoes at a price of $ 0.70 per...
-
If the mean of a population is 250 and its standard deviation is 20, approximately what proportion of observations is in the interval between each pair of values? a. 190 and 310 b. 210 and 290
-
For the two-way analysis of variance model with one observation per cell, write the observation from the ith group and jth block as Xij = + Gi + Bj + eij Refer to Exercise 15.65 and consider the...
-
Consider Example 9.6 with the null hypothesis H0: P = P0 = 0.50 and the alternative hypothesis H0: P 0.50 The decision rule is with a sample size of n = 600. What is the probability of Type II error...
-
The equivalent systems method can be used to derive the differential equation for linear SDOF systems with viscous damping. Indicate whether the statement presented is true or false. If true, state...
-
The inertia effects of a simply supported beam can be approximated by placing a particle of mass one-third of the mass of the beam at the midspan of the beam. Indicate whether the statement presented...
-
Energy dissipation is used to calculate the equivalent viscous-damping coefficient for a combination of viscous dampers. Indicate whether the statement presented is true or false. If true, state why....
Study smarter with the SolutionInn App