Spreadsheet: 889310d1740069802-simple-lookup-giving-me-problems-today-sample-mmh-1-
Sheet: 2024

 |  | Detailed Trial Balance | Detailed Income Statement |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  |  | Gross Profit
 |  | Month 1 |  | 2024
 |  |  |  |  |  |  | 2024-01-31 00:00:00 | 2024-02-28 00:00:00 | 2024-03-27 00:00:00 | 2024-04-24 00:00:00 | 2024-05-22 00:00:00 | 2024-06-19 00:00:00 | 2024-07-17 00:00:00 | 2024-08-14 00:00:00 | 2024-09-11 00:00:00 | 2024-10-09 00:00:00 | 2024-11-06 00:00:00 | 2024-12-04 00:00:00 | YTD |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | YTD
 |  |  |  |  | REVENUE: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REVENUE:
 |  |  |  |  | New |  | 779846.53 | 986340.07 | 748027.76 | 2046539.77 | 1161883.29 | 2407883.87 | 1425955.6 | 2376698 | 938299.33 | 1764548.56 | 1235486.71 | 1492064.28 | 17363573.77 |  | New |  | 0.4285396381750952 | 0.4486988156065311 | 0.3707373772077137 | 0.5789144654700483 | 0.472802958468198 | 0.6237963769703104 | 0.5083498310942618 | 0.6558051895533277 | 0.3979666565627542 | 0.5407676168491578 | 0.4745010493863931 | 0.5320918116819768 | 0.5207071937935774
 |  |  |  |  | Used |  | 27553.4 | 48000 | 75674.2 | 52000 | 4500 | 129100 | 45699 | 46050 | 100737.2 | 93484.46 | 117491.43 | 78159.22 | 818448.9099999999 |  | Used |  | 0.01514108688345856 | 0.02183581890687407 | 0.03750563271915465 | 0.01470948800786926 | 0.001831176445533433 | 0.033445181169334 | 0.01629158644994043 | 0.01270663289106598 | 0.04272628722381532 | 0.02864946298028228 | 0.04512376084475077 | 0.02787271401567914 | 0.02454403919576932
 |  |  |  |  | Service |  | 459703.56 | 511215.81 | 558534.04 | 667273.39 | 602780.4 | 607197.65 | 623942 | 611944.3 | 668887.67 | 698844.33 | 649694.22 | 676652.88 | 7336670.25 |  | Service |  | 0.2526153412136144 | 0.2325586635310613 | 0.276820535471609 | 0.1887548063110628 | 0.245288282290938 | 0.1573031402776441 | 0.2224338614137887 | 0.1688545400625483 | 0.283699434855134 | 0.2141694433632624 | 0.2495215745139615 | 0.2413042531914425 | 0.2200155928883022
 |  |  |  |  | Parts |  | 396038.01 | 486539.38 | 450069.77 | 536717.02 | 501048.98 | 531651.37 | 519244.14 | 405697.75 | 475295.35 | 515067.98 | 429861.72 | 367472.62 | 5614704.09 |  | Parts |  | 0.2176299810027811 | 0.2213330373488081 | 0.2230634944487608 | 0.1518237032559486 | 0.2038909089410116 | 0.1377318078123518 | 0.1851093195788741 | 0.1119446769594238 | 0.2015899353986793 | 0.1578489197599128 | 0.1650927003747696 | 0.1310460780679789 | 0.1683764442396366
 |  |  |  |  | Rental |  | 135216 | 133066 | 159526 | 149966.85 | 137046 | 129285 | 139025 | 138570 | 116240 | 131850 | 126199.9 | 125405 | 1621395.75 |  | Rental |  | 0.07430361421943324 | 0.06053343913879385 | 0.0790642460066425 | 0.04242183810871016 | 0.05576786825657219 | 0.03349310803623041 | 0.04956208683347486 | 0.03823578978751387 | 0.04930158498445751 | 0.04040705475487818 | 0.0484683359989019 | 0.04472124595327643 | 0.0486231948672933
 |  |  |  |  | Allied |  | 6228 | 76.8 | 0 | -8975 | 28125 | 0 | 0 | 4440 | 8267.5 | 7469.5 | 7649.59 | 29753.06 | 83034.45 |  | Allied |  | 0.00342239756655004 | 3.493731025099851e-05 | 0 | -0.002538801055204357 | 0.01144485278458396 | 0 | 0 | 0.001225134637053919 | 0.003506545542489698 | 0.002289120178168848 | 0.002937901681172806 | 0.01061037370218565 | 0.002490076986478176
 |  |  |  |  | Labor Sublet |  | 10551.39 | 28494.97 | 17177.73 | 17257.96 | 16110.44 | 14585.97 | 9499.7 | 9541.43 | 12614.15 | 4065.21 | 5948.13 | 6886.11 | 152733.19 |  | Labor Sublet |  | 0.005798177819479837 | 0.0129627292641002 | 0.008513623299999266 | 0.004881841455005526 | 0.006555790723373253 | 0.003778701852675992 | 0.003386620796921137 | 0.002632778463969679 | 0.005350116898070327 | 0.001245833621995285 | 0.002284438921149291 | 0.00245568692612987 | 0.004580236293374601
 |  |  |  |  | Other Revenue |  | 4640 | 4490 | 8666.1 | 74353.25 | 5942.48 | 40344 | 41702.08 | 31150 | 37392.33 | 47714.02 | 31428 | 27755 | 355577.2600000001 |  | Other Revenue |  | 0.002549763119587699 | 0.002042558893580512 | 0.004295090846120159 | 0.02103265844655971 | 0.00241816208978967 | 0.01045168388145322 | 0.01486669383273883 | 0.00859525764509675 | 0.01585943853459979 | 0.01462254849234245 | 0.01207023827890109 | 0.009897836461330786 | 0.01066322173556839
 |  |  |  |  | Total Revenue |  | 1819776.89 | 2198223.03 | 2017675.6 | 3535133.24 | 2457436.59 | 3860047.86 | 2805067.52 | 3624091.48 | 2357733.53 | 3263044.06 | 2603759.7 | 2804148.17 | 33346137.67 |  | Total Revenue |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  | [NAME]: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]:
 |  |  |  |  | New |  | 744430.99 | 910998.2 | 687636.25 | 1882406.67 | 1086839.82 | 2278404.11 | 1344386.02 | 2278235.07 | 885534.1 | 1642759.2 | 1235931.55 | 1397274.45 | 16374836.43 |  | New |  | 0.9545865261463687 | 0.9236147123172234 | 0.9192656834019101 | 0.9197997017179881 | 0.9354122133902106 | 0.9462267422390266 | 0.9427965499066029 | 0.9585715433765669 | 0.9437650349808947 | 0.9309798762353131 | 1.000360052436339 | 0.9364706793999518 | 0.9430568065597014
 |  |  |  |  | Used |  | 11489.28 | 8513.38 | 42442.09 | 19936.62 | 4089 | 75958.9 | 14772.5 | 26869.07 | 58989.36 | 49644.15 | 45599.44 | 63064.35 | 421368.14 |  | Used |  | 0.4169822961957508 | 0.1773620833333333 | 0.5608528402018125 | 0.3833965384615384 | 0.9086666666666666 | 0.5883725793958171 | 0.3232565264010153 | 0.5834760043431053 | 0.5855767283585409 | 0.5310417367763584 | 0.3881086475839132 | 0.8068702579171082 | 0.5148374380509592
 |  |  |  |  | Service |  | 170170.47 | 200568.53 | 218127.93 | 238229.64 | 214104.3 | 204876.81 | 206403.38 | 206733.59 | 224002.41 | 226459.74 | 230949.29 | 253610.36 | 2594236.45 |  | Service |  | 0.3701743575794801 | 0.3923363207409411 | 0.3905365015890526 | 0.357019541870237 | 0.3551945285546776 | 0.3374137070523906 | 0.3308053953732879 | 0.3378307306727099 | 0.3348879341728634 | 0.3240489051402907 | 0.3554738258253244 | 0.3748012718131045 | 0.3535986164840923
 |  |  |  |  | Parts |  | 248345.24 | 307178.58 | 272419.44 | 317141.57 | 301827.05 | 323668.27 | 319915.52 | 246671.91 | 290895.81 | 308650.25 | 261846.52 | 218786.8 | 3417346.96 |  | Parts |  | 0.627074254817107 | 0.6313539923530959 | 0.6052826876153001 | 0.590891583799597 | 0.6023903092268544 | 0.6087979609645321 | 0.6161177283579936 | 0.6080189254192314 | 0.6120316767247986 | 0.5992417738722566 | 0.6091412838528633 | 0.5953825893205322 | 0.6086423977510096
 |  |  |  |  | Rental |  | 61072.67 | 57036.41 | 69534.45 | 71623.92 | 57707.09 | 50405.81 | 51515.93 | 55276 | 53650.9 | 55602.25 | 68185.43 | 69509.74 | 721120.6000000001 |  | Rental |  | 0.4516674801798604 | 0.428632483128673 | 0.435881611774883 | 0.477598349235181 | 0.4210782510981714 | 0.3898813474107591 | 0.3705515554756339 | 0.3989030814750668 | 0.4615528217481074 | 0.4217083807356845 | 0.5402970208375759 | 0.5542820461704079 | 0.4447529851980925
 |  |  |  |  | Allied |  | 3755.57 | 33 | 0 | -7600 | 21999.98 | 0 | 0 | 2876.25 | 7659.94 | 6353.75 | 6372.38 | 24168.5 | 65619.37 |  | Allied |  | 0.6030138086062942 | 0.4296875 | 0 | 0.8467966573816156 | 0.782221511111111 | 0 | 0 | 0.6478040540540541 | 0.9265122467493195 | 0.850625878572863 | 0.8330354960200481 | 0.812303003455779 | 0.7902668109441322
 |  |  |  |  | Labor Sublet |  | 3679.56 | 20961.43 | 11231.14 | 11593.36 | 13483.09 | 10939.88 | 3771.38 | 6630.3 | 9605.49 | 4500.21 | 8841.78 | 5680 | 110917.62 |  | Labor Sublet |  | 0.3487275136261668 | 0.735618602160311 | 0.6538198004043607 | 0.6717688533291305 | 0.8369163101690581 | 0.7500275950108221 | 0.3969999052601661 | 0.694895838464465 | 0.7614853160934347 | 1.107005542149114 | 1.486480625003152 | 0.8248488624201472 | 0.7262181847966381
 |  |  |  |  | Other Revenue |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Other Revenue |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Total [NAME] |  | 1242943.78 | 1505289.53 | 1301391.3 | 2533331.78 | 1700050.33 | 2944253.78 | 1940764.73 | 2823292.189999999 | 1530338.01 | 2293969.55 | 1857726.39 | 2032094.2 | 23705445.57 |  | Total [NAME] |  | 0.6830198728372686 | 0.6847756162394495 | 0.644995310445346 | 0.7166156430358477 | 0.6917982490038534 | 0.7627505893152319 | 0.6918780799971614 | 0.7790344712821652 | 0.6490716573895439 | 0.7030151931200095 | 0.713478432744773 | 0.7246743313139549 | 0.7108902927407604
 |  |  |  |  | GROSS PROFIT: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GROSS PROFIT:
 |  |  |  |  | New |  | 35415.54000000004 | 75341.87 | 60391.51000000001 | 164133.1000000001 | 75043.46999999997 | 129479.7600000002 | 81569.58000000007 | 98462.93000000017 | 52765.22999999998 | 121789.3600000001 | -444.8400000000838 | 94789.83000000007 | 988737.3400000007 |  | New |  | 0.01946147365350927 | 0.034273988113026 | 0.02993122878623303 | 0.04642911281046937 | 0.03053729659002106 | 0.03354356336918585 | 0.02907936419298743 | 0.02716899684883235 | 0.02237964101057679 | 0.03732384784286367 | -0.0001708452588770323 | 0.03380343129300478 | 0.0296507304619426
 |  |  |  |  | Used |  | 16064.12 | 39486.62 | 33232.11 | 32063.38 | 411 | 53141.10000000001 | 30926.5 | 19180.93 | 41747.84 | 43840.31 | 71891.98999999999 | 15094.87 | 397080.77 |  | Used |  | 0.008827521707894644 | 0.0179629725742615 | 0.01647049208505074 | 0.009069921223110674 | 0.0001672474486920535 | 0.01376695365637254 | 0.01102522480457083 | 0.005292617503132123 | 0.01770676773638622 | 0.0134354024015232 | 0.02761083904939461 | 0.005383050068998317 | 0.01190784893679712
 |  |  |  |  | Service |  | 289533.09 | 310647.28 | 340406.11 | 429043.75 | 388676.1 | 402320.84 | 417538.62 | 405210.7100000001 | 444885.26 | 472384.59 | 418744.9299999999 | 423042.52 | 4742433.799999999 |  | Service |  | 0.1591036195651435 | 0.1413174531248542 | 0.1687120119805186 | 0.1213656518360818 | 0.1581632265026216 | 0.104226904585582 | 0.1488515399443932 | 0.1118102874158133 | 0.1886919171904893 | 0.1447680697268917 | 0.1608231857955248 | 0.1508631122013784 | 0.1422183836380712
 |  |  |  |  | Parts |  | 147692.77 | 179360.8 | 177650.33 | 219575.45 | 199221.93 | 207983.1 | 199328.62 | 159025.84 | 184399.54 | 206417.73 | 168015.2 | 148685.82 | 2197357.13 |  | Parts |  | 0.08115982283960098 | 0.08159354057900121 | 0.08804702301995425 | 0.06211235478072108 | 0.0810690012554912 | 0.05388096405623322 | 0.07106018610204433 | 0.04388019476815194 | 0.07821050922578177 | 0.06325925307916314 | 0.06452792091374639 | 0.05302352478756499 | 0.06589540149283502
 |  |  |  |  | Rental |  | 74143.33 | 76029.59 | 89991.55 | 78342.93000000001 | 79338.91 | 78879.19 | 87509.07 | 83294 | 62589.1 | 76247.75 | 58014.47 | 55895.25999999999 | 900275.1499999999 |  | Rental |  | 0.04074308801668539 | 0.03458684080841424 | 0.0446015950235013 | 0.02216123825646809 | 0.03228523182362154 | 0.02043476994609077 | 0.03119677846471232 | 0.02298341541864169 | 0.02654629931822703 | 0.02336706112390036 | 0.02228103845374057 | 0.01993306223900429 | 0.02699788380019604
 |  |  |  |  | Allied |  | 2472.43 | 43.8 | 0 | -1375 | 6125.02 | 0 | 0 | 1563.75 | 607.5600000000004 | 1115.75 | 1277.21 | 5584.560000000001 | 17415.08 |  | Allied |  | 0.001358644575379787 | 1.992518475252259e-05 | 0 | -0.000388952807900389 | 0.002492442744982486 | 0 | 0 | 0.0004314874524083481 | 0.0002576881535887562 | 0.000341935315455103 | 0.0004905252969388843 | 0.001991535276112033 | 0.0005222517873686929
 |  |  |  |  | Labor Sublet |  | 6871.83 | 7533.540000000001 | 5946.59 | 5664.599999999999 | 2627.35 | 3646.09 | 5728.320000000001 | 2911.13 | 3008.66 | -435 | -2893.650000000001 | 1206.11 | 41815.57 |  | Labor Sublet |  | 0.003776193684930245 | 0.003427104482660252 | 0.002947247813275831 | 0.00160237241864185 | 0.00106914254092717 | 0.0009445711898504802 | 0.002042132661391338 | 0.0008032716657582827 | 0.001276081440806417 | -0.0001333111021491999 | -0.001111335274142234 | 0.0004301163586516185 | 0.001253985406460418
 |  |  |  |  | Other Revenue |  | 4640 | 4490 | 8666.1 | 74353.25 | 5942.48 | 40344 | 41702.08 | 31150 | 37392.33 | 47714.02 | 31428 | 27755 | 355577.2600000001 |  | Other Revenue |  | 0.002549763119587699 | 0.002042558893580512 | 0.004295090846120159 | 0.02103265844655971 | 0.00241816208978967 | 0.01045168388145322 | 0.01486669383273883 | 0.00859525764509675 | 0.01585943853459979 | 0.01462254849234245 | 0.01207023827890109 | 0.009897836461330786 | 0.01066322173556839
 |  |  |  |  | Total Gross Profit |  | 576833.11 | 692933.5000000001 | 716284.3 | 1001801.46 | 757386.26 | 915794.0800000002 | 864302.79 | 800799.2900000003 | 827395.5199999999 | 969074.51 | 746033.3099999997 | 772053.9700000001 | 9640692.1 |  | Total Gross Profit |  | 0.3169801271627315 | 0.3152243837605505 | 0.3550046895546539 | 0.2833843569641523 | 0.3082017509961468 | 0.2372494106847681 | 0.3081219200028383 | 0.2209655287178348 | 0.3509283426104561 | 0.2969848068799905 | 0.286521567255227 | 0.2753256686860452 | 0.2891097072592395