2025 Panhandle Precast of NW FL LLC_Profit and Loss by Month.xlsx

	A	B	C	D	E	F	G	H	I	J
1	Profit and Loss
2	Panhandle Precast of NW FL LLC
3	January 1-August 31, 2025
4
5	Distribution account	January 2025	February 2025	March 2025	April 2025	May 2025	June 2025	July 2025	August 2025	Total
6	Income
7	Discounts given			-2,589.53	-4,754.39	-1,143.92	-721.90	-2,751.52	-1,949.62	-13,910.88
8	Sales	309,869.99	945,309.64	929,400.06	760,516.61	474,937.17	711,166.02	371,579.00	338,625.50	4,841,403.99
9	Total for Income	309,869.99	945,309.64	926,810.53	755,762.22	473,793.25	710,444.12	368,827.48	336,675.88	$4,827,493.11
10	Cost of Goods Sold
11	Cost of Goods Sold
12	Concrete	108,196.71	17,788.00	90,600.53	62,561.95	132,656.22	60,364.30	51,071.91	34,228.20	557,467.82
13	ConcreteTesting	647.93	654.99	1,270.50						2,573.42
14	DOT Testing	4,554.00	1,619.72	1,712.27						7,885.99
15	Equipment Rental	31,667.82	5,034.72	10,104.97	3,683.35	3,683.35			615.25	54,789.46
16	Foundry		364,616.78	370,557.86	93,380.46		311,361.76	21,889.82	127,526.28	1,289,332.96
17	Inventory Adjustment	-13,841.73	-36,631.48	-41,174.82	-17,066.02	-17,028.55	-30,242.27	-13,526.05	-16,505.48	-186,016.40
18	Miscellaneous Components	26,908.70	62,124.61	20,585.39	15,332.80	27,066.14	1,860.88	46,107.07	32,276.93	232,262.52
19	Shipping	3,510.75	5,291.64	22,113.53	20,332.07	9,886.03	26,691.11	12,276.85	9,489.21	109,591.19
20	Steel	28,183.30	34,179.87	23,288.03	33,322.50	41,223.92		20,391.50	3,255.50	183,844.62
21	Structure-Outsource	5,808.00		4,423.25	6,091.06	12,906.26	9,052.56	10,236.00	29,699.12	78,216.25
22	Tools for Manufacturing	9,687.62	88,698.82	86,122.29	33,912.82	37,856.72	49,989.09	50,753.25	24,001.09	381,021.70
23	Welding			21,168.00	1,600.00	4,345.00	19,525.00	1,440.00	250.00	48,328.00
24	Total for Cost of Goods Sold	205,323.10	543,377.67	610,771.80	253,150.99	252,595.09	448,602.43	200,640.35	244,836.10	$2,759,297.53
25	Total for Cost of Goods Sold	205,323.10	543,377.67	610,771.80	253,150.99	252,595.09	448,602.43	200,640.35	244,836.10	$2,759,297.53
26	Gross Profit	104,546.89	401,931.97	316,038.73	502,611.23	221,198.16	261,841.69	168,187.13	91,839.78	$2,068,195.58
27	Expenses
28	Advertising & Promotion					165.79		1,123.50		1,289.29
29	Automobile Expense
30	Auto	6,343.47								6,343.47
31	Fuel	6,041.69	604.93	6,912.83	1,605.49	5,495.34	420.08	4,372.43	3,839.30	29,292.09
32	Vehicle Registration				305.68					305.68
33	Total for Automobile Expense	12,385.16	604.93	6,912.83	1,911.17	5,495.34	420.08	4,372.43	3,839.30	$35,941.24
34	Bank Service Charges	288.74	436.85	1,691.10	85.90	113.83	85.90	85.90	85.53	2,873.75
35	Computer and Internet Expenses			7,360.12	2,325.00		5,788.00	632.00		16,105.12
36	Donation/Sponsorship		400.00							400.00
37	Dues and Subscriptions	714.13	636.12	1,674.06	6,232.13	4,204.00	1,741.18	113.92	957.02	16,272.56
38	Insurance Expense	10,876.71	20,514.54	3,947.64	39,843.94	-8,223.50	1,800.54	1,800.54	2,056.83	72,617.24
39	Legal Fees	1,285.00				300.00				1,585.00
40	Meals and Entertainment	342.40	197.22	802.99	405.17	895.93	422.41	671.53	82.85	3,820.50
41	Office Supplies	1,941.57	469.27	451.26	1,468.49	499.39	403.10	943.54	504.02	6,680.64
42	Payroll Expenses
43	Employee Reimbursements	2,243.36	800.00	925.00	800.00	1,125.98	800.00	800.00	902.64	8,396.98
44	Payroll Processing Fee		338.04	126.11	273.27	163.50	584.29	831.88	131.46	2,448.55
45	Service Fee				2.29	0.87	1.56	50.25	74.00	128.97
46	Taxes	6,757.97	8,687.07	7,952.23	9,190.10	7,743.27	7,263.84	9,192.36	7,083.07	63,869.91
47	Wages	109,340.17	107,673.86	103,597.18	119,494.37	77,190.52	94,448.96	119,513.40	116,816.19	848,074.65
48	Workers Compensation	5,814.43	3,476.32	3,807.89	6,290.64	4,224.00		7,456.00		31,069.28
49	Total for Payroll Expenses	124,155.93	120,975.29	116,408.41	136,050.67	90,448.14	103,098.65	137,843.89	125,007.36	$953,988.34
50	Professional Fees	5,663.40	80,000.00	40,942.45	40,000.00	39,350.00	46,650.00	40,000.00	40,000.00	332,605.85
51	Reimbursements			75.00	75.00	75.00	100.00	94.30	50.00	469.30
52	Rent Expense
53	Overflow Storage To KBAR	2,860.00	2,860.00	2,860.00	2,860.00	2,860.00	2,860.00	2,860.00	2,860.00	22,880.00
54	Panhandle Rent To KBAR	9,680.00	9,680.00	9,680.00	9,680.00	9,680.00	9,680.00	9,680.00	9,680.00	77,440.00
55	Total for Rent Expense	12,540.00	12,540.00	12,540.00	12,540.00	12,540.00	12,540.00	12,540.00	12,540.00	$100,320.00
56	Repairs and Maintenance	6,904.49	8,946.37	24,511.97	18,381.33	8,072.89	10,606.10	4,369.42	5,899.05	87,691.62
57	Telephone Expense	124.00	124.00	124.00	124.00	124.00	124.00	124.00	124.00	992.00
58	Travel Expense	1,404.68	1,738.39			1,052.95			61.60	4,257.62
59	Uniforms				222.99	604.75	1,023.26	1,238.59	517.19	3,606.78
60	Utilities	2,768.17	2,892.01	3,663.05	2,804.05	3,335.36	2,894.04	3,534.32	2,653.48	24,544.48
61	Total for Expenses	181,394.38	250,474.99	221,104.88	262,469.84	159,053.87	187,697.26	209,487.88	194,378.23	$1,666,061.33
62	Net Operating Income	-76,847.49	151,456.98	94,933.85	240,141.39	62,144.29	74,144.43	-41,300.75	-102,538.45	$402,134.25
63	Other Income
64	Interest Earned	132.30	118.86	130.93	126.96	129.79	125.26	129.74	346.22	1,240.06
65	Total for Other Income	132.30	118.86	130.93	126.96	129.79	125.26	129.74	346.22	$1,240.06
66	Other Expenses
67	Depreciation Expense	39,088.82	39,088.82	39,088.82	39,088.82	39,088.82	39,088.82	39,088.82	39,088.82	312,710.56
68	Florida Department of Revenue			0.00						0.00
69	Interest Expense	6,626.85	5,066.03	6,522.69	5,066.03	5,066.03	7,035.30	7,343.53	7,460.04	50,186.50
70	Total for Other Expenses	45,715.67	44,154.85	45,611.51	44,154.85	44,154.85	46,124.12	46,432.35	46,548.86	$362,897.06
71	Net Other Income	-45,583.37	-44,035.99	-45,480.58	-44,027.89	-44,025.06	-45,998.86	-46,302.61	-46,202.64	-$361,657.00
72	Net Income	-122,430.86	107,420.99	49,453.27	196,113.50	18,119.23	28,145.57	-87,603.36	-148,741.09	$40,477.25
73
74
75
76	Accrual Basis Wednesday, October 08, 2025 03:50 PM GMTZ
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100