1 / 8

Shelving Store Budget

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.

inez-kirk
Download Presentation

Shelving Store Budget

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. 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%

  2. 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

  3. 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.

  4. 2009/2010 REVENUES

  5. Freight

  6. 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%

  7. 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

More Related