This all of the data given

File Home Insert Drew Page Layout Formulas Data Review View Help Acrobat Palatino-Roman - AA - Paste Xcut Copy - Format Pointer Coboard Accounting $ -% 981 Conditional Formatting Font Alignment Number F8 X 220620.78 B D HA 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 17 18 19 20 Max 21 Min 22 A 23 VC 24 FC 25 Instructions Sheet Read Type here to search 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.7525 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 194962 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 1,344 760 2238 $ 1,362 $ 230,335 $ 189.758 $ 6.714 4,086 Questions o G 4 5 / E I 21A || s || DLL H VC FC hig ca 5 5 Use Data Table 1 to answer the following Questions 7 8 The following assumptions apply unless an alternative is specifically given in a question 9 i) The Sales Price per unit o ii) Direct materials and direct labor costs per unit. 81 ) Variable General and Administrative costs per unit. 32 iv) Fixed General and Administrative costs per month. 33 ) Marginal tax rate on Income 34 35 Part 1. Answer these questions by applying the high-low method. Assume that the 36 Overhead costs are estimated using labor hours. Instructions Sheet1 Questions Data A A A A 74.00 19.00 14.00 350,000 21% Type here to search 3 o $ 750,000 50 What is your estimate of total fixed cost per month? 51 52 What is your estimate of total fixed cost per year? 53 54 How many units are required to break-even? 55 56 How many units are required to earn an annual before tax profit equal to 57 58 What is the after tax profit required to earn a before tax profit of 59 60 How many units are required to earn an annual after tax profit equal to 61 62 What is the before tax profit if the number of units manufactured and sold is 63 64 What is the before tax profit if the number of units manufactured and sold is 65 66 What is the before tax profit if the number of units manufactured and sold is $ 750,000 $ 750,000 150,000 180,000 210,000