:Bikaner Cement is a small cement plant, primarily catering to the captive consumption of cement of some big auto manufacturers. Bikaner has provided sales and profit / loss data for past 12 months. With the help of regression analysis, you are required to: a. calculate fixed costs; b. calculate break even sales; c. calculate sales to earn 10% profit on sales. Solve in excel

Bikanee Cement is a small cement plant, primarily catering to the captive consumption of cement of some big auto manufacturers. Bikanee has provided sales and profit / loss data for past 12 months. With the help of regression analysis, you are required to: a. calculate fixed costs; b. calculate break even sales, c. calculate sales to earn 10% profit on sales. Month Sales Profit/-Loss January 324322 10123 February 361287 14997 March 379952 25832 April 402103 27093 May 422445 40513 June 472636 49826 July 463097 48083 August 439901 41126 September 319325 9872 October 246723 -5056 November 252788 -9178 December 229439 -12723