Part C | |||||||
Calculation of total Contribution margin under activity based costing method: | |||||||
Expense | Cost driver | Total cost ($) |
Annual activity per cost driver |
Cost per unit ($) | |||
Procurement | No. of parts | 840,000 | 5,084,100 | 0.17 | |||
Production scheduling | No. of boards | 460,000 | 118,650 | 3.88 | |||
Packaging and shipping | No. of boards | 920,000 | 118,650 | 7.75 | |||
Machine setup | No. of setups | 908,000 | 283,500 | 3.20 | |||
Hazardous waste disposal | Pounds of waste | 104,000 | 32,067 | 3.24 | |||
Quality control | No. of inspections | 1,144,000 | 283,500 | 4.04 | |||
General supplies | No. of boards | 144,000 | 118,650 | 1.21 | |||
Machine insertion | No. of parts | 2,600,000 | 3,681,000 | 0.71 | |||
Manual insertion | No. of parts | 8,400,000 | 1,310,000 | 6.41 | |||
Wave-soldering | No. of boards | 284,000 | 118,650 | 2.39 | |||
Calculation of total Contribution margin under activity based costing method: | |||||||
PC Board | TV Board | ||||||
Number of boards to be sold | (a) | 44,000 | 69,000 | ||||
Price per unit | (b) | 750 | 430 | ||||
Total revenue | (c ) = (a)*(b) | 33,000,000 | 29,670,000 | ||||
PC Board | TV Board | ||||||
Variable costs | Per unit | Total | Per unit | Total | |||
Direct Material Cost | (Per unit cost*No. of boards) | 223.00 | 9,812,000 | 143.00 | 9,867,000 | ||
Procurement | |||||||
Parts required per unit | 63 | 30 | |||||
Total parts required | (Parts required per unit*Total boards) | 2,772,000 | 2,070,000 | ||||
Procurement cost | (Total parts required*cost per unit) | 0.17 | 457,993 | 0.17 | 342,007 | ||
Production scheduling | (Number of boards*cost per unit) | 3.88 | 170,586 | 3.88 | 267,509 | ||
Packaging and shipping | (Number of boards*cost per unit) | 7.75 | 341,172 | 7.75 | 535,019 | ||
Machine setup | |||||||
Number of setups required per unit | 3 | 2 | |||||
Total setups required | (Setup per unit*Total boards) | 132,000 | 138,000 | ||||
Setup cost | (Total setups required*cost per unit) | 3.20 | 422,772 | 3.20 | 441,989 | ||
Hazardous waste disposal | |||||||
Waste disposed per unit | 0.60 | 0.06 | |||||
Total waste disposed | (waste disposed per unit*Total boards) | 26,400 | 4,140 | ||||
Disposal cost | (Total waste disposed*cost per unit) | 3.24 | 85,621 | 3.24 | 13,427 | ||
Quality control | |||||||
Number of inspections required per unit | 3 | 2 | |||||
Total inspections required | (Inspections per unit*Total boards) | 132,000 | 138,000 | ||||
Setup cost | (Total inspections required*cost per unit) | 4.04 | 532,656 | 4.04 | 556,868 | ||
General supplies | (Number of boards*cost per unit) | 1.21 | 53,401 | 1.21 | 83,742 | ||
Machine insertion | |||||||
Machine Insertions per unit | 40 | 29 | |||||
Total insertions required | (Machine insertions per unit*Total boards) | 1,760,000 | 2,001,000 | ||||
Machine Insertion cost | (Total insertions required*cost per unit) | 0.71 | 1,243,140 | 0.71 | 1,413,366 | ||
Manual insertion | |||||||
Manual Insertions per unit | 23 | 1 | |||||
Total insertions required | (Manual insertions per unit*Total boards) | 1,012,000 | 69,000 | ||||
Manual Insertion cost | (Total insertions required*cost per unit) | 6.41 | 6,489,160 | 6.41 | 442,443 | ||
Wave-soldering | (Number of boards*cost per unit) | 2.39 | 105,318 | 2.39 | 165,158 | ||
Total Variable costs | (d) | 19,713,819 | 14,128,529 | ||||
Contribution margin | (e) = ( c) - (d) | 13,286,181 | 15,541,471 | ||||
Manchester Technology, Inc. manufactures several different types of printed circuit boards; however, two of the boards...
Activity-based-costing! Manchester Technology, Inc. manufactures several different types of printed circuit boards; however, two of the boards account for the majority of the company's sales. The first of these boards, a television circuit board, has been a standard in the industry for several years. The market for this type of board is competitive and price-sensitive. Manchester plans to sell 69,000 of the TV boards in 20x1 at a price of $430 per unit. The second high-volume product a personal computer...
Manchester Technology, Inc. manufactures several different types of printed circuit boards; however, two of the boards account for the majority of the company’s sales. The first of these boards, a television circuit board, has been a standard in the industry for several years. The market for this type of board is competitive and price-sensitive. Manchester plans to sell 69,000 of the TV boards in 20x1 at a price of $430 per unit. The second high-volume product, a personal computer circuit...
Manchester Technology, Inc, manufactures several different types of printed circuit boards; however, two of the boards account for the majority of the company's sales. The first of these boards, a television circuit board, has been a standard in the industry for several years. The market for this type of board is competitive and price-sensitive. Manchester plans to sell 83,000 of the TV boards in 20x1 at a price of $490 per unit. The second high-volume product, a personal computer circuit...
Ultratech, Inc., manufactures several different types of printed circuit boards; however, two of the boards account for the majority of the company’s sales. The first of these boards, a television circuit board, has been a standard in the industry for several years. The market for this type of board is competitive and price-sensitive. Ultratech plans to sell 79,000 of the TV boards in 20x4 at a price of $450 per unit. The second high-volume product, a personal computer circuit board,...
Ultratech, Inc., manufactures several different types of printed circuit boards; however, two of the boards account for the majority of the company’s sales. The first of these boards, a television circuit board, has been a standard in the industry for several years. The market for this type of board is competitive and price-sensitive. Ultratech plans to sell 79,000 of the TV boards in 20x4 at a price of $450 per unit. The second high-volume product, a personal computer circuit board,...
3. Using activity-based costing, calculate the total amount that each of the two product lines will contribute toward covering fixed costs and profit in 20x1. Manchester Technology, Inc. manufactures several different types of printed circuit boards; however, two of the boards account for the majority of the company's sales. The first of these boards, a television circuit board, has been a standard in the industry for several years. The market for this type of board is competitive and price-sensitive. Manchester...
Mancnester lec n nology, inc. manuractures several aITe rent types от printea circuit Doaras; nowever, two oT tne oaras account Tor tne majority of the company's sales. The first of these boards, a television circuit board, has been a standard in the industry for several years. The market for this type of board is competitive and price-sensitive. Manchester plans to sell 85,000 of the TV boards in 20x1 at a price of $510 per unit. The second high-volume product, a...
Mancnester lec n nology, inc. manuractures several aITe rent types от printea circuit Doaras; nowever, two oT tne oaras account Tor tne majority of the company's sales. The first of these boards, a television circuit board, has been a standard in the industry for several years. The market for this type of board is competitive and price-sensitive. Manchester plans to sell 85,000 of the TV boards in 20x1 at a price of $510 per unit. The second high-volume product, a...
Please help for question 2 & 3 I was able to answer question #1. Ultratech, Inc., manufactures several different types of printed circuit boards; however, two of the boards account for the majority of the company’s sales. The first of these boards, a television circuit board, has been a standard in the industry for several years. The market for this type of board is competitive and price-sensitive. Ultratech plans to sell 79,000 of the TV boards in 20x4 at a...
QUESTION FOUR QUESTION FOUR (continued) Jinko Pty Ltd produces circuit boards used in alarm systems. They are in the process of determining the costs and selling prices of three of their main circuit boards: Advanced, Boosted and Customised, for the month of September. It has been established that Jinko will sell 3,000 units of Advanced, 1,000 units of Boosted and 500 units of Customised. Planned activity for cost driver Cost Driver Budgeted Overhead Costs Machine related overhead Machine setup Machine...