Assess current performance of an organization through analysis of financial statements

giagiagia610
ProjectTwoGuidelinesandRubric1.html.zip

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:

  1. Identify the financial records that indicate commitment to TBL.
    1. Outline which financial and other records marketing and sales maintains where TBL can provide data.
  2. 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.
    1. Which ideas in the plan support the KPI criteria? Cite specific ideas that meet the criteria.
    2. Explain how they meet the criteria.
  3. In your memo:
    1. Describe how the TBL data relates to the KPIs.
    2. 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?
    3. 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