chap4demo - Name: Date: Instructor: Course: Managerial...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
FileName: ae5a6cdf9ff84bc86b9160d55feffd73af395f22.xls, Tab: Chapter 4 Demo, Page 1 of 3, 12/03/2009, 07:03:53 Name: Date: Instructor: Course: Activity Cost Pools Estimated overhead Purchasing $240,000 Processing (weighing and mixing, grinding, thinning and drying, straining) 1,400,000 Packaging (quarts, gallons, and 5-gal) 580,000 Testing 240,000 Storage and inventory control 180,000 Washing and cleaning equipment 560,000 Total annual budgeted overhead $3,200,000 Following further analysis, activity cost drivers were identified and their expected use by product and activity were scheduled as follows. Activity Cost Pool Cost Drivers Oil-based Latex Purchasing Purchase orders 1,500 orders 800 700 Processing Gallons processed 1,000,000 gallons 400,000 600,000 Packaging Containers filled 400,000 containers 180,000 220,000 Testing Number of tests 4,000 tests 2,100 1,900 Storing Avg. gals on hand 18,000 gallons 10,400 7,600 Washing Number of batches 800 batches 350 450 Spreadwell has budgeted 400,000 gallons of oil-based paint and 600,000 gallons of latex paint for processing during the year. Instructions: SPREADWELL PAINT COMPANY Activity Cost Pools Estimated Overhead Purchasing Amount Amount Label Formula Label Processing Amount Amount Label Formula Label Packaging Amount Amount Label Formula Label Testing Amount Amount Label Formula Label Storing Amount Amount Label Formula Label Washing Amount Amount Label Formula Label Formula SPREADWELL PAINT COMPANY Activity Cost Pools Label Amount Amount Formula Amount Amount Formula
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

chap4demo - Name: Date: Instructor: Course: Managerial...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online