Question

In: Accounting

. Alpha Ltd has appointed you as a manager in the budgeting department. The company has...

. Alpha Ltd has appointed you as a manager in the budgeting department. The company has provided the following information to prepare a cash flow budget for the six months from the 1 January 2021 to 30 June 2021.

  1. Alpha Ltd produces only one type of product and the projected selling price of the product is £2 for January and February and after that will be fixed at £3 for the foreseeable future.      
  2. For the first three months of the year, 2,000 units will be sold per month. For the following three months, 2,500 units will be sold per month. Sales income is to be received in the month of sale.
  3. Insurance costs are £200 every two months. The company will pay for insurance on 1 December 2020.
  4. The company is paying 20% of sales of each month as bonus to the employees in the following month. The total sales during December 2020 will be £5,000.
  5. Alpha Ltd will pay overhead costs of £2,000 each month.
  6. The opening cash balance at 1 January 2021 will be £1,000.
  7. The monthly cost of direct material and direct labour is estimated to be £500 and the company will pay them during each month.

viii Fixed costs of production are £100 per month, payable in the month

Solutions

Expert Solution

Cash Budget Jan Feb Mar Apr May June Total
1.Opening balance 1000 1400 1800 4400 7900 11300 1000
2.Sales revenue 4000 4000 6000 7500 7500 7500 36500
3.Total cash available(1+2) 5000 5400 7800 11900 15400 18800 37500
Less: Payments for:
4.Direct material & labor 500 500 500 500 500 500 3000
5.Fixed costs of production 100 100 100 100 100 100 600
6.Insurance costs 200 200 200 600
7.Bonus to employees 1000 800 800 1200 1500 1500 6800
8.OH costs 2000 2000 2000 2000 2000 2000 12000
9.Total payments(sum 4 to 8) 3600 3600 3400 4000 4100 4300 23000
10.Ending balance(3-9) 1400 1800 4400 7900 11300 14500 14500
Ending cash balance as at Jun 30= 14500
Workings:
Jan Feb Mar Apr May June Total
1.Sales units 2000 2000 2000 2500 2500 2500 13500
2.Selling price/unit 2 2 3 3 3 3
3.Sales $(1*2) 4000 4000 6000 7500 7500 7500 36500
4.Bonus to employees(Prev.3*20%) 1000 800 800 1200 1500 1500 6800

Related Solutions

1. Alpha Ltd has appointed you as a manager in the budgeting department. The company has...
1. Alpha Ltd has appointed you as a manager in the budgeting department. The company has provided the following information to prepare a cash flow budget for the six months from the 1 January 2021 to 30 June 2021. Alpha Ltd produces only one type of product and the projected selling price of the product is £2 for January and February and after that will be fixed at £3 for the foreseeable future.     For the first three months of the...
You are appointed as a transport manager for the oil and gas company in United Arab...
You are appointed as a transport manager for the oil and gas company in United Arab Emirates. Your company has witnessed many hazmat incidents in different transportation operations over the last two years. Your key role as the new transport manager is to minimize the number of incidents. Discuss the ten measures or strategies that you will take to ensure the safe transport of these hazardous materials and minimize the number of incidents. word limit 450-500
Assume that you have been appointed as Marketing Manager for a company in your region. In...
Assume that you have been appointed as Marketing Manager for a company in your region. In the past, many of their new products were unsuccessful. The senior management team now wants to focus on proper idea generation for their new products and also wants to select profitable market segments correctly. i) How would you select profitable market segment(s) for this company? Justify your answer. ii) Discuss your strategies on how to generate proper ideas for this company’s new products.
Assignment Scenario: You have been appointed as the new Department Manager overseeing ten (10) persons within...
Assignment Scenario: You have been appointed as the new Department Manager overseeing ten (10) persons within your organization. As the new manager, you are required to re-allocate resources (including staff), monitor the progress and quality of output of your team, deal with new and ongoing conflict and report to the General Manager. Using key theories and concepts explained throughout the course, analyze and discuss, using relevant examples, your approach to management.   Your assignment should be no more than 2500 words.
You have been appointed as the Human Resource Manager of Milynn Deeds Insurance Company. For you...
You have been appointed as the Human Resource Manager of Milynn Deeds Insurance Company. For you to properly define the duties, responsibilities and accountabilities of a job, it is crucial to conduct a job analysis. Discuss the uses of job analysis information.
You have recently been appointed sales manager of an insurance company. Sales are declining and you...
You have recently been appointed sales manager of an insurance company. Sales are declining and you believe that a major factor causing this decline is a lack of motivation among your sales force. At present, they are paid a straight salary, the size of which depends on length of service. Outline your thoughts regarding how you would approach this situation. How do you motivate sales force using motivation theories in this COVID-19 pandemic process? What specific factors or activities do...
You are the newly appointed financial manager of Sami Partners company UAE. When you reviewed the...
You are the newly appointed financial manager of Sami Partners company UAE. When you reviewed the working of finance department, you found that the department doesn’t have proper internal control system to monitor the payment of Petty cash in the company. You realised that the current system may leads to leakage of cash , you are planning to establish an internal control system to address the issue. Available information for you: • Senior manager sanctions some amount cash to the...
You are working in the finance department of Innotech Ltd (INT). The Company has spent $3.4...
You are working in the finance department of Innotech Ltd (INT). The Company has spent $3.4 million in research and development over the past 12 months developing battery technology which will be incorporated into the Australian luxury car market. INT now need to choose between the following three options for bringing the product to market. These options are: Option 1: Manufacturing the product “in-house” and selling directly to the market Option 2: Licensing another company to manufacture and sell the...
You are manager of the human resource department at a large company. You will meet a...
You are manager of the human resource department at a large company. You will meet a group of new employees. You want to develop a PowerPoint presentation that describes your company’s corporate ethics code on privacy that addresses both employee privacy and the privacy of customers and users of the corporate Web site. There are a vast number of examples you can access on existing corporate Web sites to use as models (note: using them as models to create your...
You have just been appointed the Marketing Manager of YummyFoods (NZ) Limited, a company specializing in...
You have just been appointed the Marketing Manager of YummyFoods (NZ) Limited, a company specializing in healthy snacks for the New Zealand market. On your first day at work, your boss - Mr. Umami, welcomes you to the company, and tells you “there is no time to waste!” The company has just developed a new product, Manuka smoked almonds, and are keen to get them into consumers’ hands as soon as possible. Mr. Umami tells you that YummyFoods already has...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT