PLEASE ANSWER ALL QUESTIONS ABOVE WITHIN THE APPROPRIATE EXCEL CELL BELOW SO I KNOW WHICH ANSWERS GO WHERE. THANKS IN ADVANCE :)

(1): PLACE ANSWER FOR #1 TAB BELOW!!!

(2): PLACE ANSWER FOR #2 TAB BELOW!!!

Jonathan Macintosh is a highly successful Pennsylvania orchardman who has formed his own company to produce and package applesauce. Apples can be stored for several months in cold storage, so applesauce production is relatively uniform throughout the year. The recently hired controller for the firm is about to apply the high-low method in estimating the company's energy cost behavior. The following costs were incurred during the past 12 months: Month January February March April May June July August September October November December Pints of Applesauce Produced 35,000 21,000 22,000 24,000 30,000 32,000 40,000 30,000 30,000 28,000 41,000 39,000 Energy Cost $23,400 22,100 22,000 22,450 22,900 23,350 28,000 22,800 23,000 22,700 24,100 24,950 Required: 1. Use the high-low method to estimate the company's energy cost behavior and express it in equation form. Use the formula Y= a +bX, where Y denotes energy cost for a month and X denotes pints of applesauce produced. 2. Predict the energy cost for a month in which 26,000 pints of applesauce are produced. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Use the high-low method to estimate the company's energy cost behavior and express it in equation form. Use the formula Y = a + bx, where y denotes energy cost for a month and X denotes pints of applesauce produced. (Round coefficient of X to 2 decimal places.) Total energy cost Complete this question by entering your answers in the tabs below. Required 1 Required 2 Predict the energy cost for a month in which 26,000 pints of applesauce are produced. Energy cost