Cash Budget January - June                 Cash Inflow               Month January February March April May June   Beginning Cash Balance    $                 -    $                 -    $                 -    $                 -    $                 -     Add Receipts               Collections from customers  $                   -    $                 -    $                 -    $                 -    $                 -    $                 -         Total Increases To Cash  $                   -    $                 -    $                 -    $                 -    $                 -    $                 -                     Cash Outflow               Direct Material Purchases   $                   -    $                 -    $                 -    $                 -    $                 -    $                 -     Direct Labor $0 $0 $0 $0 $0 $0   Manufacturing Overhead   $                   -    $                 -    $                 -    $                 -    $                 -    $                 -     Selling and Administrative Expenses  $                   -    $                 -    $                 -    $                 -    $                 -    $                 -     Interest Expense    $                 -    $                 -    $                 -    $                 -    $                 -         Total Decreases To Cash  $                   -    $                 -    $                 -    $                 -    $                 -    $                 -                     Excess(deficiency) of cash  $                   -    $                 -    $                 -    $                 -    $                 -    $                 -     Financing (line of credit):               Borrowings (enter as positive value)               Repayments (enter as negative value)

Need 1-3

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…

How do I solve the chart?

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 December 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: 31,000 15,300 12,000 14,400 16,500 2,500 91,700 ? ? 12,000 14,400 ?

DO NOT GIVE SOLUTION IN IMAGE FORMAT

Production Budget

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

Dd.1