# Excel Homework

Description

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.

Name
First
Last
Student 1
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
calculated fields.
1. Smarmy Sales, Inc (SSI) sells herbal remedies through its Web site and through phone reps. Over the past six
YEAR
TOTAL SALES
PHONE REP
COSTS
2012
2013
2014
2015
2016
2017
\$4,790,000
\$5,750,000
\$6,900,000
\$8,280,000
\$9,930,000
\$11,920,000
\$200,000
\$210,000
\$221,000
\$230,000
\$245,000
\$255,000
WEB
SITE
COSTS
\$50,000
\$65,000
\$85,000
\$110,000
\$145,000
\$190,000
Part (a):
Part
Part (d):
Productivity (b):Productivit Productivity
(Sales/Phon y (Sales/Web (Sales/Total
AVERAGE:
Part A.
Part B.
Part C.
Part D.
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:
Output
Inputs
2012
Sales
\$375,000
Labor
\$42,000
Materials
\$61,000
Energy
\$10,000
Capital expenses
\$188,000
Other
\$6,000
Total inputs
2013
\$390,000
\$42,500
\$63,000
\$11,000
\$190,000
\$6,250
Productivity = Outputs/Inputs
Change in Productivity is found by subtracting
old from new for the difference, then dividing
the difference by old.
Ex: (2013-2012)/2012
part A
What is SunPath’s total productivity measure in 2012? in 2013? What is the percentage change between 2012 and
2013?
Ratio
% Change
2012
2013
part B
What is the labor productivity measure for SunPath in 2012? in 2013? What is the percentage change between
2012 and 2013?
Ratio
% Change
2012
2013
part C
What is the capital expenses productivity measure for SunPath in 2012? in 2013? What is the percentage change
between 2012 and 2013?
Ratio
% Change
2012
2013
part D
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)?