Hey keen to tap into the collective wisdom in the room...

Is there an excel formula for retail pricing of different size variants of products? The larger the pack size, the cheaper the per unit price. For example, the price per unit ($/ml) should be cheaper for a 10L detergent vs 2L detergent.

The formula should be non-linear but exponential. Would be good if the formula allows me to just put in the pack size variables and discount limits, and informs the price accordingly. Thanks!

likefunny
Posting as :
works at
You are currently posting as works at

There is no assumed relationship for this… every product would be different. Proctor and Gamble doesn’t just have a magic formula they plug in the package size etc. and a price is output for their detergent…

Best you could do is a non-linear regression analysis on existing products. That would output a formula you could then plug your known values into and output a price

like

Is there any particular reference material you could point me towards? Cheers!

like

Related Posts

Hi everyone! First time using this app. I always wondered, how are other IT help desk jobs? I’ll share how mine is.
I work at an MSP (Managed Service Provider) meaning we are the IT services for many other companies. It’s busy all the time and I get to experience all different types of apps, OSes, and almost every aspect of IT in this way. I make around 50k which is alright but its hectic as there’s too many tickets and not enough personnel. I heard this is common but I’m not sure.

like

Hello Barclays folks,
Good evening!!
I will be joining on 14th nov. I heard that if the bank account details are not updated before the 15th salary will not get credited for that month and I need to wait for next month for full payment.please let me know where to update and what's the lastdate

like

🐠 Fam - What’s a good whiteboard solution for my home office? What do you use and from where do I get it? Thanks!

like

If I had a traditional IRA before being employed in a 401k eligible role, can / must I roll that IRA into the 401k or can I leave the accounts separate without deleterious tax consequences?

like

Laid off after Thanksgiving. 54. Not done yet. Plenty to offer. In Detroit but ready and able to move anywhere. AD/CD. Hangin in there. How bout you?

like

2022 marketing wrapped

Post Photo
funnylike

McKinsey & Company Hi fishes, is Mckinsey Client Capability Network different from Mckinsey Digital? Also, what are the hierarchies such as analyst, senior analyst and all in CNN? McKinsey & Company

like

What are tips for salary negotiations? I'm fairly new to my registered representative role so I'm not sure if that'll impact my ability to negotiate? Any insights or tips will be greatly appreciated.

like

I am concerned with fulfilling billable hours requirement. I’m required to hit 2100 hours yearly and I’m at ~1,500 hours and I think I’ll hit 150-180hours this month. What will happen if I don’t hit my targeted amount by the end of my year.

likehelpful

Thoughts on PJT strategic advisory?

like

Hi Folks. Switching from product base to service base at level 9 in accenture in SAP Domain .
Can some1 explain how the journey starts from day 1.
Heard Noise abt client interviews , bench process,layoffs etc etc.
Need Serious Comforting advise.

like

Just curious, how many of the people who are very active on the Politics bowl women. It may not hurt to hear what they care. I get a sense that dudes from both sides seem to be speaking for you.....

like

Terrible culture at Moelis true?

like

Is it weird that I'm ass3 and not yet driving client meetings or making page creates?

like
like

Everything crypto has gone from "this cryptocurrency has a price target of X because of its use case Y probably in 5 years" to "do you guys think poopoopeepee coin can 100x tomorrow? I'm considering investing my kid's college fund."

likesmart

Hi everyone! Any BCGDV folks on here who can help me prep for a product manager interview? I had an intro call with the recruiter and he mentioned that I was supposed to do a presentation on Growth, monetization strategies. Can you please connect with me or comment below so I can reach out to you? I am super passionate about landing the job and any help would be greatly appreciated. Thanks a ton!

like

Hi Account friends! It’s the start of a new year and I was hoping you all could share any book / newsletter / blog / course recommendations that help keep you up to snuff. Feeling a bit stale and like the last year has been a tactical grind. I want to brush up on modern thinking for our industry - the latest and greatest marketing books, strategy perspectives, creative self help, etc. to feel more alive as we start 2022.

Comment your favs and THANK YOU in advance!

like

Additional Posts in Data & Analytics Consultants

Newish to data analytics. Have some experience in power BI, sql, and R. I wanted to get some exposure to aws and saw the AWS cloud practitioner as an available course at my job. Is this cert worth it? Or should I try one of the more advanced ones ? The data analytics one for example but wasn’t sure if it would be difficult to get through as a beginner. Will it look good on my resume?

like

Is anyone working with Elastic at DoD?

Currently in consulting where I get to do data visualizations sometimes but not always, have an opportunity to shift to a data analytics focused role. Struggling to decide as I am not fully sure if I would be competent in/happy with daily data work. Advice, thoughts? 😣 I just never find what I like…

like
like

from God import pandemic
From China import coronavirus, mortality_rate

covid_19 = pandemic.coronavirus.set_mortality(mortality = 1.)

like

Big 4 Data Scientists, how did you exit to big tech firms? I’ve been unlucky with online applications and even referrals. I think it might be my resume or how I present myself. Can any free birds please give guidance?

like

What are the top sales & marketing metrics that tech companies track? I have an interview for a Data architect role and the data aspect is my strength but need to brush up on the business insight part

like

Hiring for data scientists and BI analysts across a couple levels, DM me if interested!!

like

What is a data lake in basic terms?

like

Anybody interviewed for a data engineer role for Facebook? I have a SQL and Python coding interview next, any idea on what to expect?

like

My manager continues to ask me to help other teams and do work on other billable projects. I’m sick of it .. and I’m going to explicitly say that no I can’t do it because my hours are taken by the existing project we are doing. Is this appropriate?

like

What are some interesting non-tech/insurance/advertising/consulting careers where data science is applied? Thinking of epidemiology and economics

like

Any conda users in here have to install a binary and use conda forge? Need some help installing pdftotext. Throwing a weird message saying “Found conflicts!” Any and all help would be appreciated.

like

Any cyber security folks here? or those interested in systems engineering? Potential role with TC 120-180, awesome team and wlb, at least compared to consulting.

like

Anyone have a ballpark range on dataiku price per seat or however they price? It looks like an interesting product.

This might be a long shot ... but I have a Statistics assignment due for tonight in a few hours

Does anyone know how to do Linear Discriminant Analysis with more than one predictor - by hand? I know how to compute in R but my professor wants it done by hand .... fml

likefunny

Is there a good online course on storytelling with data? Something that can help structure your thought process and design choices when creating visualizations and Dashboards in Tableau, Power BI etc.

like

Anyone know of an alternative to StackOverflow for asking tech questions? The community is super toxic and I'm looking for a place I can casually ask questions that might seem dumb without being hrangued for not providing an essay proof of the research I've already done. Or some sort of buddy system where I can ping a person of relevant experience those questions. It's better to poke someone's brain for a minute than to spin in circles reading docs/dead end articles sometimes.

like

Mεntal mαth in iηtervieωs. Thoughts, tips, rants, grievances?

like

Anyone who has done masters in business analytics Singapore? Could you help on courses, Scholarships and careers and jobs. Looking for help.

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal