BGA1 Student Template 308(1).1.7-02, 08, 09 Budget Task 2

Check balances have been provided in some cells as comments in the template. Your cursor over the cell with a red triangle in the upper right corner will display the check balance. Cursor here Company A Selling and Administrative Budget For the Quarter Ended March 31, Year 11 Total January February March Expenses Selling Expenses: Variable: Sales Commissions 10500 12000 10500 33000 Sales Manager Override 5250 6000 5250 16500 Advertising Expenses 24500 28000 24500 77000 Travel Expenses 14000 16000 14000 44000 Total Variable Selling Expense 54250 62000 54250 170500 Fixed: Sales Manager 5000 5000 5000 15000 Total Selling Expenses 59250 67000 59250 185500 Administrative Expenses: Variable: Utilities 1500 1700 1520 4720 Fixed: Administrative Salaries & Support 8000 8000 8000 24000 Insurance Expense 600 600 600 1800 Total Administrative Expense 10100 10300 10120 30520 Total Selling and Admin Expense 69350.00 77300.00 69370.00 216020.00

Company A Accounts Receivable For the Quarter Ended March 31, Year 11 Total January February March Collections November Sales 60000 60000 December Sales 120000 48000 168000 January Sales 91000 175000 70000 336000 February Sales 104000 200000 304000 March Sales 91000 91000 Total Monthly Collections 271000 327000 361000 959000