Financial and Managerial Accounting: P20-3 All Eyes Security Services Company provides security

Reminder: There are several versions of this problem (company names and amounts might be different); please compare and review your homework questions to our tutorial. If this tutorial is different from your questions, the format of the solution is the same. If you need more assistance, please email us. Financial and Managerial Accounting P20-3. Cash Budget All Eyes Security Services Company provides security monitoring services. It employs four security specialist. Each specialist works an average of 180 hours a month. The company’s controller has compiled the information that follows. Actual data for last year Forecasted data for current year November December January February March Securities billings sales 30,000 35,000 25,000 20,000 30,000 Selling and admin. Expenses 10,000 11,000 9,000 8,000 10,500 Operating supplies 2,500 3,500 2,500 2,000 3,000 Service overhead 3,000 3,500 3,000 2,500 3,000 Sixty percent of the client billings are cash sales collected during the month of sale, 30% are collected in the month following the sale; and 10 percent are collected in the second month following the sale. Operating supplies are paid for in the month of purchase. Selling and administrative expenses and service overhead are paid in the month following the cost’s incurrence. The company has a bank loan of $12,000 at a 12 percent annual interest rate. Interest is paid monthly, and $2,000 of the loan principal is due on Feb 28. Income taxes of $2,500 for the last calendar year are due and payable on March 15. The four security specialists each earn $15 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 $15,000 Required: Prepare a monthly cash budget for All Eyes for the three-month period ended March 31
Powered by