Operating Number of High/Low Method Variable cost/un it of activity Trips Costs Cost 29965 January 705 Fixed cost February 710 27910 March 33503 950 Two aptions April 670 26312 Insert text box BELOW showing resulting H/L equation and fill in the 1) Hand crunch numbers and input May 504 25160 box with highlighting color like this one. Be sure to tell what the x resulting values; OR and y variables represent (e.g., x = ?; y= ? June 880 29605 July 685 21496 2) Use Excel formulas and cell references to arrive at costs WITHOUT using any August 610 27320 actual numbers September 744 28247 October 1020 37511 For anyone un familiar with Excel, a basic arithmatic formula begins with ="and November 1074 30974 34987 December 1050 contains cell references (e.g., B4, C9) rather than numbers. -To multiply, use "" -To divide, use "/" Cost Prediction Number of trips Predicted cost - To add or subtract FIRST before multiplying or dividing, you must put 1,000 parentheses around the cell references you wish to add or subtract