Copy of unit 9

30 Sep No Comments





Unit 9 Assignment Spreadsheet Month 1  
     
Revenue  
Number of customers 230  
Average price 6  
Total Revenue 1380  
 
Expenses  
Inventory costs 60  
  Advertising 93  
  Bad Debt Expense 40  
  Bank Charges 80  
  Depreciation & Amortization 120  
  Dues & Subscriptions 45  
  Insurance 34  
  Licenses & Fees 50  
  Marketing & Promotion 15  
  Meals & Entertainment 0  
  Miscellaneous 20  
  Office Expense 40  
  Office Supplies 20  
  Outside Services 60  
  Payroll Expenses 0  
    Salaries & Wages 200  
    Payroll Taxes 3  
    Benefits 0  
  Professional Fees 0  
  Property Taxes 27  
  Rent 50  
  Repairs & Maintenance 40  
  Shipping & Delivery 0  
  Telephone 100  
  Training & Development 0  
  Travel 0  
  Utilities 25  
  Vehicle 0  
Other 0  
Other 0  
Other 100  
Total Expenses 1222  
 
Profit 158  





Click following link to download this document

Copy of unit 9.xlsx