G H Sales $14,326,700.00 B C D E Percent of SCOGS Sales Margin Gross Profit 50.00% $5,014,345.00 $7,163,350.00 30.00% $2,149,005.00 20.00% $2,349,578.80 $2,865,340.00 18.00% $515,761.20 18.00% $1,805,164.20 $2,578,806.00 30.00% $773,641.80 7.00% $671,922 23 $1,002,869.00 33.00% $330,946.77 5.00% $358,167.50 S716,335.00 50.00% $358,167.50 100.00% $10,199,177.73 $14,326,700.00 28.81% $4,127,522.27 1 2 Grocery 3 Meat 4 Prodce 5 Seasonal 6 Bakery 7 Overall 8 9 10 11 Grocery 12 Meat 13 Prodce 14 Seasonal 15 Bakery 16 Overall 17 18 19 Grocery 20 Meat 21 Prodce 22 Seasonal 23 Bakery 24 Percent of S. COGS Sales 50.00% $4,512,910.50 $6,447,015.00 20.00% $2,349,578,80 $2,865,340.00 18.00% $1,805,164.20 $2,578,806.00 7.00% $671,922.23 $1,002,869.00 5.00% $358,167.50 $716,335.00 100.00% $9,697,743.23 $13,610,365.00 Margin Gross Profit Test Sales 30.00% $1,934,104.50 $6,447,015.00 18.00% $515,761.20 $2,865,340.00 30.00% $773,641.80 $2,578,806.00 33.00% $330,946.77 $1,002,869.00 50.00% $358,167.50 $716,335.00 28.81% 53,921,146.16 $13,618,889.39 Price cut % (anter as a decimal, Lo..05 for 5%) 0.1 0 OC 0 0 15 This is the sales breakdown for Value Supermarket 7 Wite formulas at allow you to enter a percentage price out for one of the above categories and folum fures for the below the questione Output your loures into com E2, E30 and 31 18 19 1 Profits Needed to breakeven 0 2 Revenues needed to breakeven 12 3 Percent Revenues needed to breakeven 12 G H Sales $14,326,700.00 B C D E Percent of SCOGS Sales Margin Gross Profit 50.00% $5,014,345.00 $7,163,350.00 30.00% $2,149,005.00 20.00% $2,349,578.80 $2,865,340.00 18.00% $515,761.20 18.00% $1,805,164.20 $2,578,806.00 30.00% $773,641.80 7.00% $671,922 23 $1,002,869.00 33.00% $330,946.77 5.00% $358,167.50 S716,335.00 50.00% $358,167.50 100.00% $10,199,177.73 $14,326,700.00 28.81% $4,127,522.27 1 2 Grocery 3 Meat 4 Prodce 5 Seasonal 6 Bakery 7 Overall 8 9 10 11 Grocery 12 Meat 13 Prodce 14 Seasonal 15 Bakery 16 Overall 17 18 19 Grocery 20 Meat 21 Prodce 22 Seasonal 23 Bakery 24 Percent of S. COGS Sales 50.00% $4,512,910.50 $6,447,015.00 20.00% $2,349,578,80 $2,865,340.00 18.00% $1,805,164.20 $2,578,806.00 7.00% $671,922.23 $1,002,869.00 5.00% $358,167.50 $716,335.00 100.00% $9,697,743.23 $13,610,365.00 Margin Gross Profit Test Sales 30.00% $1,934,104.50 $6,447,015.00 18.00% $515,761.20 $2,865,340.00 30.00% $773,641.80 $2,578,806.00 33.00% $330,946.77 $1,002,869.00 50.00% $358,167.50 $716,335.00 28.81% 53,921,146.16 $13,618,889.39 Price cut % (anter as a decimal, Lo..05 for 5%) 0.1 0 OC 0 0 15 This is the sales breakdown for Value Supermarket 7 Wite formulas at allow you to enter a percentage price out for one of the above categories and folum fures for the below the questione Output your loures into com E2, E30 and 31 18 19 1 Profits Needed to breakeven 0 2 Revenues needed to breakeven 12 3 Percent Revenues needed to breakeven 12
