Transcribed Image Text
The Alex Thomsen Company is planning to request a line of creditfrom its bank. The following sales forecasts have been made forparts of 2017 and 2018:May 2017$150,000June150,000July300,000August450,000September600,000October300,000November300,000December75,000January 2018150,000Collection estimates obtained from the credit and collectiondepartment are as follows: collected within the month of sale, 5percent; collected the month following the sale, 80 percent;collected the second month following the sale, 15 percent. Paymentsfor labor and raw materials are typically made during the monthfollowing the month in which these costs are incurred. Total laborand raw materials costs are estimated for each month asfollows:May 2017$75,000June75,000July105,000August735,000September255,000October195,000November135,000December75,000General and administrative salaries will amount to approximately$22,500 a month; lease payments under long-term lease contractswill be $7,500 a month; depreciation charges will be $30,000 amonth; miscellaneous expenses will be $2,250 a month; income taxpayments of $52,500 will be due in both September and December; anda progress payment of $150,000 on a new research laboratory must bepaid in October. Cash on hand on July 1 will amount to $110,000 anda minimum cash balance of $75,000 will be maintained through-outthe cash budget period.A. Prepare a cash budget for the lastsix months of 2017 with an estimate of required financing (orexcess funds).