Question

Sarah’s Book and Tea Boutique has 2 Service Departments, Warehouse and Data Centre. Warehouse Department costs...

Sarah’s Book and Tea Boutique has 2 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

Production Departments

Warehouse Department

Data Centre Department

Tea

Books

Budgeted costs

$175,000

$75,000

$125,000

$150,000

Budgeted warehouse-hours

NA

250

500

750

Number of computer hours

100

NA

400

500

Required:

  1. Using the Step-Down method, what amount of Warehouse Department cost will be allocated to Tea, if the service department with the highest percentage of interdepartmental support service is allocated 1st? (Round up)    (3 marks)

Warehouse

Data Centre

Tea

Books

TOTALS

  1. Using the Step-Down method, what amount of Data Centre Department cost will be allocated to Tea, if the service department with the highest percentage of interdepartmental support service is allocated 1st? (Round up)           

Warehouse

Data Centre

Tea

Books

TOTALS

Homework Answers

Answer #1

Answer :

(a) Amount of Warehouse Department cost will be allocated to Tea = $ 58333

Warehouse Data centre Tea Books
Budgeted cost $ 175000 $ 75000 $ 125000 $ 150000
Warehouse department cost allocated (250 ; 500 : 750) $ (175000) $ 29167 $ 58333 $ 87500

(b) amount of Data Centre Department cost will be allocated to Tea = $ 46296

Warehouse Data centre Tea Books
Budgeted cost $ 175000 $ 75000 $ 125000 $ 150000
Warehouse department cost allocated (250 ; 500 : 750) $ (175000) $ 29167 $ 58333 $ 87500
Total - $ 104167 $ 183333 $ 237500
Data centre cost allocated ( 400 : 500) $ (104167) $ 46296 $ 57871
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Goldfarb's Book and Music Store has two service departments, Warehouse and Data Center. Warehouse Department costs...
Goldfarb's Book and Music Store has two service departments, Warehouse and Data Center. Warehouse Department costs of $350,000 are allocated on the basis of budgeted warehouse-hours. Data Center Department costs of $150,000 are allocated based on the number of computer log-on hours. The costs of operating departments Music and Books are $250,000 and $300,000, respectively. Data on budgeted warehouse-hours and number of computer log-on hours are as follows: Support Departments Production Departments Warehouse Department Data Center Department Music Books Budgeted...
Goldfarb's Book and Music Store has two service departments, Warehouse and Data Center. Warehouse Department costs...
Goldfarb's Book and Music Store has two service departments, Warehouse and Data Center. Warehouse Department costs of $350,000 are allocated on the basis of budgeted warehouse-hours. Data Center Department costs of $150,000 are allocated based on the number of computer log-on hours. The costs of operating departments Music and Books are $250,000 and $300,000, respectively. Data on budgeted warehouse-hours and number of computer log-on hours are as follows: Support Departments Production Departments Warehouse Department Data Center Department Music Books Budgeted...
Goldfarb's Book and Music Store has two service departments, Warehouse and Data Center. Warehouse Department costs...
Goldfarb's Book and Music Store has two service departments, Warehouse and Data Center. Warehouse Department costs of $370,000 are allocated on the basis of budgeted warehouse-hours. Data Center Department costs of $200,000 are allocated based on the number of computer log-on hours. The costs of operating departments Music and Books are $142,500 and $171,000, respectively. Data on budgeted warehouse-hours and number of computer log-on hours are as follows: Production Support Departments Departments ​ Warehouse Department Data Center Department Music Books...
Betty's Book and Music Store has two service departments, Warehouse and Data Center. Warehouse Department costs...
Betty's Book and Music Store has two service departments, Warehouse and Data Center. Warehouse Department costs of $180,000 are allocated on the basis of budgeted warehouse-hours. Data Center 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 Production Departments Warehouse Department Data Center Department Music Books Costs...
Jake’s Battery Company has two service departments, Maintenance and Personnel. Maintenance Department costs of $160,000 are...
Jake’s Battery Company has two service departments, Maintenance and Personnel. Maintenance Department costs of $160,000 are allocated on the basis of budgeted maintenance-hours. Personnel Department costs of $40,000 are allocated based on the number of employees. The costs of operating departments A and B are $80,000 and $120,000, respectively. Data on budgeted maintenance-hours and number of employees are as follows: Support Departments Production Departments Maintenance Department Personnel Department A B Budgeted costs $160,000 $40,000 $80,000 $120,000 Budgeted maintenance-hours NA 400...
Hanung Corp has two service departments, Maintenance and Personnel. Maintenance Department costs of $300,000 are allocated...
Hanung Corp has two service departments, Maintenance and Personnel. Maintenance Department costs of $300,000 are allocated on the basis of budgeted maintenance-hours. Personnel Department costs of $170,000 are allocated based on the number of employees. The costs of operating departments A and B are $188,000 and $282,000, respectively. Data on budgeted maintenance-hours and number of employees are as follows: Production Support Departments Departments   Maintenance Department Personnel Department A B Budgeted costs $300,000 $170,000 $188,000 $282,000 Budgeted maintenance-hours NA 860 1280...
At the Spring Valley​ Company, the cost of the personnel department has always been charged to...
At the Spring Valley​ Company, the cost of the personnel department has always been charged to production departments based upon number of employees.​ Recently, opinions gathered from the department managers indicate that the number of new hires might be a better predictor of personnel costs. Total personnel department costs are $290,000. Department A B C Number of employees 65 260 250 Number of new hires 20 18 14 If the number of employees is considered the cost​ driver, what amount...
17. Hanung Corp has two service​ departments, Maintenance and Personnel. Maintenance Department costs of $ 340...
17. Hanung Corp has two service​ departments, Maintenance and Personnel. Maintenance Department costs of $ 340 comma 000$340,000 are allocated on the basis of budgeted maintenanceminus−hours. Personnel Department costs of $ 140 comma 000$140,000 are allocated based on the number of employees. The costs of operating departments A and B are $ 192 comma 000$192,000 and $ 288 comma 000$288,000​, respectively. Data on budgeted maintenanceminus−hours and number of employees are as​ follows:                                                                                                                     Support Departments Production Departments Maintenance Department Personnel Department...
Company “ABC” has two service departments. Maintenance and personnel. Maintenance Department cost pf $320,000 are allocated...
Company “ABC” has two service departments. Maintenance and personnel. Maintenance Department cost pf $320,000 are allocated on the basis of budgeted maintenance-hours. Personnel department costs of $80,000 are allocated based on the number of employees. The costs of operating departments A and B are $160,000 and $240,000 respectively. Data on budgeted maintenance-hours and number of employees: Support Departments Production Departments Maintenance Department Personnel Department A B Budgeted costs $320,000 $80,000 $160,000 $240,000 Budg maintenance-hrs NA 800 960 640 Number of...
Exercise 22-3 Service department expenses allocated to operating departments LO P2 Advertising department expenses of $75,000...
Exercise 22-3 Service department expenses allocated to operating departments LO P2 Advertising department expenses of $75,000 and purchasing department expenses of $58,300 of Cozy Bookstore are allocated to operating departments on the basis of dollar sales and purchase orders, respectively. Information about the allocation bases for the three operating departments follows.    Department Sales Purchase Orders Books $ 150,000 1,680 Magazines 84,000 945 Newspapers 66,000 875 Total $ 300,000 3,500    Complete the following table by allocating the expenses of...