contribution

PRODUCT. SALES. CONTRIBUTION A. $250. 25% B $350. 35% C. $100 10% D. $300 30% I am trying to build a simple tool to update contribution % based on user input (new sales volume) for a...

Hi, I hope I manage to explain this in a way that makes sence. I have two departments which are rated by customers every week. Calculating the change in average score for each department is simple enough, but I need a formula that calculates hos much each department has contributed to the...

Dear, Every month I receive a sales sheet similar to the one attached below. To do a year to date sales sheet I manually copy the new sales sheet and paste it under the old sales sheet. Then I do a pivot table and some interactive charts I learnt recently. The challenge I am facing is...

Hello All. I have an issue in my loop and I have no idea why it's not working. Can anyone please help me. It's the only thing (so far) holding me back from completing this project. In my Payroll project there is a time, every 2 to 3 years, our Government National Insurance Service (a.k.a. NIS)...

Hi all, I need some help figuring out how to pick up data from one tab within an excel workbook and transposing some of that data onto another tab. Basically, I have a list of names, addresses, and monetary values with a drop down list of answers (yes or no). If the answer is yes I want...

Driving Table TL_Lookup Empl # Name Trad calc Method Roth calc Method AGE Trad Amt Roth Amt Rate 004 SMITH,JOHN Gross Pay 36 22 25 076 CORTEZ,JANELLE Default 49 140 16.5 137...

SQL View: a view created from SQL query from different tables Unpivot SQL View: and unpivot version of table created in point 1 through power query Report : Desired presentation Objective: adding contribution column next to sales column where contribution is total sales - total prime cost...

I am working with calculations that result in percentages (Rate = Commission / Sales) based on sales and commission for several products. I would like to take the results one step further by determining the contribution that each product makes to the total rate, i.e. I need to be able to...