After completing the first task, your supervisor has asked you to work with a client named Miss. Bennet to assist her in preparing a cash budget

After completing the first task, your supervisor has asked you to work with a client named Miss. Bennet to assist her in preparing a cash budget. It can be used to inform efficient resource allocation and support effective control and decision-making, Miss. Bennet starts a small business cleaning office on a trading estate in Amman, Jordan.

If you know that the Fiscal year begins on 01/01 and ends on 31/12, and the account balances of beginning year are as follows:

Account

£

Cash

400,000

Accounts receivable

50,000

Accounts payable

60,000

Selling and General administrative expenses

50,000

In addition, the company estimates its sales and purchases for the next three months, from the beginning of the January to the end of April according to the following schedules:

Month

Budgeted Sales

Budgeted Purchases

January

£120,000

£600,000

February

£250,000

£120,500

March

£160,000

£70,000

April

£260,000

£160,000

Total

790,000

415,000

Instructions:

From the data given above Prepare a cash budget using a spreadsheet. Considering the information listed below.

· Preparing a Scheduled of expected cash collection proceeds from sales, if you know that the company’s policy when selling states that 70% of sales are collected during the month of sale, and 30% of sales are collected during the following month.

· Prepare a Scheduled of expected cash disbursement for purchases, if you know that the company pays 50% of the purchases during the month of purchase and pays 50% of the purchases during the following month.

· Management would like to have a cash balance at least 3,000 at the beginning of each Month.

· The board of director has approved cash dividend of 4,000 for March.

· Management planes to spend 8,000 on equipment purchase on April.

Discuss the benefits and limitations of budgets and budgetary control systems for the given business. Identify the cash problem revealed by budgetary planning that might facing in businesses and recommend corrective actions that can be taken by management by justifying how that solution can ensure better decision making and efficient use of resources in business.

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.