This is all of the information given

PS 0 sont & Thor B C D E Units Mfg'd A Data Table 1 Month January February March April May June July August September October November December 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 230,304 198,758 232,883 239,335 223,621 228,848 215,957 213,047 226,754 230,287 203,962 207,559 2,651,313 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 1,344 760 2,238 $ 1,362 $ 239,335 $ 198,758 $ Max Min A VC FC 6,714 4,086 h . Queries & Connections Lo Recent Sources [Existing Connections co 8 Po From Web From Table/Range 2110 Z Refresh Properties All Edit Links Queries & Connections Stocks Geography Advan Get & Transform Data Data Types Sort & Filter B 4 August September October November December Totals 1,006 1,344 1.196 760 792 13,164 1,773 $ 1,641 $ 1,971 $ 1,752 $ 2,229 S 22,986 $ D 213,047 226,754 230,287 203,962 207,559 2,651,313 E 5,319 4,923 5,913 4,560 4,752 65,940 9 6,714 4,086 Max 1,344 2,238 $ 239,335 $ 1 Min 760 1,362 $ 198,758 $ 2 3 VC 4 FC 5 6 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 i) The Sales Price per unit $ 30 ii) Direct materials and direct labor costs per unit. $ 31 iii) Variable General and Administrative costs per unit. $ 32 iv) Fixed General and Administrative costs per month 33 ) Marginal tax rate on Income 34 74.00 19.00 14.00 350,000 21% D In order to complete the remaining questions use the regression capabilities of Excel to estimate the following cost equation: Monthly OH = b0 + b1 x labor hours + b2 x machine hours Based on the results, what is the estimate of monthly fixed manufacturing OH costs? What is the estimate of variable OH costs per labor hour? What is the estimate of variable OH costs per machine hour? 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 Costs? 3 If output where 15% higher than average what is your estimate of the contribution margin per unit? 2 3 4 6 7 8 59 an