Question

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 $ 8,000
February 9,000
March 8,000
April 10,500
May 11,500
June 13,000
July 14,000
August 14,000
September 15,000
October 15,000
November 14,000
December 16,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.

Alpha-Tech’s excellent record in accounts receivable collection is expected to continue. Sixty percent of billings are collected the month after the 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 30 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 month’s sales, are paid in the month incurred.

General and administrative expenses are projected to be $16,520,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,100
Promotion 4,300
Property taxes 1,450
Insurance 1,710
Utilities 1,600
Depreciation 4,360
Total $ 16,520

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 $4,700,000. The company pays 100 percent of the estimated tax payment.

Alpha-Tech maintains a minimum cash balance of $585,000. If the cash balance is less than $585,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 $585,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:

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.)

Please provide detail working for each

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The following data relate to the operations of Soper Company, a wholesale distributor of consumer goods...
The following data relate to the operations of Soper Company, a wholesale distributor of consumer goods as of March 31:   Cash $ 8,000   Accounts receivable 20,000   Inventory 36,000   Building and equipment, net 120,000   Accounts payable 21,750   Common shares 150,000   Retained earnings 12,250 a. The gross margin is 25% of sales. b. Actual and budgeted sales data are as follows:   March (actual) $ 50,000   April $ 60,000   May $ 72,000   June $ 90,000   July $ 48,000 c. Sales are 60% for...
The following data relate to the operations of Soper Company, a wholesale distributor of consumer goods...
The following data relate to the operations of Soper Company, a wholesale distributor of consumer goods as of March 31:   Cash $ 8,000   Accounts receivable 20,000   Inventory 36,000   Building and equipment, net 120,000   Accounts payable 21,750   Common shares 150,000   Retained earnings 12,250 a. The gross margin is 25% of sales. b. Actual and budgeted sales data are as follows:   March (actual) $ 50,000   April $ 60,000   May $ 72,000   June $ 90,000   July $ 48,000 c. Sales are 60% for...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master budget for the second quarter. a. As of March 31 (the end of the prior quarter), the company’s balance sheet showed the following account balances: Cash $9,000 Acct Receviable 48,000 Inventory 12,6000 Buildings & Equip. (net) 214,100 Acct. Payable 18,300 Common Stock 190,000 Retained Earnings 75,400 Totals 283,700 283,700 b. Sales for March total...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 8,100 Accounts receivable $ 22,400 Inventory $ 43,200 Building and equipment, net $ 129,600 Accounts payable $ 25,800 Common stock $ 150,000 Retained earnings $ 27,500 The gross margin is 25% of sales. Actual and budgeted sales data: March (actual) $ 56,000 April $ 72,000 May $ 77,000 June $ 102,000 July $ 53,000 Sales are...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 8,600 Accounts receivable $ 24,400 Inventory $ 46,200 Building and equipment, net $ 118,800 Accounts payable $ 27,675 Common stock $ 150,000 Retained earnings $ 20,325 The gross margin is 25% of sales. Actual and budgeted sales data: March (actual) $ 61,000 April $ 77,000 May $ 82,000 June $ 107,000 July $ 58,000 Sales are...
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended...
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended June 30th. The following information is available Deacon Company Balance Sheet March 31 Assets Cash $ 55,000 Accounts receivable 36,000 Inventory 40,000 Buildings and equipment, net of depreciation 100,000 Total assets $ 231,000 Liabilities and Stockholders’ Equity Accounts payable $ 51,300 Common stock 70,000 Retained earnings 109,700 Total liabilities and stockholders’ equity $ 231,000 Budgeted Income Statements April May June Sales $ 100,000 $...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 7,600 Accounts receivable $ 20,400 Inventory $ 40,200 Building and equipment, net $ 128,400 Accounts payable $ 23,925 Capital stock $ 150,000 Retained earnings $ 22,675 The gross margin is 25% of sales. Actual and budgeted sales data:    March (actual) $ 51,000 April $ 67,000 May $ 72,000 June $ 97,000 July $ 48,000   ...
The following data relate to the operations of Soper Company, a wholesale distributor of consumer goods...
The following data relate to the operations of Soper Company, a wholesale distributor of consumer goods as of March 31:   Cash $ 8,000   Accounts receivable 20,000   Inventory 36,000   Building and equipment, net 120,000   Accounts payable 21,750   Common shares 150,000   Retained earnings 12,250 a. The gross margin is 25% of sales. b. Actual and budgeted sales data are as follows:   March (actual) $ 50,000   April $ 60,000   May $ 72,000   June $ 90,000   July $ 48,000 c. Sales are 60% for...
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of...
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare comprehensive budgets for the upcoming second quarter in order to show management the...
To prepare a master budget for April, May, and June of 2019, management gathers the following...
To prepare a master budget for April, May, and June of 2019, management gathers the following information. ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash $ 54,000 Accounts receivable 354,375 Raw materials inventory 100,495 Finished goods inventory 333,000 Total current assets 841,870 Equipment 628,000 Accumulated depreciation (164,000 ) Equipment, net 464,000 Total assets $ 1,305,870 Liabilities and Equity Accounts payable $ 212,195 Short-term notes payable 26,000 Total current liabilities 238,195 Long-term note payable 514,000 Total liabilities 752,195 Common...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT