Problem 5: Cash Budget Alpha-Tech, a rapidly growing distributor of electronic components, is formulating its plans for 20x5. C^bl Jones, the firm's marketing director, has completed the following sales forecast. ALPHA-TECH 20X5 Forecasted Sales (in thousands) Month January February March Sales Month S 9,000 July 10,000 August 9,000 September 11,500 October 12,500 November 14,000 Decembeir Sales S15,000 15,000 16,000 16,000 15,000 17,000 May une 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-Tech's excellent record in accounts receivable collection is expected to continue. Sixty percent of billing are collected in the month after sale, and the remaining 40 percent two months after * *The purchase of electronic components is Alpha-Tech's largest expenditure, and each month's 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, 75 percent of accounts payable has been paid one month after receipt of the purchased components, and the remaining 25 percent has been paid two months after receipt. Hourly wage and fringe benefits, estimated to be 30 percent of the current month's sales, are paid in the month's sales, are paid in the moth incurred. General administrative expenses are projected to be $15,620,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 instalments at the end of each quarter * 20x5 Forecasted General and Administrative Costs (in thousands) $ 3, 200 3, 800 1,360 2,000 1,800 3,460 $ 15, 620 Salaries and fringe benefits Property taxes Insurance Utilities Depreciation Total oblem solving assignment Page 7 of 10 *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-Tech's operating income for the first quarter of 20x5 is projected to be S 3, 200, 000. The company pays 100 percent of the estimated tax payment. * Alpha-Tech maintains a minimum cash balance of S500,000. If the cash balance is less than S500,00 at the end of each month, the company borrows amounts necessary to maintain this balance. All amount borrowed are repaid out of the subsequent positive cash flow. The projected April 1, 20x5, opening balance is S500, 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. * * Required: 1. Prepare a cash budget for Alpha-Tech by month for the second quarter of 20x5. For simplicity, ignore any interest expense associated with borrowing