Please help prepare the Cash Disbursements Schedule part of the final cash budget. (The budgets are to be prepared for the following year from January to December.)

the given information:

After gathering information about next year's operations, X company wants to do a detailed budget for next year. Direct Materials Per Cell Phone: Circuit $35.00 Battery $20.00 Case $10.00 Direct Labor: Hours Assembly .5 Packing Cost Per Hour Assembly $65.00 Packing $35.00 Cost Per Cell Phone Assembly $30.00 Packing $5.00 Inventory Information: Beginning Target Ending Circuit $25,000 $35,000 Battery $20,000 $25,000 Case $10,000 $12,000 Finished Goods (units) 2,000 2,200 Finished Goods (cost) $107,850 Revenue Assumptions: Selling Price per Cell Phone $150 Volume of Cell Phone Sales 100,000Following are estimated manufacturing overhead costs. Both fixed and variable overhead will be allocated based on the number of cell phones produced: Estimated variable manufacturing overhead costs: Supplies $220,000 Indirect labor 300,650 Maintenance 140,200 Miscellaneous 55,200 Total 716,050 Estimated fixed manufacturing overhead costs: Amortization $320,728 Property Taxes 32,228 Insurance 72,368 Plant Management 340,600 Fringe Benefits 406,840 Miscellaneous 89,992 Total 1,262,756 Following is the information that the accountant collected about support department costs: Support Department Fixed Costs Administration $1,534,800 Marketing 1,020,748 Distribution 510,374 Customer Service 303,458 $3,369,380_| The company's managers budget cash ows on a quarterly basis so that they can plan short-term investments and borrowings. Cellular phone sales are highest during the spring and summer. Sales are fairly even within each quarter. The company pays its vendors 10 days after raw materials are received, so approximately 80% of purchases are paid in the month of production and 20% are paid the following month. Accounts payable at the end of the prior year totaled $130,000. Employee wages and other production costs are paid during the month incurred. Property taxes are paid in two equal installments on March 31 and September 30, and insurance is paid annually on June 30. Support costs are paid evenly throughout the year. Estimated income tax payments are made at the end of the quarter, based on 25% of total estimated taxes for the year. In addition to customer receipts, the company expects to receive $10,000 in proceeds from the sale of equipment during January. The company also plans to purchase and pay for new equipment costing $100,000 in January