Schedule of Expected Cash Collections Collection of Cash Sales Credit Sales: Collected Month of Sale Collected Month After Sale Total Collections Inventory Purchases Budget Budgeted Costs of Goods Sold Add Desired Ending Inventiory Total Inventory Needs Deduct Beginning Inventory Total Purchases Schedule of Cash Disbursements-Inventory Operating Expenses: Salaries and Wages Shipping Advertising Total Cash Disbursements Cash Budget Inventory Purchases: Paid Month of Purchases Paid Month After Purchases Total Cash Disbursements Schedule of Cash Disbursements-Operating Expenses Cah Balance Beginning Add Cash Collections Total Cash Available Less Cash Disbursements: For Inventory Purchases For Operating Expenses For Land Purchases For Dividends Total Cash Disbursements Excess (Deficiency) of Cash Financing: Borrowed from Bank AUG $ 180,000.00 $210,000.00 $240,000.00 $ 210,000.00 $245,000.00 $280,000.00 $ 175,000.00 $210,000.00 $245,000.00 $ 565,000.00 $665,000.00 $765,000.00 Principal Repayment Interest Paid Cash Balance, Ending Expenses JUL JUL $ 330,000.00 $385,000.00 $440,000.00 $ 57,750.00 $66,000.00 $49,500.00 $ 387,750.00 $451,000.00 $489,500.00 $ 100,000.00 $57,750.00 $66,000.00 $ 287,750.00 $393,250.00 $423,500.00 JUL JUL AUG JUL AUG $ 115,100.00 $157,300.00 $169,400.00 $ 110,000.00 $172,650.00 $235,950.00 $ 225,100.00 $329,950.00 $405,350.00 SEP 0 AUG $34,600.00 SEP $ 170,000.00 $190,000.00 $210,000.00 $ 12,000.00 $14,000.00 $16,000.00 $ 12,500.00 $12,500.00 $12,500.00 $ 194,500.00 $216.500.00 $238,500.00 AUG SEP SEP $100,000.00 $100,000.00 $183,258.00 $565,000.00 $665,000.00 $765,000.00 $665,000.00 $765,000.00 $948,258.00 SEP $225,100.00 $329,950.00 $405,350.00 $194,500.00 $216,500.00 $238,500.00 $180,000.00 0 $191,008.00 0 $25,000.00 $599,600.00 $546,450.00 $859,858.00 $65,400.00 $218,550.00 $88,400.00 $11,600.00 0 $34,600.00 $692.00 0 $100,000.00 $183,258.00 $100,000.00 Q3 Totals $ 630,000.00 $735,000.00 $630,000.00 1995000 Q3 $1,155,000.00 $ 173,250.00 $1,328,250.00 $ 223,750.00 $1,104,500.00 Q3 $ 508,350.00 $518,600.00 $ 960,400.00 Q3 $570,000.00 $ 42,000.00 $ 37,500.00 $ 649,500.00 Q3 $100,000.00 $1,995,000.00 $2,095,000.00 $ 960,00.00 $649,500.00 $ 371,008.00 $ 25,000.00 $2,005,908.00 $ 89,092.00 $46,200.00 $ 34,600.00 $ 692.00 $100,000.00

Schedule of Expected Cash Collections Collection of Cash Sales Credit Sales: Collected Month of Sale Collected Month After Sale Total Collections Inventory Purchases Budget Budgeted Costs of Goods Sold Add Desired Ending Inventiory Total Inventory Needs Deduct Beginning Inventory Total Purchases Schedule of Cash Disbursements-Inventory Operating Expenses: Salaries and Wages Shipping Advertising Total Cash Disbursements Cash Budget Inventory Purchases: Paid Month of Purchases Paid Month After Purchases Total Cash Disbursements Schedule of Cash Disbursements-Operating Expenses Cah Balance Beginning Add Cash Collections Total Cash Available Less Cash Disbursements: For Inventory Purchases For Operating Expenses For Land Purchases For Dividends Total Cash Disbursements Excess (Deficiency) of Cash Financing: Borrowed from Bank AUG $ 180,000.00 $210,000.00 $240,000.00 $ 210,000.00 $245,000.00 $280,000.00 $ 175,000.00 $210,000.00 $245,000.00 $ 565,000.00 $665,000.00 $765,000.00 Principal Repayment Interest Paid Cash Balance, Ending Expenses JUL JUL $ 330,000.00 $385,000.00 $440,000.00 $ 57,750.00 $66,000.00 $49,500.00 $ 387,750.00 $451,000.00 $489,500.00 $ 100,000.00 $57,750.00 $66,000.00 $ 287,750.00 $393,250.00 $423,500.00 JUL JUL AUG JUL AUG $ 115,100.00 $157,300.00 $169,400.00 $ 110,000.00 $172,650.00 $235,950.00 $ 225,100.00 $329,950.00 $405,350.00 SEP 0 AUG $34,600.00 SEP $ 170,000.00 $190,000.00 $210,000.00 $ 12,000.00 $14,000.00 $16,000.00 $ 12,500.00 $12,500.00 $12,500.00 $ 194,500.00 $216.500.00 $238,500.00 AUG SEP SEP $100,000.00 $100,000.00 $183,258.00 $565,000.00 $665,000.00 $765,000.00 $665,000.00 $765,000.00 $948,258.00 SEP $225,100.00 $329,950.00 $405,350.00 $194,500.00 $216,500.00 $238,500.00 $180,000.00 0 $191,008.00 0 $25,000.00 $599,600.00 $546,450.00 $859,858.00 $65,400.00 $218,550.00 $88,400.00 $11,600.00 0 $34,600.00 $692.00 0 $100,000.00 $183,258.00 $100,000.00 Q3 Totals $ 630,000.00 $735,000.00 $630,000.00 1995000 Q3 $1,155,000.00 $ 173,250.00 $1,328,250.00 $ 223,750.00 $1,104,500.00 Q3 $ 508,350.00 $518,600.00 $ 960,400.00 Q3 $570,000.00 $ 42,000.00 $ 37,500.00 $ 649,500.00 Q3 $100,000.00 $1,995,000.00 $2,095,000.00 $ 960,00.00 $649,500.00 $ 371,008.00 $ 25,000.00 $2,005,908.00 $ 89,092.00 $46,200.00 $ 34,600.00 $ 692.00 $100,000.00

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter8: Standard Costs And Variances

Section: Chapter Questions

Problem 18MC: A flexible budget______. A. predicts estimated revenues and costs at varying levels of production B....

See similar textbooks