Question

In: Accounting

Referring to the same problem as above, the County departments will utilize a total of 30,000...

Referring to the same problem as above, the County departments will utilize a total of 30,000 hours of service time, broken down according to the table below. How does the IT Department bill the $3,000,000 to each department (i.e. How much should each department be billed in order to cover the $3,000,000 IT costs?) (Again, format your answer in dollar amounts only. Do not use the dollar sign ($) or any commas.)

Department Hours of processing time used

Finance 12,000

Water 6,000

Police 2,000

Planning 10,000

TOTAL 30,000 Total amount to be billed$3,000,000

Solutions

Expert Solution

Billing for each service hour

= Budgeted Activity / Budgeted hours of service

= $3,000,000 / 30,000

= $ 100 per hour

Calculations A B C = A x B
Department Hours used Allocation rate Cost allocated
Finance          12,000 100           1,200,000
Water             6,000 100              600,000
Police             2,000 100              200,000
Planning          10,000 100           1,000,000
         30,000           3,000,000

Related Solutions

Referring to Problem 2 above, suppose the HTML file references ten very small objects on the...
Referring to Problem 2 above, suppose the HTML file references ten very small objects on the same server. Neglecting transmission time, how much time elapses with a. Non-persistent HTTP with no parallel TCP connections? b. Non-persistent HTTP with the browser configured for 3 parallel connections? c. Persistent HTTP? (Assume that pipelining is used.)
Problem 2 For the same list as above, sort the list in such a way where...
Problem 2 For the same list as above, sort the list in such a way where the first set of numbers are ascending even and the second set of numbers are ascending odd. Your output should look like the following: [ 2, 4, 6, … 1, 3, 5 .. ]. The list is A = [ 6, 9, 0, 4, 2, 8, 0, 0, 8, 5, 2, 1, 3, 20, -1 ]
Calculate interest on balances up to 30,000( 3.25% interest) and above 30,000(.25% interest). In this program,...
Calculate interest on balances up to 30,000( 3.25% interest) and above 30,000(.25% interest). In this program, we prompt the user for the balance and output the dividends earned. (example a 10,000 deposit earning 1.15% would earn 10,000*1.15%=$115) In this program we prompt the user for the anticipated balance and then output the dividends earned. What formula would you create if you prompt the user for the balance and then display dividends earned?(you can use variable constants, if then statements.
By the due date assigned, you will write the final 2 reports, referring to the departments...
By the due date assigned, you will write the final 2 reports, referring to the departments of Endocrinology and Neurology and use them as your script for your Week 5 Oral Report. Your writing section for this assignment will include 2 paragraphs for each department. In order to earn the maximum credit for the written report you need to incorporate at least 10 medical terms for each department, using them in a manner that demonstrates your knowledge of their meaning....
you will write 2 reports (referring to the departments of Dermatology and Cardiology) and use them...
you will write 2 reports (referring to the departments of Dermatology and Cardiology) and use them as your script for your Week 3 Oral Report. Your writing section for this assignment will include 2 paragraphs for each department. In order to earn the maximum credit for the written report you need to incorporate at least 10 medical terms for each department (a total of 20 terms for this assignment), using them in a manner that demonstrates your knowledge of their...
What are some explanations for a yield going above 100%? Referring specifically to a yield produced...
What are some explanations for a yield going above 100%? Referring specifically to a yield produced when re-using products from a previous experiment (re-using recovered NaI to produce CuI).
In two companies making the same product and with the same total sales and total expenses,...
In two companies making the same product and with the same total sales and total expenses, the contribution margin ratio will be higher in the company with a higher proportion of fixed expenses in its cost structure. True False
Following is the model for the above problem:
Question 2 options: Groovy Juice Mixers, Inc. Groovy Juice Mixers, Inc. mixes specialty drinks out of apple, guava, and papaya juices. Currently it has 1300, 700, and 600 gallons of each of these kinds of juices in inventory, respectively. Groovy currently has two products, Tropical Breeze and Guava Jive, which sell for $2.20 and $1.70 per gallon, respectively. Tropical Breeze is a mixture of all three ingredients that consists of 20% to 25% guava juice, and also 20% to 25%...
The total wage expense for Lake Co. was $152,000. Of this​ total, $26,000 was above the...
The total wage expense for Lake Co. was $152,000. Of this​ total, $26,000 was above the OASDI wage base limit and not subject to this tax. All earnings are subject to Medicare​ taxes, and $64,000 was above the federal and state unemployment wage base limits and not subject to unemployment taxes. Please calculate and journalize the total payroll tax expense for Lake Co. given the following rates and wage base​ limits: a. FICA tax​ rate: OASDI, 6.2​% with a wage...
Most healthcare focused departments utilize technology for data collection, storage, analysis, and reporting of information. For...
Most healthcare focused departments utilize technology for data collection, storage, analysis, and reporting of information. For this assignment, select a healthcare organization or hospital department and Describe the organization or hospital department. Identify types of information collected, including format and approximate volume. Compare and contrast three data storage or databases used by the department. Identify and describe at least three communication technologies (for example a VPN) and how they are used in your selected organization or department. Identify and describe...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT