G47 + X V fx A B C D E F G H L K L Part 1: High Low Calculations Additional data about Xnew is given below: W Use the data in the following table to answer Sales price per unit of Xnew 210.00 4 questions regarding the production of a product Xnew. Direct Labor costs per unit of Xnew 22.50 5 based on 1/2 hour per unit 6 Month Labor Hours OH Costs Direct Material costs per unit of Xnew 40.40 7 January 4,738 399,684 Variable Sales and Administrative 54.00 8 February 4,953 408,965 costs per unit of Xnew March 4,883 403,815 Fixed Sales and Administrative costs $ 104,000 10 April 5,677 457,656 traceable to Xnew per month 11 May 4,465 390,263 12 June 5,505 451,085 Q3. What is the estimated contribution margin of 13 July 4,135 363,054 a unit of Xnew? 14 August 5,743 459,855 15 September 5,084 423,221 Q4. What is the monthly break-even number of units? 16 October 5,109 412,494 17 November 3,797 336,453 Q5. What is the expected profit 8,700 18 December 3,575 $ 358,638 units are produced and sold? (Before taxes) 19 20 Q1. Use the high low method to estimate the amount Q6. If the tax rate is 20% how many units need to be 21 of variable overhead per labor hour. sold in a month to earn $310,000 after tax? 22 Place your answer in highlighted cell. 23 Q7. If the cost of materials increases by $1.50 per 24 unit what is the new break-even point? 25 Q2. Use the high low method to estimate the amount 26 of fixed overhead per month. Q8. What is the expected total profit if discounting the 27 Place your answer in highlighted cell. price by 8% increases expected sales to + 28 9,500 units? (on a before tax basis)? 29 30 31