Amar Products Ltd has been in business for several years. They are preparing their budget for...

 

Transcribed Image Text:

Amar Products Ltd has been in business for several years. They are preparing their budget for the four months starting on 1 January 2022. Estimated sales are: November December January February March April May Sales RM 15,000 18,000 12,000 13,000 15,000 14,000 16,000 • Purchases are made one month before sale and cost 45% of the sales value. They are paid for in cash. • All sales are on credit. It is expected that 35% will pay one month after the sale and 65% two months after the sale. • Salaries of RM6,500 will be paid each month; • Gas and electricity of RM400 per month is payable quarterly on the last day of February, May, August and November of each year, in respect of the three months ending on that day. • Rent is due every quarter in advance in January, April, July and October. Rent for the year ended 31 March 2022 is RM1,800 per quarter. This will increase to RM2,100 per quarter for the year starting in April 2022 • Interest on investments of RM2,000 will be received in March. • Loan interest of RM5,000 will be paid in January • On I January Amar Products Ltd expect to have RM2,000 in the bank Required (a) Prepare a cash budget using Microsoft excel, month-by-month, for the period 1 January to 30 April 2022. Assume that overdraft facilities will be available, if needed. (b) Discuss your recommendations to Amar Product based on the budget that you have prepared in part (a). (Word count 500-600 words) (c) Your answer should also include a detail explanation of the importance of budgeting to an organisation and how budgeting assist the organisation in planning and decision-making. Provide real life case studies to support your answer. (Word count 1,000-1,500 words). Amar Products Ltd has been in business for several years. They are preparing their budget for the four months starting on 1 January 2022. Estimated sales are: November December January February March April May Sales RM 15,000 18,000 12,000 13,000 15,000 14,000 16,000 • Purchases are made one month before sale and cost 45% of the sales value. They are paid for in cash. • All sales are on credit. It is expected that 35% will pay one month after the sale and 65% two months after the sale. • Salaries of RM6,500 will be paid each month; • Gas and electricity of RM400 per month is payable quarterly on the last day of February, May, August and November of each year, in respect of the three months ending on that day. • Rent is due every quarter in advance in January, April, July and October. Rent for the year ended 31 March 2022 is RM1,800 per quarter. This will increase to RM2,100 per quarter for the year starting in April 2022 • Interest on investments of RM2,000 will be received in March. • Loan interest of RM5,000 will be paid in January • On I January Amar Products Ltd expect to have RM2,000 in the bank Required (a) Prepare a cash budget using Microsoft excel, month-by-month, for the period 1 January to 30 April 2022. Assume that overdraft facilities will be available, if needed. (b) Discuss your recommendations to Amar Product based on the budget that you have prepared in part (a). (Word count 500-600 words) (c) Your answer should also include a detail explanation of the importance of budgeting to an organisation and how budgeting assist the organisation in planning and decision-making. Provide real life case studies to support your answer. (Word count 1,000-1,500 words).

Answer rating: 100% (QA)

1 Cash Budget for Jan to April 2022 Particulars JAn AmountRm FebRm MarRm AprilRM Cash Collection Credit sales35next month of sale 6300 4200 4550 5250 ... View the full answer