Castanza Company produces computer printers. You just started working for the production department and your boss wants you to reanalyze the cost of the production equipment used to produce printers. The company reported the following monthly cost data related to production equipment:

Reporting Machine Period Total Costs Hours (Month) January 920,000 45,000 February 600,000 25,000 March un 500,000 20,000 April 1,100,000 90,000 May $ 1,140,000 95,000 June 620,000 30,000 July 880,000 38,000 August 910,000 48,000 September 1,060,000 78,000 October 960,000 51,000 November 1,400,000 96,000 un ur December 980,000 54,000 1. What is the relationship between machine hours and total costs based on this data? Analyze it in Excel of Google Sheets to show both the high-low method and regression analysis. Be sure to include a graph! [WARNING: make sure your analysis comes out correctly! (3] 2. What do you estimate Castanza's total costs should be if it expects to use 50,000 machine hours next month? Clearly show how you calculated your answer. 3. What do you estimate Castanza's total costs should be if it expects to use 100,000 machine hours next month? Clearly show how you calculated your