Blanket Formula for revenue estimating

Our take

Estimating revenue efficiently can transform how you manage your fruit shop's purchasing data. You're on the right track with your purchase ledger breakdown, but it sounds like you need a streamlined formula to automate calculations. By leveraging your existing data, you can create a formula that identifies items, retrieves their quantities, and multiplies these by their respective prices—like calculating that 3 apples at $0.50 each totals $1.50. Let’s explore how to simplify this process and enhance your revenue estimation seamlessly.

Hi,

I'm trying to find a way to estimate revenue, I posted earlier today about a Hypothetical fruit shop so i'm going to continue with that.

Earlier someone helped me an amazing formula to read and return Values from a purchase ledger. This worked and was able to return my values, but now I cant figure out how to get it all to calculate the actual $ amount.

For my earlier example i used

Johnny bought 5x apples granny smith 3x oranges 3x strawberry

Lisa bought 1x pineapple Large fresh 2x blueberry packaged 1x grape bunch large

Kerry bought 9 x apple loose 1 x Banana bunch 5x kiwi

I now have a sheet where i can copy and paste my purchase ledger and it breaks it down

https://preview.redd.it/29afs6w32dvg1.png?width=145&format=png&auto=webp&s=a9949aba4b23dbac4f83c6bb982e4bdf6dfff5aa

What i can't figure out is how to get it all to calculate without having to do loads and loads of tedious work. I need it to read Apples, then than the quantity and give me the result. So lets say an Apple is 0.50c then i want it to Find Apples, find the value and times by 3 to give me $1.50. Hopefully this makes sense as its quite long winded

submitted by /u/Intelligent_Let7166
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Blanket Formula for revenue estimating

Related Articles