I am creating a cash budget but im not sure how how to continue. I started with the budgeted monthly receipts which I believe are correct. But, I'm lost and don't know how to input the numbers necessary in each of the budgeted tables.

Fixed overhead is incurred evenly throughout the year. Fixed overhead per year is DYE-ASPORA, Incorporated composed of the following costs: Balance Sheet Salaries December 31, 20XX $78,000 UtiliLies 2.000 Assets LIabilities and Blog older Equity Insurance-factory 2.400 Cash $8.080 Notes Payable $25.000 Depreciation-factory 27.600 Accounts Receivable 26.500 Accounts Payable 2,148 Raw Materials Inventory 2000 Dividends Payable 10.000 6. There is no beginning work in process inventory. All work in process is completed in the Finished Goods Inventory 2,680 Total Liabilities 37.148 period in which it is started. Raw materials inventory at the beginning of the year consists Prepaid Insurance 1,200 Common Stock 100,000 of 1.000 gallons of Mordant. There are 400 gallons of dye in finished goods inventory at the Building 300,000 Paid-in Capital 50.000 beginning of the year carried at standard cost. Acc Depreciation (20 000) 280.000 Retained Earnings 130.312 280.312 Total Assets $317 460 Total Liabilities and Equity $317460 7. Accounts Payable relates solely to raw material and is paid 60 percent in the month of purchase and 40 percent in the month after purchase. No discounts are given for prompt The Accounts Receivable balance al December 31si represents the remaining balances of payment November and December credit sales: $70,000 and $65,000, respectively, 8. The dividend will be paid in January. 3. Estimated sales in gallons of dye for January through May follow, January 8,000 9. A new piece of equipment costing $9,000 will be purchased on March 1. Payment of 80 February 10.000 percent will be made in March and 20 percent in April. The equipment has a useful life of March 16.000 three years and will have no salvage value. April 18:000 May 1 1,000 10. The note payable has a 6% interest rate; interest is paid at the end of each month. The Each gallon of dye sells for $12.75. principal of the note is repaid as cash is available to do so. The collection pattern for accounts receivable is as follows: . 70% in the month of sale, 1 1. Dye-Aspora's management has set a minimum cash balance at $5,000. Investments and * 20% the month after sale, and borrowings are made in $100 increments. Investments are expected to earn 9% per year. 10% the second month after sale. 12. The ending finished goods inventory should include 15 percent of the next month's needs. Dye-Aspora expects no bad debts and gives no cash discounts. This is not true at the beginning of January due to a miscalculation in sales for December. Each gallon of dye has the following standard quantities and costs for direct materials and The ending inventory of raw materials also should be 25 percent of the next month's needs direct labor. 13_ Monthly selling and administrative costs are paid in cash. Per month costs are as follows: Mordant (DM) Quantity 1.20 ON Direct labor 0.25 Hr $1200 $3.00 Salaries $18.000 Utilities 800 Some evaporation loss occurs during processing. Variable overhead (VOH) is applied basis machine-hours. The processing of 1 gallon of dye lakes S MIL. The variable overhead rate Office Rent 7,000 is 50.06 per MIL. VOH is entirely of utility costs. FOH is applied per gallon based on an expected annual capacity of 120,000 gallons. Required: Prepare a master budget, by month, for the first quarter including quarterly totals and the pro- forma income statement and balance sheet as of March 3Ist. DYE-ASPORA DYE-ASPORA Budgeted Monthly Cash Receipts Budgeted Monthly Purchases For the Quarter Ended March 31, 20XX For the Quarter Ended March 31, 20XX January February March 1st Quarter January February March Total Sales $ 102,000,00 $ 127.500.00 $ 191.250.00 $ 420,750.00 Total Sales $ 102,000.00 $ 127,500.00 $ 191,250.00 Cash Collections Cash Sales (70%) 7070 71400.00 69250.00 133875.00 294525.00 Purchases (80%) 6400 In month after sale 20% 13000.00 20400.00 25500.00 58900.00 Total Payment $ 184,850.00 Two months after sale 10% 7000.00 6500.00 10200.00 23700.00 Credit Sales $ 20,000.00 $ 26 900.00 $ 35,700.00 $ 82,600.00 Total Receipts $ 91,400.00 $ 116,150.00 $ 169 575.00 $ 377,125.00 DYE-ASPORA DYE-ASPORA DYE-ASPORA Budgeted Monthly Cash Operating Costs Budgeted Monthly Cash Disbursements udgeted Cash Receipts and Disbursements For the Quarter Ended March 31, 20XX For the Quarter Ended March 31, 20xx For the Quarter Ended March 31, 20xx January February March Ist Quarter January February March January February March Total Sales $ 102,000.00 $ 127,500.00 $ 191.250.00 $ Purchases 6400 Receipts Operating Costs 25800 25800 25800 Disbursements Salaries 18000 18000 8000 Other Net Cash Income (decrease) Utilities 800 800 800 Total Disbursements Office Rent 7000 7000 7000 Total Payments 25800 25800 25800 Financing Required