Assignment # 1 Whitman Printing Ltd. has contracts to complete weekly supplements required by its' customers. For the current year, manufacturing overhead cost estimates total $336,000 for an annual production capacity of 12 million pages. Whitman Printing decided to evaluate the use of additional cost pools. After analyzing manufacturing overhead costs, it was determined that number of design changes, setups, and inspections are the primary manufacturing overhead cost drivers. The following information was gathered during the analysis: Manufacturing Cost pool overhead costs Activity level Design changes $ 60,000 200 design changes Setups 96,000 8,000 setups Inspections 180,000 12,000 inspections Total manufacturing overhead costs $336,000 Two customers, Money Managers and Hospital Systems, are expected to use the following printing services: Activity Money Managers Hospital Systems Pages 80,000 96,000 Design changes 10 0 Setups (one per job) 50 12 Inspections 40 12 Designs (one per job) 50 12 Pages are a direct cost at $0.03 per page. Design costs per job average of $1,000 and $1,200 for Money Managers and Hospital Systems, respectively. Whitman Printing sets prices at $0.10 per page plus 120% of design costs. Assume that all costs are variable. Required: Prepare income statements in contribution margin format for both customers using: a. Traditional (simple) costing with overhead applied on a page capacity basis b. Activity-based costing c. How much a page should Money Managers be charged if Whitman Printing wants to breakeven on this customer? Assume that manufacturing overhead costs are fixed and that they are allocated to customers based on pages sold as a percentage of production capacity; and, that design costs are also fixed.
Homework Answers
| a) Using traditional costing with overhead applied on page capacity basis | ||||
| Money managers | working | Hospital systems | working | |
| Sales | $ 68,000 | 80,000*0.10+120%*50*1000 | $ 26,880 | 96,000*0.10+120%*12*1200 |
| Variable costs | ||||
| Pages direct costs | $ 2,400 | 80,000*0.03 | $ 2,880 | 96,000*0.03 |
| Design costs | $ 50,000 | 50*1000 | $ 14,400 | 12*1200 |
| Total variable costs | $ 52,400 | $ 17,280 | ||
| Contribution margin | $ 15,600 | $ 9,600 | ||
| Fixed Manufacturing OH | $ 2,240 | (336,000/12,000,000)*80,000 | $ 2,688 | (336,000/12,000,000)*96,000 |
| Net income | $ 13,360 | $ 6,912 | ||
| b) Using Activity based costing | ||||
| Money managers | working | Hospital systems | working | |
| Sales | $ 68,000 | 80,000*0.10+120%*50*1000 | $ 26,880 | 96,000*0.10+120%*12*1200 |
| Variable costs | ||||
| Pages direct costs | $ 2,400 | 80,000*0.03 | $ 2,880 | 96,000*0.03 |
| Design costs | $ 50,000 | 50*1000 | $ 14,400 | 12*1200 |
| Total variable costs | $ 52,400 | $ 17,280 | ||
| Contribution margin | $ 15,600 | $ 9,600 | ||
| Fixed Manufacturing OH | ||||
| Design changes | $ 3,000 | 300*10 | $ - | 300*0 |
| Setups | $ 600 | 12*50 | $ 144 | 12*12 |
| Inspections | $ 600 | 15*40 | $ 180 | 15*12 |
| Net income | $ 11,400 | $ 9,276 | ||
| Activity | Cost pool | Volume of driver | ABC rate | |
| Design changes | $ 60,000 | 200 | $ 300 | |
| Setups | $ 96,000 | 8,000 | $ 12 | |
| Inspections | $ 1,80,000 | 12,000 | $ 15 | |
| c) | ||||
| Money managers | working | |||
| Manufacturing OH | $ 2,240 | (80,000/12,000,0000)*336,000 | ||
| Design costs | $ 50,000 | 50*1000 | ||
| Total Fixed costs | $ 52,240 | A | ||
| Variable costs | ||||
| Pages direct costs | $ 2,400 | 80,000*0.03 | ||
| Total Variable costs | $ 2,400 | B | ||
| Total costs to be recovered | $ 54,640 | A + B | ||
|
Know the answer?
Add Answer to:
|
Corp. has contracts to complete weekly supplements required by forty-six customers. For the year 2018, manufacturing overhead cost estimates total $900,000 for an annual production capacity of 10 million pages. For 2018, Xylon decided to evaluate the use of additional cost pools. After analyzing manufacturing overhead costs, it was determined that number of design changes, setups, and inspections are the primary manufacturing overhead cost drivers. The following information was gathered during the analysis: Cost pool Manufacturing overhead costs Design changes...
Velshi Printers has contracts to complete weekly supplements required by forty-six customers. For the year 2018, manufacturing overhead cost estimates total $1,500,000 for an annual production capacity For 2018 Velshi Printers has decided to evaluate the use of additional cost pools. After analyzing manufacturing overhead costs, it was determined that number of design changes, setups, and inspections are the primary manufacturing overhead cost drivers. The following information was gathered during the analysis: Cost pool Manufacturing overhead costs Design changes $100,000...
wed Score: 0 of 10 pts 8 of 10 (6 complete) 5.5-29a Question Help Velshi Printers has contracts to complete weekly supplements required by forty-six customers. For the year 2018, manufacturing overhead cost estimates total $2,700,000 for an annual production capacity of 18 million pages. For 2018 Velshi Printers has decided to evaluate the use of additional cost pools. After analyzing manufacturing overhead costs, it was determined that number of design changes, setups, and inspections are the primary manufacturing overhead...
1. Milton Manufacturing has three departments (or activities) in its manufacturing process: machine setups, machining, and inspections. Estimated annual overhead cost for each activity is $80,000, 162,500, and $28,000, respectively. The expected annual use for each activity is 1,000 setups, 12,500 machine hours, and 875 inspections Compute the overhead rate for each activity Machine Setups Machinin Inspections 2. Wilson Bradley & Associates, a law firm, uses Activity Based Costing for assigning overhead costs. The following budgeted data for each of...
For many years, Sinclair Graphic Design has provided design and digital printing services for indoor banners. The nylon banners, which come in a standard size, are used for a variety of purposes, including trade shows, sporting events, and other promotional activities. Three years ago, the company introduced a second printing and production service for outdoor banners that has become increasingly popular. The outdoor banners are a more complex product than the indoor banners, requiring weatherproof vinyl materials and a different...
Home Insert A Page Layout B С D G H Cause-and-Effect Relationship Between Allocation Base and Activity Cost Total Standard Job Special Job 400 200 $ 600 $ 750 $ 100 $ 125 $ 90 $ 100 10 10 $ 75,000 Indirect costs of operating printing machines increase with printing machine hours 7 1 2 Number of printing jobs 3 Price per job 4 Cost of supplies per job 5 Direct labor costs per job 6 Printing machine-hours per job...