how do i calculate the % of planned sales ? It is based of projected net sales which is 100%.

C M Operating Expert July June 90000 $ 85.00 20.00 $ 40.00 $ 100.00 $ 900.00 $ 85.00 $ 20.00 $ 40.00 $ 100.001s Fired Expenses February March April May $ 900.00 S 900.00 $ 90000 $ Utilities $ 85.00 85.005 85.00$ Phone Internet-2 lines $ 20.005 20.005 20.00$ Insurance building & contents $ 40.00 S 40.005 40.00 $ Baldeat Lone Payment including fixtures 100.00 5 100.00 $ 100.00 $ Patie Tags $ 125.00 Store Rops $ 35.00 $ Office Supplies $ 40.00 $ 4000 $ 40200 Wrapping Supplies $ 15.00 $ 15.00 Store Supplies (including cleaning supplies 20.00 $ Security System & Surveillance $ 138.99 Credit Card Processing $ 180,00 5 180.005 180.00 Total Fixed Espases $ 1.688.995 1.365.00 5 1,405.00$ 2500 Total 900.00 $ $5.00 S 20.00 40.00 100.003 $ 25.00 $ 40.00 $ $ 20.00 $ $ 180.00 1.410.00 % of Planned Sales 5,400.00 510.00 120.00 240.00 600.00 125.00 75.00 240,00 45.00 60.00 138.99 3,080.00 633 99 $ 40.00 S 15.00 5 40,00 S $ 20.00 180.005 1.385.00 180.00 1,380.005 Variable Expenses 1 Freight 2 Travel Payroll Expenses Advertising and Promotion Wabuse Maintenance Visual Merchandising Pro Materiale Total Variable Expenses TOTAL OPERATING EXPENSES 3 $ $ 3 5 $ $ 250.00 47500 S 7,580.00 $ 1,000.00 5 15.00 400 005 9,720.00 250.00 5 475.00$ 7.580.005 1.000.00 250.00 475.00 $ 7580.00 1.000.00 250.005 475 00 15 750.00 $ 980.005 250.00 $ 475.005 7.580.00 200.00 250,00 475.00$ 7.580.00 $ 900.00 S $ 100.00 9.305.00 3 3 1,500,00 2.850.00 45,480.00 5.780.00 15.00 900.00 56 525.00 05158,99 100,005 9.405.00 100005 9,405.00 IS 100.00 15 9.385.00 15 100.00 9,305.005 Pasto B I Uv A B6 x vfx =84-85 B D E F A G NIMIN 2 Projected Income Statement 3 4 Planned Gross Sales $450,000.00 5 Less Reductions $ 67,500.00 15.00% 6 Projected Net Sales $382.500.00 100.00% 7 8 Cost of Goods Sold 9 Opening Inventory $ 226,800.00 10 Purchases $ 91,645.20 u Inward Freight $ 1,500.00 12. Total Goods Handled $319,945.20 13 Closing Inventory $ 150,000.00 14 15 Net Cost of Goods Sold $ 169,945.20 16 17 Gross Margin $212,554.80 19 Operating Expenses 8,633.99 20 Fixed S 1,410.00 21 Variable $ 56,525.00 22 TOTAL OE $ 65,158.99 23 24 Net Profit Before Taxes $ 147,395.81 25 26 27 28 35 Hanning for Market Payroll Operating Expenses (EO) Promotion 56.816