Valves (24% of company revenues) were created from four brass components. Scott
ID: 2339033 • Letter: V
Question
Valves (24% of company revenues) were created from four brass components. Scott had designed machines that held each component in jigs while it was machined automatically. Each machinist could operate two machines and assemble the valves as machining was taking place. The expense of precise machining made the cost of Destin's valves too high to compete in the nonspecialized valve market, so all monthly production of valves took place in a single production run, which was immediately shipped to its single customer upon completion. Although Scott felt several competitors could match Destin's quality in valves, none had tried to gain market share by cutting price, and gross margins had been maintained at a standard 35%.
Pumps (55% of revenues) were created by a manufacturing process that was practically the same as that for valves. Five components required machining and assembly. The pumps were then shipped to each of seven industrial product distributors on a monthly basis. To supply the distributors, whose orders were fairly stable as long as Destin would meet competitive prices, the company scheduled five production runs each month. Pump prices to distributors had been under considerable pressure. The pump market was large, and specifications were less precise than those for valves. Recently, it seemed as if each month brought new reports of reduced prices for pumps. Steve Abbott felt Destin had no choice but to match the lower prices or give up its place as a supplier of pumps. As a result, gross margins on pumps sales in the latest month had fallen to 22%, well below the company's planned gross margin of 35%. Guidry and Alford could not see how the competitors could be making profits at current prices unless pumps were being subsidized by other products.
Flow controllers (21% of revenues) were used to control the rate and direction of flow of liquids. As with pumps, the manufacturing operations required for flow controllers were similar to those for valves. More components were needed for each finished unit, and more labor was required. In recent months, Destin had manufactured 4,000 flow controllers in 10 production runs, and the finished flow controllers had been distributed in 22 shipments to distributors and other customers. Steve Abbott was trying to understand the market for flow controllers better because it seemed to him that Destin had almost no competition in the flow controller market. He had recently raised flow controller prices by 122% with no apparent effect on demand.
Below is the Monthly Overhead Cost Activity Analysis created by the company:
Below is also additional information created by the company:
1. Use the Overhead Cost Activity Analysis in Exhibit 5 and other data on manufacturing costs to estimate product costs for valves, pumps, and flow controllers.
Exhibit 5 Monthly Overhead Cost Activity Analysis Valves Pumps Flow Controllers Receiving and Materials Handling 4 transactions (396) 4 transactions (3%) 25 transactions (19%) 25 transactions (19%) 100 transactions (78%) 100 transactions (78%) Receive each component once per run Handle each component once per run Packing and Shipping 1 transaction (396) 7 transactions (23%) 22 transactions (73%) One packing order per shipment Engineering Estimated engineering work-order percentage (subjective) Maintenance: 20% 30% 50% 3,750 hours (35%) 6,250 hours (58%) 800 hours (7%) Machine-hour basisExplanation / Answer
ALLOCATION OF COMMON MANUFACTURING OVERHEAD COST Valves Pumps Flow controller Total A Receiving (allocation pecentage) 3% 19% 78% 100% B=20000*A Receiving (Amount) $ 600 $ 3,800 $ 15,600 $20,000 C Material handling(allocation percentage) 3% 19% 78% 100% D=200000*C Material handling(Amount)) $ 6,000 $ 38,000 $ 156,000 $200,000 E Engineering(allocation percentage) 20% 30% 50% 100% F=100000*E Engineering(Amount) $ 20,000 $ 30,000 $ 50,000 $100,000 G Pakaging and shipping(allocation percentage) 3.33% 23.33% 73.33% 100% H=60000*G Pakaging and shipping(Amount)) $ 2,000 $ 14,000 $ 44,000 $60,000 I Maintenance(Allocation percentage) 35% 58% 7% 100% J=30000*I Maintenance(Amount)) $ 10,500 $ 17,400 $ 2,100 $30,000 K=B+D+F+H+J Total $ 39,100 $ 103,200 $ 267,700 $ 410,000 L Total Production in units(monthly) 7500 12500 4000 M=K/L Allocated cost per unit $ 5.21 $ 8.26 $ 66.93 N Machine usage per unit(hour) 0.5 0.5 0.2 P=N*25 Depreciation cost per unit $ 12.50 $ 12.50 $ 5.00 Q=M+P Total manufacturing overhead cost per unit $ 17.71 $ 20.76 $ 71.93 CALCULATION OF PRODUCT COST Valves Pumps Flow controller R Material cost per unit $16 $20 $22 S Number of production run per month 1 5 10 T Set up labor hour per run 8 8 12 U=S*T Set up labor hour per month 8 40 120 V=U*16 Set up labor cost per month $ 128 $ 640 $ 1,920 W=V/L Set up labor cost per unit $ 0.02 $ 0.05 $ 0.48 X Run Labor hour per unit 0.25 0.5 0.4 Y=X*16 Run labor cost per unit $ 4.00 $ 8.00 $ 6.40 Z=W+Y Direct labor cost per unit $ 4.02 $ 8.05 $ 6.88 Q Manufacturing overhead cost per unit $ 17.71 $ 20.76 $ 71.93 PC=R+Z+Q PRODUCT COST PER UNIT $37.73 $48.81 $100.81
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.