Cash Operating ExpensePayments  
Return ToTutorial
Estimated Monthly Totals Table  
This is a quick method for entering your estimated  cash operating payments (expenses).
Enter an amount for both a 4 week and 5 week period OR a percentage of sales amount
for any or all of the listed payment types. Items not entered in this table should be entered in the
Estimate Each Month Table.  If you enter amounts or a percentage for a category in this sheet
don't also enter an amount for the same category in the Estimate Each Month Table.
If you want to add some additional payment categories, add the new categories in the
yellow highlighted portion of the table below.
Note: Categories added in this table are also automatically added to the Estimate Each Month Table.
4-Week 5-Week Percentage
Period Period OR of Sales
Cash Operating Expense Payments          
Salaries and Wages         3200 4000  
Employee Benefits         640 800  
Worker's Compensation         116 145  
Rent-Property         2200 2200  
Rent-Equipment              
Utilities         700 900  
Repairs and Maintenance           1.34%
Insurance         625 625  
Car & Truck Expenses         350 450  
Travel              
Entertainment             1.34%
Telephone         450 550  
Postage         75 100  
Office Supplies         90 115  
Advertising             2.68%
Marketing/Promotion              
Professional Fees         475 600  
Training and Development       300 300  
Bank Charges         10 10  
Credit Card Fees             0.34%
Miscellaneous              
Refinishing Supplies             1.57%
Shipping & Packing Supplies           1.79%
               
               
               
               
               
               
               
               
               
               
               
               
               
               
               
               
               
               
               
               
               
               
               
  Total Monthly Cash Operating Expense Disbursements 9,231 10,795
Estimate Each Month Table  
This method requires the user to enter the estimated amounts for the number.
of periods that the user wants to prepare an estimate for. The number of periods
that need to be entered is the number of periods that you entered in the
Cash Projection Worksheet and appears at the top of the worksheet.
that need to be entered is the number of periods that you entered in the
If you enter amounts for a category in this sheet don't also enter an amount
for the same category in the Estimated Monthly Totals Table.
Estimate Each Month Table     Number Of Periods Needing To Be Entered: 12
Cash Operating Expense Payments       Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Total
Salaries and Wages                                
Employee Benefits                                
Worker's Compensation                                
Rent-Property                                
Rent-Equipment                                
Utilities                                
Repairs and Maintenance                              
Insurance                                
Car & Truck Expenses                                
Travel                                
Entertainment                                
Telephone                                
Postage                                
Office Supplies                                
Advertising                                
Marketing/Promotion                                
Professional Fees                                
Training and Development                              
Bank Charges                                
Credit Card Fees                                
Miscellaneous                                
Refinishing Supplies                                
Shipping & Packing Supplies                              
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
                                 
  Total Cash Operating Expense Payments By Month                                
Return To Tutorial