Question

In: Accounting

3.      General Hospital provides a wide range of health services in its community. The board of directors...

3.      General Hospital provides a wide range of health services in its community. The board of directors has authorized the following capital expenditures:
     Intra-aortic balloon pump                                          $1,400,000
        Computed tomographic scanner                                   850,000
        X-ray equipment                                                                550,000
        Laboratory equipment                                                   1,200,000
        Total                                                                                 $4,000,000
The expenditures are planned for October 1, 20X7, and the board wishes to know the amount of
borrowing, if any, necessary on that date. Rebecca Singer, hospital controller, has gathered the following information to be used in preparing an analysis of future cash flows. Billings, made in the month of service, for 20X7 are shown below, with actual amounts for January through June and estimated amounts for July through December:

        Month                                                                             Actual Amount
        January                                                                            $5,300,000
        February                                                                           5,300,000
        March                                                                                5,400,000
        April                                                                                   5,400,000
        May                                                                                    6,000,000
        June                                                                                   6,000,000
        July (estimated)                                                              5,800,000
        August (estimated)                                                        6,000,000
        September (estimated)                                                6,600,000
        October (estimated)                                                      6,800,000
        November (estimated)                                                  7,000,000
        December (estimated)                                                  6,600,000
Ninety percent of Highline billings are made to third parties, such as BlueCross, federal or state
governments, and private insurance companies. The remaining 10% of the billings are made directly
to patients. Historical patterns of billing collections are:
                                                   Third-Party Billings                        Direct-Patient Billings
Month of service                                    20%                                                    10%
Month following service                      50                                                       40
Second month following service        20                                                       40
Uncollectible                                           10                                                       10
Singer expects the same billing and collection patterns that have been experienced during the first six months of 20X7 to continue during the last six months of the year. The following schedule presents the purchases that have been made during the past three months and the planned purchases for the last six months of 20X7.
                                     Month                                                  Amount
                                      April                                                   $1,300,000
                                      May                                                      1,450,000
                                    June                                                     1,450,000
                                      July                                                       1,500,000
                                      August                                                 1,800,000
                                      September                                         2,200,000
                                      October                                               2,350,000
                                      November                                          2,700,000
                                      December                                           2,100,000
All purchases are made on account, and accounts payable are remitted in the month following the
purchase.
• Salaries for each month during the remainder of 20X7 are expected to be $1,800,000 per
month plus 20% of that month’s billings. Salaries are paid in the month of service.
• Highline’s monthly depreciation charges are $150,000.
• Highline incurs interest expenses of $180,000 per month and makes interest payments of
$540,000 on the last day of each calendar quarter.
• Endowment fund income is expected to continue to total $210,000 per month.
• Highline has a cash balance of $350,000 on July 1, 20X7, and has a policy of maintaining a
minimum end-of-month cash balance of 10% of the current month’s purchases.
• Highline Hospital employs a calendar-year reporting period.
1. Prepare a schedule of budgeted cash receipts by month for the third quarter of 20X7.
2. Prepare a schedule of budgeted cash disbursements by month for the third quarter of 20X7.
3. Determine the amount of borrowing, if any, necessary on October 1, 20X7, to acquire the capital items totaling $4,000,000.

Solutions

Expert Solution



Related Solutions

3.      General Hospital provides a wide range of health services in its community. The board of directors...
3.      General Hospital provides a wide range of health services in its community. The board of directors has authorized the following capital expenditures:      Intra-aortic balloon pump                                          $1,400,000         Computed tomographic scanner                                   850,000         X-ray equipment                                                                550,000         Laboratory equipment                                                   1,200,000         Total                                                                                 $4,000,000 The expenditures are planned for October 1, 20X7, and the board wishes to know the amount of borrowing, if any, necessary on that date. Rebecca Singer, hospital controller,...
3.      General Hospital provides a wide range of health services in its community. The board of directors...
3.      General Hospital provides a wide range of health services in its community. The board of directors has authorized the following capital expenditures:      Intra-aortic balloon pump                                          $1,400,000         Computed tomographic scanner                                   850,000         X-ray equipment                                                                550,000         Laboratory equipment                                                   1,200,000         Total                                                                                 $4,000,000 The expenditures are planned for October 1, 20X7, and the board wishes to know the amount of borrowing, if any, necessary on that date. Rebecca Singer, hospital controller,...
3-27. The Georgeville city government provides a wide variety of services to the community. Among them...
3-27. The Georgeville city government provides a wide variety of services to the community. Among them is the protection provided by the police force. In order to provide that force, it spends $3 million on salaries, $200,000 on vehicle costs, and $300,000 on supplies. The police force expects to have 7,000 measurable actions, consisting of 1,000 arrests, 4,000 traffic citations, and 2,000 responses to emergency calls. It has noted that the average cost for each one of these actions is...
1. General purpose governments provide a wide range of services to their residents, such as public...
1. General purpose governments provide a wide range of services to their residents, such as public safety, road maintainance, and health and welfare. True False 2. Examples of special purpose governments include public schools, libraries, and water supply plants that receive tax revenue to finance the services they provide. True False 3.The Governmental Accounting Standards Board (GASB) has the authority to establish accounting principles for all governmental and not-for-profit organizations. True False 4. A key characteristic of a government is...
The head start program provides a wide range of services to low-income children up to the...
The head start program provides a wide range of services to low-income children up to the age of 5 years and their families. Its goals are to provide services to improve social and learning skills and to improve health and nutrition status so that the participants can begin school on an equal footing with their more advantaged peers. The distribution of ages for participating children is as follows 12% five-year-olds, 47% four-year-olds, 33% three-year-olds, and 8% under three years. When...
A community hospital is planning to expand its services to three new service lines in the...
A community hospital is planning to expand its services to three new service lines in the medical diagnostic categories (MDC-2, MDC-19, and MDC-21). Five common resources must be allocated among these three new service lines according to which will bring the most revenue. The resources are LOS, nursing hours, radiology procedures, laboratory procedures, and operating rooms. The health care manager in charge of this expansion project obtained the average consumption patterns of these resources for each MDC from other peer...
Dollars and Cents versus a Sense of Ethics    Grizzly Community Hospital in central Wyoming provides health...
Dollars and Cents versus a Sense of Ethics    Grizzly Community Hospital in central Wyoming provides health care services to families living within a 200-mile radius. The hospital is extremely well equipped for a relatively small, community facility. However, it does not have renal dialysis equipment for kidney patients. Those patients requiring dialysis must travel as far as 300 miles to receive care. Several of the staff physicians have proposed that the hospital invest in a renal dialysis center. The minimum...
A hospital administrator tells the board of directors that, on average, at least 185 beds are...
A hospital administrator tells the board of directors that, on average, at least 185 beds are filled on any given day. One of the board members believes this figure is inflated and manages to secure a random sample of occupancy figures for 16 days. The data is given below and in the Excel file Ass3_Q3a.xlsx. (i) Use the sample data and a significance level of 0.01 to carry out a hypothesis test to test the administrator’s claim. Assume the number...
A rural country hospital facility provides health care services to over 35,000 citizens, with a high...
A rural country hospital facility provides health care services to over 35,000 citizens, with a high percentage being older Americans who have retired to this area of the country. The hospital administrator has asked the Vice President of Risk Management to attend a meeting with the senior staff next week in the Board Room. The hospital administrator has asked Vice President of Risk Management to present areas of opportunity for increasing the hospital’s risk management strategies to ensure a litigation-free...
A rural country hospital facility provides health care services to over 35,000 citizens, with a high...
A rural country hospital facility provides health care services to over 35,000 citizens, with a high percentage being older Americans who have retired to this area of the country. The hospital administrator has asked the Vice President of Risk Management to attend a meeting with the senior staff next week in the Board Room. The hospital administrator has asked Vice President of Risk Management to present areas of opportunity for increasing the hospital’s risk management strategies to ensure a litigation-free...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT