Create an excel spreadsheet to allocate costs using the, Ask an Expert

Accounting

Create an Excel spreadsheet to allocate costs using the direct method and the step-down method. Use the results to answer questions about your findings.

Scenario: Texas Building Services has asked you to help it determine the best method for allocating costs from its service departments to its producing departments. Before the allocation, the four departments incurred costs of $4,100,000. $1,260,000 was deducted from facilities management and added it to the other three departments. There was no net effect on the total cost. In step 2 $660,000 was deducted from human resources and added to the remaining two departments. Total cost was unaffected. After allocation, all $4,100,000 remains, but it is all in the processing and assembly departments. Nothing is left in facilities management or human resources.

1.What are the total costs for the residential departments using the direct method? What are the total costs for the commercial department using the direct method?

2.What are the total costs for the residential department using the step-down method?

3.What are the total costs for the commercial department using the step-down method?

4.Which method would you recommend that Dallas Cleaning use to allocate its service departments' costs to its producing departments? Why?

View complete question

Accounting Basics, Accounting

Category:- Accounting Basics
Reference No.:- M9799080

Have any Question?Write your Review or question?

Related Questions in Accounting Basics

Question - the standards for one case of springfever tonic

Question - The standards for one case of Springfever Tonic are as follows: Direct materials 5.40 lb @ $ 4.40 /lb = $ 23.76 Direct labor 4.40 hr @ $ 12.30 /hr = $ 54.12 Variable overhead (based on direct labor hours) 4.40 ...

Question - on january 1 revis consulting entered into a

Question - On January 1, Revis Consulting entered into a contract to to create cost reduction program for Green Financial over a six-month period. Revis will receive $60,800 from Green at the end of each month. If total ...

Question - this needed to be solved likedirect materials

Question - This needed to be solved like Direct materials Inventory beginning balance- $184 Direct materials purchased- $640 Direct materials used- $675 Total Manufacturing overhead costs- $788 Variable manufacturing ove ...

Question - what are the steps for finding the rate of

Question - What are the steps for finding the rate of return stock is $26.1 a share. Dividend is increased by 8 percent annually and the next dividend is expected to be $1.8.

Question - from the information below bank reconciliation

Question - From the information below, bank reconciliation for the month of January 2015. (a) January 31, 2015 cash balance per book for the company is $35,342.02 (b) Bank statement balance at January 31, 2015 is $33,017 ...

Questions -q1 during 2017 remy paid the following expenses

Questions - Q1. During 2017, Remy paid the following expenses: Prescription medicines $640 Aspirin, vitamins, and cold medicine 165 Hospital and treatment fees 1,050 Health insurance premiums 250 What is the total amount ...

Question - nuthatch corporation began its operations on

Question - Nuthatch Corporation began its operations on September 1 of the current year. Budgeted sales for the first three months of business-September, October, and November-are $245,000, $303,000, and $400,000, respec ...

Question - carpenter inc had a balance of 80000 in its

Question - Carpenter Inc. had a balance of $80,000 in its quality-assurance warranty liability account as of December 31, 2015. In 2016, Carpenter's warranty expenditures were $445,000. Its warranty expense is calculated ...

Question - oriole company manufactures equipment orioles

Question - Oriole Company manufactures equipment. Oriole's products range from simple automated machinery to complex systems containing numerous components. Unit selling prices range from $200,000 to $1,500,000 and are q ...

Question 1what step in the accounting cycle do adjusting

Question: 1. What step in the accounting cycle do Adjusting Entries show up 2. How do these relate to the Accounting Worksheet? 3. Why are they completed at the end of each accounting period? The response must be typed, ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Accounting Basics Expert