Green Enterprises Ltd is preparing to set up a new business on the first of January...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Green Enterprises Ltd is preparing to set up a new business on the first of January 2021 to manufacture a single product. Below is the sales budget for the company for the first 6 months of 2021. Sales Budget Sales Unit Sales Revenue January 8 000 240 000 February 8 500 255 000 March 10 000 300 000 April 11 000 330 000 May 11 500 345 000 June 10 500 315 000 Additional Information; 1. The Cash collections patterns from sales is expected to be as follows: (a) Cash Customers 30% of sales revenue will be for immediate cash (b) Credit Customers 70% of sales revenue will be from credit customers. These debtors will pay their bills, 50% in the month after sales and the reminder in the second month after sales. 2. Stocks of finished goods are maintained 60% of the following months sales requirement, and the budgeted cost of a unit of finished goods is valued at N$ 20. 3. The product requires 4 kg of material X which cost N$ 1.5 per kg, it is expected that this price will increase with five cents from April. 4. One month's credit is received from suppliers. 5. Stock of raw materials sufficient for 10% of the following month's requirement in kgs are held at the end of each month. 6. One month's credit is received from suppliers. 7. Expenses of the business will be settled as follows; (a) Expected Costs Wages N$ 20 000 per month payable as incurred. Variable Overheads of N$ 5 per Unit is payable as incurred. (b) There will be an Equipment to be purchased on 01 January 2021 it cost N$ 30 000, this equipment is expected to have a useful life of 5 years. To finance this purchase, a loan of N$ 24 000 will be secured from Development Bank of Namibia at 10% per annum. Interest is payable monthly, but capital loan repayment will not commence until July 2021. REQUIRED: 1.1. 1.2. Prepare a production budget for the first four months of 2021 Prepare a material purchases budget for the first four months of 2021 (both in units and N$) 1.3. Prepare a budgeted Trading Profit and Loss Account for the four months ending April 2021 TOTAL MARKS Marks 4 8 13 25 Green Enterprises Ltd is preparing to set up a new business on the first of January 2021 to manufacture a single product. Below is the sales budget for the company for the first 6 months of 2021. Sales Budget Sales Unit Sales Revenue January 8 000 240 000 February 8 500 255 000 March 10 000 300 000 April 11 000 330 000 May 11 500 345 000 June 10 500 315 000 Additional Information; 1. The Cash collections patterns from sales is expected to be as follows: (a) Cash Customers 30% of sales revenue will be for immediate cash (b) Credit Customers 70% of sales revenue will be from credit customers. These debtors will pay their bills, 50% in the month after sales and the reminder in the second month after sales. 2. Stocks of finished goods are maintained 60% of the following months sales requirement, and the budgeted cost of a unit of finished goods is valued at N$ 20. 3. The product requires 4 kg of material X which cost N$ 1.5 per kg, it is expected that this price will increase with five cents from April. 4. One month's credit is received from suppliers. 5. Stock of raw materials sufficient for 10% of the following month's requirement in kgs are held at the end of each month. 6. One month's credit is received from suppliers. 7. Expenses of the business will be settled as follows; (a) Expected Costs Wages N$ 20 000 per month payable as incurred. Variable Overheads of N$ 5 per Unit is payable as incurred. (b) There will be an Equipment to be purchased on 01 January 2021 it cost N$ 30 000, this equipment is expected to have a useful life of 5 years. To finance this purchase, a loan of N$ 24 000 will be secured from Development Bank of Namibia at 10% per annum. Interest is payable monthly, but capital loan repayment will not commence until July 2021. REQUIRED: 1.1. 1.2. Prepare a production budget for the first four months of 2021 Prepare a material purchases budget for the first four months of 2021 (both in units and N$) 1.3. Prepare a budgeted Trading Profit and Loss Account for the four months ending April 2021 TOTAL MARKS Marks 4 8 13 25
Expert Answer:
Answer rating: 100% (QA)
11 Production budget January February March April Sales Unit 8 000 8 500 10 000 11 000 Stocks ... View the full answer
Related Book For
Financial Accounting and Reporting
ISBN: 978-0273744443
14th Edition
Authors: Barry Elliott, Jamie Elliott
Posted Date:
Students also viewed these general management questions
-
Jane Parker is going to set up a new business on 1 January 20X1. She estimates that her first six months in business will be as follows: (i) She will put 150,000 into a bank account for the firm on 1...
-
Jane Parker is going to set up a new business in Bruges on 1 January 20X1. She estimates that her first six months in business will be as follows: (i) She will put 150,000 into the firm on 1 January...
-
Mr. Norman is going to set up a new business in Singapore on 1 January 20X8. He will invest $150,000 in the business on that date and has made the following estimates and policy decisions: 1....
-
Two popular methods of financial statement analysis are horizontal analysis and vertical analysis. Explain the difference between these two methods. Discuss.
-
Very briefly highlight the seven federal laws (discussed in this chapter) regulating the securities industry.
-
Ethylene glycol is heated from 25C to 40C at a rate of 2.5 kg/s in a horizontal copper tube (k = 386 W/mK) with an inner diameter of 2.0 cm and an outer diameter of 2.5 cm. A saturated vapor (T g =...
-
When should an organization consider conducting independent audits?
-
A wealthy businessman owns a large number of paintings that he loans to museums all over the world. He is interested in setting up a system that records what he loans to whom so that he doesn't lose...
-
Scheduled payments of $794, $725, and $632 are due in one-and-a-half years, four years, and six years respectively. What is the equivalent single replacement payment two years from now if interest is...
-
Create a Budget Analysis Report for the month of September, to include creating a Master Budget, and calculating the variance analyses between Actuals versus the Flexible Budget and versus the Master...
-
On April 3, 2023, David's Chocolates purchased a machine for $71,200. It was assumed that the machine would have a five-year life and a $15,200 trade-in value. Early in January 2026, It was...
-
6. What is the magnitude of charge on a particle that is moving at 3.6 x 106 m/s and experiences a magnetic force of 1.2 x 10-10 N when it encounters a magnetic field of 3.0 T? a. What are the...
-
Findthevalue oftheBooleanvariable "b",assuming that intx=3; inty=4; intz=2; boolean b = !((x > y) || ((y + z) >= (x - z))) b=
-
An electric ceiling fan is rotating about a fixed axis with an initial angular velocity magnitude of 0.220 rev/s . The magnitude of the angular acceleration is 0.882 rev/s2 . Both the the angular...
-
A Balanced Scorecard Analysis: A brief comparison and explanation of your team compared to the other teams in the simulation for your selected quarter. Please include graphs or charts of simulation...
-
When marketing using online tools and websites, companies will often track the cost-per-click and the cost-per-impression. Define both terms and how they are useful to a company. Make a chart of 3...
-
X Question 16 0/1 pt 249 Details Score on last try: 0 of 1 pts. See Details for more. Get a similar question You can retry this question below Suppose a product's revenue function is given by R(q) =...
-
Briefly discuss the implications of the financial statement presentation project for the reporting of stockholders equity.
-
(a) Assume that on 1 January 20X7 Parent Ltd acquired all the ordinary shares in Daughter Ltd for £10,800 cash. The fair value of the net assets in Daughter Ltd was their book value. (b) The...
-
Forest plc acquired 80% of the ordinary shares of Bulwell plc some years ago. At acquisition, the fair values of the assets of Bulwell plc were the same as their carrying value. Bulwell plc...
-
Epsilon is a listed entity. You are the financial controller of the entity and its consolidated financial statements for the year ended 30 September 2008 are being prepared. Your assistant, who has...
-
Ferris Corporation makes a powdered rug shampoo in two sequential departments, Compounding and Drying. Materials are added at the beginning of the process in the Compounding Department. Conversion...
-
The following data (and annotations) are for the work-in-process account of the first of Crocker Company's four departments used in manufacturing its only product for October of 2019. Assuming that...
-
The following selected operating data are for Jackson Company's Blending Department for the month of April 2019. Tinting and packaging operations are carried out subsequently in other departments....
Study smarter with the SolutionInn App