Question
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:
- 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.
- 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.
- 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 |
- General and administrative expenses are budgeted to be $2 640 000 for the year. All of these expenses are incurred evenly throughout the year.
- 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.
- 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:
- Prepare a schedule of cash collections for A&A Corporation by month and in total only for the second quarter.
- Prepare a schedule of cash payments for A&A Corporation by month and in total only for the second quarter.
- 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.
- 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started