Question: Need completed budgeted income statement. I will paste my total of fixed and variable S&A expenses, but then need to remove accruals of decprectioin, 14000
Need completed budgeted income statement. I will paste my total of fixed and variable S&A expenses, but then need to remove accruals of decprectioin, 14000 per quarter, as well remove accrual of commissions per quarter, which is the commssions earned in that quarter, 5% of sales. Then add commssions payments per quarter. commissions is earned in quarters,5% of sales, and paid out in the following quarter. So need to keep timing correct. Also insurance payments are 6000/quarter. Insurance is prepaid every year on oct.1 of 240000.per quarter that are earned in the quarter sndf paid out in the following quarter. Also remove accrual of insurance payments, and add prepaid insurance payments. Insurance is prepaid for 12 months on oct 1 every year.
this is what my problem states:
Sales commissions are accrued in the quarter the sales are made, but are paid to the sales staff in the next quarter.
Insurance for a twelve month period is prepaid on October 1 of each year. All other expenses are paid in the quarter incurred.
BW has a regular dividend pattern which is expected to continue during 2020. This pattern involves BWs board of directors declaring a $25,000 quarterly dividend on March 15th, June 15th, September 15th, and December 15th. The dividends are paid 30 days after the boards declaration.
..and i need bottom portion of the Sellling and admin budget. need the accruals and expenses done to keep track of time of expenses and paymetns done at bottom
| Selling and Administrative Expense Budget | |||||||
| Quarter | 1 | 2 | 3 | 4 | Year | ||
| Variable Selling Expense: | |||||||
| Commission Expense | $ 39,000 | $ 61,920 | $ 18,000 | $ 32,400 | $ 151,320 | ||
| Fixed Selling and Adminustrative Expenses: | |||||||
| Advertising Expense | $ 200,000 | 200,000 | 200,000 | 200,000 | $200,000 | ||
| Rent Expense | $ 18,000 | 18,000 | 18,000 | 18,000 | 18,000 | ||
| Salaries Expense | $ 113,000 | 113,000 | 113,000 | 113,000 | 113,000 | ||
| Utiliities Expense | $ 9,000 | 9,000 | 9,000 | 9,000 | 9,000 | ||
| Insurance Expense | $ 6,000 | 6,000 | 6,000 | 6,000 | 6,000 | ||
| Depreciation Expense | $ 14,000 | 14,000 | 14,000 | 14,000 | 14,000 | ||
| Total Fixed Costs | $ 360,000 | $ 360,000 | $ 360,000 | $ 360,000 | $ 1,440,000 | ||
| Total Variable and Fixed S&A Expense
| $ 399,000 | $421,920 | $378,000 | $392,400 | $1,591,320 | ||
| Depreciation Expense | |
| Remove accrual commission expense | |
| Add: cash commission payments | |
| Remove accrual of Insurance expense | |
| Add: Prepaid Insurance payments: Oct.1 $24,000 | |
| Totals | |
| Selling and Admin. Expense Cash Disbursemnts | |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
