Path A Technical Analysis with Excel
PLUS Final Stage
You are provided with an Excel template for HFFA
already set up for this scenario, to fill in with appropriate Excel formulas to
conduct the Matrix Map analyses.
You also have a pdf KEY for HFFA with the final
answer values shown.
You also have
the complete worked example for Everest Environmentalists INCLUDING FORMULAS
(which is more complicated than this assignment) which I have created for you
(and commented extensively).
Your task is to fill in all tables in the assignment
template spreadsheet for HFFA with proper Excel formulas to get the answers shown
in the key, AND to recreate the Matrix Map figure yourself using Excel’s
graphing tools on the indicated tab. If you can’t get the right answer in a
cell with your formula after comparing to key and checking the corresponding
cell in the Everest Environmentalists worked example spreadsheet, or if you
have trouble using the graphing tools to create the figure, please ask for help
if you need to. Since I am providing
the key, I am expecting your template to be fully accurate when turned in.
NOTE: YOU CANNOT GET CREDIT FOR SIMPLY
TYPING IN THE ANSWERS FROM THE KEY INTO THE CELLS OF THE TEMPLATE. YOU MUST
CREATE EXCEL FORMULAS TO GET THE ANSWERS.
FORMULAS START WITH =. I WILL CHECK, AND IF YOU ONLY ENTERED VALUES AND
NOT FORMULAS YOU WILL NOT GET CREDIT FOR THIS HALF OF THE MATRIX MAP ASSIGNMENT.
Once you have completed that Excel template, move on to the FINAL
STAGE (Word document) described below, which everyone must complete
regardless of path. You will upload two (2) files to the dropbox for this
assignment, the completed Excel template file PLUS the Final Stage Word
document.
you will also need (which are attached)
Everest Environmentalist Excel Example to help you (all worked) – goes along with the same example covered throughout the text
Healthy Food For All Excel Template (ready for you to fill in; this is your Path A assignment file (also need to complete Final Stage in Word doc per the instructions).
Healthy Food For All PDF KEY (so you can check and fix your template work as you go)
**** AND
(EVERYONE MUST DO) ****
FINAL STAGE – Everyone completes this
in Word
Finally, having completed either Part A or Part B, everyone
must write a narrative based on the Matrix Map for HFFA included in the pdf
Key. Write up the talk you would give the board and CEO about their current
business model as revealed by the Matrix Map AND summarizing your
recommendations for strategy moving forward given the information revealed.
Length should be about 750-1,000 words. Reflect both your understanding of the
readings for Modules 5 and 6, including the Bell, Masaoka and Zimmerman (2010) book
as well as your understanding of the HFFA context described in the scenario
earlier in this document and revealed through the analysis. Communicate as if
you were in fact dealing with your nonprofit leadership audience (professional,
layperson style), not as if you are writing to me (academic style). Write
clearly and professionally but do not condescend or be overly casual. Those who
chose Path A (Excel) will upload this document as a second file along with
their Excel file to the dropbox. Those who chose Path B (Conceptual) can
include the Final Stage as the last part of their Word document, and upload
just that one Word document to the dropbox. No one needs to upload the PDF
key, I have that already .
