Supremo Burritos has approached you because they would like to better understand their operating costs aside from their costs for food, labor and rent. You have been given a dataset which includes several pieces of data the client has collected over the past two years. Your goal is to use data analysis to help SupremoBurritos management generate a cost equation that willbe useful for predicting future other operating costs for your client using the best available cost driver or drivers.The dataset includes 24 months of data for SupremoBurritos Other Operating Costs as well as 6 possible drivers(the six possible cost drivers are Number of Transactions, Number of Items Sold, Direct MaterialsCost, Direct Labor Cost, Direct Labor Hours and Revenue).

Part 1: Estimate the basic cost equation for Other Operating Costs using the High-low method separately for each possible cost driverUse the High-low method to determine the cost equation that expresses how monthly Other Operating Costs behave in relation to that particular cost driver. Clearly show the two months you used to generate the High-low equation. Be sure to clearly state and label the resulting high-low equation for each possible cost driver.

The Whole Instruction is below (Screenshot)

The above is data

I would like you to solve only part 1. For solving part 1, above information is enough.

Overview: You are working as a business consultant, helping companies to better manage their costs. One of your clients is Supremo Burritos, a chain of 100 quick service burrito stores located across the eastern US. Supremo Burritos has approached you because they would like to better understand their operating costs aside from their costs for food, labor and rent. You have been given a dataset which includes several pieces of data the client has collected over the past two years. Your goal is to use data analysis to help Supremo Burrito's management generate a cost equation that will be useful for predicting future "other operating costs for your client using the best available cost driver or drivers. Getting started: Download the Excel file from Canvas labeled Cost Behavior Case" that contains the dataset you will need. The dataset includes 24 months of data for Supremo Burritos' "Other Operating Costs as well as 6 possible drivers (the six possible cost drivers are Number of Transactions, Number of Items Sold, Direct Materials Cost, Direct Labor Cost, Direct Labor Hours and Revenue). The dataset also includes additional data on the underlying items that make up the total "Other Operating Costs. To complete the project you will need to follow the all the steps in parts 1, 2, 3 and 4 and write a memo as described in part 5. For Parts 1-3, Treat Other Operating Costs as a single cost pool Part 1: Estimate the basic cost equation for "Other Operating Costs using the High-low method separately for each possible cost driver Use the High-low method to determine the cost equation that expresses how monthly "Other Operating Costs behave in relation to that particular cost driver. Clearly show the two months you used to generate the High-low equation. Be sure to clearly state and label the resulting high- low equation for each possible cost driver. Number of Transactions Number of Items Sold Jan-19 1,507,046 5,817,198 Feb-19 1,603,174 6,412,696 Mar-19 1,546,554 6,279,009 Apr-19 1,504,934 5,929,440 May-19 1,500,128 6,105,521 Jun-19 1,445,337 5,752,441 Jul-19 1,454,791 5,557,302 Aug-19 1,511,497 6,015,758 Sep-19 1,524,889 5,962,316 Oct-19 1,485,374 6,000,911 Nov-19 1,527,204 6,154,632 Dec-19 1,537,212 5,872,150 Jan-20 1,582,214 6,819,342 Feb-20 1,547,040 5,863,282 Mar-20 1,521,721 6,406,445 Apr-20 1,504,175 6,167,118 May-20 1,594,684 6,267,108 Jun-20 1,474,974 5,752,399 Jul-20 1,507,636 6,045,620 Aug-20 1,521,370 5,857,275 Sep-20 1,605,573 6,374,125 Oct-20 1,635,514 6,852,804 Nov-20 1,557,065 6,165,977 Dec-20 1,551,456 6,174,795 Direct Materials Cost $6,599,629.03 $4,786,620.18 $4,973,528.00 $3,622,069.93 $5,196,605.23 $5,664,385.55 $5,851,651.31 $4,985,792.38 $4,012,832.57 $4,036,768.94 $4,948,145.04 $6,707,544.06 $6,846,509.60 $4,088,749.74 $4,942,982.44 $6,307,116.89 $5,288,567.84 $6,108,425.57 $6,292,155.74 $4,305,288.46 $7,057,222.77 $5,790,868.59 $5,414,834.51 $5,608,318.85 Direct Labor Cost $3,972,995.64 $4,265,633.45 $4,281,966.24 $3,836,858.56 $4,489,067.87 $3,458,678.32 $3,842,414.21 $3,796,025.11 $4,313,261.35 $3,934,307.90 $4,585,830.82 $4,744,293.06 $4,657,523.83 $4,107,389.90 $4,442,680.10 $4,091,295.91 $4,577,899.73 $4,766,494.18 $4,448,024.03 $4,153,322.60 $4,783,450.56 $4,510,192.81 $4,499,732.35 $4,377,732.66 Direct Labor Hours Revenue 248,185 $16,711,030.28 283,261 $17,670,504.46 272,937 $17,080,297.03 266,499 $16,654,051.12 309,446 $18,134,297.33 206,888 $ 16,073,448.24 234,112 $16,196,915.60 226,085 $18,373,606.38 279,655 $17,070,369.91 257,336 $16,638,416.86 299,101 $17,141,337.70 312,251 $18,826,081.64 297,430 $19,451,580.69 276,225 $17,511,873.98 296,604 $18,742,885.38 265,247 $17,101,717.66 286,521 $18,121,670.04 306,149 $18,269,617.95 272,822 $17,256,250.89 279,511 $17,396,713.81 332,836 $20,001,265.09 308,794 $18,846,354.92 279,852 $17,917,146.96 288,149 $19,438,657.66 Other Operating Costs $2,402,865.01 $2,691,247.72 $2,586,498.57 $2,441,163.20 $2,627,041.43 $2,411,103.28 $2,437,846.76 $2,464,073.40 $2,637,997.13 $2,498,316.27 $2,554,570.49 $2,582,052.29 $2,659,146.65 $2,445,726.17 $2,754,692.88 $2,276,436.05 $2,507,897.25 $2,534,443.63 $2,584,546.49 $2,402,516.84 $2,809,416.39 $2,814,013.77 $2,705,579.92 $2,564,894.09