The company’s managers budget cash flows on a Quantity basis

The company’s managers budget cash flows on a Quantity basis so that they can plan short term Investments and borrowings Celular phone sales are highest during the spring and summer.

Sales are baiety even within each quarter, but sales vary across quarters as follows. 

January March 10% 

Apr June 50% 

July  Sep 30% 

October December 10%

Accounts receivable at the end of the prior year consisting of sales made during December totaled $180,000 Payments from customers are usually received as follows.

Pay during the month good are received 50%

Pay the next month 50%

Bad Debts 0% 

The company pays it 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 gender 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 $100000 in January The company finances its short-term operations with a line of and from the bank which had a balance of $500.000 at the end of the prior year. The line of credit requires quarterly interest rates payments at an annual rate of 5.5% (For simplicity, assume that will barrowing and repayments occur on the last day of each quarter 

Prepare Quarterly budgets for cash receipts, cash disbursements and short-term financing?