Basic hospital has twelve producing departments and four supporting departments. The budgeted data here pertain to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Basic hospital has twelve producing departments and four supporting departments. The budgeted data here pertain to these sixteen departments, and the allocation statistics table below identifies the allocation bases used to distribute the costs of each supporting department. ALLOCATION STATISTICS TABLE Dept. General Admin Maintenance Housekeeping Cafeteria Statistic Payroll dollars Total Assets Patient Days # of employees *Step method support department rankings are based on the proportion of the department's statistic that is used up by other support departments. Required: 1. Create a table (Table 1) showing the allocation of supporting departments to producing departments using the direct method. See example 7.3 from the textbook for guidance on preparing the allocation schedule. 2. Create a table (Table 2) showing the allocation of supporting departments to producing departments using the sequential method. (See example 7.4 for guidance) 3. Create a table (Table 3) showing the comparison of the two allocation methods. Table 3 should be a summary table. It should have columns for total amounts allocated for each method. It should also have a column for the difference between the two methods. Rows should exist for each producing department. For Example: Table Title Direct Method Step Method Producing Dept. A $X $ Y Difference $Y -$X Producing Dept. B $ A $ B $A-$B www Producing Dept. L Totals $ L Sum $ M Sum $ L - $ M Sum 4. If the hospital is currently using the direct method, do you think (based on the differences you see) that they should switch to the sequential method? Write up your recommendation to the management of Basic Hospital in 250 words or less. 5. Combine Table 1, Table 2, Table 3, and your recommendation into a single PDF and upload the PDF to complete the assignment. Be sure to reference the grading rubric and thoroughly review your work prior to submission. A B D E F G H 1 2 Direct Overhead $ 753,547 $ General Admin Maintenance Housekeeping Cafeteria 548,687 $ 654,853 $ Emergency Room Labor and Delivery Surgery K Intensive Care (Radiology L M N P R General Med/S Opthamology Psychiatry Long-term Care Physical Therap Palliative Care Coronary Care 3 Payroll dollars $ 542,568 $ 227,927 $ 456,852 $ 4 Total Assets $ 807,052 $ 398,312 $ 393,907 $ 996,452 $ 525,458 $ 435,127 $ 512,475 $ 1,024,950 $ 624,239 $ 179,612 $ 125,132 $ 428,129 $ 415,091 $ 450,316 $ 1,248,478 $ 359,224 $ 250,264 $ 856,258 $ 830,182 $ 900,632 $ 5 Patient Days 703,617 $ 7,452 850,583 $ 181,217 $ 237,380 $ 849,170 $ 793,965 $ 724,377 $ 2,816 13,082 3,050 5,662 3,983 1,448 6 Employees 5 3 8 9 11 13 5 4 10 10 10 358,314 $ 716,628 $ 547,952 $ 1,581 9 546,974 $ 1,093,948 $ 1,041,184 $ 8,715 104,291 $ 267,706 $ 184,130 208,582 $ 535,412 $ 368,260 206,694 $ 4,000 492,682 $ 716 268,154 4,795 12 3 7 5 7 8 1. DIRECT METHOD TABLE 1 Emergency Labor & Surgery room delivery Intensive Care Radiology Gen Med Opthamology Psychiatry Long term Phy. Therapy Pal. Care Cor. Care Total care Number of 11 13 5 4 10 10 10 9 12 3 7 5 99 employees Payroll dollars $ $ $ $ $ $ $ $ $ $ $ $ $ 1,024,950.00 1,248,478.00 359,224.00 250,264.00 856,258.00 830,182.00 900,632.00 716,628.00 1,093,948.00 208,582.00 535,412.00 368,260.00 8,392,818.00 Patient days $ $ $ $ $ $ $ $ $ $ $ $ $ 7,452.00 2,816.00 13,082.00 3,050.00 5,662.00 3,983.00 1,448.00 1,581.00 8,715.00 4,000.00 716.00 4,795.00 57,300.00 Total assets $ $ $ $ $ $ $ $ $ $ $ $ $ 703,617.00 850,583.00 181,217.00 237,330.00 849,170.00 793,965.00 724,377.00 547,952.00 1,041,184.00 206,694.00 492,682.00 268,154.00 6,896,925.00 ALLOCATION: Cafeteria (# of $ $ $ $ $ $ $ $ $ $ $ $ $ employees) 110,716.89 130,847.23 50,325.86 40,260.69 100,651.72 100,651.72 100,651.72 90,586.55 120,782.06 30,195.52 70,456.20 50,325.86 996,452.00 Gen. Admin $ $ $ $ $ $ $ $ $ $ $ $ $ (Payroll $) 92,024.87 112,094.28 32,252.83 22,469.89 76,878.90 74,537.68 80,863.01 64,342.26 98,219.84 18,727.48 48,071.83 33,064.13 753,547.00 Housekeeping $ $ $ $ $ $ $ $ $ $ $ $ $ (patient days) 85,165.18 32,182.65 149,507.63 34,856.92 64,708.16 45,519.71 16,548.47 18,068.46 99,599.37 45,714.00 8,182.81 54,799.65 654,853.00 Maintenance (total assets) TOTAL $ $ $ $ $ $ $ $ $ $ $ $ $ 55,966.27 67,656.06 14,414.15 18,877.42 67,543.67 63,152.62 57,617.53 43,584.55 82,816.62 16,440.61 39,188.33 21,329.19 548,587.00 $ $ $ $ $ $ $ $ $ $ $ $ $ 343,873.20 342,780.22 246,500.47 116,464.92 309,782.45 283,861.73 255,680.73 216,581.81 401,417.89 111,077.60 165,899.16 159,518.83 2,953,439.00 Basic hospital has twelve producing departments and four supporting departments. The budgeted data here pertain to these sixteen departments, and the allocation statistics table below identifies the allocation bases used to distribute the costs of each supporting department. ALLOCATION STATISTICS TABLE Dept. General Admin Maintenance Housekeeping Cafeteria Statistic Payroll dollars Total Assets Patient Days # of employees *Step method support department rankings are based on the proportion of the department's statistic that is used up by other support departments. Required: 1. Create a table (Table 1) showing the allocation of supporting departments to producing departments using the direct method. See example 7.3 from the textbook for guidance on preparing the allocation schedule. 2. Create a table (Table 2) showing the allocation of supporting departments to producing departments using the sequential method. (See example 7.4 for guidance) 3. Create a table (Table 3) showing the comparison of the two allocation methods. Table 3 should be a summary table. It should have columns for total amounts allocated for each method. It should also have a column for the difference between the two methods. Rows should exist for each producing department. For Example: Table Title Direct Method Step Method Producing Dept. A $X $ Y Difference $Y -$X Producing Dept. B $ A $ B $A-$B www Producing Dept. L Totals $ L Sum $ M Sum $ L - $ M Sum 4. If the hospital is currently using the direct method, do you think (based on the differences you see) that they should switch to the sequential method? Write up your recommendation to the management of Basic Hospital in 250 words or less. 5. Combine Table 1, Table 2, Table 3, and your recommendation into a single PDF and upload the PDF to complete the assignment. Be sure to reference the grading rubric and thoroughly review your work prior to submission. A B D E F G H 1 2 Direct Overhead $ 753,547 $ General Admin Maintenance Housekeeping Cafeteria 548,687 $ 654,853 $ Emergency Room Labor and Delivery Surgery K Intensive Care (Radiology L M N P R General Med/S Opthamology Psychiatry Long-term Care Physical Therap Palliative Care Coronary Care 3 Payroll dollars $ 542,568 $ 227,927 $ 456,852 $ 4 Total Assets $ 807,052 $ 398,312 $ 393,907 $ 996,452 $ 525,458 $ 435,127 $ 512,475 $ 1,024,950 $ 624,239 $ 179,612 $ 125,132 $ 428,129 $ 415,091 $ 450,316 $ 1,248,478 $ 359,224 $ 250,264 $ 856,258 $ 830,182 $ 900,632 $ 5 Patient Days 703,617 $ 7,452 850,583 $ 181,217 $ 237,380 $ 849,170 $ 793,965 $ 724,377 $ 2,816 13,082 3,050 5,662 3,983 1,448 6 Employees 5 3 8 9 11 13 5 4 10 10 10 358,314 $ 716,628 $ 547,952 $ 1,581 9 546,974 $ 1,093,948 $ 1,041,184 $ 8,715 104,291 $ 267,706 $ 184,130 208,582 $ 535,412 $ 368,260 206,694 $ 4,000 492,682 $ 716 268,154 4,795 12 3 7 5 7 8 1. DIRECT METHOD TABLE 1 Emergency Labor & Surgery room delivery Intensive Care Radiology Gen Med Opthamology Psychiatry Long term Phy. Therapy Pal. Care Cor. Care Total care Number of 11 13 5 4 10 10 10 9 12 3 7 5 99 employees Payroll dollars $ $ $ $ $ $ $ $ $ $ $ $ $ 1,024,950.00 1,248,478.00 359,224.00 250,264.00 856,258.00 830,182.00 900,632.00 716,628.00 1,093,948.00 208,582.00 535,412.00 368,260.00 8,392,818.00 Patient days $ $ $ $ $ $ $ $ $ $ $ $ $ 7,452.00 2,816.00 13,082.00 3,050.00 5,662.00 3,983.00 1,448.00 1,581.00 8,715.00 4,000.00 716.00 4,795.00 57,300.00 Total assets $ $ $ $ $ $ $ $ $ $ $ $ $ 703,617.00 850,583.00 181,217.00 237,330.00 849,170.00 793,965.00 724,377.00 547,952.00 1,041,184.00 206,694.00 492,682.00 268,154.00 6,896,925.00 ALLOCATION: Cafeteria (# of $ $ $ $ $ $ $ $ $ $ $ $ $ employees) 110,716.89 130,847.23 50,325.86 40,260.69 100,651.72 100,651.72 100,651.72 90,586.55 120,782.06 30,195.52 70,456.20 50,325.86 996,452.00 Gen. Admin $ $ $ $ $ $ $ $ $ $ $ $ $ (Payroll $) 92,024.87 112,094.28 32,252.83 22,469.89 76,878.90 74,537.68 80,863.01 64,342.26 98,219.84 18,727.48 48,071.83 33,064.13 753,547.00 Housekeeping $ $ $ $ $ $ $ $ $ $ $ $ $ (patient days) 85,165.18 32,182.65 149,507.63 34,856.92 64,708.16 45,519.71 16,548.47 18,068.46 99,599.37 45,714.00 8,182.81 54,799.65 654,853.00 Maintenance (total assets) TOTAL $ $ $ $ $ $ $ $ $ $ $ $ $ 55,966.27 67,656.06 14,414.15 18,877.42 67,543.67 63,152.62 57,617.53 43,584.55 82,816.62 16,440.61 39,188.33 21,329.19 548,587.00 $ $ $ $ $ $ $ $ $ $ $ $ $ 343,873.20 342,780.22 246,500.47 116,464.92 309,782.45 283,861.73 255,680.73 216,581.81 401,417.89 111,077.60 165,899.16 159,518.83 2,953,439.00
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
SA-TIED YOUNG SCHOLARS PROGRAMME Young Scholars This paper was produced as a part of the SA-TIED Young Scholars' programme. The programme is a part of SATIED's capacity building initiatives, designed...
-
For the increasing marginal-extraction-cost model of the allocation of a depletable resource, how would the ultimate cumulative amount taken out of the ground be affected by (a) An increase in the...
-
In a survey of women in the United States (ages 20 29), the mean height was 64.2 inches with a standard deviation of 2.9 inches. (a) What height represents the 95th percentile? (b) What height...
-
Jane Kent is a licensed CPA. During the first month of operations of her business, the following events and transactions occurred. May 1 Kent invested $25,000 cash. 2 Hired a secretary-receptionist...
-
In a test of homogeneity, the alternate hypothesis says that the distributions in the rows are the same. In Exercises 68, determine whether the statement is true or false. If the statement is false,...
-
You are auditing the financial statements of a cosmetics distributor that sells thousands of individual items. The distributor keeps its inventory in its distribution center and in two public...
-
Cost of goods sold, inventory, and purchases budget Quinn Company sells mobile phones worldwide. The company begins January with $235,800 of inventory. It expects to sell 4,600 mobile phones for $160...
-
Q Describe the superheating process?
-
Kegler Bowling buys scorekeeping equipment with an invoice cost of $190,000. The electrical work required for the installation $19,200. Additional costs are $3,840 for delivery and $13,635 for sales...
-
Environmental friendly marketing indicates marketing of environment friendly products and services. What can we call such marketing strategies that create long term customer relationship along with...
-
Please correct the trial balance below. Debit Credit Buildings 10,400 Sales 9,980 Salaries payable 655 Bank Loan 3,100 Cash 215 Bank balance 1,240 Owner's equity 4,785 Purchases 2,670 Sales returns...
-
Journalize the following transactions for Blossom Company. (If no entry is required, select "No Entry" for the account titles and enter O for the amounts. Credit account titles are automatically...
-
Suppose that in year 20X1, taxpayer owes a deficiency of $11,000, a penalty of $3,000 and interest of $200. For year 20X2, taxpayer owes a deficiency of $20,000, a penalty of $5,000 and interest of...
-
1. Should Prostitution be Legalized 2: Problem Solving When faced with a problem, what do you do to solve it? Apply a six-step to problem solving process to a specific problem scenario. You will...
Study smarter with the SolutionInn App