Budgeted Selling and Administrative ExpensesSalary ExpenseSales Commissions 5% of SalesInsurance ExpenseRentDepreciation on equipmentUtilitiesTotal Operating ExpensesSchedule of Cash Payments for Selling andAdministrative ExpensesSalary Expense100% of Prior Month Sales CommissionsInsurance ExpenseOctober November DecemberMultiple Choice30,000 30,50015,000 15,50012,000 12,00014,400 14,40016,500 16,5002,1002,30090,00091, 200?15,10012,000?2,200?30,500?12,000???Rent100% of Prior Months Utilities ExpenseTotal Payments for Selling and Administrative ExpensesThe amount of cash paid for Selling and Administrative expenses during the month of November is:31,00015,30012,00014,40016,5002,50091,700??12,00014,400?

Workings :- 1) Calculation of sales commissions paid in November :- 100% of sales commissions during…

Budgeted Selling and Administrative Expenses Salary Expense Sales Commissions 5% of Sales Insurance Expense Rent Depreciation on equipment Utilities Total Operating Expenses Schedule of Cash Payments for Selling and Administrative Expenses Salary Expense 100% of Prior Month Sales Commissions Insurance Expense October November Multiple Choice 30,000 30,500 15,000 15,500 12,000 12,000 14,400 14,400 16,500 16,500 2,100 2,300 90,000 91,200 ? 15,100 12,000 ? 2,200 ? 30,500 ? 12,000 Rent 100% of Prior Months Utilities Expense Total Payments for Selling and Administrative Expenses The amount of cash paid for Selling and Administrative expenses during the month of November is: ? ? > December 31,000 15,300 12,000 14,400 16,500 2,500 91,700 ? ? 12,000 14,400 ? ?

Budgeted Selling and Administrative Expenses Salary Expense Sales Commissions 5% of Sales Insurance Expense Rent Depreciation on equipment Utilities Total Operating Expenses Schedule of Cash Payments for Selling and Administrative Expenses Salary Expense 100% of Prior Month Sales Commissions Insurance Expense October November Multiple Choice 30,000 30,500 15,000 15,500 12,000 12,000 14,400 14,400 16,500 16,500 2,100 2,300 90,000 91,200 ? 15,100 12,000 ? 2,200 ? 30,500 ? 12,000 Rent 100% of Prior Months Utilities Expense Total Payments for Selling and Administrative Expenses The amount of cash paid for Selling and Administrative expenses during the month of November is: ? ? > December 31,000 15,300 12,000 14,400 16,500 2,500 91,700 ? ? 12,000 14,400 ? ?

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Graded HW i Fixed Budget For Year Ended December 31 $ Sales 3,171,000 Costs Direct materials 996,600 Direct labor 226,500 Sales staff commissions 60,400 Depreciation-Machinery 295,000 Supervisory salaries 203,000 Shipping 226,500 Sales staff salaries (fixed annual 250,000 amount) Administrative salaries 556,450 Depreciation-Office equipment 198,000 Income $ 158,550 Saved Required: 1&2. Prepare flexible budgets at sales volumes of 14,100 and 16,100 units. 3. The company's business conditions are improving. One possible result is a sales volume of 18,100 units. Prepare a simple budgeted income statement if 18,100 units are sold. Complete this question by entering your answers in the tabs below. Req 1 Req 3 and 2 Prepare flexible budgets at sales volumes of 14,100 and 16,100 units. Sales Variable costs Direct materials Direct labor Sales staff commissions Shipping Total variable costs Contribution margin Fixed costs PHOENIX COMPANY Flexible Budgets For Year Ended December 31 Flexible…
Please do not give solution in image format thanku
Cash Flow Budget Assumptions: Beginning balance is $20,000 Cost of goods sold is 80% of sales Building rent is $3,000 a month Accounts payable turnover ratio is 12 Accounts receivable ratio is 6 Inventory turnover ratio is 6 A quarter of sales are paid in cash Minimum cash balance is never less than $5,000
Please do not give solution in image format
October November December Budgeted S&A Expenses Salary Expense 10,000 10,500 11,000 Sales Commissions 5% of Sales. 5,300 5,000 5,500 2,000 Insurance Expense 2,000 2,000 Rent 2,400 2,400 2,400 1,500 1,500 1,500 Depreciation on equipment Utilities 1,100 1,300 1,500 Total Operating Expenses 22,000 23, 200 23,700 Schedule of Cash Payments for S&A Expenses Salary Expense ? 10,500 ? 100% of Prior Month Sales 5,100 ? ? Commissions Insurance Expense 2,000 2,000 ? 2,000 2,400 Rent ? 100% of Prior Months Utilities 1,200 ? ? Expense Total Payments for S&A Expenses ? ? ? What is the total amount of S&A expenses for the fourth quarter that the company will report on its pro forma income statement? Multiple Choice $64,400 $68,900 $23,700 $63,900
Please do not give solution in image format thanku
None
If the excel spreadsheet looked like this how would you set it up?
Please do not give solution in image format thanku