Fiske Corporation manufactures a popular regional brand of kitchen utensils. The design and variety have been fairly constant over the last three years. The managers at Fiske are planning for some changes in the product line next year, but first they want to understand better the relation between activity and factory costs as experienced with the current products. Discussions with the plant supervisor suggest that overhead seems to vary with labor-hours, machine-hours, or both. The following data were collected from the last three years of operations: Quarter 1 2 3 4 5 6 7 8 9 10 11 12 Machine-Hours 18,850 18,590 17,480 19,240 21,280 19,630 19,240 18,850 18,460 20,670 17,550 18,460 Labor-Hours 14,905 15,477 16,720 15,983 17,501 17,369 Required A Required B 15,290 14,366 15,994 16,995 14,278 18,444 Factory costs $ 3,388,671 3,425,136 3,617,144 3,573,240 3,812,284 3,777,312 3,531,726 3,369,102 3,512,487 3,730,734 3,230,115 3,723,786 Required: a. Use the high-low method to estimate the fixed and variable porti of factory costs based on labor-hours. b. Managers expect the plant to operate at 20,000 labor-hours next quarter. Assuming the relationship remains the same with the new product line, what are the estimated quarterly factory costs? Complete this question by entering your answers in the tabs below. Managers expect the plant to operate at 20,000 labor-hours next quarter. Assuming the relationship remains the same with the new product line, what are the estimated quarterly factory costs? Note: Round "Variable cost" to 2 decimal places. Estimated quarterly factory costs < Required A Required B >

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter20: Activity-based Costing (abc)

Section: Chapter Questions

Problem 1R: Bumblebee Mobiles manufactures a line of cell phones. The management has identified the following...

See similar textbooks

Related questions

Question

Transcribed Image Text:Fiske Corporation manufactures a popular regional brand of kitchen utensils. The design and variety have been fairly constant over the last three years. The managers at Fiske are planning for some changes in the product line next year, but first they want to understand better the relation between activity and factory costs as experienced with the current products. Discussions with the plant supervisor suggest that overhead seems to vary with labor-hours, machine-hours, or both. The following data were collected from the last three years of operations: Quarter 1 2 3 4 5 6 89912 10 11 12 Machine-Hours 18,850 18,590 17,480 19,240 21,280 19,630 19,240 18,850 18,460 20,670 17,550 18,460 Labor-Hours 14,905 15,477 16,720 15,983 17,501 17,369 15,290 14,366 Required A Required B 15,994 16,995 14,278 18,444 Required: a. Use the high-low method to estimate the fixed and variable portions of factory costs based on labor-hours. b. Managers expect the plant to operate at 20,000 labor-hours next quarter. Assuming the relationship remains the same with the new product line, what are the estimated quarterly factory costs? Factory costs $ 3,388,671 3,425, 136 3,617,144 3,573,240 3,812,284 3,777,312 3,531,726 3,369,102 3,512,487 3,730,734 3,230,115 3,723,786 Complete this question by entering your answers in the tabs below. Estimated quarterly factory costs Managers expect the plant to operate at 20,000 labor-hours next quarter. Assuming the relationship remains the same with the new product line, what are the estimated quarterly factory costs? Note: Round "Variable cost" to 2 decimal places. < Required A Required B >

Expert Solution

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Decision to Sell before or after additional processing

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.