Monetary Cost of Social Media - Prior to Research
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGH
1
2
Hourly Rate$7.25I was wondering how I can calculate the ROI of doing social media. The total figure of $7,860 is based initially 'doing' social media for three months... just to see "where everything goes" I did this prior to doing research. I figured quantifying the hours would be enough. This is a simple practice quantification with not much thinking or analysis needed. I'm now doing the actual 'homework' and it's looking like a lot of work... coming up with a formula, specifically.
3
Project Length (in months)3
4
# of Work Days Per Week4
5
6
Honestly, I did not put much effort into verifying my formulas. I WONDER IF THE FIGURE IS CORRECT. MAYBE I DID A TYPO OR LOGICAL ERROR SOMEWHERE?!?!?! YOU'RE COMMENTS ARE WELCOME.
7
8
TASKONE-TIME (hrs)PER DAY (hrs)PER WEEK (hrs)PER MONTH (hrs)PROJECT DURATION (hrs)ONE-TIME COSTTOTAL COST
9
strategic planning and research20141648$145.00$493.00
10
project management tasks20141648$145.00$493.00
11
twitter30.251412$21.75$108.75
12
facebook3141648$21.75$369.75
13
youtube50.52824$36.25$210.25
14
content generation231248144$14.50$1,058.50
15
training and user support50.251412$36.25$123.25
16
reports50.52824$36.25$210.25
17
meetings20000$14.50$14.50
18
$471.25$7,860.00
19
20
21
22
Loading...
 
 
 
Sheet1
Sheet2
Sheet3