1. Manufacturing Overhead

Indirect materials $0.30 per labor hour

Indirect labor $0.50 per labor hour

Utilities $0.45 per labor hour

Maintenance $0.25 per labor hour

Factory supervisors salary $42,000 per month

Factory Depreciation $16,800 per month

Property taxes $ 2,675 per month

Insurance $ 1,200 per month

Repairs $ 1,300 per month

2. Selling and Administrative expenses

Salaries $72,000 per month

Advertising $15,000 per month

Insurance $ 1,400 per month

Office Depreciation $ 2,500 per month

Other fixed costs $ 3,000 per month

Other Information

The cash balance on December 31, 2014, totaled $100,500, but management has decided it would like to maintain a cash balance of at least $800,000 beginning on January 31, 2015.

Dividends are paid each month @ $2.50 per share for 5,000 shares. The company has an open line of credit with national Bank. The terms of the agreement require borrowing to be in the increments of $1,000, and the interest rate is 8%. Sprinkler borrows on the first day of the month and repays on the last day of the month if possible.

A $500,000 equipment purchase is planned for February 2015.

Required:

Do the following for the first quarter (January, February & March) of 2015 by using EXCEL spreadsheet:

1. Prepare manufacturing Overhead Budget
2. Prepare Selling and Administration Budget
3. Prepare Schedule of expected cash collections from customers
4. Prepare a schedule for expected cash payments for materials purchases
5. Prepare a Cash Budget.