Cash Budget
FM Company provides fraud monitoring services. It employs four fraud specialists. Each specialist works an average of 200 hours a month. The company’s controller has compiled the following information:
|
Actual Data for Last Year |
Forecasted Data for Next Year |
||||
|
November |
December |
January |
February |
March |
|
|
Billings (sales) |
$100,000 |
$80,000 |
$60,000 |
50,000 |
$70,000 |
|
Selling and administrative |
|||||
|
expenses |
15,000 |
12,000 |
8,000 |
7,000 |
10,000 |
|
Operating |
|||||
|
supplies |
2,500 |
3,500 |
2,500 |
2,000 |
3,000 |
|
Service |
|||||
|
overhead |
14,000 |
13,500 |
13,000 |
12,500 |
13,000 |
Seventy percent of the client billings are cash sales collected during the month of sale; 20 percent are collected in the first month following the sale; and 10 percent are collected in the second month following the sale. Operating supplies are paid in the month of purchase. Selling and administrative expenses and service overhead are paid in the month the cost is incurred.
The company has a bank loan of $12,000 at a 6 percent annual interest rate. Interest is paid monthly, and $2,000 of the loan principal is due on February 28. Income taxes of $6,500 for last calendar year are due and payable on March 15. The four security specialists each earn $48.00 an hour, and all payroll-related employee benefit costs are included in service overhead. The company anticipates no capital expenditures for the first quarter of the coming year. It expects its cash balance on December 31 to be $10,000.
Required
Prepare a monthly cash budget for FM Company for the three-month period ended March 31.