NHM 310 - BASIC COST CONCEPTS - HW/QZ:_ (CHP6-4) NAME: SCORE: MIXED COSTS Months January February March April May June July August September October November December Total Room Sold 1,560 1,650 1,770 1,820 2,450 2,750 2,600 1,880 1,780 1,900 1,620 1,580 23,360 Repair Expenses $3,200 $3,800 $4,200 $4,450 $4,620 $4,880 $4,620 $4,470 $4,250 $4,500 $3,720 $3,400 $50,110 1. By using the High-Low Two Point Method, determine the Total Fixed and Total Variable Costs (from the repair expense above) for the year. 2. By using Regression Analysis, determine the Total Fixed and Total Variable Costs (from the repair expense above) for the year. (You must solve this problem using a spreadsheet program.)