turnover

Hi, I have the yearly turnover target for a company and would like to calculate the monthly, weekly and daily targets to meet the yearly. I want to be able to put the actual daily revenue and automatically recalculate the next day target and the next month target. For example if my yearly...

I am trying to find Employee turnover by Year/Company I have and employee table and I have created a Calendar table The employee table has the following columns ID Hire Date Term Date Company Active Status I would like to createa dashboard to show by Company turnover % by Year (2018 &...

Hi all, It drives me crazy but I don't understand why it does not work. Excel gives me always #VALUE! Those formulas should automatically add the new values in the chart created where in the column A there is ''MONTH'' and in the column B ''TURNOVER'' Here is the formula for the turnover...

Hi, I need some help please, I work with a basket of products that fall under different groupings (a,b,c) I want to execute a price increase on my turnover and of x percent but I want to make group "A" increase by a certain percentage only and then be able to calculate the increase on the rest...

Dear I have a question to you. Im using SUMPRODUCT for some querry and its perfectli works if at criteria Im using onlu one paramiter for one comumn. But now I want to use two parameters for one of columns. Simple example below Month Turnover ……. Jan 1 Feb 2 March 3...

Hi everyone, Apologies if my question has been posted or solved before, however I could not find so here I go. I have a series of HR headcount data, which contains various columns of 1's and 0's. I am trying to figure out turnover or attrition, but I would like to calculate this within a...

Hello, all. I can't find this question referenced in the forum before. I have a sheet where Column 'A' always remains the same each year I use it. But I always add columns between column 'A' and 'C' each year, like this: Year 1 <tbody> 2017 2016 Turnover </tbody> Year 2 <tbody>...

Hi, Hopefully somebody can help me with this as it is puzzling me. I am trying to auto add the total annual sales for a group of products as follows: Tab "Customer Analysis" - cell F8 = total annual turnover of a group of products, I have one tab with a product group (Data) and one tab with...

I need help calculating a 12 month rolling average for employee turnover for the month of January. After I get the turnover, then I need to display this in a graph or sort. I'm lost. I know how to do the rolling average for each the turnover and the headcount, then calculate Jan turnover, BUT...

I am trying to calculate turnover for contract to hire employees, Over the course of the last 6 months we have: 937 total number of employees hired 283 separations 307 were hired after their contract 347 still work for us Is our turnover percentage seperations(283)/total employees(937) *100?

I'm working on metrics for our inventory Days on hand. Let's say I have a table with weekly inventory information, a table with weekly sales information and a calender date table. I need everything is linked together by an Item table and the date table. To calculate my days on hand I need...