Question

In: Accounting

Sheridan Publishing identified the following overhead activities, their respective costs, and their cost drivers to produce...

Sheridan Publishing identified the following overhead activities, their respective costs, and their cost drivers to produce the three types of textbooks the company publishes.

Type of Textbook
Activity (Cost) Cost Driver Deluxe Moderate Economy
Machine maintenance ($360,000) Number of machine hours 300 900 1,200
Setups ($640,000) Number of setups 30 15 5
Packing ($168,000) Number of cartons 15 35 55
Photo development ($680,000) Number of pictures 4,500 2,500 1,500

Deluxe textbooks are made with the finest-quality paper, six-color printing, and many photographs. Moderate texts are made with three colors and a few photographs spread throughout each chapter. Economy books are printed in black and white and include pictures only in chapter openings.


Required

  1. Sheridan currently allocates all overhead costs based on machine hours. The company produced the following number of books during the prior year:

Deluxe Moderate Economy
60,000 180,000 240,000

Determine the overhead cost per book for each book type.

  1. Determine the overhead cost per book, assuming that the volume-based allocation system described in Requirement a is replaced with an activity-based costing system.


(For all requirements, round your answers to 2 decimal places.)

Solutions

Expert Solution

1) Based on machine hours
total overhead cost
Machine maintenance 360,000
Setups 640,000
Packing 168,000
Photo Devlopment 680,000
total overhead cost 1,848,000
overhead rate = 1848000/(300+900+1200)
770
overhead cost per book
Deluxe Moderate Economy
overhead allocated
Deluxe 770*300 231000
Moderate 770*900 693000
Econmoy 770*1200 924000
total overhead allocated (a) 231000 693000 924000
books produced (b) 60,000 180,000 240,000
OH cost per book c=a/b 3.85 3.85 3.85
2) Based on ABC activity
activity rate total overhead
total cost activity rate per activity
Machine maintenance 360,000 2400 150 per machine hour
Setups 640,000 50 12800 per setup
Packing 168,000 105 1600 per cartons
Photo Devlopment 680,000 8500 80 per picture
total overhead cost 1,848,000
overhead allocation
Deluxe Moderate Economy
Machine maintenance 45000 135000 180000
Setups 384000 192000 64000
Packing 24000 56000 88000
Photo Devlopment 360000 200000 120000
total overhead allocated 813000 583000 452000
books produced 60,000 180,000 240,000
OH cost per book 13.55 3.24 1.88

Related Solutions

Grass Inc. identified the following overhead activities, their respective costs, and their cost drivers to produce...
Grass Inc. identified the following overhead activities, their respective costs, and their cost drivers to produce the three types of lawn mowerss Type of Mowers   Activity (Cost) Cost Driver Deluxe Moderate Economy   Machine maintenance ($545,600)   Number of machine hours 220 780 1,200   Setups ($416,000)   Number of setups 29 13 6   Quality control ($203,322)   Number of inspections 15 34 45   Rent ($408,100)   Number of square feet 420 180 110 The company produced the following number of lawn mowers during the prior...
DAB Company has identified the following overhead activities, costs, and activity drivers for the coming year:...
DAB Company has identified the following overhead activities, costs, and activity drivers for the coming year: Activity                                Expected Cost          Activity Driver               Activity Capacity Material-handling costs.. £45,000             Number of moves.........        450 Machine costs................ £80,000             Machine hours.............. 20,000 Order costs.................... £15,000             Number of orders.........        750 Receiving costs.............. £30,000             Number of parts........... 50,000 Setup costs.................... £50,000             Number of setups.........        250 Assume that each activity corresponds to a process. DAB’s normal activity is 5,000 direct labor hours. The following two jobs...
5) A company has identified the following overhead costs and cost drivers for the coming year:...
5) A company has identified the following overhead costs and cost drivers for the coming year: Overhead Item Cost Driver Budgeted Cost Budgeted Activity Level Machine setup Number of setups $ 20,000 200 Inspection Number of inspections 130,000 6,500 Material handling Number of material moves 80,000 8,000 Engineering Engineering hours 50,000 1,000 Total $280,000 The following information was collected on three jobs that were completed during the year: Job 101 Job 102 Job 103 Direct materials $5,000 $12,000 $8,000 Direct...
Orange, Inc. has identified the following cost drivers for its expected overhead costs for the year:...
Orange, Inc. has identified the following cost drivers for its expected overhead costs for the year: Total overhead budgeted = $200,000 Total direct labor hours budgeted = 2,000 hours Actual direct labor hours worked on Job 21 = 100 Actual direct materials = $5,000 total Actual direct labor = $3,000 total Actual units completed = 100 The totoal cost of Job 21 is: a. $ 22,500 b. $ 16,000 c. $ 18,000 d. $ 19,900 The Total Cost of Job...
This question has 3 parts. Thank you. 1 A PB Publishing identified the following overhead activities,...
This question has 3 parts. Thank you. 1 A PB Publishing identified the following overhead activities, their respective costs, and their cost drivers to produce the three types of textbooks the company publishes. Type of Textbook Activity (Cost) Cost Driver Deluxe Moderate Economy Machine maintenance ($300,000) Number of machine hours 250 750 1,000 Setups ($760,000) Number of setups 40 35 5 Packing ($192,000) Number of cartons 20 40 60 Photo development ($448,000) Number of pictures 3,500 1,500 2,000 Deluxe textbooks...
Xie Company identified the following activities, costs, and activity drivers for this year. The company manufactures...
Xie Company identified the following activities, costs, and activity drivers for this year. The company manufactures two types of go-karts: Deluxe and Basic. Activity Expected Costs Expected Activity Handling materials $ 710,000 100,000 parts Inspecting product 985,000 1,500 batches Processing purchase orders 190,000 700 orders Paying suppliers 260,000 500 invoices Insuring the factory 385,000 40,000 square feet Designing packaging 160,000 2 models Assume that the following information is available for the company’s two products for the first quarter of this...
Xie Company identified the following activities, costs, and activity drivers for this year. The company manufactures...
Xie Company identified the following activities, costs, and activity drivers for this year. The company manufactures two types of go-karts: Deluxe and Basic. Activity Expected Costs Expected Activity Handling materials $ 675,000 100,000 parts Inspecting product 950,000 1,500 batches Processing purchase orders 155,000 700 orders Paying suppliers 225,000 500 invoices Insuring the factory 350,000 40,000 square feet Designing packaging 125,000 2 models     Required: 1. Compute a single plantwide overhead rate for the year, assuming that the company assigns overhead...
Xie Company identified the following activities, costs, and activity drivers for 2015. The company manufactures two...
Xie Company identified the following activities, costs, and activity drivers for 2015. The company manufactures two types of go-karts: Deluxe and Basic.        Activity Expected Costs Expected Activity   Handling materials $ 625,000      100,000 parts   Inspecting product 900,000      1,500 batches   Processing purchase orders 105,000      700 orders   Paying suppliers 175,000      500 invoices   Insuring the factory 300,000      40,000 square feet   Designing packaging   75,000    2 models Assume that the following information is available for the company’s two products...
Xie Company identified the following activities, costs, and activity drivers for 2017. The company manufactures two...
Xie Company identified the following activities, costs, and activity drivers for 2017. The company manufactures two types of go-karts: Deluxe and Basic. Activity Expected Costs Expected Activity Handling materials $ 625,000 100,000 parts Inspecting product 900,000 1,500 batches Processing purchase orders 105,000 700 orders Paying suppliers 175,000 500 invoices Insuring the factory 300,000 40,000 square feet Designing packaging 75,000 2 models Assume that the following information is available for the company’s two products for the first quarter of 2017. Deluxe...
Fischer Company identified the following activities, costs, and activity drivers: Activity Expected Costs Expected Activity Handling...
Fischer Company identified the following activities, costs, and activity drivers: Activity Expected Costs Expected Activity Handling Parts 425,000 25,00 parts in stock Inspecting Parts 390,000 940 batches Processing Purchase Orders 220,000 440 orders Designing Packaging 230,000 5 models a. Compute a plantwide overhead rate assuming the company assigns overhead based on 70,000 budgeted direct labor hours (Round to two decimals). b. Compute separate rates for each of the four activities using the activity-based costing.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT