Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a. Panda Ltd is a mature company that has been operating in a stable market for a number of years. The company has a cash

a. Panda Ltd is a mature company that has been operating in a stable market for a number of years. The company has a cash balance of 40,500 at the beginning of May. The directors require a forecast of the firm's cash balance at the end of May, June and July.

The following information is available:

(1) Salaries are paid at the end of each month.

(2) Suppliers allow one month's credit.

(3) Fixed overheads are paid one month in arrears and include a charge for depreciation of 7,500 per month.

(4) Credit sales are settled 50% in the month of sale and 50% in the following month.

Month Purchases Salaries Fixed Credit Cash
overheads sales sales
March 82,800 13,500 45,000 111,000
April 79,100 13,500 45,000 123,000
May 80,000 14,250 45,000 120,000 30,000
June 83,500 14,250 48,000 135,000 33,000
July 82,750 15,000 48,000 150,000 37,500

Required:

1. Prepare a cash budget for each of the months ending May, June and July.

2. Given the forecast cash balances over the months of May to July, comment on two actions the directors could take.

3. Describe the role of budgets in organisational control.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Corporate Annual Reports

Authors: William Pasewark

7th Edition

0073526932, 9780073526935

Students also viewed these Accounting questions

Question

Describe ERP and how it can create efficiency within a business

Answered: 1 week ago