Mini-HW Market survey_activity data_Final-1

xlsx

School

University of Idaho *

*We aren’t endorsed by this school

Course

416

Subject

Accounting

Date

Apr 3, 2024

Type

xlsx

Pages

25

Uploaded by ProfessorMaskChinchilla21

Report
Job Total Job Evaluation Points Cashier (C ) 180 Deli, Team Member (DTM) 198 Prepared Foods, Team Member (PTM) 220 Kitchen, Team Member (KTM) 230 Stock and Display, Team Member II (STM2) 230 Prepared Foods, Associate Team Leader (PATL) 250 Stock and Display, Team Member (STM) 255 Prepared Foods, Team Leader (PTL) 270 Regional Team Leader (RTL) 300
Task Q. Which job evaluation method is used to compute total job evalua
ation points?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Company Job # of Job Incumbents Base Pay (Ave) A Cashier (C ) 1 $ 21,000 B Cashier (C ) 2 $ 22,000 C Cashier (C ) 1 $ 18,000 D Cashier (C ) 2 $ 21,000 E Cashier (C ) 2 $ 18,500 F Cashier (C ) 1 $ 17,500 A Deli, Team Member (DTM) 4 $ 25,000 B Deli, Team Member (DTM) 4 $ 31,000 C Deli, Team Member (DTM) 3 $ 30,000 D Deli, Team Member (DTM) 5 $ 33,000 E Deli, Team Member (DTM) 4 $ 29,000 F Deli, Team Member (DTM) 4 $ 28,000 A Prepared Foods, Team Membe 2 $ 35,000 B Prepared Foods, Team Membe 3 $ 34,000 C Prepared Foods, Team Membe 1 $ 35,000 D Prepared Foods, Team Membe 3 $ 35,000 E Prepared Foods, Team Membe 2 $ 36,000 F Prepared Foods, Team Membe 2 $ 29,000 A Kitchen, Team Member (KTM) 2 $ 55,000 B Kitchen, Team Member (KTM) 4 $ 57,000 C Kitchen, Team Member (KTM) 3 $ 56,000 D Kitchen, Team Member (KTM) 5 $ 58,500 E Kitchen, Team Member (KTM) 3 $ 59,000 F Kitchen, Team Member (KTM) 3 $ 54,000 A Stock and Display, Team Mem 1 $ 62,000 B Stock and Display, Team Mem 2 $ 61,500 C Stock and Display, Team Mem 1 $ 60,000 D Stock and Display, Team Mem 3 $ 64,000 E Stock and Display, Team Mem 2 $ 63,000 F Stock and Display, Team Mem 1 $ 66,000 A Prepared Foods, Associate Te 2 $ 63,000 B Prepared Foods, Associate Te 1 $ 62,000 C Prepared Foods, Associate Te 1 $ 60,000 D Prepared Foods, Associate Te 1 $ 63,000 E Prepared Foods, Associate Te 2 $ 63,000 F Prepared Foods, Associate Te 2 $ 66,000 A Stock and Display, Team Mem 2 $ 62,000 B Stock and Display, Team Mem 2 $ 61,500 C Stock and Display, Team Mem 2 $ 60,000 D Stock and Display, Team Mem 3 $ 63,500 E Stock and Display, Team Mem 2 $ 65,000 F Stock and Display, Team Mem 4 $ 67,000 A Prepared Foods, Team Leader 1 $ 65,000 B Prepared Foods, Team Leader 1 $ 66,000 C Prepared Foods, Team Leader 1 $ 65,000 D Prepared Foods, Team Leader 1 $ 66,000
E Prepared Foods, Team Leader 1 $ 70,000 F Prepared Foods, Team Leader 1 $ 69,000 A Regional Team Leader (RTL) 1 $ 70,000 B Regional Team Leader (RTL) 1 $ 75,000 C Regional Team Leader (RTL) 1 $ 72,000 D Regional Team Leader (RTL) 1 $ 78,000 E Regional Team Leader (RTL) 1 $ 74,000 F Regional Team Leader (RTL) 1 $ 75,000
Min Max TotalBasePay $ 21,000 Tasks $ 21,000 $ 23,000 $ 44,000 1. Check variables in a $ 18,000 2. See how to compute $ 20,000 $ 22,000 $ 42,000 3. Understand why som $ 18,000 $ 19,000 $ 37,000 4. compute total base p $ 17,500 $ 21,000 $ 28,000 $ 100,000 $ 27,000 $ 34,500 $ 124,000 $ 29,000 $ 32,000 $ 90,000 $ 28,000 $ 34,000 $ 165,000 $ 27,000 $ 30,000 $ 116,000 $ 27,000 $ 30,000 $ 112,000 $ 34,000 $ 36,000 $ 70,000 $ 32,000 $ 35,000 $ 102,000 $ 35,000 $ 33,000 $ 37,000 $ 105,000 $ 35,000 $ 37,000 $ 72,000 $ 27,000 $ 31,000 $ 58,000 $ 50,000 $ 60,000 $ 110,000 $ 54,000 $ 59,000 $ 228,000 $ 54,000 $ 58,000 $ 168,000 $ 52,000 $ 61,000 $ 292,500 $ 57,000 $ 61,000 $ 177,000 $ 53,000 $ 55,000 $ 162,000 $ 62,000 $ 61,000 $ 62,000 $ 123,000 $ 60,000 $ 62,000 $ 65,000 $ 192,000 $ 62,000 $ 64,000 $ 126,000 $ 66,000 $ 55,000 $ 67,000 $ 57,000 $ 61,000 $ 53,000 $ 55,000 $ 61,000 $ 63,000 $ 61,000 $ 62,000 $ 59,000 $ 61,000 $ 62,000 $ 65,000 $ 62,000 $ 64,000 $ 64,000 $ 68,000
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
market survey e the total base pay me jobs have min and max values pay (Blue cells)
Jobs Total number of job Incumbants Cashier (C ) 9 Deli, Team Member (DTM) 24 Prepared Foods, Team Member (PTM) 13 Kitchen, Team Member (KTM) 20 Stock and Display, Team Member II (STM2) 10 Prepared Foods, Associate Team Leader (PATL) Stock and Display, Team Member (STM) Prepared Foods, Team Leader (PTL) Regional Team Leader (RTL) Tasks 1. Compute a total number of job incu 2. Compute sum of base pay for each 3. Compute Weighted means (blue cel 4. Compute simple means (grey cells) Q. Why do you think that we compute Weighted means of base pay should be calculated for each benchmark job from the survey data. Weighted means, as compared to simple means, are calculated to better represent the market data (Milkovich & Newman, 2008).
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Sum of basepay for each job Weighted means (verify) Simple Mean 179500 19944.4 19666.7 707000 29458.3 29333.3 442000 34000.0 34000.0 1137500 56875.0 56583.3 629000 62900.0 62750.0 umbants (green cells) job (yellow cells) lls) ) e weighted means? A simple mean would be calculated by adding up the average base pay rates and dividing by the number of organizations; but small and large companies would both be given the same weight if using a simple mean. A weighted mean gives equal weight to each job incumbent’s wage and thus is more representative of the data.
Regression Analysis Job Evaluation Weighted Task Points Avg $ 1. Fill out Labels x (JobEvalP) y (WeightedAvg) 2. Using t Cashier (C ) 180 $ 19,944.44 3. In your Deli, Team Member (DTM) 198 $ 29,458.33 4. Interpr Prepared Foods, Team Member (P 220 $ 34,000.00 Kitchen, Team Member (KTM) 230 $ 56,875.00 Stock and Display, Team Member I 230 $ 62,900.00 Prepared Foods, Associate Team L 250 Stock and Display, Team Member 255 Prepared Foods, Team Leader (PTL 270 Regional Team Leader (RTL) 300 To perform a simple regression 1.        Install “Analysis ToolPak” in Add-ins in Options (File->Options->Add-ins->Analysis T 2.        Now, you can see “Data Analysis” in “Data”. 3.        Click on “Data Analysis”. 4.        Select “Regression” 5.        Select “Input Y Range” and “Input X Range” including cells of labels. 6.        Select “Line Fit Plot” and “Worksheet” and enter the spreadsheet label. 7.        In the Output spreadsheet, make the plot larger and change the chart type.
t the green cells using the computed weighted means in the previous spreads the data in the table, perform a simple regression and report your result by cr r OUTPUT spreadsheet, you must have the following information (x coefficient ret the result (x-coefficient and p-value) in your output 1) x-coefficient: explain what the $ value of x-coefficent means 2) p-value ToolPak):(see also the slide: Excel-Install Data Anal Toolpak in the class site)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
sheet reating a new worksheet (label it OUTPUT) t and p-value, R-square, the market line): see the output (example) spreadsh
heet
SUMMARY OUTPUT Regression Statistics Multiple R 0.9011687461127 R Square 0.8121051089704 * The highest value should be 1. 0.8 or 0.9 is good in t Adjusted R 0.7494734786271 Standard E 9217.3925145025 Observatio 5 ANOVA df SS MS F ignificance F Regression 1 1.1E+09 1.1E+09 12.96637 0.036739 * = p-value Residual 3 2.55E+08 84960325 Total 4 1.36E+09 Coefficients tandard Erro t Stat P-value Lower 95%Upper 95% Intercept -119180.1240928 44573.35 -2.673798 0.075446 -261032 22672.17 x (JobEvalP 755.27258077879 209.7464 3.600885 0.036739 87.76602 1422.779 * Check if the p-value is <.05 (le RESIDUAL OUTPUT Observation dicted y (WeightedA Residuals 1 16768.94044739 3175.5 2 30363.846901409 -905.5169 3 46979.843678542 -12979.84 4 54532.56948633 2342.431 5 54532.56948633 8367.431
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
this context. e of X in simple regression) Lower 95.0% Upper 95.0% -261032 22672.17 87.76602 1422.779 ess than 5%) * Two lines: light green (original value 170 180 190 $- $10,000.00 $20,000.00 $30,000.00 $40,000.00 $50,000.00 $60,000.00 $70,000.00 x (JobEv y (WeightedAv y (WeightedAvg)
es) & dark green (predicted values) 200 210 220 230 240 valP) Line Fit Plot vg) Predicted y (WeightedAvg) x (JobEvalP)
Job Predicted Pay ($) Cashier (C ) - Deli, Team Member (DTM) Prepared Foods, Team Member (PTM) Kitchen, Team Member (KTM) Stock and Display, Team Member II (STM2) Prepared Foods, Associate Team Leader (PATL) Stock and Display, Team Member (STM) Prepared Foods, Team Leader (PTL) Regional Team Leader (RTL) Simple Regression Y=intercept+slope*X
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Intercept Slope (beta) TotalJobEvalPoint 180 Task 198 1. Fill out 220 230 230 250 255 270 300
t yellow, blue, and green cells
Job Predicted Pay ($) LeadPayPolicyRate Cashier (C ) - 3% Deli, Team Member (DTM) - 3% Prepared Foods, Team Member (PTM) - 3% Kitchen, Team Member (KTM) - 3% Stock and Display, Team Member II (ST - 3% Prepared Foods, Associate Team Leader - 3% Stock and Display, Team Member (STM) - 3% Prepared Foods, Team Leader (PTL) - 3% Regional Team Leader (RTL) - 3% Predicted pay with lead pay policy= Job's Predicted Pay Rate * 1.03 * These results are on a pay-policy line with 3% lead pay policy
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Predicted Pay with Lead Policy Task: Fill out the yellow cells
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Job Predicted Pay ($) Cashier (C ) - Deli, Team Member (DTM) - Prepared Foods, Team Member (PTM) - Kitchen, Team Member (KTM) - Stock and Display, Team Member II (STM2) - Prepared Foods, Associate Team Leader (PATL - Stock and Display, Team Member (STM) - Prepared Foods, Team Leader (PTL) - Regional Team Leader (RTL) - * These results are on a pay-policy line with -3% lag pay policy
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
LagPayPolicyRate Predicted Pay with Lag Policy -3% Task: Fill -3% -3% -3% -3% -3% -3% -3% -3%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
out the yellow cells
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help