B D E 1 2 Data Table 1 Month 4 January 5 February 6 March 7 April 8 May 9 June 10 July 11 August 12 September 13 October 11 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 35,319 4.923 5.913 4,560 4.752 65.940 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 291) The Sales Price per unit 30 ii) Direct materials and direct labor costs per unit. 31 l) 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 35 Part 1. Answer these questions by applying the high-low method. Assume that the 36 Overhead costs are estimated using labor hours 37 A 5 69.480 Q1 Q2 1.100 03 3 38 What is the estimated variable cost per labor hour? 39 What is the estimated monthly fixed overhead cost? 41 42 Forecast monthly overhead costs for a month when labor hours are equal to 41 What is the average number of labor hours per unit? 1. What is your estimate of the variable overhead cost per unit? As What is your estimate of the contribution margin per unit? so What is your entimate of total fixed cost per month? What is your estimate of total fixed cost per year? Q5 00 Q7 08 How many units are required to break-even? 09