Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Prepare a Cash budget for the first three months of 2021. Accepting that there is now a greater need to plan properly for the future,

image text in transcribed

Prepare a Cash budget for the first three months of 2021. Accepting that there is now a greater need to plan properly for the future, Management has sought your help in revisiting their existing budgets, especially those affecting the cash flow of the company. It had been agreed that the company should maintain a balance of at least $ 40,000 at all times. The balance at the start of the year was $ 45,000. The current sales policy allows for all sales to be done on a credit basis with 50 % of the sales being collected in the month of sale; 40% in the next month and 10% in the second month after the sale. Sales projections for the first three months of 2021 are as follows: January $ 150,000 February $ 160,000 March $ 180,000 You have also learnt that sales in the months of November and December 2020, were $ 130,000 and $ 140,000 respectively. The purchasing policy is also under scrutiny as the market gets more demanding. Currently all purchases are on credit also and payments are made with 30% in the month of purchase, 50% in the following month and the balance in the second month. Purchases for November and December in 2020 were, $ 75,000 and $ 80,000 respectively. In 2021 these are expected to increase to $ 100,000 in Janual.m $ 110,000 in February and $90,000 in March. In additiion the company has the following monthly expenses which have to be paid: January February March Direct Labour Selling & Administrative Expenses Maintenance Costs Motor Vehicle Expenses 30,000 20,000 5,000 35,000 15,000 7,500 4,500 20,000 12,000 3,000 2,500 3,000

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

Cadmus Operational Auditing W R Institute Of Internal Auditors Professional Books Series

Authors: David S. Kowalczyk

1st Edition

047182660X, 978-0471826606

More Books

Students also viewed these Accounting questions

Question

What is the function of a goal within a feedback loop?

Answered: 1 week ago

Question

Describe the job youd like to be doing five years from now.

Answered: 1 week ago

Question

So what disadvantages have you witnessed? (specific)

Answered: 1 week ago