P939

Round lake medical Centre is located in a summer resort community during the summer months the centre operaters and out patient clinic for the treatment of minor injuries and illnesses. The clinic is administrated as a separate department with the hospital. It has its own staff and maintains its own financial records. All patients requiring extensive and intensive care refered to other hospital departments. An analysis of past operating data for the out-patient clinic reveals the following: staff: Seven full time employes with total monthly salaries of $42.000. On a month basis one additional staff member is hired for every 500 budgeted patients visists in excess of 3,000. at a cost of $4,000 per month. Facilities: Monthly facilitiy costs, including depreciation of 2,000, total $8,000. Supplies. The supplies expense averages $10 per patient visit. the centre maintains an end-of-month suppiles inventory equal to ten percent of the predicted needs of the following month, with a minimum ending inventory of $3,000, which is also the desired inventory at the end of August. Additional variable patient costs, such as medication, are charged directly to the patient by the hospital pharmacy. Payments: All staff and maintenance expenses are paid in the month the cost is incorrect suppillies are purchased at cost directly from the hospital and immediate transfer of cash from the clininc cash account to the hospital cash account. Collections: the average bill for service rendered is $60. of the total bills, 40percent are paid in cash at the time the services rendered. 10percent are never paid, and remaing 50percent are covered by insurance, In the past, insurance companies have disallowed 20 percent of the claimsa filled and paid the balance 2months after service rendered. May 30 status: At the end of May, the clinic had$12,000 in cash supplies costing $3,000. Budgeted patients visits for next summer are as follows: Required For the Round Lake OutPatient Clinic: Prepare a supplies purchases budget for june,july, and August, with a total coloumn. Prepare a revenue and expense budget for june,july, and August with a total coloumn. prepare a cash budget for june,july, and August with a total coloumn. Developing a Master Budget for a Merchandising Organisation Peyron Department Store prepares budgets quaterly. The following information is available for