. 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.

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 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.
Insurance costs are £200 every two months. The company will pay for insurance on 1 December 2020.
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.
Alpha Ltd will pay overhead costs of £2,000 each month.
The opening cash balance at 1 January 2021 will be £1,000.
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

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

ekkarill92 answered 1 year ago

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.

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...

You have been appointed as financial manager for MBA. The company manufactures one product and uses...

You have been appointed as financial manager for MBA. The company manufactures one product and uses standard costing system. Standard cost per unit Material 5kg at R12 50 per unit Labour 2 hours at R35 per hour Factory overheads R45 per labour hour. Actual data for the month: Number of units manufactured 12500 Material used R811 250 Issue price of material R13 75 per kg Calculate and explain the difference between the total actual and the total standard cost. Suggest...

Question