Sweeteacha Tracker
https://communities.sas.com/kntur85557/tracker
Sweeteacha TrackerSat, 25 May 2024 02:47:39 GMT2024-05-25T02:47:39ZRe: Individual target to meet overall target
https://communities.sas.com/t5/SAS-Procedures/Individual-target-to-meet-overall-target/m-p/643616#M78459
<P>Thank you Steve.</P><P>I did similar to my merit increase model based on each employee performance ( high solid low) and their current salary based on market. We had specific % allocated per each 3*3 cell ( i.e high performance and high salary will get 2% increase, low performance and high salary will get 0% merit etc.) and did goal seek function to stay at our budget.</P><P>However on my current case that % is not allocated and need to do some kind of statistical modeling to have optimal %. I am not a statistician at any means but have solid understanding on the insides of model if somebody could guide me what model/test to apply based on my business case.</P><P>I will investigate linear programming. Do you have any article or link that is relevant ? Please do share.</P><P>Much appreciated</P><P> </P>Tue, 28 Apr 2020 14:20:05 GMThttps://communities.sas.com/t5/SAS-Procedures/Individual-target-to-meet-overall-target/m-p/643616#M78459Sweeteacha2020-04-28T14:20:05ZRe: Individual target to meet overall target
https://communities.sas.com/t5/SAS-Procedures/Individual-target-to-meet-overall-target/m-p/643564#M78457
<P>Actually I am struggling in the approach. Any idea to start? I will do some research if I get some direction</P>Tue, 28 Apr 2020 12:03:24 GMThttps://communities.sas.com/t5/SAS-Procedures/Individual-target-to-meet-overall-target/m-p/643564#M78457Sweeteacha2020-04-28T12:03:24ZRe: Individual target to meet overall target
https://communities.sas.com/t5/SAS-Procedures/Individual-target-to-meet-overall-target/m-p/643554#M78455
<P>Thank you Miller</P><P>I thought of 5% increase in all manager's current average sales. The only thing I was not sure is.... is it ok to have flat 5% to all of them because every sales manager has different in terms of # of product sales per day, the cost of product, etc. what if one manager is already exceeded the goal ,,, is it fair for him to again improve the sales by 5 %? </P><P>is there any way to adjust that?</P><P>I know its not straight forward.. I am here to seek some guidance as I am very lost here</P>Tue, 28 Apr 2020 11:46:46 GMThttps://communities.sas.com/t5/SAS-Procedures/Individual-target-to-meet-overall-target/m-p/643554#M78455Sweeteacha2020-04-28T11:46:46ZRe: Individual target to meet overall target
https://communities.sas.com/t5/SAS-Procedures/Individual-target-to-meet-overall-target/m-p/643515#M78453
<P>The average is calculated just by sum of total sales / # of rows</P><P>I need to have weighted target for each manager. Some manager have higher influence on average overall and their sales is skewed to right and some are in lower quartiles.</P><P>I am not sure how we can do but generally speaking if we want to target for each managers to meet the 5% increase goal how do we model it?</P>Tue, 28 Apr 2020 10:59:54 GMThttps://communities.sas.com/t5/SAS-Procedures/Individual-target-to-meet-overall-target/m-p/643515#M78453Sweeteacha2020-04-28T10:59:54ZIndividual target to meet overall target
https://communities.sas.com/t5/SAS-Procedures/Individual-target-to-meet-overall-target/m-p/643440#M78451
<P>Hi All</P><P>We have an average sales in X company and want to target for 5% increase in next year</P><P>So want to set up a goal for each sales manager to meet the overall goal</P><P>I have data like:</P><P>Manager name product sales</P><P> ABC A 2345</P><P>ABC B 2323</P><P>ASD A 3434</P><P>GHR G 2434</P><P> </P><P>So average of sales now = overall sales lets say 1234</P><P>Overall Goal = 5% increase in an average of sales i.e 1295 in end of 2020</P><P> </P><P>So want to set a target for individual manager how much each manger has to have average sales to meet overall goal</P><P>Given individual manager current average and variation, plus # of product sales, because some manager have sold 1000 and some juts 50…..how do we set up a goal for each manager?</P>Mon, 27 Apr 2020 23:31:34 GMThttps://communities.sas.com/t5/SAS-Procedures/Individual-target-to-meet-overall-target/m-p/643440#M78451Sweeteacha2020-04-27T23:31:34ZRe: Understanding each predictors weight on response variables
https://communities.sas.com/t5/Statistical-Procedures/Understanding-each-predictors-weight-on-response-variables/m-p/642877#M30767
<P>Hi Miller</P><P>I apologize for confusing title.</P><P>To summarize here is my two cases:</P><P>1. I want to understand how much each group has to reduce in an average to meet the goal of 5% reduction in average LOS.</P><P>Firstly I need to run a model how each group contribute to have an average overall LOS. And then .. now how much each group had to reduce compared to its weighted factor( some group have higher influence in los because some group consist of 50% of total patients and some have just 3 patients under that groups.. which means not all groups should be treated equal)</P><P>2. Now we need to find out which area should we focus among these top 3 contributer group? Theymay think we have higher LOS because we treat high risk patient or we treat medicare patients. So we have to run a model where if insurance is same, age of patient is same, severity is same, how each groups have a influence in LOS.</P><P>In general we want to know where should we focus to be honest and we are making up all these hypothesis among groups to first target.</P><P> </P><P>Does it make sense?</P><P> </P><P>Thank you in advance</P>Sat, 25 Apr 2020 14:02:38 GMThttps://communities.sas.com/t5/Statistical-Procedures/Understanding-each-predictors-weight-on-response-variables/m-p/642877#M30767Sweeteacha2020-04-25T14:02:38ZUnderstanding each predictors weight on response variables
https://communities.sas.com/t5/Statistical-Procedures/Understanding-each-predictors-weight-on-response-variables/m-p/642814#M30758
<P>Hi All</P><P>I have hospital's average LOS and want to reduce this by 5% in coming Fiscal year.</P><P>1.I want to understand how much each group ( 15 hospital groups ie cluster of physicans) should individually reduce to meet the goal of 5% reduction.</P><P>2. Also want to understand where/which area ( payor, physicians or groups etc.) should we focus to reduce the LOS? </P><P>I want to tell that if we focus on <STRONG>ABC physicians group and the payer/insurance xyz</STRONG> then we can reduce LOS by 5 % because ABC group when dealing with XYZ insurance has higher likelihood of having higher LOS </P><P> </P><P>Any guidance on this will be highly appreciated </P>Fri, 24 Apr 2020 23:35:37 GMThttps://communities.sas.com/t5/Statistical-Procedures/Understanding-each-predictors-weight-on-response-variables/m-p/642814#M30758Sweeteacha2020-04-24T23:35:37Z