I have attached an excel file with this question. Please don’t just input numbers but input all the formulas. So if i place my mouse on the excel cells, it should show me the formulas that was used to obtain the answers.
Students should refer to BH text Chapter 4 if you need help understanding the theory/problem
For Excel extra credit assignment fill in the yellow fields. The cells in the exercise must be
1. Smarmy Sales, Inc (SSI) sells herbal remedies through its Web site and through phone reps. Over the past six
Productivity (b):Productivit Productivity
(Sales/Phon y (Sales/Web (Sales/Total
Calculate productivity for the phone reps for each of the past six years.
Calculate productivity for the Web site for each of the past six years.
Calculate multi-factor productivity score for each year where input is the total amount spent on both the phone reps and the Web site.
Examine all three productvity measures and comment on the results by comparing productivity.
2. (PRODUCTIVITY). Various financial data for SunPath Manufacturing for 2012 & 2013 follow:
Productivity = Outputs/Inputs
Change in Productivity is found by subtracting
old from new for the difference, then dividing
the difference by old.
What is SunPath’s total productivity measure in 2012? in 2013? What is the percentage change between 2012 and
What is the labor productivity measure for SunPath in 2012? in 2013? What is the percentage change between
2012 and 2013?
What is the capital expenses productivity measure for SunPath in 2012? in 2013? What is the percentage change
between 2012 and 2013?
Without calculation, but using the 3 different measures calculated in parts a, b, and c, what conclusions can you
draw about the productivity of the other accounts (Materials, Energy, Other)?
Answer Write down your answer, please print!
Purchase answer to see full