please give totals for table below for month september and month october from info given
1 | Total Cash Receipts | | |
| | | |
2 | Inventory Purchases | | |
| | | |
3 | Cash Payments for Inventory Purchases | | |
| | | |
4 | Total Variable Selling & Administrative Costs | | |
| | | |
5 | Total Fixed Selling & Administrative Costs | | |
| | | |
6 | Total Cash Payments (S&A Budget) | | |
| | | |
7 | Total Cash Surplus (Deficit) | | |
| | | |
8 | Total New Borrowing (Repayments) | | |
| | | |
9 | Contribution Margin | | |
| | | |
10 | Interest Expense | | |
| | | |
11 | Pre-tax income | | |
| | | |
12 | Income tax expense | | |
| | | |
13 | Accounts Receivable | | |
| | | |
14 | Inventory | | |
| | | |
15 | Prepaid Insurance | | |
| | | |
16 | Accumulated Depreciation | | |
| | | |
17 | Accounts Payable | | |
| | | |
18 | Commissions Payable | | |
| | | |
19 | Long-Term Debt | | |
| | | |
20 | Retained Earnings | | |
Layout References Mailings Review View Grammarly Acrobat Table Design Layc Bobcat Beverage Company Balance Sheets As of August 31, 2021 ASSETS CURRENT ASSETS Cash $ 25,800 Accounts Receivable $ 595,000 Inventory 5 50,688 Prepaid Insurance $ 27.500 $ TOTAL CURRENT ASSETS 698,988 PROPERTY PLANT & EQUIPMENT Land Equipment $ 100,000 $ 300.000 $ (100,000) Accumulated Depreciation TOTAL PPE $ 300,000 TOTAL ASSETS 998,988 LIABILITIES & STOCKHOLDERS EQUITY CURRENT LIABILITIES Accounts Payable $ Commissions Payable $ Advertising Exponse Payable $ Income Tabes Payable $ Dividends Payablo $ 81,859 59.500 121.250 22.000 I $ 284,509 TOTAL CURRENT LIABILITIES LONG TERM DEBT 220.000 STOCKHOLDERS EQUITY Common Stock Rotained Earnings 89,500 404 879 TOTAL STOCKHOLDERS EQUITY $ 494.379 TOTAL LIABILITIES & STOCKHOLDERS EQUITY 998,988 8508 Document Mallings View an Review Acrobat Layout References Table Design Grammarly Layout Tell me September 5800,000 October $900,000 November $980,000 Expected sales (all sales are credit salen) Collections of Accounts Receivable Month of Sala Month following Sale 24% 76% 44% Cost of Goods Sold percentage of sales Inventory Purchase Information Purchases paid a current month Purchases paid in next month Purchases Mal on Credit Planned ending inventory as a percentage of next month's Cost Goods Sold 78% 22% 8% Sales Commission Information Sales commissions as a percentage of skies Sales commissions are paid the month after they are incurred 8.5% Advertising Expense Information Variable Rats 17.30X Food Cost $60,000 12 Insurance policy Information of months of insurance coverage paid for each year The policy period is from August 1 to July 31 each year The premom was peld on July 31, 2021 The premium will be charged to prepaid insurance $30.000 $55.000 15.00% General and Administrative Expense Information Fixed cost portion Variable rate as a percentage of ) Song and administrative expenses are paid in the month incurred Fixed Asset Information Purchase Land on September 15, 2021 Current Depreciation expenso per month 130,000 10,000 Long Term Loan Interest Information The interest rate on the long-term debt per months Interest is paid on the principle balance at the beginning of the month Minimum Cash Balance New borrowing must be in $1,000 increments 15 $25,000 Tax Information Income tax tato Taxes are pad in the month after they are incurred (exposed 25% Dvidend Information Cash dividend declared on September 20, 2021 Cash dividend paid on October 15, 2021 $25.000 riglish (United States Focus 29,620