[SOLVED] Working Out Gross Revenue minus cost of goods sold

**hanlemc** · 07-12-2021, 09:39 AM

Hi!

I have been asked to work out the gross revenue of men's sales for the last 6 months. Is this as simple as units sold x RRP or does it need to be units sold x RRP - COGS? If its more complicated I have attached a sheet with some sample data as I don't know how to work out this data.

Thanks
Hannah

**Croweater** · 07-13-2021, 03:13 AM

From the very limited data provided...

Gross REVENUE would be Units Sold * RRP.
Gross PROFIT would be Units Sold * (RRP-CostPrice)

**torachan** · 07-13-2021, 07:55 AM

Some thing along the lines of the attached - simple formulas in cells of the table.

**Croweater** · 07-13-2021, 09:04 AM

Just wondering where you got those overheads from? Did I miss something or did you make it up?

What did you include in your overheads to come up with a Net Profit?

**torachan** · 07-13-2021, 09:29 AM

just a made up figure - to extend the table to differentiate nett from gross.

[SOLVED] Working Out Gross Revenue minus cost of goods sold

LinkBack

Thread Tools

Rate This Thread

Display

[SOLVED] Working Out Gross Revenue minus cost of goods sold

Re: Working Out Gross Revenue minus cost of goods sold

Re: Working Out Gross Revenue minus cost of goods sold

Re: Working Out Gross Revenue minus cost of goods sold

Re: Working Out Gross Revenue minus cost of goods sold

Thread Information

Users Browsing this Thread

Similar Threads

Calculate the correct cost of goods sold using FIFO

[SOLVED] I need help calculating Cost of Goods Sold in Multi Sku Inventory Tracking Model Please!!

Calculating Asking Price Based on Cost of Goods Sold

Costs Price Profit and Cost of goods sold

cost of goods sold formula

array formulas to determine cost of goods sold

Complex Array Formulas for cost of goods sold valuation

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions