Answered step by step
Verified Expert Solution
Question
1 Approved Answer
fill out the green empty pages what are the formulas to get the operrating expenses and the rest on grey PROFIT & LOSS STATEMENT P&L
fill out the green empty pages
what are the formulas to get the operrating expenses and the rest on grey
PROFIT & LOSS STATEMENT P&L Month 3 Month 2 Month 3 Mont Month Month Month Month Months Nors or 12 Year Sales (5) 2,1653.9555.746 46 11.576 36.64 2165328.8031728 40.33 254390.00 74120 Cost of sales Materials and Manufacturing 150 25 1,490 7. 10:56 1654 2008 23.10.201511280 32 Totalcool sa 1,374 2.43 2597 16914 2002 25 23:35 5:12.30 Gross profit 1.470 2.14 3,364 4.180 1.041 7.91 11341 25.52 37.239 $93.3 $16.50 54074 Operating Manegem 2 4.000 4.000 5200 4000 54.000 54000 54000 54.000 5400 $500 S600 5700 $55 558 561 $54 SET 5800 SA DOO SMO 50 S420 S. SA $1.00 54 SROO SALDO $1.000 SAD Som S. $1.00 S. SM $ SL. 5.000 $12.00 S.RO SLO $100.000 S. Sh.300 SO 34.95.38.353 25 435151843 S4 S427 S. $57515 SUS SR 3.500 $500 SSO $15 Sales and Marketing Payroll Advertising Promotional Materials Trade Shows 151 Total Marketing and Advertising |cara states Esp Administration Payroll Mentis) Utilities S Telephone 5 Insurance ! Supplies (5) Miscellaneous Total General and Adminitrate Omerta Legal [5] Credit Card Fees Total Others | Total expenses (5) PS! 1.500 S500 550 $15 SO $500 $50 5.00 $2.500 $500 5500 550 550 SIS 515 SA SA 550 550 5300 $100 5600 $3.500 52.500 $500 $500 SSD $50 $ $15 SA SED 950 $50 $100 $100 SILVO S500 550 $35 SRO $500 $50 SIS SSO $ 550 SIS SH4.000 S4000 5600 S250 $1.200 5.00 $1200 18.00 5600 S. $ SSO 3 $50 $100 $90 $100 550 $50 $100 $50 $100 $50 $300 550 5000 S. 5660 $ SHO $1.400 $500 $4,7 14, 5 $4,70 12 14 16 147 154 $1,400 $990 SL274 $ S. St. 514150 SL $100 $500 $100 $100 $100 $100 $100 $100 $300 $57 $110 5170 5228 5280 5425 $50 SOM SW 1153 5211 $2.30 3383 $ 38.70 4.464 $8833 59,363 33,342 393 333 1075 SEL12335 57,814 7.3 57.475.05.16 53541-51.999 500 5520 $1,000 3123354SSIL 54 S. ES 5225 $1827 SALES PROJECTONS Month 1 Month 2 Month 3 Month & Month Month More Morth Month Month 10 11 Year 2 Year 3 40 60 80 100 300 2.000 20 10 150 30 200 500 350 180 450 200 2.400 1.125 5.000 2.000 15 20 40 60 120 140 2000 7070 7076 2025 70.70 75.00 70.78 75.00 70.76 75.00 70.78 75.00 70.76 75.00 7076 75.00 7075 75.00 7075 75.00 70.76 75.00 7076 75.00 75.00 75.00 75.00 75.00 75.00 Sales Unit al units Website Sales Ebay Sales Unit prices ( Website Sales Ebay Sales Total sales ( Website Sales Ebay Sales Total sales ( Lini con Website Sales Ebay Sales Total cost of 24,78 39306 1.415 2.830 4245 750 1.500 2.165 3.9555.746 5.661 7078 10,614 14.152 17.630 21 22 3.000 4500 5.000 7500 9.000 10.500 8,661 11.578 16,8742161 26.88031728 13.500 1,04 31.542 16033353.800 849120 15.000 150.000 225.000 5.50 0.00 1034120 36. 42.46 42. . - 42.46 12 42.46 . 52 50 52.50 42.46 246 52 50 52.50 42.46 5250 2.4 5250 24 5250 52.50 52 50 5250 52.50 sales 1.698 2547 3.396 4.246 6.368 8.491 14.30 509472 Website Sales Ebay Sales Total cost of sales 849 525 10.614 12.737 6.300 7950 788 2.100 1.400 9.50 1.050 2597 3.150 4,200 5.250 7,300 10,506 13.741 19.405 02 212.290 S063 105,000 23.6562531721 157.500 408.0721 1,374 2.400 5.400 18014 20.05 PROFIT & LOSS STATEMENT P&L Month 3 Month 2 Month 3 Mont Month Month Month Month Months Nors or 12 Year Sales (5) 2,1653.9555.746 46 11.576 36.64 2165328.8031728 40.33 254390.00 74120 Cost of sales Materials and Manufacturing 150 25 1,490 7. 10:56 1654 2008 23.10.201511280 32 Totalcool sa 1,374 2.43 2597 16914 2002 25 23:35 5:12.30 Gross profit 1.470 2.14 3,364 4.180 1.041 7.91 11341 25.52 37.239 $93.3 $16.50 54074 Operating Manegem 2 4.000 4.000 5200 4000 54.000 54000 54000 54.000 5400 $500 S600 5700 $55 558 561 $54 SET 5800 SA DOO SMO 50 S420 S. SA $1.00 54 SROO SALDO $1.000 SAD Som S. $1.00 S. SM $ SL. 5.000 $12.00 S.RO SLO $100.000 S. Sh.300 SO 34.95.38.353 25 435151843 S4 S427 S. $57515 SUS SR 3.500 $500 SSO $15 Sales and Marketing Payroll Advertising Promotional Materials Trade Shows 151 Total Marketing and Advertising |cara states Esp Administration Payroll Mentis) Utilities S Telephone 5 Insurance ! Supplies (5) Miscellaneous Total General and Adminitrate Omerta Legal [5] Credit Card Fees Total Others | Total expenses (5) PS! 1.500 S500 550 $15 SO $500 $50 5.00 $2.500 $500 5500 550 550 SIS 515 SA SA 550 550 5300 $100 5600 $3.500 52.500 $500 $500 SSD $50 $ $15 SA SED 950 $50 $100 $100 SILVO S500 550 $35 SRO $500 $50 SIS SSO $ 550 SIS SH4.000 S4000 5600 S250 $1.200 5.00 $1200 18.00 5600 S. $ SSO 3 $50 $100 $90 $100 550 $50 $100 $50 $100 $50 $300 550 5000 S. 5660 $ SHO $1.400 $500 $4,7 14, 5 $4,70 12 14 16 147 154 $1,400 $990 SL274 $ S. St. 514150 SL $100 $500 $100 $100 $100 $100 $100 $100 $300 $57 $110 5170 5228 5280 5425 $50 SOM SW 1153 5211 $2.30 3383 $ 38.70 4.464 $8833 59,363 33,342 393 333 1075 SEL12335 57,814 7.3 57.475.05.16 53541-51.999 500 5520 $1,000 3123354SSIL 54 S. ES 5225 $1827 SALES PROJECTONS Month 1 Month 2 Month 3 Month & Month Month More Morth Month Month 10 11 Year 2 Year 3 40 60 80 100 300 2.000 20 10 150 30 200 500 350 180 450 200 2.400 1.125 5.000 2.000 15 20 40 60 120 140 2000 7070 7076 2025 70.70 75.00 70.78 75.00 70.76 75.00 70.78 75.00 70.76 75.00 7076 75.00 7075 75.00 7075 75.00 70.76 75.00 7076 75.00 75.00 75.00 75.00 75.00 75.00 Sales Unit al units Website Sales Ebay Sales Unit prices ( Website Sales Ebay Sales Total sales ( Website Sales Ebay Sales Total sales ( Lini con Website Sales Ebay Sales Total cost of 24,78 39306 1.415 2.830 4245 750 1.500 2.165 3.9555.746 5.661 7078 10,614 14.152 17.630 21 22 3.000 4500 5.000 7500 9.000 10.500 8,661 11.578 16,8742161 26.88031728 13.500 1,04 31.542 16033353.800 849120 15.000 150.000 225.000 5.50 0.00 1034120 36. 42.46 42. . - 42.46 12 42.46 . 52 50 52.50 42.46 246 52 50 52.50 42.46 5250 2.4 5250 24 5250 52.50 52 50 5250 52.50 sales 1.698 2547 3.396 4.246 6.368 8.491 14.30 509472 Website Sales Ebay Sales Total cost of sales 849 525 10.614 12.737 6.300 7950 788 2.100 1.400 9.50 1.050 2597 3.150 4,200 5.250 7,300 10,506 13.741 19.405 02 212.290 S063 105,000 23.6562531721 157.500 408.0721 1,374 2.400 5.400 18014 20.05 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started