R-Work

profileBatman007
Rosin_Preservation_LLCPLbymonth06.30.2021.xlsx
Home>Business & Finance homework help>Operations Management homework help>R-Work

Sheet1

Jan 21 Feb 21 Mar 21 Apr 21 May 21 Jun 21 TOTAL
Ordinary Income/Expense
Income
Consulting Income 49,418.28 59,758.16 60,776.16 102,412.42 86,119.48 73,769.45 432,253.95
Total Income 49,418.28 59,758.16 60,776.16 102,412.42 86,119.48 73,769.45 432,253.95
Gross Profit 49,418.28 59,758.16 60,776.16 102,412.42 86,119.48 73,769.45 432,253.95
Expense
Other Gen & Admn
Dues and Subscriptions 491.87 1,112.92 42.92 42.92 192.92 42.92 1,926.47
Community Contributions 0.00 0.00 0.00 20.00 100.00 0.00 120.00
Service Charges & Fees 8.50 280.06 9.50 9.50 3.50 8.50 319.56
Reconciliation Discrepancies 0.00 0.00 0.00 -0.04 0.00 0.25 0.21
License and Permits 0.00 559.91 0.00 0.00 0.00 20.50 580.41
Political Contributions 0.00 3,000.00 0.00 0.00 0.00 0.00 3,000.00
Bad Debt Expense 0.00 29.21 0.00 0.00 0.00 698.94 728.15
Total Other Gen & Admn 500.37 4,982.10 52.42 72.38 296.42 771.11 6,674.80
Occupancy Expenses
Rent Expense 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 60,000.00
Building Repairs & Maintenance 396.54 627.68 772.77 332.52 352.38 417.62 2,899.51
Utilities
Internet 130.00 130.00 130.00 130.00 130.00 130.00 780.00
Security 0.00 0.00 260.25 0.00 0.00 260.25 520.50
Telephone 213.30 213.78 213.78 347.46 16.75 186.11 1,191.18
Total Utilities 343.30 343.78 604.03 477.46 146.75 576.36 2,491.68
Total Occupancy Expenses 10,739.84 10,971.46 11,376.80 10,809.98 10,499.13 10,993.98 65,391.19
Employee Expenses
Staff Meals 0.00 0.00 36.91 14.63 155.51 531.67 738.72
Staff Development 0.00 0.00 0.00 0.00 0.00 246.28 246.28
Benefits - Disability Ins 368.57 372.58 -0.04 737.16 -0.02 368.58 1,846.83
Benefits - Health Ins 1,426.93 1,426.66 1,427.20 -1,428.72 1,427.20 1,426.66 5,705.93
HSA Contributions 800.00 800.00 800.00 800.00 800.00 800.00 4,800.00
Retirement Benefits 575.70 755.02 1,042.23 799.11 799.11 1,339.11 5,310.28
Employee Wages 25,708.52 29,398.86 42,616.85 28,460.89 31,484.39 54,187.52 211,857.03
Payroll Taxes 2,238.61 2,469.40 3,306.33 2,112.60 2,384.69 4,132.29 16,643.92
Total Employee Expenses 31,118.33 35,222.52 49,229.48 31,495.67 37,050.88 63,032.11 247,148.99
Business Development
Memberships 0.00 0.00 0.00 1,250.00 0.00 125.00 1,375.00
Meals 0.00 0.00 3.93 0.00 0.00 0.00 3.93
Sponsorships 0.00 0.00 0.00 1,000.00 0.00 0.00 1,000.00
Consulting 4,000.00 0.00 4,000.00 2,000.00 0.00 0.00 10,000.00
Meals {Business Development} 0.00 0.00 0.00 38.67 194.90 38.69 272.26
Postage 0.00 0.00 0.00 0.00 0.00 11.70 11.70
Hotel & Travel 0.00 0.00 0.00 0.00 0.00 70.75 70.75
Total Business Development 4,000.00 0.00 4,003.93 4,288.67 194.90 246.14 12,733.64
Insurance
General Liability Insurance 0.00 0.00 0.00 0.00 2,207.00 0.00 2,207.00
Total Insurance 0.00 0.00 0.00 0.00 2,207.00 0.00 2,207.00
Office Expenses
Office Supplies 303.00 168.02 403.43 145.15 147.08 73.90 1,240.58
Postage and Delivery 33.70 4.80 22.00 0.00 20.65 22.00 103.15
Software 248.84 270.71 321.54 261.54 273.54 780.54 2,156.71
Copier 310.19 310.19 310.19 310.19 310.19 338.38 1,889.33
Hardware Expense 0.00 0.00 0.00 357.23 0.00 2,514.13 2,871.36
Total Office Expenses 895.73 753.72 1,057.16 1,074.11 751.46 3,728.95 8,261.13
Professional Development
Conferences, Seminars, Classes 328.85 0.00 0.00 0.00 0.00 0.00 328.85
Total Professional Development 328.85 0.00 0.00 0.00 0.00 0.00 328.85
Professional Fees
Accounting 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 6,000.00
Computer Consulting 1,725.23 1,725.23 1,725.23 1,725.23 1,725.23 1,725.23 10,351.38
Marketing & Public Relations 490.00 350.00 350.00 0.00 817.50 2,334.44 4,341.94
Total Professional Fees 3,215.23 3,075.23 3,075.23 2,725.23 3,542.73 5,059.67 20,693.32
Project Expenses
License & Permits 0.00 0.00 0.00 0.00 0.00 100.00 100.00
Meals {Project Expenses} 472.23 314.62 317.05 24.20 -439.55 167.04 855.59
Photography 1,855.50 3,120.00 4,020.00 3,835.00 390.00 2,047.50 15,268.00
Postage & Delivery 107.67 2.34 190.17 59.22 119.45 66.82 545.67
Printing & Reproduction 291.58 218.30 261.44 233.03 441.40 -110.58 1,335.17
Research Fees 0.00 0.00 0.00 0.00 30.00 0.00 30.00
Hotel, Travel, Parking 1,425.58 -391.12 2,684.87 175.24 -1,441.02 1,512.50 3,966.05
Total Project Expenses 4,152.56 3,264.14 7,473.53 4,326.69 -899.72 3,783.28 22,100.48
Taxes
Property 0.00 0.00 0.00 0.00 -10.41 0.00 -10.41
Total Taxes 0.00 0.00 0.00 0.00 -10.41 0.00 -10.41
Total Expense 54,950.91 58,269.17 76,268.55 54,792.73 53,632.39 87,615.24 385,528.99
Net Ordinary Income -5,532.63 1,488.99 -15,492.39 47,619.69 32,487.09 -13,845.79 46,724.96
Other Income/Expense
Other Income
Early Payment Discounts 0.00 15.00 19.00 28.00 18.00 19.00 99.00
Interest Income 17.99 22.63 26.68 24.26 22.65 13.54 127.75
Other Income 0.00 0.00 0.00 0.00 28.69 0.00 28.69
Total Other Income 17.99 37.63 45.68 52.26 69.34 32.54 255.44
Other Expense
Depreciation Expense 1,321.59 1,321.59 1,321.59 1,321.59 1,321.59 1,321.59 7,929.54
Yoga 0.00 0.00 1,170.00 0.00 0.00 300.00 1,470.00
Interest Expense 3,082.19 15.41 0.00 0.00 0.00 0.00 3,097.60
Other Expense 6.21 0.00 0.00 0.00 28.69 0.00 34.90
Total Other Expense 4,409.99 1,337.00 2,491.59 1,321.59 1,350.28 1,621.59 12,532.04
Net Other Income -4,392.00 -1,299.37 -2,445.91 -1,269.33 -1,280.94 -1,589.05 -12,276.60
Net Income -9,924.63 189.62 -17,938.30 46,350.36 31,206.15 -15,434.84 34,448.36

&"Arial,Bold"&8 3:46 PM &"Arial,Bold"&8 07/19/21 &"Arial,Bold"&8 Accrual Basis &"Arial,Bold"&12 Rosin Preservation, LLC &"Arial,Bold"&14 Profit && Loss &"Arial,Bold"&10 January through June 2021

&"Arial,Bold"&8 Page &P of &N