40 D E B A 1 2 Data Table 1 3 Month 4 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 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 740 . B D E 25 26 Use Data Table 1 to answer the following Questions 27 28 The following assumptions apply unless an alternative is specifically given in a question 29 ) The Sales Price per unit 30 ii) Direct materials and direct labor costs per unit. 31 in) Variable General and Administrative costs per unit. 32 iV) Fixed General and Administrative costs per month 33 ) Marginal tax rate on Income $ $ $ $ 74.25 19.25 14.25 350,000 21% 34 70 7 Part 2 Be In order to complete the remaining questions use the regression capabilities of Excel to estimate 69 the following cost equation: Monthly OH = b0 + b1 x labor hours + b2 x machine hours 7. Based on the results, what is the estimate of monthly fixed manufacturing OH costs? n What is the estimate of variable OH costs per labor hour? 70 What is the estimate of variable OH costs per machine hour? 016 Q17 M 018 7 What are the estimated total OH costs for an average month based on the cost model? Q19 7 If output whero 10% higher than average what is your estimate of total Mfg OH Costs? 020 - if output where 15% higher than average what is your estimate of the contribution margin per unit? 021 40 D E B A 1 2 Data Table 1 3 Month 4 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 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 740 . B D E 25 26 Use Data Table 1 to answer the following Questions 27 28 The following assumptions apply unless an alternative is specifically given in a question 29 ) The Sales Price per unit 30 ii) Direct materials and direct labor costs per unit. 31 in) Variable General and Administrative costs per unit. 32 iV) Fixed General and Administrative costs per month 33 ) Marginal tax rate on Income $ $ $ $ 74.25 19.25 14.25 350,000 21% 34 70 7 Part 2 Be In order to complete the remaining questions use the regression capabilities of Excel to estimate 69 the following cost equation: Monthly OH = b0 + b1 x labor hours + b2 x machine hours 7. Based on the results, what is the estimate of monthly fixed manufacturing OH costs? n What is the estimate of variable OH costs per labor hour? 70 What is the estimate of variable OH costs per machine hour? 016 Q17 M 018 7 What are the estimated total OH costs for an average month based on the cost model? Q19 7 If output whero 10% higher than average what is your estimate of total Mfg OH Costs? 020 - if output where 15% higher than average what is your estimate of the contribution margin per unit? 021
