Alpha Geek

(8)

$10/per page/Negotiable

About Alpha Geek

Levels Tought:
University

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Environmental science,Essay writing,Programming,Social Science,Statistics Hide all
Teaching Since: Apr 2017
Last Sign in: 438 Weeks Ago, 3 Days Ago
Questions Answered: 9562
Tutorials Posted: 9559

Education

  • bachelor in business administration
    Polytechnic State University Sanluis
    Jan-2006 - Nov-2010

  • CPA
    Polytechnic State University
    Jan-2012 - Nov-2016

Experience

  • Professor
    Harvard Square Academy (HS2)
    Mar-2012 - Present

Category > Accounting Posted 24 May 2017 My Price 7.00

Prepare a monthly cash budget for Security Services Company for the three-month period ended March 31

Security Services Company provides security monitoring services. It employs five security specialists. Each specialist works an average of 160 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

Security

$30,000 $35,000

$25,000 $20,000 $30,000

billings (sales)

 

 

Selling and

10,000 11,000

9,000 8,000 10,500

administrative

 

 

expenses

 

 

Operating

2,500 3,500

2,500 2,000 3,000

supplies

 

 

Service

3,000 3,500

3,000 2,500 3,000

overhead

 

 

Sixty percent of the client billings are cash sales collected during the month of sale; 30 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 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 February 28. Income taxes of $4,500 for last calendar year are due and payable on March 15. The five security specialists each earn $8.50 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 $13,000.

Required

Prepare a monthly cash budget for Security Services Company for the three-month period ended March 31.

 

Answers

Alpha Geek
(8)
Status NEW Posted 24 May 2017 07:05 AM My Price 7.00

-----------

Attachments

file 1495612546-Answer.docx preview (291 words )
S-----------ecu-----------rit-----------y S-----------erv-----------ice-----------s C-----------omp-----------any----------- pr-----------ovi-----------des----------- se-----------cur-----------ity----------- mo-----------nit-----------ori-----------ng -----------ser-----------vic-----------es.----------- It----------- em-----------plo-----------ys -----------fiv-----------e s-----------ecu-----------rit-----------y s-----------pec-----------ial-----------ist-----------s. -----------Eac-----------h s-----------pec-----------ial-----------ist----------- wo-----------rks----------- an----------- av-----------era-----------ge -----------of -----------160----------- ho-----------urs----------- a -----------mon-----------th.----------- Th-----------e c-----------omp-----------any-----------’-----------s c-----------ont-----------rol-----------ler----------- ha-----------s c-----------omp-----------ile-----------d t-----------he -----------fol-----------low-----------ing----------- in-----------for-----------mat-----------ion-----------: -----------  -----------Act-----------ual----------- Da-----------ta -----------for----------- La-----------st -----------Yea-----------r F-----------ore-----------cas-----------ted----------- Da-----------ta -----------for----------- Ne-----------xt -----------Yea-----------r -----------  -----------Nov-----------emb-----------er -----------Dec-----------emb-----------er -----------Jan-----------uar-----------y F-----------ebr-----------uar-----------y M-----------arc-----------h -----------Sec-----------uri-----------ty -----------$30-----------,00-----------0 $-----------35,-----------000----------- $2-----------5,0-----------00 -----------$20-----------,00-----------0 $-----------30,-----------000----------- b-----------ill-----------ing-----------s (-----------sal-----------es)-----------  -----------  ----------- S-----------ell-----------ing----------- an-----------d 1-----------0,0-----------00 -----------11,-----------000-----------
Not Rated(0)