Assess current performance of an organization through analysis of financial statements
Project Two Guidelines and Rubric1.html
Competency
In this project, you will demonstrate your mastery of the following competency:
- Assess current performance of an organization through analysis of financial statements.
Scenario
In Project One: Applying Strategic and Operational Thinking, you prepared Key Performance Indicators (KPIs) for the marketing and sales departments of your product line.
Now, the CEO has provided you with a revised set of KPIs. You need to apply these KPIs toward the analysis of a proposed marketing and sales initiative to increase loyalty card memberships in neighborhoods with predominantly low-income populations, whether the populations are in rural, suburban, or city locations.
The CEO wants this analysis so that she can chart the sustainability and growth of the initiative while assuring it meets standards for Corporate Social Responsibility.
The CEO has provided you with several documents, available in the Supporting Materials section of this project. She wants you to use the provided Triple Bottom Line Balanced Scorecard to assess the strategic plan’s compliance with the KPIs and summarize your findings in a memo.
Directions
Complete the following to provide the analysis required by the CEO:
- Identify the financial records that indicate commitment to TBL.
- Outline which financial and other records marketing and sales maintains where TBL can provide data.
- Using the TBL scorecard, evaluate the alignment of the strategic plan with KPIs. Remember, there may be multiple outcomes of this exercise. Your focus should be to apply your understanding of the scenario and evaluate the plan accordingly.
- Which ideas in the plan support the KPI criteria? Cite specific ideas that meet the criteria.
- Explain how they meet the criteria.
- In your memo:
- Describe how the TBL data relates to the KPIs.
- Identify which additional TBL financial line items are needed to measure the cost for each criterion. For example, should there be a line entry for hiring temporary workers?
- Referring back to the SWOT analyses from Project One, explain how functional considerations of individual departments contribute to financial performance.
What to Submit
To complete this project, you must submit the following:
KPI and Triple Bottom Line Balanced Scorecard
- Complete and submit the KPI and Triple Bottom Line Balanced Scorecard. In the scorecard spreadsheet, identify one additional KPI, a related SMART objective, and its measurement criterion. You need to do this for all three elements of TBL: people, planet, and profit. You have been provided with one example for each TBL element.
Analysis Memo
- In a Word document, write a memo outlining your analysis. Ensure that the memo is organized by TBL element with a header for each segment of your analysis. The Word document should use double-spacing, 12-point Times New Roman font, and one-inch margins. This memo should be no more than 6 pages in length, and include references cited in APA format. Consult the Shapiro Library APA Style Guide for more information on citations.
Supporting Materials
The following resource(s) may help support your work on the project:
The following resources support your work on the project:
Document: Consolidated Balance Sheet
This is a consolidated balance sheet for the company. The CEO has highlighted the areas of the financial statements she wants you to focus your attention and analysis on.
Document: Consolidated Cash Flow Statement
This is a consolidated cash flow statement for the company. The CEO has highlighted the areas of the financial statements she wants you to focus your attention and analysis on.
Document: Consolidated Income Statement
This document is a consolidated income statement and a consolidated statement of comprehensive income of the company. The CEO has highlighted the areas of the financial statements she wants you to focus your attention and analysis on.
Document: KPI and Triple Bottom Line Balanced Scorecard
This is the final and authoritative draft of the KPI Scorecard the CEO wants you to use. This scorecard provides three KPIs: one for a social measure (people); one for an environmental measure (planet) and one for an economic measure (profits). You need to identify three more KPIs and associated information.
Document: Marketing and Sales Executive Summary
This is a proposal from the sales and marketing departments to increase rewards memberships in low-income markets. This summary includes a high-level estimate of projected sales, costs, and profits.
Document: SWOT Analyses from Sales and Marketing
This document contains a combined SWOT analysis from the two departments.
Project Two Rubric
| Criteria | Exemplary (100%) | Proficient (90%) | Needs Improvement (70%) | Not Evident (0%) | Value |
|---|---|---|---|---|---|
| Financial Records | Exceeds proficiency in an exceptionally clear, insightful, sophisticated, or creative manner | Identifies key financial records that indicate commitment to triple bottom line (TBL) | Shows progress toward proficiency, but with errors or omissions; areas for improvement may include identifying appropriate financial records to assess the commitment to TBL | Does not attempt criterion | 18 |
| Evaluate for KPIs | Exceeds proficiency in an exceptionally clear, insightful, sophisticated, or creative manner | Evaluates the strategic plan for alignment with KPIs | Shows progress toward proficiency, but with errors or omissions; areas for improvement may include aligning KPIs with the TBL factors of people, profit and planet | Does not attempt criterion | 18 |
| TBL Data and KPIs | Exceeds proficiency in an exceptionally clear, insightful, sophisticated, or creative manner | Identifies appropriate KPIs related to each element of TBL using SMART objective setting and clear measurement criteria | Shows progress toward proficiency, but with errors or omissions; areas for improvement may include identifying appropriate KPIs related to at least one element of TBL using SMART objective setting and clear measurement criteria | Does not attempt criterion | 18 |
| Additional Line Items for Measuring Cost | Exceeds proficiency in an exceptionally clear, insightful, sophisticated, or creative manner | Identifies additional TBL financial lines needed to measure cost | Shows progress toward proficiency, but with errors or omissions; areas for improvement may include identifying the financial records and line items therein, which measure TBL performance | Does not attempt criterion | 18 |
| Functional Considerations | Exceeds proficiency in an exceptionally clear, insightful, sophisticated, or creative manner | Explains how functional considerations contribute to financial performance | Shows progress toward proficiency, but with errors or omissions; areas for improvement may include assessing the alignment of the departmental/ functional roles and their contributions to financial performance | Does not attempt criterion | 18 |
| Articulation of Response | Exceeds proficiency in an exceptionally clear, insightful, sophisticated, or creative manner | Clearly conveys meaning with correct grammar, sentence structure, and spelling, demonstrating an understanding of audience and purpose | Shows progress toward proficiency, but with errors in grammar, sentence structure, and spelling, negatively impacting readability | Submission has critical errors in grammar, sentence structure, and spelling, preventing understanding of ideas | 10 |
| Total: | 100% |
Course Documents/Consolidated Balance Sheet for Rewards Program Product Line.xlsx
Course Documents/Consolidated Cash Flow Statement for Rewards Program Product Line.xlsx
CFS
| Consolidated Cash Flow Statement | |||
| for the year ended 31 December | |||
| $ thousand | $ thousand | $ thousand | |
| 2018 | 2017 | 2016 | |
| Cash Flow from Operating Activities: | |||
| Net Income | $ 18,565 | $ 11,423 | 10,784 |
| Adjustments to Reconcile Net Income to | |||
| Net Cash Flow from Operating Activities | |||
| Change in Accounts receivable | (3,696) | (1,263) | (2,750) |
| Change in Inventory | (3,863) | (339) | (1,335) |
| Change in Prepaid expense | (925) | 16 | (2,250) |
| Depreciation and amortization | 1,000 | 890 | 800 |
| Change in Accounts Payable | 311 | 1,031 | (1,525) |
| Change in Short term debt | 1,078 | (4,765) | 240 |
| Change in Deferred revenue | (547) | 357 | 432 |
| Change in Other current liabilities | (4) | 99 | 33 |
| Net Cash Flow from Operating Activities | 11,919 | 7,449 | 4,429 |
| Cash Flow from Investing Activities: | |||
| Cost of new Property, buildings, and equipment purchased | (6,974) | (1,708) | (200) |
| Cost of new Intangible assets | (810) | (632) | - 0 |
| Cost of new Other current assets | (2,355) | (56) | (25) |
| Net Cash Flow: Investing Activities | (10,139) | (2,396) | (225) |
| Cash Flow from Financing Activities: | |||
| Payments of Long-term debt | (285) | (2,374) | (1,150) |
| Change in Other noncurrent liabilities | (7) | (854) | (24) |
| Issuance of Common Stock | 14 | 10 | - 0 |
| Change in Additional paid-in-capital | 1,347 | 120 | - 0 |
| Payment of Dividends | (1,000) | (1,000) | (1,000) |
| Net Cash Flow: Financing Activities | 69 | (4,098) | (2,174) |
| Total Cash Flow increase/(decrease) | 1,849 | 955 | 2,030 |
| Cash Balance, Beginning | 4,272 | 3,317 | 1,287 |
| Cash Balance, Ending December 31 | $ 6,121 | $ 4,272 | 3,317 |
Course Documents/Consolidated Income Statement for Rewards Product Line.xlsx
IS
| Consolidated Income Statement | |||||
| for the year ended 31 December | |||||
| $ thousand | $ thousand | $ thousand | |||
| 2018 | 2017 | 2016 | |||
| Sales Revenue | $ 174,090 | $ 150,000 | $ 130,000 | ||
| Cost of Goods Sold | 93,000 | 88,000 | 75,000 | ||
| Gross Profit | 81,090 | 62,000 | 55,000 | ||
| Operating Expenses: | |||||
| Selling expenses | |||||
| Salary expense | 35,000 | 29,000 | 24,500 | ||
| Advertising expense | 8,000 | 7,500 | 6,800 | ||
| Administration expense | |||||
| Depreciation and amortization expense | 1,000 | 890 | 750 | ||
| Salary expense | 10,800 | 8,700 | 7,500 | ||
| Other Operating Expenses | 2,200 | 1,900 | 1,400 | ||
| Total Operating Expenses | 57,000 | 47,990 | 40,950 | ||
| Operating Income | 24,090 | 14,010 | 14,050 | ||
| Other Revenue and (Expenses) | |||||
| Charitable donations | 500 | 450 | 400 | ||
| Total Other Revenues and Expenses | 500 | 450 | 400 | ||
| Income Before Income Tax | 23,590 | 13,560 | 13,650 | ||
| Income Tax Expense | 5,025 | 2,137 | 2,867 | ||
| Net Income | $ 18,565 | $ 11,423 | $ 10,784 | ||
Question to consider - Our TBL strategies include giving back to the low-income neighborhoods we are targeting. Does our charitable giving reflect that increased support to those neighborhoods?
Questions to consider - - Are we seeing year-over-year growth in revenues? - Is this growth attributable to our CSR and TBL efforts?
Question to consider - - Are we hiring to support TTL efforts and objectives?
Question to consider - - Are we hiring to support TTL efforts and objectives?
Course Documents/KPI and Triple Bottom Line Balanced Scorecard.xlsx
KPI TBL BSC
| KPI and Triple Bottom Line Balanced Scorecard (Marketing and Sales) | ||||
| Bottom Line | Areas of Impact (Key Performance Indicators) | SMART Objective | Measurement Criterion | |
| People | To be a global contributor to the communities we operate in. | |||
| Example: Community contributions based on points achieved | $50,000 by EOY 2021 | Charitable contributions from program | ||
| Identify one additional people-focused KPI, a related SMART objective, and its measurement criterion in this row. | ||||
| Planet | To promote and use a platform of reuse, recycling, and sustainable energy use. | |||
| Example: Reduction in packaging costs from recycled materials | 3% Reduction by EOY 2021 | Cost of packaging | ||
| Identify one additional planet-focused KPI, a related SMART objective, and its measurement criterion in this row. | ||||
| Profit | To reach a global audience with healthy and sustainable products. | |||
| Example: Grow market share | 1% increase by EOY 2021 | Market share performance tracking | ||
| Identify one additional profit-focused KPI, a related SMART objective, and its measurement criterion in this row. | ||||
Course Documents/MBA 500 Projects Two and Three Marketing and Sales Executive Summary.pdf
Executive Summary
Sales and Marketing Proposal to Increase Rewards Memberships
in Low‐Income Markets
The U.S. Federal Government’s definitions of low income are tied to regional income demographics. For our
campaign, we define low income as being at 100–200% of the national average poverty line for the 48 contiguous
states:
Persons in Household
48 Contiguous States and D.C. Poverty Guidelines (Annual)
100% 133% 138% 150% 200%
1 $12,760 $16,971 $17,609 $19,140 $25,520
2 $17,240 $22,929 $23,791 $25,860 $34,480
3 $21,720 $28,888 $29,974 $32,580 $43,440
4 $26,200 $34,846 $36,156 $39,300 $52,400
5 $30,680 $40,804 $42,338 $46,020 $61,360
6 $35,160 $46,763 $48,521 $52,740 $70,320
7 $39,640 $52,721 $54,703 $59,460 $79,280
8 $44,120 $58,680 $60,886 $66,180 $88,240 Source: 2020 Health & Human Services Poverty Guidelines / Federal Poverty Levels
According to the U.S. Census Bureau, the total percent of households with incomes up to $49,999 is 37.1%.
Low‐income populations represent a large untapped market for our company’s rewards membership program.
However, drawing customers of limited means to this program will require marketing and sales strategies that are
creative, ethical, and mutually beneficial.
What We Are Proposing
Our loyalty membership program is proposing a marketing and sales initiative to increase loyalty card
memberships in low‐income neighborhoods.
Specifically, we aim to improve the quality of life for both our customers/members and their communities through
incentives tied to the membership:
Our consumers would earn points based on their individual purchases. Their communities would earn points based on both the number of members in the community and the
total purchases those loyalty members make.
Low‐income consumers would realize the benefits of points earned through our program membership. At the
same time, points earned in aggregate by communities via purchases would be converted into charitable
donations to nonprofit organizations or schools that serve the neighborhoods or regions of our low‐income
members.
Considerations of the Target Market
As previously mentioned, a key consideration of this initiative is eliminating barriers to access.
According to the Pew Research Center, among households with incomes below $30,000 a year in 2019, roughly
30% did not own a smartphone, 46% did not have a desktop or laptop computer, and 44% did not have broadband
Internet access. According to a recent survey by the FDIC, 25% of U.S. households are “unbanked” or
“underbanked.” An “unbanked consumer has no bank accounts of any kind—no savings, no checking, no loans. An
“underbanked” consumer may have a savings and/or a checking account but may also use nonbanking financial
outlets such payday loan or check‐cashing services.
In contrast, our current typical rewards member has a household income of $85,000 a year and purchases their
membership online with a credit or debit card. Most purchases and points redemptions made through this
membership are also done online.
How to Reach Our New Target Market
While social media marketing strategies should still be employed, the missing or reduced access to Internet
technologies among low‐income populations indicate a need for additional channels.
Direct mailings to individuals in the targeted areas will be one option. But because many of the members of the
community may not be on the mailing lists, we will want to go beyond direct mail.
We would also use a temporary hiring agency to recruit members of the community to distribute leaflets and fliers
to their neighbors, and to place them in community centers and other public spaces. By “other public spaces,” we
include such strategies as tacking or taping fliers on trees and buildings in the neighborhood, placing fliers under
car windshields wipers, handing fliers out on busy intersections, creating doorknob tags, or stuffing fliers into
mailboxes. Which combination of outreach tactics we use would depend on the geography and infrastructure of
the community.
To augment the youth market outreach, we propose two approaches. First, we will partner with high schools to
create a card that can be customized to use school colors, logos, and mascots. In return, the schools will receive a
regular donation from us based on a percent of sales generated by those who carry and use the school‐associated
loyalty card.
As an extension of the school partnership, we will identify students who are influencers among their peers. We will
recruit them to be ambassadors via discounted memberships and membership points awards credited to their
accounts. Because we want to reach younger adults who are emerging buyers, these ambassadors will receive t‐
shirts branded with our logo and the school’s mascot so that being a part of the rewards program is associated
with peer activities and considered “cool.”
The rewards to ambassador accounts will be based on the growth of memberships associated with the high school
card. Memberships can come from other students or their family members.
Secondly, we also propose partnering directly with brick‐and‐mortar merchants to set up kiosks with information
about the rewards program and ways to sign up in person. We plan to identify merchants who own local
businesses or franchises—a corner grocer, for example. Our employees representing the diversity of the
community served would also be available to give presentations at stores and community centers.
Combining the Rewards Program with Other Sales Initiatives
We currently run ad campaigns in local newspapers, via social media, and other distribution channels that target
low‐income consumers with discount coupons. We recognize that low‐income rewards members may make
purchases that combine the use of the membership card with the use of the discount coupon. That is, if two or
more items are purchased, it is possible that one of them will have a coupon.
For award points accounting simplicity, we propose to base awards points on having the coupon discount rate
apply to the entire purchase and not just to the one item the coupon was for. This practice is known as pro‐rata
coupon accounting and is a common rewards program accounting method. Here is an example of how it works.
Imagine a customer purchases two items: Item A at $10 and Item B at $20. In a non‐coupon transaction, the
customer would have $30 applied to their rewards points. If the customer uses a 20% off coupon for Item B, the
final purchase price is $26. However, in pro‐rata coupon accounting, the discount rate is applied to the entire $30
for rewards purposes, meaning the customer will be credited for a $24 purchase.
The efficiencies of this method will reduce accounting costs, off‐setting some of the increased costs associated
with reliance on our paper‐based marketing campaigns.
Selling and Implementing the Program
The same brick‐and‐mortar small business partners who market the program could also enable sales to cash
customers and provide a physical card for customers without smartphone access to earn or redeem points. These
key partners would receive an incentive in two ways.
First, our credit fees are 2.5% for swiped cards and 3.5% for keyed‐in transactions. We would offer our partners 2%
for each cash transaction.
Second, we would give each participating local business owner partner a gratis loyalty membership. In addition to
that free membership, for every 25 rewards memberships a partner sells, we would provide $50 in bonus points to
their loyalty membership account.
Third, because many of these consumers will be new customers, we would tailor the membership application to
collect useful engagement data. For example, we can ask for mailing addresses, the option for parents to provide
the names and birthdates of children so that we can send them discounts codes and coupons for age‐appropriate
merchandise as birthdays approach.
Ad Lines for the Marketing and Sales Campaign
We propose the following marketing and sales themes and campaign lines. We know from demographic research
that many low‐income communities have people and families who are supportive of others: they donate to
foodbanks, run errands for neighbors, and help in emergencies. These following lines appeal to these qualities and
instincts while capturing the benefits of membership and the savings members accrue.
Membership pays for itself Purchases become rewards The more you buy, the more you give to your [school], [community], [local charities] There is no better way to give The best way to help your neighbor is to help yourself to our loyalty membership
Individual Incentives
The key to this program’s success is proper selection of brick‐and‐mortar partnerships. We need to be where our
customers go to shop, such as grocery stores, gas stations, and local retailers. Individual rewards redemptions
would focus on any purchase of our products or services.
Community Incentives
It is essential to distinguish between rewards earned by individuals and rewards earned for the community. The
value of community‐based incentives would be determined by the number of customers enrolled in a given
community, while the distribution of incentives could be selected by the consumer or based upon the type of
purchase made. For example, grocery store purchases could earn points for local food banks and homeless
shelters; sporting good purchases could benefit community recreation centers; and educational and technology
purchases could benefit local schools. And as stated earlier, the membership card for young adults tied to the high
school would benefit the high school specifically.
Why We Are Doing This: Benefits to TBL
In accordance with our commitment to corporate social responsibility, we are evaluating all initiatives against the
three Ps of the triple bottom line (TBL): People, Planet, and Profit. This initiative should be viewed as both a moral
and economic opportunity. We must be alert to the profit opportunities in providing affordable products and
services to a previously overlooked population.
At the same time, we must approach this opportunity in such a way that the rewards we offer to low‐income
populations benefit them and their communities. If we do this right, we foresee the dual benefits of increased
profits while helping people who are struggling.
Finally, we must ensure that the measures we take to market are environmentally neutral. If properly
implemented, profits realized through this program could be reinvested with companies that support green
initiatives, further enhancing our positive impact on the planet.
Cost Analysis: High‐Level Projected Sales and Expenses
In $millions, rounded, for a campaign in the 48 contiguous United States—
Projected Sales Revenue 500
Total Sales and Marketing Expenses (280)
Total Research and Development Expenses (6)
Total General and Administrative Expenses (2)
Gross Profit 212
Total Operating Expenses (112)
Net Profit 100
Course Documents/MBA 500 Project One SWOT Analyses From Sales and Marketing.pdf
SWOT Analyses From Sales and Marketing
Strengths Weaknesses
S a
le s
Hi gh referral rate from exi s ti ng cus tomers to thei r fri ends
Ideati on for new programs frequentl y conducted wi th empl oyees
Ongoi ng i mpl ementati on of empl oyee l earni ng and growth
Li mi ted retai l network for redempti on of l oyal ty rewards /poi nts
Hi gh turnover of s al es team
Communi cati on of new products not s treaml i ned
Li mi ted di vers i ty of market s egments
M a
rk e
ti n
g
Hi gh retenti on of exi s ti ng cus tomers / members hi ps
Hi gh uti l i zati on of al l members hi p programs
Hi gh cus tomer s ati s facti on among exi s ti ng members
Zero wai t ti me for cus tomer s ervi ce
Annual brand anal ys is /res earch
Sl ow devel opment of di gi tal content creati on/pos ti ng
Low engagement of cus tomers through s oci al medi a
Low brand i mage of l oyal ty program wi th potenti al cus tomers
Hi gh turnover of marketi ng team
Lack of focus on di vers i ty i n company and wi th cons umer groups
Opportunities Threats
S a
le s
Captures new market s egments that have previ ous l y not adopted brand
Seeks s trategi c partners hi ps to i mprove l oyal ty poi nts redempti on opti ons
Expl ores communi ty-bas ed organi zati ons that i denti fy wi th di vers e cons umer groups
Identi fi es new product devel opment opportuni ti es for di vers e cons umer groups
Expl ores s uppl i ers for s us tainable
packagi ng for products
Increas ed s harehol der des i re to i nves t i n di vers e compani es
Increas ed pres s ure from s harehol ders to i ncreas e di vers i ty i n workforce
Increas i ng cos t of admi ni s teri ng poi nts for l oyalty programs
Indus try pres s uri ng compani es to us e pos t-cons umer recycl ed pl as ti cs
Increas ed col l aboration of cons umer products compani es
M a
rk e
ti n
g
Hos ts focus groups wi th di vers e cons umer groups for product i nput
Devel ops caus e-rel ated marketi ng l oyal ty program for poi nts redempti on opti ons
Redes i gns al l marketi ng us i ng gl obal l oyal ty marketi ng agency
Indus try l eader/competi tor i ncreas i ng i ts focus on
di vers i ty i n marketi ng/s oci al medi a
Trend towards decreas ed envi ronmental i mpact of cons umer products
Increas ed cons umer des i re to s ee compani es focus ed on phi l anthropy