Hey, I hope fishies could help me out here... Is there a model for:

Given item goes on varying % discount at different frequencies in a year and client receives varying funding depth from vendor to support the % discount, what is the average funding $ across the year?

For example, item cost $10, price $15. It goes to 50% disc 4 wks/yr with funding $2.50; 25% disc 8 wks/yr with funding of $1.50. What should the avg funding $ across the year? It needs to consider greater sales at deeper disc lvl

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

Is it just rules-based model? What’s your challenges? If all frequencies & numbers are provided, case when statements within sql or if else with Python can simply be applied to calculate the average?

like

The funding is provided for per unit sold. So despite the item going on 50% discount 4 wks/yr, we would disproportionately sell more units during that period. Discount % and sales volume is not linear increment but exponential? Wondering if there is a formula for it

like

You could potentially use excel’s sumproduct depending on size / shape data.

Eg, with your numbers you’d have percent of year as one vector (4/52, 8/52, 40/52) then the funding level (1.5, 2.5, 0) which would get you the avg funding for year.

The operation I think you want is weighted average, where weeks per year is the weight

Still think you’re in weighted average territory

Related Posts

Landed an interview tomorrow with Zendesk. I’m so excited for this! The role is for a business development representative. I have around 8 YOE in sales/client services. What kind of questions should I expect to answer in tomorrows interview? Also, can anyone give some insight on salary negotiation, schedule and benefits?

like

Confronted client today about partner forcing us to travel while client site has travel restrictions. As a result is team is remote next week. Counting down days till I get rolled off/fired now lol

like

Hi Advisors,
I gave one interview and Solve Game assessment for McKinsey & Company - Specialist / Teamlead role Client Capability Network CCN.
Could some one guide me.. on what will be the next steps in Interview and hiring process
How can I prepare for next rounds
What's approximate time taken for hirng cycle
What would be the base salary for this role

Current CTC 15L, 7YoE

Thank you
- McKinsey & Company

like

I have ADD and occasionally make small mistakes in my work, like leaving a word missing when editing sentences, small formatting errors or leaving an internal comment in drafts sent to clients. All partners have been very understanding and care about the quality of my work, and no client has ever complained. Partners and clients praise my work.

But now, one partner has become super mad and when I explained ADD, he said:

likefunny

I have one pro bono case that I kept when I left my firm to go in house. It’s a matter completely unrelated to my company and I have malpractice insurance through the nonprofit organization associated with the case. I’ve made clear to my client that I’m repping this client in my personal capacity. No one has asked me specifically about pro bono stuff at my company - if I know there’s no conflict of interest, is this something I should disclose? To whom should I disclose this?

like

When you successfully get away by using another client’s deliverable at your new client.

Post Photo
likefunny

Anyone know of any headhunter/recruitment firms for client-side marketing roles? (Nyc)

like
like

Sharks, is there any project release policy for Cognizant ? Kindly let me know from where i can get the policy ? I want to switch the project . Reason - No scope of learn new technology in the new project . Tata Consultancy Accenture India Wipro wipro IBM

like

Do I need a client experience letter for first time h1b visa stamping in India
when I work at Deloitte?

like

Please do not show to client before Partner review!

Post Photo
likefunny

I am working as a technology consultant specialist in PwC ac. As of now I'm working on an internal project of the company but i have received mail from a senior that if someone wants to volunteer for this project "financial service capital market- COI" should i opt or not? Will it be useful?

I am the president of our school board at Franklin Country School Corporation in Brookville, In. I would like to start a NASA Stem project starting in school year 2022-2023. Does anyone know where I need to start?

likehelpful

Public client seemed confused when I told them a copy of a JE and a one word description "void" wouldn't be sufficient evidence for the item selected for testing.

like

Guys, can you list down your experience in working with EY, which you are missing in your previous job. Or, something good at your previous job which is missing in EY. Please comment those. It can be anything like good project, managers, WFH, benefits, flexibilities, Hi, 

I want to cancel this 200Rs Netflix membership for this month. How to change this in my card settings, I am not able to find the settings in ICICI website to cancel this. 

like

Client: We need to speak to Millennials and Gen Z. But make it appeal to everyone.

Me: mAke iT aPpEal tO eVeRyOnE

Post Photo
likefunny

I want to be a client instead of an investment banker. Where do I sign up?

likefunny

For those who have asked to switch clients, does it make a drastic difference? Currently so bored with my main client but not sure if grass is always greener. Thanks.

likesmart

Need Suggestion.

I am the only developer in my team and my manager has assigned me a project in which I need to create a tool from scratch although that is currently running in production build by third party and we don't have access to that code.

I am on notice period and I am 100% sure that project won't be completed before my LWD.

What should I do, I asked him to put some extra team members but he didn't agree, seems like he will add extra team members 2-3 weeks before my LWD.

like

Hi All,
Need an help!

Help me choose :
Apexon 22 fixed client : Paypal
Virtusa 23.5 fixed
Which one should I join?


Virtusa Apexon

like

More Posts

Is anyone's agency currently looking for a Senior or ACD position?

How is it legal for agencies to make you work unpaid overtime on nights, weekends and holidays with the thinly veiled threat of losing your job for lack of "performance" ?

likesmart

Hi , I am 11 years Exp, and have an offer of 17.2 ( 16LPA fixed) Cracked AWS and waiting for salary negotiation. Can someone guide me how much should be the base pay , bonus and equity.

like

This might be a long shot but I'm looking for a volunteer who is trying to break into a federal career. Maybe a transitioning veteran, recent grad, or career-changer.

I'm pursuing my master career coaching cert and need to do a recorded 45-minute session. You don't have to be identified if you don't want to.

The single session is all I'm asking but could certainly turn into a longer lasting coaching relationship (at no cost), if you like.

like

Hello all, I am learning DSA on scalar. My only dream company is Microsoft .for me package and level doesn't matter. Just development role so minimum sde 1. And optional if possible wfh. I have 7 years of experience in DOTNET. I am NOT much confidence in DSA. So I need help and guide and support how can I join Microsoft. Right now possible? as I am already learning DSA and not much salary requirements. So can they take me as sde 1. Any view and guidance help to impossible to possible.

like

Hi guys. What's the status of Microsoft employees in India currently. Any firings going on due to market conditions? Microsoft

like
likehelpful

Need Suggestion.

I am the only developer in my team and my manager has assigned me a project in which I need to create a tool from scratch although that is currently running in production build by third party and we don't have access to that code.

I am on notice period and I am 100% sure that project won't be completed before my LWD.

What should I do, I asked him to put some extra team members but he didn't agree, seems like he will add extra team members 2-3 weeks before my LWD.

like

Cmon. Look at this guy.

Post Photo
like

How do you take care of your dog if you travel for work with your dog? Does your dog get enough exercises when you’re in travel? If it’s possible, I would like to know everything.

Ollie, yip yip!

Post Photo
like

What is the fastest way to sponsor a pup?

like

My dog keeps licking his paws. We think its because of all the salt on the ground from the snow, but getting worried his feet hurt. I am not sure he will like it if we get him shoes, what do y’all think?

like

Hi,
Need some advice. My pet had been eating his kebble food on a consistent basis. Then I introduced a bit of raw chicken into his kebble and loved having it even more. But now I'm realizing that if I don't add chicken, he just doesn't eat his regular kebble food. What should I do? (Don't want to feed chicken every day)

Can anyone tell what would CTC TCS offers for a 15.5 Exp resource. What would be the best designation one could expect to be offered with 15.5 years of exp.

like

Accenture Tata Consultancy Infosys Cognizant Wipro

Sharks, Can someone please refer me. 45 days remaining in LWD aur aosa dhak dhak ho raha hai ☹️.
Tech Stack: .Net Developer
Skills: MVC, .Net Core, WebAPI, jQuery, EntityFramework
YOE: 8.5
LWD: 30December

like

What IEP software/web service does your district use? My district has been converting from SEAS Achieve to SEAS Attain this year, but I’m curious about what else is out there.

likehelpful

Who all are coming to Sunburn this year?

like

How do you deal with students that say they don’t know what to do after you have repeated the directions multiple times?

like

Additional Posts in Data & Analytics Consultants

today I choose violence

Post Photo
funnylikesmartuplifting

Partner: Let’s take the data in the spreadsheet and put it in PowerBI so we can cut it up.

Me: What? It’s already cut up in the spreadsheet. I don’t get it.

Also me: Yeah! Analytics!

likefunny

Is anyone working with Elastic at DoD?

Noob question - I want to consolidate the dates into a single dates column. Would numpy or pandas help me reorganize this dataset effectively or should I do it within excel?

Post Photo
like

I am currently working mostly in Data Analytics, but I want to transition into Data Engineering. I've applied to a couple Data engineer positions but it seems I don't have the qualifications for them. Should I maybe look for Jr. Data Engineer positions to get experience and try to move up from there? If so anybody know of any Jr. Data Engineer positions available?

like

How does everyone in this bowl feel towards master’s degrees in data science/analytics? I didn’t study this in undergrad so I’m looking to get an analytics degree but I’ve heard mixed reviews.

like

Single book recommendation for user research?

Goal is interview prep. Ideally focused on applications in tech.

like

I'm planning to transition to Data Science. What should be the key technologies that i need to learn and add to my resume to make this work?

Thanks for your suggestions.

like

Meeting with a recruiter at one of the FAANG companies. I won’t be able to move jobs because of H1b /GC at least for the next year. Any idea if I should start off with that or should I just try to understand the work that they have been doing?

like

Accenture federal what’s the day to day like as a manager? Is it hands on or more review? Is there a lot of business development at the manager level?

like

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

Got Amazon career essentials (ACE) assessment to complete for Business Analyst role
To anyone who has experience with it- What kind of work simulation questions should I be expecting?
Is there a way I can prepare for it or any resources one must know of?

like
like

What do you think when associates/senior associates misspeak on a concept during a meeting or interview?

I’ve learned something new on each project, and I’m afraid of coming off as an idiot so I rarely contribute to conversations; only after I have done research on the topic and have prepared do I speak/give ideas

like

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

Have you ever failed to deliver? What was it and why?

like

Hello, Anyone here from Deloitte Omnia AI who could refer me for an open opportunity.

like

Can anyone at Ford Motor Company tell me more about the “Learning Analytics and Engagement Specialist” remote position? Very curious and would love a referral!

like

How is Deloitte’s Analytics and Cognitive practice doing? Saw a couple of open Data Science roles open on their website, are they actively hiring

like

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