Page 18 - Q1 2022 RNR

$ 2,452,975
$ 982,923
$ 59,979
$ 26,500
$ 5,250,365
$ 35,400,000
$ 37,900,000
$ 6,541,747
$ 10,265,366
$ 2,574,214
$ 5,262,365
$ 200,000
$ 37,550
$ 2,497,396
$ 394,434
$ 4,671,065
$ 1,493,860
$ 1,160,000
$ 5,020,202
$ 2,335,224
$ 2,152,000
$ 362,500
$ 780,180
$ 774,444
$ 1,067,030
$ 899,222
127,039,164
$ 130,561,543
2
Schedule B
R N R Construction, Inc.
Schedule of Revenue, Costs and Profits
as of and for the three months ended March 31, 2022
Total Estimated Contract Costs
2,227,941
Total
Estimated Contract
Costs
Estimated Gross Margin
1,294,438
Estimated Gross
Margin
Gross Margin Recognized
Costs in Excess of Billings
Billings in Excess of Costs
Contract Description COMPLETED CONTRACTS
145 HazelSoundwalls,TeichertConstruction,DesignBuild 167 Hollman Rd, Arnaiz Development, Stockton
169 HStreetBridgeSign,CityofSacramento-DesignBuild
170 TuttleGateRepair,IrrigtionDistrict,Glenn-Colusa
Miscellaneous Small Jobs and Adjustments to Prior Completed Contracts
Total Completed Contracts
Contract Description
CONTRACTS IN PROGRESS
124 OakKnollBridges,Goodfellow,Oakland,CADesignBuild 129 I-5Anderson,CalTrans02-4C40V4,J.F.Shea
139 I-5Sacramento,CalTrans03-0H10U4,GraniteConstruction
142 Nividia,DevCon,SantaClara,DesignBuild
143 GoogleCaribbean,DevCon,Sunnyvale,DesignBuild
146 WhiteRockRd,Goodfellows,Folsom
152 WestBrookPhase3,AnthemUnited,Roseville
153 CannonBridge,McKinleyPartners,Fairfield-DesignBuild
154 Building3RRTunnel,Sobrato,MenloPark-DesignBuild
155 Sump163Railyards,T&SConstruction,Sacramento
156 Lot 4 RW Horizon Circle, Lewis Homes, Fairfield- Design Build
157 Village7Bridges,LewisHomes,LincolnDesignBuild
160 MageePreserveBridge,DavidonHomes,DanvilleDesignBuild
161 WhitehawkBridges,Teichert,GraniteBay
162 GrayLodgePhase5Bm,DucksUnlimited,Gridley
164 PleasantValleyRdBridge,StanislausCounty
165 PleasantGroveCreekBridge,TaylorBuilders,Roseville-DesignBuild
166 CompostLeachatePond,RJGordon,Lincoln
168 CroftwoodII,KnightDevelopment,Rocklin-DesignBuild
171 AlderCreekSteelPedestrianBridge,Goodfellows,Folsom
172 Google-Landings,WhitingTurner
173 EnclavveHMBStructures,FolsomRanch,GoodFellows-Prime
Total Contracts in Progress Total all Contracts
Underapplied Indirect Costs Contracts in Progress at
December 31, 2021
Current Total Cost1; Total Margin2 ;& Total Revenue3
Estimated Backlog Cost4; Backlog Margin5; & Backlog Revenue6
Contract Amount
3,522,379
Contract Amount
Contract Costs to Date
2,227,941
Contract Costs to Date
Percent Complete
Prior Years
Current Year
Margin on Earnings
Revenues Earned
3,522,379
Revenues Earned
Billings to Date
3,522,379
Billings to Date
$ 1,665,307
$ 510,304
$ 38,968
$ 7,399
$ 3,800,365
$ 26,900,000
$ 32,400,000
$ 6,191,747
$ 8,765,366
$ 2,174,214
$ 4,312,365
$ 130,000
$ 29,895
$ 1,772,396
$ 213,251
$ 4,571,065
$ 1,293,860
$ 985,000
$ 4,270,202
$ 1,935,224
$ 2,002,000
$ 262,500
$ 680,180
$ 674,444
$ 917,030
$ 849,222
105,130,326
$ 107,358,267
5,963
$ 1,665,307
$ 510,304
$ 38,968
$ 7,399
$ 5,963
$ 3,253,100
$ 26,799,073
$ 31,949,506
$ 5,936,879
$ 474,644
$ 2,172,076
$ 4,286,925
$ 129,662
$ 29,695
$ 1,476,717
$ 213,051
$ 118,201
$ 982,648
$ 128,858
$ 3,477,077
$ 1,859,563
$ 751,748
$ 299
$ 30,666
$-
$-
$-
84,070,388
100.0%
100.0%
100.0%
100.0%
100.0%
Percent Complete
Prior Years
Recognized Current
Year
Margin on Earnings
Costs in Excess
of Billings
Billings in Excess
of Costs
85.6%
99.6%
98.6%
95.9%
5.4%
99.9%
99.4%
99.7%
99.3%
83.3%
99.9%
2.6%
75.9%
13.1%
81.4%
96.1%
37.5%
0.1%
4.5%
0.0%
0.0%
0.0%
$ 787,668
$ 472,619
$ 21,011
$ 19,101
$ 1,450,000
$ 8,500,000
$ 5,500,000
$ 350,000
$ 1,500,000
$ 400,000
$ 950,000
$ 70,000
$ 7,655
$ 725,000
$ 181,183
$ 100,000
$ 200,000
$ 175,000
$ 750,000
$ 400,000
$ 150,000
$ 100,000
$ 100,000
$ 100,000
$ 150,000
$ 50,000
(5,961)
21,908,838
$ 23,203,276
$ 771,400
$ 111,628
$-
$-
883,028
Gross Margin
411,410
$ 1,234,569
$ 8,431,728
$ 5,364,287
$ 326,889
$ 498,826
$ 394,913
$ 928,054
$ 71,519
$ 911
$ 190,804
$-
$-
$-
$ 22,752
$ 207,659
$ 96,007
$ 55,879
$-
$-
$-
$-
$-
17,824,797
$ 18,707,825
-
$ 16,268
$ 360,991
$ 21,011
$ 19,101
$ 6,626
$ 36,381
$ 59,240
$ 8,704
$ (417,601)
$ 4,694
$ 16,342
$ (1,701)
$ 6,693
$ 413,248
$ 181,013
$-
$ 151,894
$ 142
$ 403,040
$ 288,354
$ 446
$-
$-
$-
$-
$-
(5,961)
1,157,515
48.08%
35.03%
72.08%
27.62%
24.01%
14.51%
5.35%
14.61%
15.54%
18.05%
35.00%
20.39%
29.03%
45.93%
0.00%
13.39%
15.09%
14.94%
17.13%
6.97%
0.00%
0.00%
0.00%
0.00%
0.00%
$ 2,452,975
$ 982,923
$ 59,979
$ 26,500
$ 4,494,295
$ 35,267,182
$ 37,373,033
$ 6,272,472
$ 555,869
$ 2,571,683
$ 5,231,321
$ 199,480
$ 37,299
$ 2,080,769
$ 394,064
$ 118,201
$ 1,134,542
$ 151,752
$ 4,087,776
$ 2,243,924
$ 808,073
$ 299
$ 30,666
$-
$-
$-
103,052,700
2
$ 2,452,975
$ 982,923
$ 59,979
$ 26,500
$ 4,726,278
$ 35,345,743
$ 37,296,229
$ 6,541,747
$ 865,000
$ 2,508,630
$ 5,235,525
$ 180,000
$ 37,550
$ 2,443,021
$ 394,434
$-
$ 1,195,971
$ 128,061
$ 4,337,121
$ 2,149,971
$ 446,282
$-
$ 66,000
$-
$-
$-
103,897,563
$ 107,419,942
2
76,804
63,053
19,480
118,201
23,691
93,953
361,791
757,272
$ 757,272
299
231,983
78,561
269,275
309,131
4,204
362,252
249,345
251
370
61,429
35,334
1,602,135
$ 1,602,135
$
$
86,298,329 474,655
(79,405,808)
7,367,176 1
21,059,938 4
12.9% $
12.2% $
1,568,925 (474,655)
1,094,270 2
2,926,526 5
$
$
106,575,079
(98,113,635)
8,461,444 3
23,986,464 6
Created by R N R Construction, Inc. Refer to Accompanying Management's Internal Report.
32.11%
9 of 11