1: The accountant of Manama Corporation has collected the following data on its copy machine costs for the last six months of the year. Total copy cost Month Number of copies July 3,500 $14,000 August 3,200 13,500 September 4,100 16,000 October 5,100 18,000 November 5,600 18,500 December 4,800 17,500 Requirements: 1- Use the regression analysis method to: a-Estimate the cost function (Y=F+vX). b- What percentage of the copy cost depends on number of copies? What portion of the fluctuation is not explained by that cost driver? You need to perform this using Excel. Submit the excel sheet along with your paper. 2- Using the high-low method, calculate the total fixed factory overhead cost and the variable factory overhead cost per direct labour hour and Prepare the cost function. 3. What would the total factory copy cost be at a level of 4,600 copies using each method above? 4. Which prediction method is the best method? Why? [Total: 6 Marks] Q2: The following information was taken from the records of the CBA Company for the year ended December 31, 2020: Sales Direct Materials purchased Finished goods, (December 1") Finished goods, December 31") Direct Materials (December 1") Direct Materials (December 31") WIP (December 1") $220,000 59,000 23,000 15,000 18,000 1,000 30,000 WIP (December 31") Costs: Sales salaries expense Direct labour 17,000 16,360 28,600 Advertising expense Depreciation expense-office equipment Depreciation expense-factory equipment 5,200 3,400 9,600 Heat, light, and power-factory 15,350 Indirect labour 22,300 Office salaries expense 18,620 Property taxes-factory 19,150 Property taxes-headquarters building 6,700 Rent expense-factory 26,000 Page 2 of 5