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

Answer

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?

Answer

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?

Answer

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)?

Answer Write down your answer, please print!

Purchase answer to see full

attachment

Order your essay today and save **15%** with the discount code: VACCINE