Alpha-Tech, a rapidly growing distributor of electronic
components, is formulating its plans for 20x5. Carol Jones, the
firm’s marketing director, has completed the following sales
forecast.
ALPHA-TECH | ||||
20x5 Forecasted Sales | ||||
(in thousands) | ||||
Month | Sales | |||
January | $ | 9,000 | ||
February | 10,000 | |||
March | 9,000 | |||
April | 11,500 | |||
May | 12,500 | |||
June | 14,000 | |||
July | 15,000 | |||
August | 15,000 | |||
September | 16,000 | |||
October | 16,000 | |||
November | 15,000 | |||
December | 17,000 | |||
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.
20x5 Forecasted General and Administrative Costs | |||
(in thousands) | |||
Salaries and fringe benefits | $ | 3,200 | |
Promotion | 3,800 | ||
Property taxes | 1,360 | ||
Insurance | 2,000 | ||
Utilities | 1,800 | ||
Depreciation | 3,460 | ||
Total | $ | 15,620 | |
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. (Negative amounts should
be indicated by a minus sign. Enter your answers in whole dollars,
not in thousands.)
Alpha-Tech Cash Budget For the Second Quarter 20x5 |
|||
April | May | June | |
beginning balance | 500,000 | 500,000 | 1,230,000 |
Collections | |||
February sales | 4,000,000 | ||
March
sales 9000000*60% |
5,400,000 | 3,600,000 | |
April sales | 6,900,000 | 4,600,000 | |
May sales | 7,500,000 | ||
Total Receipts | 9,400,000 | 10,500,000 | 12,100,000 |
Total cash available | 9,900,000 | 11,000,000 | 13,330,000 |
Disbursements | |||
Accounts payable | 4155000 | 4735000 | 5285000 |
Wages 11500000*30% 12500000*30% 14000000*30% |
3450000 | 3750000 | 4200000 |
General
& Admin (15620-3460-1360)/12 |
900000 | 900000 | 900000 |
Property taxes | 340,000 | ||
Income
taxes 3,200,000*30% |
1280000 | ||
Total disbursements | 9785000 | 9385000 | 10725000 |
Cash balance | 115,000 | 1,615,000 | 2,605,000 |
Cash
borrowed 500000-115000 |
385,000 | ||
Cash repaid | -385,000 | ||
Ending Balance | 500,000 | 1,230,000 | 2,605,000 |
Cost of goods sold | ||||||
Month | 40% of sales | timming | Feb | Mar | Apr | May |
Feb 10000000*40% |
4,000,000 | 0.3 | 1,200,000 | |||
Mar 9000000*40% |
3,600,000 | 0.7 | 2,520,000 | |||
Mar | 3,600,000 | 0.3 | 1,080,000 | |||
Apr | 4,600,000 | 0.7 | 3,220,000 | |||
Apr | 4,600,000 | 0.3 | 1,380,000 | |||
May | 5,000,000 | 0.7 | 3,500,000 | |||
May | 5,000,000 | 0.3 | 1,500,000 | |||
June | 5,600,000 | 0.7 | 3,920,000 | |||
3,720,000 | 4,300,000 | 4,880,000 | 5,420,000 |
Payments | |||||||
Feb | 0.25 | 930,000 | |||||
Mar | 0.75 | 3,225,000 | |||||
Mar | 0.25 | 1,075,000 | |||||
Apr | 0.75 | 3,660,000 | |||||
Apr | 0.25 | 1,220,000 | |||||
May | 0.75 | 4,065,000 | |||||
0 | 0 | 4155000 | 4735000 | 5285000 |
Alpha-Tech, a rapidly growing distributor of electronic components, is formulating its plans for 20x5. Carol Jones,...
Alpha-Tech, a rapidly growing distributor of electronic components, is formulating its plans for 20x5. Carol Jones, the firm’s marketing director, has completed the following sales forecast. ALPHA-TECH 20x5 Forecasted Sales (in thousands) Month Sales January $ 10,000 February 11,000 March 10,000 April 12,500 May 13,500 June 15,000 July 16,000 August 16,000 September 17,000 October 17,000 November 16,000 December 18,000 Phillip Smith, an accountant in the Planning and Budgeting Department, is responsible for preparing the cash flow projection. The following information...
Alpha-Tech, a rapidly growing distributor of electronic components, is formulating its plans for 20x5. Carol Jones, the firm's marketing director, has completed the following sales forecast. ALPHA-TECH 20x5 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...
Alpha-Tech, a rapidly growing distributor of electronic components, is formulating its plans for 20x5. Carol Jones, the firm's marketing director, has completed the following sales forecast 28x5 Forecasted Sales (in March April May 8, 5ee 7,5e0 10,000 12,580 13,500 13,58a 14,500 14,580 13,500 15,580 July August 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...
Alpha-Tech, a rapidly growing distributor of electronic components, is formulating its plans for 20x5. Carol Jones, the firm's marketing director, has completed the following sales forecast ALPHA-TECH (in thousands) 8,see 18,000 11,000 12,500 13, see 13,580 Apri1 14,500 13, 5e0 15,5ee 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. eferences is expected to continue, Sixty percent of billings...
Alpha-Tech, a rapidly growing distributor of electronic components, is formulating its plans for 20x5. Carol Jones, the firm's marketing 28x5 Forecasted Sales s 7,580 8,509 7,580 18,000 11,008 12,580 February April 13,580 14,500 14,5e0 13,580 15,500 following information will be used in preparing the cash flow projection. erences s ex 40 percent two months after is Alpha-Tech's largest expenditure, and each month's cost of goods sold is estimated to month after the sale, and the . The be 35 percent...
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, a rapidly growing distributor of electronic components, is formulating its plans for 20x5. Carol Jones, the firm's marketing director, has completed the following sales forecast. ALPHA-TECH 20x5 Forecasted Sales (in thousands) Month Sales $ 9,000 January February 10,000 9,000 11,500 12,500 14,000 March April May June July...
#50 Aigna Tech a rapidy growng estributor of electronic components, formdating its plans for 20ss Cerol Jones the fam's marketing director, has completed the following sales rebruary April 1s, 000 Phillip Smith, an accountant in the Planning and Budgeting Department, is responsible for preparing the cash flow projectsion. The following information will be used in preparing the cash flow projection. Alpha-Tech's excellent record in accountsarcevable collection is expected to c month after the sale, and the remaining 40 percent two...
Concord Products, a rapidly growing distributor of home gardening equipment, is formulating its plans for the coming year. Carol Jones, the firm’s marketing director, has completed the following sales forecast. Month Sales Month Sales January $904,000 July $1,507,200 February $1,004,100 August $1,507,200 March $904,000 September $1,605,000 April $1,152,200 October $1,605,000 May $1,258,600 November $1,507,200 June $1,400,600 December $1,707,500 Phillip Smith, an accountant in the Planning and Budgeting Department, is responsible for preparing the cash flow projection. He has gathered the...
Swifty Products, a rapidly growing distributor of home gardening equipment, is formulating its plans for the coming year. Carol Jones, the firm’s marketing director, has completed the following sales forecast. Month Sales Month Sales January $904,900 July $1,501,400 February $1,002,000 August $1,501,400 March $904,900 September $1,606,000 April $1,154,600 October $1,606,000 May $1,260,000 November $1,501,400 June $1,406,000 December $1,704,000 Phillip Smith, an accountant in the Planning and Budgeting Department, is responsible for preparing the cash flow projection. He has gathered the...
Swifty Products, a rapidly growing distributor of home gardening equipment, is formulating its plans for the coming year. Carol Jones, the firm’s marketing director, has completed the following sales forecast. Month Sales Month Sales January $904,900 July $1,501,400 February $1,002,000 August $1,501,400 March $904,900 September $1,606,000 April $1,154,600 October $1,606,000 May $1,260,000 November $1,501,400 June $1,406,000 December $1,704,000 Phillip Smith, an accountant in the Planning and Budgeting Department, is responsible for preparing the cash flow projection. He has gathered the...