A B D m Data Table 1 Month January 5 February 6 March 7 April 8 May 9 June 10 July 11 August 12 September 13 October 14 November 15 December 16 Totals 17 18 Labor Hours 1,262 962 1,318 1,280 942 1.188 1,114 1,006 1,344 1,196 760 792 13,164 Machine Hours 1,752 $ 1,362 $ 2,238 $ 2,205 $ 2,013 $ 2,205 $ 1,845 $ 1,773 $ 1,641 $ 1,971 $ 1.752 $ 2,229 $ 22,986 $ OH Costs 221,304 189,758 223,883 230,335 214,621 219,848 206,957 204,047 217.754 221,287 194,962 198,559 2,543,313 Units Mfg'd 5,256 4,086 6,714 6,615 5,652 6,615 5,535 5,319 4,923 5,913 4,560 4.752 65,940 19 Questions C G Menu + This will bring plot will upda trendline you $ $ $ $ 74.25 19.25 14.25 350.000 21% With this tech 26 Use Data Table 1 to answer the following Questions 28 The following assumptions apply unless an alternative is specifically given in a question 29) The Sales Price per unit 0 19 Direct materials and direct labor costs per unit, 31 ) Variable General and Administrative costs per unit. x ) Fixed General and Administrative costs per month 33 ) Marginal tax rate on Income 35 Part 1 Answer these questions by applying the high-low method Assume that the 16 Overhead costs are estimated using labor hours What is the estimated variable cost per labor hour? a. What is the estimated monthly fixed overhead cost? A Forecast monthly overhead costs for a month when labor hours are equal to 14 01 02 41 1.100 Q3 G 03 B 1.100 04 05 45 08 Forecast monthly overhead costs for a month when labor hours are equal to What is the average number of labor hours per unit? What is your estimate of the variable overhead cost per unit? - What is your estimate of the contribution margin per unit? So What is your estimate of total fixed cost per month? 2. What is your estimate of total fixed cost per year? How many units are required to break-even? 07 Q 53 09 5 750,000 010 Se How many units are required to earn an annual before tax profit equal to 5 750,000 011 What is the after tax profit required to com a before tax profit of G Q11 Q12 013 014 E What is the after tax profit required to earn a before tax profit of $ 750,000 60 How many units are required to eam an annual after tax profit equal to $ 750,000 1 What is the before tax profit if the number of units manufactured and sold is 150,000 What is the before tax profit if the number of units manufactured and sold is 180.000 What is the before tax profit if the number of units manufactured and sold is 210,000 - Part 2 In order to complete the remaining questions use the regression capabilities of Excel to estimate the following cost equation Monthly OH b0b1 x labor hours + b2 x machine hours 2: Bated on the results, what is the estimate of monthly fixed manufacturing OH costs? 7 What is the estimate of variable OH costs per labor hour? 3 1 What is the estimate of vonable OH costs per machine hour? 015 10 016 017 Q18 Q17 Q18 What is the estimate of variable OH costs per labor hour? + What is the estimate of variable OH costs per machine hour? 7 What are the estimated total OH costs for an average month based on the cost model? - if output where 10% higher than average what is your estimate of total Mfg OH Costa? 11 If output where 15% higher than average what is your estimate of the contribution margin per unit? 019 78 020 NO 021 2 A B D m Data Table 1 Month January 5 February 6 March 7 April 8 May 9 June 10 July 11 August 12 September 13 October 14 November 15 December 16 Totals 17 18 Labor Hours 1,262 962 1,318 1,280 942 1.188 1,114 1,006 1,344 1,196 760 792 13,164 Machine Hours 1,752 $ 1,362 $ 2,238 $ 2,205 $ 2,013 $ 2,205 $ 1,845 $ 1,773 $ 1,641 $ 1,971 $ 1.752 $ 2,229 $ 22,986 $ OH Costs 221,304 189,758 223,883 230,335 214,621 219,848 206,957 204,047 217.754 221,287 194,962 198,559 2,543,313 Units Mfg'd 5,256 4,086 6,714 6,615 5,652 6,615 5,535 5,319 4,923 5,913 4,560 4.752 65,940 19 Questions C G Menu + This will bring plot will upda trendline you $ $ $ $ 74.25 19.25 14.25 350.000 21% With this tech 26 Use Data Table 1 to answer the following Questions 28 The following assumptions apply unless an alternative is specifically given in a question 29) The Sales Price per unit 0 19 Direct materials and direct labor costs per unit, 31 ) Variable General and Administrative costs per unit. x ) Fixed General and Administrative costs per month 33 ) Marginal tax rate on Income 35 Part 1 Answer these questions by applying the high-low method Assume that the 16 Overhead costs are estimated using labor hours What is the estimated variable cost per labor hour? a. What is the estimated monthly fixed overhead cost? A Forecast monthly overhead costs for a month when labor hours are equal to 14 01 02 41 1.100 Q3 G 03 B 1.100 04 05 45 08 Forecast monthly overhead costs for a month when labor hours are equal to What is the average number of labor hours per unit? What is your estimate of the variable overhead cost per unit? - What is your estimate of the contribution margin per unit? So What is your estimate of total fixed cost per month? 2. What is your estimate of total fixed cost per year? How many units are required to break-even? 07 Q 53 09 5 750,000 010 Se How many units are required to earn an annual before tax profit equal to 5 750,000 011 What is the after tax profit required to com a before tax profit of G Q11 Q12 013 014 E What is the after tax profit required to earn a before tax profit of $ 750,000 60 How many units are required to eam an annual after tax profit equal to $ 750,000 1 What is the before tax profit if the number of units manufactured and sold is 150,000 What is the before tax profit if the number of units manufactured and sold is 180.000 What is the before tax profit if the number of units manufactured and sold is 210,000 - Part 2 In order to complete the remaining questions use the regression capabilities of Excel to estimate the following cost equation Monthly OH b0b1 x labor hours + b2 x machine hours 2: Bated on the results, what is the estimate of monthly fixed manufacturing OH costs? 7 What is the estimate of variable OH costs per labor hour? 3 1 What is the estimate of vonable OH costs per machine hour? 015 10 016 017 Q18 Q17 Q18 What is the estimate of variable OH costs per labor hour? + What is the estimate of variable OH costs per machine hour? 7 What are the estimated total OH costs for an average month based on the cost model? - if output where 10% higher than average what is your estimate of total Mfg OH Costa? 11 If output where 15% higher than average what is your estimate of the contribution margin per unit? 019 78 020 NO 021 2