Required informationTuscaloosa National Bank has two service departments, the Human Resources (HR) Department and the ComputingDepartment. The bank has two other departments that directly service customers, the Deposit Department and the LoanDepartment. The usage of the two service departments' output for the year is as follows:User of ServiceProvider of ServiceHRHRComputingDepositLoanComputing020%10%070%20%40%40%The budgeted costs in the two service departments for the year are as follows:HRComputing$ 162,000238,500Required:Use the step-down method to allocate the budgeted costs of the HR and Computing departments to the Deposit and Loandepartments. Tuscaloosa National Bank allocates the costs of the HR Department first.Note: Do not round intermediate calculations.

Step 1:Allocation of HR and Computing department costs to Deposit and Loan departments using…

Answered: Required information Tuscaloosa…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

PART 3 Betty's Book and Music Store has two service departments, Warehouse and Data Centre. Warehouse Department costs of $175,000 are allocated on the basis of budgeted warehouse-hours. Data Centre Department costs of $75,000 are allocated based on the number of computer log-on hours. The costs of operating departments Music and Books are $125,000 and $150,000, respectively. Data on budgeted warehouse-hours and number of computer log-on hours are as follows: Support Departments Warehouse Production Departments Department Data Centre Department Music Books Budgeted costs $175,000 $75,000 $125,000 $150,000 Budgeted warehouse- NA 250 500 750 hours Number of computer hours 100 ΝΑ 400 500 Required: 1. Assign the support department costs to the production departments using: a. The Direct Method (3) b. The Step-Down Method assigning the Warehouse Department first (4) c. The Reciprocal Method using linear equations. (4)
In Organizational Development (OD), each area of OD has its own budget to maintain. Please create a spreadsheet indicating the following purchases for the different OD areas and the remaining balance for each department based on the beginning budget and purchases as indicated. The Center for the Advancement of Teaching and Learning Beginning Budget $60,000 Speaker Books Speaker Gifts $2,000 100 @ $22.50 each $200.00 Leadership Development Beginning Budget $40,000 Retreat Location Rental Retreat Lunch Conference Awards $8,000 $11.00 each for 72 attendees $9,000 $8,800 Creative and Strategic Initiatives Beginning Budget $25,000 Camera Software Digital subscriptions $7,000 $2,000 $550.00
Finance
digital
How does the budgeting process translate long-term goals into operating objectives? Suppose Framecraft has an Information Processing Division that provides database management services for the professional photographers and artists who buy its frames. The division uses state-of-the-art equipment and employs five information specialists. Each specialist works an average of 160 hours a month. The division’s controller has com piled the following information: Actual Data for Past Year Forecasted Data for This Year November December January February March Client billings (sales) $25,000 $35,000 $25,000 $20,000 $40,000 Selling and administrative expenses 12,000 13,000 12,000 11,000 12,500 Operating supplies 2,500 3,500 2,500 2,500 4,000 Processing overhead 3,200 3,500 3,000 2,500 3,500 Of the client billings, 60 percent are cash sales collected during the month of sale, 30 per cent are collected in the first month following the sale, and 10 percent are collected in the second month…
Valley Trails is preparing the Cash Budget for the upcoming period, and is concerned about their ability to meet their financial obligations in the short term. Following is information relating to Valley’s financial performance: Beginning-of-period balances:Accounts Receivable: $135,000Accounts Payable: $67,500Accumulated Factory Depreciation: $720,000Cash: $33,750 Estimates for end-of-period balances:Accounts Receivable: $168,750Accounts Payable: $45,000Accumulated Factory Depreciation: $740,000 Budgeted activity levels for the period:Sales: $625,000Purchases of Direct Materials: $112,000Direct Labor Wages: $187,500Manufacturing Overhead: $62,500Selling and Administrative Expenses: $105,000 Except for purchases of direct materials, all expenses are paid as incurred. What is the budgeted ending cash balance for the period? Select one: a. None of these options are correct. b. $223,000 c. $191,750 d. $175,500 e. $155,500
Professional Fees Earned Budget Day & Spieth, CPAs, offer three types of services to clients: auditing, tax, and small business accounting. Based on experience and projected growth, the following billable hours have been estimated for the year ending March 31, 20Y6: Billable Hours Audit Department: Staff 28,100 Partners 4,200 Tax Department: Staff 21,100 Partners 2,600 Small Business Accounting Department: Staff 3,900 Partners 500 The average billing rate for staff is $110 per hour, and the average billing rate for partners is $230 per hour. Prepare a professional fees earned budget for Day & Spieth, CPAs, for the year ending March 31, 20Y6. DAY & SPIETH, CPAs Professional Fees Earned Budget For the Year Ending March 31, 20Y6 Billable Hours Hourly Rate Total Revenue Audit Department: Staff $ $ Partners Total $ Tax Department: Staff $ $ Partners Total $…
Perfect Parties, Inc. has several divisions, one of which provides birthday parties at their facility, and has provided the actual and planning budget results for the month of June. The Controller has asked you prepare the Birthday Party Division Budget Performance Report. Please provide me with the answers for the cells in yellow. greatly appreciate your help!
Activity-Based Budgeting (ABB) OFC Company of Kansas City prints business forms andother specialty paper products, such as writing paper, envelopes, note cards, and greeting cards. ItsBusiness Services division offers inventory management services and desktop delivery on request.The division uses an activity-based costing (ABC) system. The budgeted usage of each activity costdriver and cost-driver rates for January 2019 for the Business Services division are:Activity Cost Driver Budgeted Activity Cost-Driver RateStorage Cartons in inventory 400,000 $0.4925/carton/monthRequisition handling Requisitions 30,000 12.50Pick packing Lines 800,000 1.50Data entry Lines 800,000 0.80Requisitions 30,000 1.20Desktop delivery Per delivery 12,000 30.00For the month, the division expects to make 11,700 deliveries to deliver 1,170,000 cartons tocustomers.Required1. What is the total budgeted cost for each activity and for the Business Services division in January 2019?2. Assume, in contrast to…
Hudson Community College enrolls students in two departments, Liberal Arts and Sciences. The college also has two service departments, the Library and the Computing Services Department. The usage of these two service departments' output for the year is as follows: User of Service Library Computing Services Liberal Arts Sciences Provider of Service Computing Services 20% Library Computing Services Library 65% 35% The budgeted costs in the two service departments for the year are as follows: $1,090,000 550,000 30% 50% Required: 1. Use the step-down method to allocate Hudson Community College's service department costs to the Liberal Arts and Sciences departments. (Do not round intermediate calculations.) Allocation of Computing Service costs Allocation of Library costs Total costs allocated to each department Liberal Arts Sciences
Professional Labor Cost Budget for a Service Company Rollins and Cohen, CPAS, offer three types of services to clients: auditing, tax, and small business accounting. Based on experience and projected growth, the following billable hours have been estimated for the year ending December 31, 20Y7: Billable Hours Audit Department: Staff 37,500 Partners 5,600 Tax Department: Staff 27,400 Partners 3,400 Small Business Accounting Department: Staff 4,900 Partners 700 Based on the data provided above and assuming that the average compensation per hour for staff is $45 and for partners is $140, prepare a professional labor cost budget for each department for Rollins and Cohen, CPAS, for the year ending December 31, 20Y7. Rollins and Cohen, CPAS Professional Labor Cost Budget For the Year Ending December 31, 20Y7 Staff Partners Audit department hours Tax department hours Small business accounting department hours Total hours Average compensation per hour X $ Total professional labor cost $
13) Gotham University offers only high-tech graduate-level programs. Gotham has two principal operating departments, Engineering and Computer Sciences, and two support departments, Facility and Technology Maintenance and Enrollment Services. The base used to allocate facility and technology maintenance is budgeted total maintenance hours. The base used to allocate enrollment services is number of credit hours for a department. 13) The Facility and Technology Maintenance budget is $350,000, while the Enrollment Services budget is $950,000. The following chart summarizes budgeted amounts and allocation-base amounts used by each department: Services Provided: (Annually) Computer F&T Enrollment Budget Engineering Sciences Maintenance Service F&T Maintenance (in hours) $350,000 1,000 2,000 Zero 5,000 Enrollment Service (in credit hrs) $950,000 24,000 36,000 2,000 Zero Required: Prepare a schedule which allocates service department costs using the step-down method with the sequence of…

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS