Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A&A Corporation, a rapidly expanding specialist photocopier manufacturer, is in the process of formulating plans for next year. The director of marketing has completed her

A&A Corporation, a rapidly expanding specialist photocopier manufacturer, is in the process of formulating plans for next year. The director of marketing has completed her sales budget and is confident that sales estimates will be met or exceeded. The following budgeted sales figures show the growth expected and will provide the planning basis for other corporate departments.

Budgeted sales in $

Budgeted sales in $

January

February

March

April

May

June

1 800 000

2 000 000

1 800 000

2 200 000

2 500 000

2 800 000

July

August

September

October

November

December

3 000 000

3 000 000

3 200 000

3 200 000

3 000 000

3 400 000

You, as an assistant chief accountant, have been given the responsibility for formulating the cash budget, a critical element during a period of rapid expansion. The following information provided by operating managers will be used in preparing the cash budget:

  1. A&A Corporation has experienced an excellent record in debtors collection and expects this trend to continue. 60% of billings are collected in the month after the sale and 40% in the second month after the sale. Uncollectable accounts are negligible and will not be considered in this analysis.
  2. The purchase of raw materials is A&As largest expenditure; the monthly cost of raw materials equals 50% of monthly sales. Prior experience shows that 80% of creditors are paid by A&A one month after receipt of the purchased materials, and the remaining 20% are paid the second month after receipt.
  3. Wages and salaries will be paid on the following bases:

April

May

June

Total 2nd Quarter

Wages in $

440,000

500,000

560,000

1,500,000

  1. General and administrative expenses are budgeted to be $2 640 000 for the year. All of these expenses are incurred evenly throughout the year.
  2. Equipment and warehouse facilities are being acquired to support the companys rapidly growing sales. Purchases of equipment and facilities are budgeted at $28 000 for April and $324 000 for May.
  3. A&A has a corporate policy of maintaining an end-of-month cash balance of $100 000. Cash is borrowed or invested monthly, as needed, to maintain this balance.

Required:

  1. Prepare a schedule of cash collections for A&A Corporation by month and in total only for the second quarter.
  2. Prepare a schedule of cash payments for A&A Corporation by month and in total only for the second quarter.
  3. Prepare a cash budget for A&A Corporation by month and in total only for the second quarter. Be sure that all receipts, disbursements and borrowing investing amounts are shown for each month.
  4. Discuss why cash budgeting is particularly important for a rapidly expanding company such as A&A Corporation.

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

Step: 3

blur-text-image

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

Information Systems Audit In Banking Sector A Study Of SBI And ICICI Banks

Authors: C. Mallesha, M. Sulochana

1st Edition

6200254397, 978-6200254399

More Books

Students also viewed these Accounting questions