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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!