80 likes | 221 Views
Shelving Store Budget. Shelving Store Actual. $ Over/(Under). % Over/(Under). Net Revenues. 100,000. 171,170. 71,170. 71.2%. Cost of Goods Sold. 42,310 55.0%. 74,101 57.3%. 31,791. 75.1%. Freight Incurred. 21,940. 35,267. 13,327. 60.7%. Gross Profit on Revenue. 35,750.
E N D
Shelving Store Budget Shelving Store Actual $ Over/(Under) % Over/(Under) Net Revenues 100,000 171,170 71,170 71.2% Cost of Goods Sold 42,310 55.0% 74,101 57.3% 31,791 75.1% Freight Incurred 21,940 35,267 13,327 60.7% Gross Profit on Revenue 35,750 61,802 26,052 72.9% Gross Profit % 35.8% 36.1% 0.3% 0.8% Advertising 8,000 8,954 954 11.9% CC Fees (est.) & Web Site Fees 3,565 5,360 1,795 50.4% Web Services 6,000 6,000 -- -- Profit / (Loss) from Operations** 18,185 41,488 23,303 128.1% Profit / (Loss) on Revenues 18.2% 24.2% 6.0% 33.0%
Revenues exceeded Budget by 71.2% for the month Gross Profit exceeded Budget by 72.9% for the month Monthly Freight Expense reported was $35,267; Freight Collected from Customers $41,772; Actual collected exceeded incurred by $6,505 – Freight reported includes $2,900 estimated costs for drop shipments and inbound freight
Advertising exceeded Budget by 11.9% for the month. Advertising includes PPC, CSE and affiliates Credit Card fees are shown at 3% of sales Website costs reflect 50% Brand Labs costs ($6,000) in both 2010 Budget and 2010 Actual numbers.
Shelving Store Budget Shelving Store Actual $ Over/(Under) % Over/(Under) Net Revenues 900,000 1,192,661 292,661 32.5% Cost of Goods Sold 380,790 55.0% 519,287 57.9% 138,497 2.9% 36.4% Freight Incurred 197,460 243,177 45,717 23.2% Gross Profit on Revenue 321,750 430,197 108,447 33.7% Gross Profit % 35.8% 36.1% 0.3% 0.8% Advertising 72,000 75,603 3,603 5.0% CC Fees (est.) & Web Site Fees 32,085 37,805 5,720 17.8% Web Services 67,419 67,419 -- -- Profit / (Loss) from Operations** 150,246 249,370 99,124 66.0% Profit / (Loss) on Revenues 16.7% 20.9% 4.2% 25.1%
Revenues have exceeded projections by $292,661 during 2010 Reported freight expense for 2010 is $243,177 as reported from bills and estimates; Freight Collected from Customers is $295,338; Collected exceeds incurred by $52,161. Advertising spent is 5.0% over budget Website costs reflect 100% of Brand Labs costs in both 2010 Budget and 2010 Actual numbers. Profit for 2010 is $249,370 from Operations, 20.9% of revenue Financial Issues