Create a Budget & Budget explanation for any company.

pictures attached is an example of how the excel sheet should look like. Thanks

Yes, it has to be in excel. Is to better understand how to create a budget & budget explanation for a company.

this is a better example.. see below

X Company Profit and to State Budget For the Year end ne Deceber 31, 2019 6T. OTE S06 $ es sos OP 09 OGT OPT DE $ORT Date: Jan 19 Feb 19 Mar-19 Apr May-19 Nun-19 Total Gym Memberships A-19 Sep-19 Oct-19 Now 19 Dec 19 200 210 221 272 243 2355 256 211 205 120 Monthly Membership Costs 342 50 $ 50 $ 505 50 $ 50 $ Total Personal Training Plan Members 50 S 50 $ 50 $ 50 20 80 120 140 180 200 220 240 Personal Training Monthly Cost: 120 120 $ 1205 120S 120 S 120S 120 1.20 $ 10 $ 120$ $ 120 Ex Jan 19 Feb-19 M-19 A-1 May 19 Jun-19 Jul 19 Aug 19 Sep 19 19 Nov Dec 19 Membership Revenue 10.000 30.50 11.005 11.576 12.135 12,76 1407 34.775 15,510 16.289 17.100 Personal Training 2.400 4.800 7,200 SOO 12.000 14.00 16.00 11.200 Bakce Bar Revenue Estimated at 515 per membership a month) 21.600 22.000 26.400 20.000 3.000 3.150 3:47) 3.647 1.829 4.020 4.221 4,432 4,654 4.87 Total Revenue 15.400 TRASO 21.513 26 21.02 M221 17.492 9.97 40167 49,575 101 11.401 . Tecal 199,171 187,200 47.251 194,123 TEIS POTS M10 7.500 Feb-19 7.500 30 2.100 un 7.500 A-19 7.500 Total 0.000 088 ON O Sep 10 7.500 880 2.100 275 OR Oct 19 Nov 18 De 10 7.500 7.500 BAD 380 2.160 2160 2.100 215 275 25 1. 2.100 : Apr 19 Mey 19 7.500 7.500 280 180 2,160 2.150 25 500 210 250 150 204 201 25.9.20 Set 2,160 225 Jul 19 7.500 380 2.150 2.75 100 210 20 24 SCE land Montent for the face 7.500 Gym Equipment Rental Employee Salaries and Payroll Taxes 2.160 Office Cleaning Supplies 275 Websiting Advertising and Marketing Internet Expense 2 Uspense 100 Deprecationen 204 rance Total Expenses 12,828 E 006 008 38 006 OLE 000 000 006 230 006 2.100 295 00 250 100 204 160 TIN 310 200 OCE 10 304 OST 250 M10 204 MO 210 410 304 OR 150 19 208 20 10.10 LIN 4,00 2455 5520 24 204 304 09 12.00 12. 12. OM 6011 11019 11 11 12.00 12,00 Operating come/ 1,471 10 8.00 21,172 NYTT M 17.00 M 100 14,3 SUN 2411 ON 20. AN ILIS ON WS 2 NEE 23 NE Capital Arts Depreciation Expense Caleator U Month Reci ile Deprecio 00 Add text Page view A Read aloud TOURNAL PROFILI SWEDX TZ HUNDU.D. Uudes: $300.00 a month (pro-rated 50% of usage) $150.00 x 12 month= $1,800.00 Repairiaintenance: $50 a month x 12 month= $600.00 Janitorial Supplie: $30 a month x 12 months $360.00. Liability Property Insurance $1.546.00 per year (pro-rated 50%) = $773.00. L Room and Board Residential Treatment - MIA Total: $0 J. Service Payments - NA Total: $0 K. Other Total: $11,781.00 Meeting Supplies to provide supplies for administrative meetings, workshops, etc. $75.00 x 12 months $900.00 Employee Training: to provide supplies for professional development and orientation for stafl. 541.67 x 12 months = $500.00 Dues and Subscriptions: to maintain memberships to organizations $10 x 12 months = $1200.00 Flex Funds: to provide financial support to participants pay bills, provide clothing etc. S 91.66 per month x 12 months = $1,100.00 Office Supplies including binders, file folders, printer paper, toner, staples, etc. $100.0Oper month x 12 months = $1,200.00 Phone and Internet Service: This service is needed to stay connected to funding sources, parents, community colaborators and stam $ 125.00 per month x 12 months = $1,500.00 Postage: Includes mailing, postage of flyers, program announcements, fiscal reports etc. $100 x 12 months =$1,200.00 Printing to include fyers, registration forms, handouts, workshop information, binding $41.67 x 12 months = $500.00 Advertising: To include hining notices, meetings, special events $5000 x 12 months+$600.00 Sub Contracting for Lawn and Parking lot: to maintain the appearance and safety of the outside area of the organization $83 33 x 12 = $1,000.00 Curricula Cost (Name Curricula and population it will serve) $1.200.00. Snacks: provided for meetings, participants, etc. $70.92 x 12 months = $851.00 Tota: 50 L. Indirect costs - NIA Total: $100.000.00 Jan 23 - Dec 23 Budget Budget Explanation On the Road Services Profit and Loss Statement Budget For the Year Ending December 312023 Jan-23 Feb-23 64 225 Apr 23 60 May-29 64 Datet Trip Heat Express Inc to Port Miami Miami Dade Expecss Inc to Port Miami Miami Dude Payment trip Trips: Heat Express Inc. to Cavo Calaveral Heat Express Inc. to Cavo Calaveral Payment trip Jul 21 64 Mar 23 60 225 8 450 Sep-20 60 225 235 Jun-23 60 235 8 450 225 8 450 225 Aug-23 54 235 8 450 Dec-20 66 225 Oct-3) 0 225 8 450 Nov-23 66 225 8 450 8 450 8 450 18 450 450 450 450 Feb-23 14.400 Nep-13 O13 13.500 Revenue Heat Express Inc to Port Miami-Miami Dade Heat Express Ineto Cave Calaveral Total Revenue JA-23 13.275 3.00 16,875 Mar 23 13.500 3.600 17.100 Apr-23 13.500 3.600 17.100 May 33 14.400 3.600 18.000 Jun-13 13.500 3.600 17.100 14.400 3.600 18.000 3.600 14400 300 1,000 Nov-23 14,850 3100 1,450 11.500 . 17.100 Total 168.07 43.200 211.27 Dee-23 14,850 3.000 11.450 100 18.000 17.100 Expenses Jan-23 Fuel 7.000 Track Menance Truck Inuwe 1.221 Food and Beverages 400 Tolle 200 100 Phone 35 Depreciation 205 Total Expenses 10.347.66 Feb-23 Mar 23 Apr-23 May-23 Jul-23 Awg-23 Sep-23 Oct-23 Nov-23 x 500 Dee-23 Total 7.000 7.000 500 7.500 500 K.500 7.000 7.000 X.500 K.500 93.500 1.166.66 1.166.66 1.166.66 1.166.66 1.166.66 1,166.66 1.1666 1.166.66 1.166. 1.166.66 1.166.66 11,999.9 1.221 1.221 1.221 1.321 1.221 1.221 1.221 1.221 1.221 1.221 400 1.221 400 14.45 400 400 400 400 400 400 400 400 400 200 4 NOE 200 200 200 200 200 200 200 200 200 200 100 2.400 100 100 100 100 100 100 100 100 100 100 1.200 55 35 35 55 35 35 35 55 15 55 55 205 205 203 205 205 205 205 205 205 205 11.847.66 10347.66 10.347.66 11.847.66 10.847.66 11.647.44 11.847.66 10.34746 10.447.46 11.847.66 11.847.66 1371.9 2.46: 6.152.346.752.346,752.4 6.152.4 6,252.14 6,152.14 615234 6,75234 6,752.14 6,602.34 6,603.14 77.40.0 199 14% 34% 149 1994 399 3696 30% 171 205 Operating Income 4.527.34 Capitalized Assets Depreciation Expense Calculator Cost Residual wil Monthly Cost month Depreciate 15.00 000 60 205 Truck with GPS Jan 23 - Dec 23 Budget Budget Explanation On the Road Services Subleasing huling company Owner of one 2000 Volvo VNL Hauling Truck Driven and administered by owner Has 2 signed contracs with Hent Express Inc for the Budgeted year Heat Express Inc to Port Miami Miami Dade Contract for 1 year - 12 mi one way trip Minimum amount of trips per month 55 Maximum amount of trips per month 70 Flat Payment per Trip: 5225 We have an approximate of trips per month based on past experience, Holiday sexton, and demand of products in the state of Florida. Heat express In to Cave Canal Contact for 3 years - 222 mi - 224 mi one way trip Trips per month Flat Payment per Trip: $450 Fuel Truck performs approximately 5 miles per fuel gallon. The truck tank equals to approximately 500 gallows when tult, resulting on approximately 2500 miles per tank Based on Florida's average Diesel price (S5.05), filling up our tank costs about S 2525. Our driver drives between 5060 and 5270 miles per month on his trips. For instance we will fill up our tank between 2 and 3 times per month, we do not necessarily need to fill our tank all the way for the last trips of the month, since we will be only driving approximately between 80 and 270 miles after filling it up the 2nd time We buve allocated $7000 for the months with lowest demand of trips, and $8500 for the months with more trips on it Truck Maintenance Maintenance includes Tires change calculated at every S 80000 miles, approximately once a year based on amount of trips and miles - $850 per service - oil change every 14 000 miles, approximately every 2 1/2 months (5 services per year)- $200 per service - S1000 per year. On the road repairs Broken parts and Read Assistance $12 150 All these divided by 12 months Truck Insurance Quoted for $14552 for 1 year Divided between 12 months Food and Beverages Food and beverages bought during the trips Total of $4800 for the whole year - 5400 per month - 5100 per week Budget is based on Trips on Dolphin (16) and 195 Expressway $200 are designated in case of rushed trips using Tumpike Expressway Weight Station l'hong Pees paid at weight station, based on previous experience Phone Bilt paid moothly to communicate between courpanies about trips -Flatrate 555 - Unlimited Straight-line method of Depreciation Truck was bought at S15300 with a savage value of $3000. It included a GPS that is depreciated as part of the truck - Makes a total of 205 of Depreciation per month Depreciation X Company Profit and to State Budget For the Year end ne Deceber 31, 2019 6T. OTE S06 $ es sos OP 09 OGT OPT DE $ORT Date: Jan 19 Feb 19 Mar-19 Apr May-19 Nun-19 Total Gym Memberships A-19 Sep-19 Oct-19 Now 19 Dec 19 200 210 221 272 243 2355 256 211 205 120 Monthly Membership Costs 342 50 $ 50 $ 505 50 $ 50 $ Total Personal Training Plan Members 50 S 50 $ 50 $ 50 20 80 120 140 180 200 220 240 Personal Training Monthly Cost: 120 120 $ 1205 120S 120 S 120S 120 1.20 $ 10 $ 120$ $ 120 Ex Jan 19 Feb-19 M-19 A-1 May 19 Jun-19 Jul 19 Aug 19 Sep 19 19 Nov Dec 19 Membership Revenue 10.000 30.50 11.005 11.576 12.135 12,76 1407 34.775 15,510 16.289 17.100 Personal Training 2.400 4.800 7,200 SOO 12.000 14.00 16.00 11.200 Bakce Bar Revenue Estimated at 515 per membership a month) 21.600 22.000 26.400 20.000 3.000 3.150 3:47) 3.647 1.829 4.020 4.221 4,432 4,654 4.87 Total Revenue 15.400 TRASO 21.513 26 21.02 M221 17.492 9.97 40167 49,575 101 11.401 . Tecal 199,171 187,200 47.251 194,123 TEIS POTS M10 7.500 Feb-19 7.500 30 2.100 un 7.500 A-19 7.500 Total 0.000 088 ON O Sep 10 7.500 880 2.100 275 OR Oct 19 Nov 18 De 10 7.500 7.500 BAD 380 2.160 2160 2.100 215 275 25 1. 2.100 : Apr 19 Mey 19 7.500 7.500 280 180 2,160 2.150 25 500 210 250 150 204 201 25.9.20 Set 2,160 225 Jul 19 7.500 380 2.150 2.75 100 210 20 24 SCE land Montent for the face 7.500 Gym Equipment Rental Employee Salaries and Payroll Taxes 2.160 Office Cleaning Supplies 275 Websiting Advertising and Marketing Internet Expense 2 Uspense 100 Deprecationen 204 rance Total Expenses 12,828 E 006 008 38 006 OLE 000 000 006 230 006 2.100 295 00 250 100 204 160 TIN 310 200 OCE 10 304 OST 250 M10 204 MO 210 410 304 OR 150 19 208 20 10.10 LIN 4,00 2455 5520 24 204 304 09 12.00 12. 12. OM 6011 11019 11 11 12.00 12,00 Operating come/ 1,471 10 8.00 21,172 NYTT M 17.00 M 100 14,3 SUN 2411 ON 20. AN ILIS ON WS 2 NEE 23 NE Capital Arts Depreciation Expense Caleator U Month Reci ile Deprecio 00 Add text Page view A Read aloud TOURNAL PROFILI SWEDX TZ HUNDU.D. Uudes: $300.00 a month (pro-rated 50% of usage) $150.00 x 12 month= $1,800.00 Repairiaintenance: $50 a month x 12 month= $600.00 Janitorial Supplie: $30 a month x 12 months $360.00. Liability Property Insurance $1.546.00 per year (pro-rated 50%) = $773.00. L Room and Board Residential Treatment - MIA Total: $0 J. Service Payments - NA Total: $0 K. Other Total: $11,781.00 Meeting Supplies to provide supplies for administrative meetings, workshops, etc. $75.00 x 12 months $900.00 Employee Training: to provide supplies for professional development and orientation for stafl. 541.67 x 12 months = $500.00 Dues and Subscriptions: to maintain memberships to organizations $10 x 12 months = $1200.00 Flex Funds: to provide financial support to participants pay bills, provide clothing etc. S 91.66 per month x 12 months = $1,100.00 Office Supplies including binders, file folders, printer paper, toner, staples, etc. $100.0Oper month x 12 months = $1,200.00 Phone and Internet Service: This service is needed to stay connected to funding sources, parents, community colaborators and stam $ 125.00 per month x 12 months = $1,500.00 Postage: Includes mailing, postage of flyers, program announcements, fiscal reports etc. $100 x 12 months =$1,200.00 Printing to include fyers, registration forms, handouts, workshop information, binding $41.67 x 12 months = $500.00 Advertising: To include hining notices, meetings, special events $5000 x 12 months+$600.00 Sub Contracting for Lawn and Parking lot: to maintain the appearance and safety of the outside area of the organization $83 33 x 12 = $1,000.00 Curricula Cost (Name Curricula and population it will serve) $1.200.00. Snacks: provided for meetings, participants, etc. $70.92 x 12 months = $851.00 Tota: 50 L. Indirect costs - NIA Total: $100.000.00 Jan 23 - Dec 23 Budget Budget Explanation On the Road Services Profit and Loss Statement Budget For the Year Ending December 312023 Jan-23 Feb-23 64 225 Apr 23 60 May-29 64 Datet Trip Heat Express Inc to Port Miami Miami Dade Expecss Inc to Port Miami Miami Dude Payment trip Trips: Heat Express Inc. to Cavo Calaveral Heat Express Inc. to Cavo Calaveral Payment trip Jul 21 64 Mar 23 60 225 8 450 Sep-20 60 225 235 Jun-23 60 235 8 450 225 8 450 225 Aug-23 54 235 8 450 Dec-20 66 225 Oct-3) 0 225 8 450 Nov-23 66 225 8 450 8 450 8 450 18 450 450 450 450 Feb-23 14.400 Nep-13 O13 13.500 Revenue Heat Express Inc to Port Miami-Miami Dade Heat Express Ineto Cave Calaveral Total Revenue JA-23 13.275 3.00 16,875 Mar 23 13.500 3.600 17.100 Apr-23 13.500 3.600 17.100 May 33 14.400 3.600 18.000 Jun-13 13.500 3.600 17.100 14.400 3.600 18.000 3.600 14400 300 1,000 Nov-23 14,850 3100 1,450 11.500 . 17.100 Total 168.07 43.200 211.27 Dee-23 14,850 3.000 11.450 100 18.000 17.100 Expenses Jan-23 Fuel 7.000 Track Menance Truck Inuwe 1.221 Food and Beverages 400 Tolle 200 100 Phone 35 Depreciation 205 Total Expenses 10.347.66 Feb-23 Mar 23 Apr-23 May-23 Jul-23 Awg-23 Sep-23 Oct-23 Nov-23 x 500 Dee-23 Total 7.000 7.000 500 7.500 500 K.500 7.000 7.000 X.500 K.500 93.500 1.166.66 1.166.66 1.166.66 1.166.66 1.166.66 1,166.66 1.1666 1.166.66 1.166. 1.166.66 1.166.66 11,999.9 1.221 1.221 1.221 1.321 1.221 1.221 1.221 1.221 1.221 1.221 400 1.221 400 14.45 400 400 400 400 400 400 400 400 400 200 4 NOE 200 200 200 200 200 200 200 200 200 200 100 2.400 100 100 100 100 100 100 100 100 100 100 1.200 55 35 35 55 35 35 35 55 15 55 55 205 205 203 205 205 205 205 205 205 205 11.847.66 10347.66 10.347.66 11.847.66 10.847.66 11.647.44 11.847.66 10.34746 10.447.46 11.847.66 11.847.66 1371.9 2.46: 6.152.346.752.346,752.4 6.152.4 6,252.14 6,152.14 615234 6,75234 6,752.14 6,602.34 6,603.14 77.40.0 199 14% 34% 149 1994 399 3696 30% 171 205 Operating Income 4.527.34 Capitalized Assets Depreciation Expense Calculator Cost Residual wil Monthly Cost month Depreciate 15.00 000 60 205 Truck with GPS Jan 23 - Dec 23 Budget Budget Explanation On the Road Services Subleasing huling company Owner of one 2000 Volvo VNL Hauling Truck Driven and administered by owner Has 2 signed contracs with Hent Express Inc for the Budgeted year Heat Express Inc to Port Miami Miami Dade Contract for 1 year - 12 mi one way trip Minimum amount of trips per month 55 Maximum amount of trips per month 70 Flat Payment per Trip: 5225 We have an approximate of trips per month based on past experience, Holiday sexton, and demand of products in the state of Florida. Heat express In to Cave Canal Contact for 3 years - 222 mi - 224 mi one way trip Trips per month Flat Payment per Trip: $450 Fuel Truck performs approximately 5 miles per fuel gallon. The truck tank equals to approximately 500 gallows when tult, resulting on approximately 2500 miles per tank Based on Florida's average Diesel price (S5.05), filling up our tank costs about S 2525. Our driver drives between 5060 and 5270 miles per month on his trips. For instance we will fill up our tank between 2 and 3 times per month, we do not necessarily need to fill our tank all the way for the last trips of the month, since we will be only driving approximately between 80 and 270 miles after filling it up the 2nd time We buve allocated $7000 for the months with lowest demand of trips, and $8500 for the months with more trips on it Truck Maintenance Maintenance includes Tires change calculated at every S 80000 miles, approximately once a year based on amount of trips and miles - $850 per service - oil change every 14 000 miles, approximately every 2 1/2 months (5 services per year)- $200 per service - S1000 per year. On the road repairs Broken parts and Read Assistance $12 150 All these divided by 12 months Truck Insurance Quoted for $14552 for 1 year Divided between 12 months Food and Beverages Food and beverages bought during the trips Total of $4800 for the whole year - 5400 per month - 5100 per week Budget is based on Trips on Dolphin (16) and 195 Expressway $200 are designated in case of rushed trips using Tumpike Expressway Weight Station l'hong Pees paid at weight station, based on previous experience Phone Bilt paid moothly to communicate between courpanies about trips -Flatrate 555 - Unlimited Straight-line method of Depreciation Truck was bought at S15300 with a savage value of $3000. It included a GPS that is depreciated as part of the truck - Makes a total of 205 of Depreciation per month Depreciation