Alpha Tech, a rapidly growing distributor of electronic components, is formulating its plans for 20x5 Carol Jones, the firms marketing director, has completed the following sales forecast ALPHA TECH20x5 Forecasted Sales(in thousands) Month Sales January $10,500 February 11,500 March 10,500 April 13,000 May 14,000 June 15,500 July 16,500 August 16,500 September 17,500 October 17,500 November 16,500 December 18,500 Phillip Smith, an accountant in the Planning and Budgeting Department, is responsible for preparing the cash flow projection The following information will be used in preparing the cash flow projection Alpha Techs excellent record in accounts receivable collection is expected to continue Seventy percent of billings are collected the month after the sale, and the remaining 30 percent two months after The purchase of electronic components is Alpha Techs largest expenditure, and each months cost of goods sold is estimated to be 40 percent of sales Seventy percent of the parts are received by Alpha Tech one month prior to sale, and 30 percent are received during the month of sale Historically, 80 percent of accounts payable has been paid one month after receipt of the purchased components, and the remaining 20 percent has been paid two months after receipt Hourly wages and fringe benefits, estimated to be 30 percent of the current months sales, are paid in the month incurred General and administrative expenses are projected to be $16,070,000 for the year The breakdown of these expenses is presented in the following schedule All cash expenditures are paid uniformly throughout the year, except the property taxes, which are paid in four equal installments at the end of each quarter 20x5 Forecasted General and Administrative Costs(in thousands) Salaries and fringe benefits $3,000 Promotion 4,100 Property taxes 1,480 Insurance 2,280 Utilities 1,300 Depreciation 3,910 Total $16,070 Income tax payments are made at the beginning of each calendar quarter based on the income of the prior quarter Alpha Tech is subject to an income tax rate of 40 percent Alpha Techs operating income for the first quarter of 20x5 is projected to be $3,800,000 The company pays 100 percent of the estimated tax payment Alpha Tech maintains a minimum cash balance of $590,000 If the cash balance is less than $590,000 at the end of each month, the company borrows amounts necessary to maintain this balance All amounts borrowed are repaid out of the subsequent positive cash flow The projected April 1, 20x5, opening balance is $590,000 Alpha Tech has no short term debt as of April 1, 20x5 Alpha Tech uses a calendar year for both financial reporting and tax purposes Prepare a cash budget for Alpha Tech by month for the second quarter of 20x5 For simplicity, ignore any interest expense associated with borrowing (Negative amounts should be indicated by a minus sign ) ALPHA TECH Cash Budget For the Second Quarter of 20x5 April May June Beginning balance Collections February sales March sales April sales May sales Total receipts $0 $0 $0 Total cash available $0 $0 $0 Disbursements Accounts payable Wages General and administrative Property taxes Income taxes Total disbursements $0 $0 $0 Cash balance $0 $0 $0 Cash borrowed Cash repaid Ending balance $0 $0 $0

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 12, 2024

Alpha-Tech, a rapidly growing distributor of electronic components, is formulating its plans for 20x5. Carol Jones, the firms marketing director, has completed the following sales

Alpha-Tech, a rapidly growing distributor of electronic components, is formulating its plans for 20x5. Carol Jones, the firms marketing director, has completed the following sales forecast.

ALPHA-TECH20x5 Forecasted Sales(in thousands)

Month Sales

January $10,500

February 11,500

March 10,500

April 13,000

May 14,000

June 15,500

July 16,500

August 16,500

September 17,500

October 17,500

November 16,500

December 18,500

Phillip Smith, an accountant in the Planning and Budgeting Department, is responsible for preparing the cash flow projection. The following information will be used in preparing the cash flow projection.

Alpha-Techs excellent record in accounts receivable collection is expected to continue. Seventy percent of billings are collected the month after the sale, and the remaining 30 percent two months after.
The purchase of electronic components is Alpha-Techs largest expenditure, and each months cost of goods sold is estimated to be 40 percent of sales. Seventy percent of the parts are received by Alpha-Tech one month prior to sale, and 30 percent are received during the month of sale.
Historically, 80 percent of accounts payable has been paid one month after receipt of the purchased components, and the remaining 20 percent has been paid two months after receipt.
Hourly wages and fringe benefits, estimated to be 30 percent of the current months sales, are paid in the month incurred.
General and administrative expenses are projected to be $16,070,000 for the year. The breakdown of these expenses is presented in the following schedule. All cash expenditures are paid uniformly throughout the year, except the property taxes, which are paid in four equal installments at the end of each quarter.

20x5 Forecasted General and Administrative Costs(in thousands)

Salaries and fringe benefits. $3,000

Promotion 4,100

Property taxes 1,480

Insurance 2,280

Utilities 1,300

Depreciation 3,910

Total $16,070

Income-tax payments are made at the beginning of each calendar quarter based on the income of the prior quarter. Alpha-Tech is subject to an income-tax rate of 40 percent. Alpha-Techs operating income for the first quarter of 20x5 is projected to be $3,800,000. The company pays 100 percent of the estimated tax payment.
Alpha-Tech maintains a minimum cash balance of $590,000. If the cash balance is less than $590,000 at the end of each month, the company borrows amounts necessary to maintain this balance. All amounts borrowed are repaid out of the subsequent positive cash flow. The projected April 1, 20x5, opening balance is $590,000.
Alpha-Tech has no short-term debt as of April 1, 20x5.
Alpha-Tech uses a calendar year for both financial reporting and tax purposes.

Prepare a cash budget for Alpha-Tech by month for the second quarter of 20x5. For simplicity, ignore any interest expense associated with borrowing. (Negative amounts should be indicated by a minus sign.)

ALPHA-TECH
Cash Budget
For the Second Quarter of 20x5
	April	May	June
Beginning balance
Collections:
February sales
March sales
April sales
May sales
Total receipts	$0	$0	$0
Total cash available	$0	$0	$0
Disbursements:
Accounts payable
Wages
General and administrative
Property taxes
Income taxes
Total disbursements	$0	$0	$0
Cash balance	$0	$0	$0
Cash borrowed
Cash repaid
Ending balance	$0	$0	$0