Year 2 Forecast MAPE
New Star Grocery Company | |||||||||||||
Sales | |||||||||||||
b1 | Year 2 | Customers (x) | Actual Y(t) | Forecast F(t) | Y(t) - F(t) | PE | APE | ||||||
b0 | January | 215 | |||||||||||
February | 259 | ||||||||||||
Y= b0+ b1x | March | 325 | |||||||||||
April | 354 | ||||||||||||
May | 258 | ||||||||||||
June | 199 | ||||||||||||
July | 254 | ||||||||||||
August | 299 | ||||||||||||
September | 264 | ||||||||||||
October | 198 | ||||||||||||
November | 223 | ||||||||||||
December | 261 | ME = Mean error | |||||||||||
MPE = Mean percentage error | |||||||||||||
ME | MPE | MAPE | MAPE = Mean absolute percentage error | ||||||||||
SES - MAPE
New Star Grocery Company | ||||||||||||||
Alpha | Alpha | |||||||||||||
0.15 | 0.9 | |||||||||||||
Year 2 | Sales, Y(t) | F(t) | Y(t) - F(t) | PE | APE | F(t) | Y(t) - F(t) | PE | APE | |||||
January | ||||||||||||||
February | ||||||||||||||
March | ||||||||||||||
April | ||||||||||||||
May | ||||||||||||||
June | ||||||||||||||
July | ||||||||||||||
August | ME = Mean error | |||||||||||||
September | MPE = Mean percentage error | |||||||||||||
October | MAPE = Mean absolute percentage error | |||||||||||||
November | ||||||||||||||
December | ||||||||||||||
ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||||||
ME | MPE | MAPE | ME | MPE | MAPE | |||||||||
2/10/2018 Reviewing Your Message
https://newconnect.mheducation.com/flow/connect.html 1/7
LO6.3 Describe and apply the
components of the
reviewing stage, including
a FAIR test, proofreading,
and feedback.
Reviewing Your Message
You will recall from Chapter 5 that expert business writers use their time differently than do average business writers (see Figure 5.2 in Chapter 5 ). They devote more time to planning and reviewing and proportionately less time to drafting. They spend most of their time— before and after drafting—carefully thinking about how the message will influence and affect others.
Many business professionals get anxious to send their messages as soon as they finish drafting them. It is human nature to want to move on to the next task. Resist the urge to move on without carefully reviewing your messages. During the reviewing stage, you will improve your message, making it far more successful. You will also minimize the possibility of embarrassing and damaging mistakes.
The reviewing process includes three interrelated components: conducting the FAIR test, proofreading, and getting feedback (not generally needed for routine messages). These reviewing components ensure that you show fairness, get the message right, avoid errors, and get perspectives from trusted colleagues. For short, routine messages (one to four paragraphs),
2/10/2018 Reviewing Your Message
https://newconnect.mheducation.com/flow/connect.html 2/7
Page 186
expert business writers can often check for fairness and proofread in just a few minutes. For long, important messages, such as business proposals or business plans, the reviewing stage may take weeks or months.
2/10/2018 Reviewing Your Message
https://newconnect.mheducation.com/flow/connect.html 3/7
Page 188
TECHNOLOGY TIPS USING SPELLING AND GRAMMAR CHECKS Most word processing software programs contain
spelling and grammar checks to help you avoid
misspellings and grammatical mistakes. Many of
these programs, such as Microsoft Word, also
have tools to evaluate writing style and ease of
reading. Typically, these tools are not set by
default. You will need to manually select them. (In
Microsoft Word, you can access these additional tools by changing settings in
the Proofing area of Word Options.)
When you run spelling and grammar checks, you can review your document
sentence by sentence for passive voice, noun clusters, and other elements.
Once you finish the check, you will see a final calculation of readability
statistics. Keep in mind that the software is not perfect. Generally, however, it
will help you improve your writing style.
Source: Microsoft Office Word 2007
Source: Microsoft Office Word 2007
Source: Microsoft Office Word 2007
2/10/2018 Reviewing Your Message
https://newconnect.mheducation.com/flow/connect.html 4/7
Conduct a FAIR Test In Chapter 1 , we introduced the FAIR test as a way of ensuring ethical business communication. Of course, you will consider such issues during the planning and writing stages. Also, during the review process you can also take the time to think about the degree to which your entire message conforms to standards for facts, access, impacts, and respect. For important messages—particularly those that involve complicated business issues—apply the FAIR test:
Proofread Proofreading involves rereading your entire document to make sure it is influential and accurate. You might consider rereading each sentence several times, each time with a different focus. On your first pass, place yourself in the position of your audience members. Imagine how they will respond. On your second pass, check for problems with writing style and language mechanics.
Get Feedback As one business writing expert stated, one of the best ways to ensure that your communication is effective and fair is to get feedback from others:
Ask some people whose judgment you respect to give it a test read and get their reaction. Do they think it’s too energetic or hyperbolic for the audience and the occasion? Or is it too frosty? Similarly, do they think the writing is too distant or too familiar? What are the offending words or phrases? How can they be changed to do the job at hand? Using test readers is hardly rocket science, but those willing to go through this trouble invariably produce more effective writing.
Facts: Are you confident in your facts? Are your assumptions clear? Have you avoided slanting the facts or made other logical errors?
Access: Have you granted enough access to message recipients about decision making and information? Have you granted enough access to the message recipients to provide input? Are you open about your motives, or do you have a hidden agenda?
Impacts: Have you thought about how the message will impact various stakeholders? Have you evaluated impacts on others from ethical, corporate, and legal perspectives?
Respect: Have you demonstrated respect for the inherent worth of others: their aspirations, thoughts, feelings, and well-being? Have you shown that you value others?
6
2/10/2018 Reviewing Your Message
https://newconnect.mheducation.com/flow/connect.html 5/7
Page 189
This advice reveals an important point: Your trusted colleagues are giving your message a trial run—trying to simulate how the intended message recipient will respond. As they review your message, they can provide insights about making it better. Before they begin to read, ask them to consider whether you have framed the idea correctly, whether the business logic holds up, whether the message has the intended effects, whether the tone is appropriate, and so on. Effective business communicators make a habit of getting this advance feedback for important messages. In the Communication Q&A with Ronald Scott, you can learn more about the importance of clarity, tone, and accuracy in business writing.
2/10/2018 Reviewing Your Message
https://newconnect.mheducation.com/flow/connect.html 6/7
COMMUNICATION Q&A CONVERSATIONS WITH CURRENT BUSINESS PROFESSIONALS Pete Cardon: How important are writing skills in
the workplace?
Ronald Scott: They are vital. Members of my staff
are regularly required to take complex and
technical ordinance language and explain it in
plain terms to citizens or customers. This requires
the ability to capture the essence and translate it
into simple language that the customer can
understand and act on. In today’s workplace,
having good writing skills is an asset that will
distinguish an employee from his or her peers. One of the first opportunities an
employer has to assess writing skills is when he or she reviews an application
for employment or a résumé. A basic review of these two documents can
either thoroughly impress or completely horrify a potential employer.
PC: How much time do you spend writing? What types of writing?
RS: I spend approximately half my time writing. Examples include writing
emails; drafting letters to customers, citizens, and businesses; drafting letters
to local, state, and federal officials; reviewing and correcting written
documents and reports prepared by staff; creating policy and procedure
manuals; creating form letters; creating grant application and grant documents;
and creating budget documents and periodic budget reports.
PC: How formal is business writing?
RS: Typically, business writing is a formal means of communication. Recently,
one of my employees wrote a letter to a customer he knew quite well. After his
salutation he wrote, “How are you doing today? I hope you are doing well and
that you are feeling better.” While this language may have been acceptable for
Ronald Scott has been the chief development officer at
Eau Claire Cooperative
Health Centers and the
director of community
development for Lexington
County in South Carolina.
He is currently a juris doctor
candidate at the University
of South Carolina. Courtesy of Ronald Scott
2/10/2018 Reviewing Your Message
https://newconnect.mheducation.com/flow/connect.html 7/7
an in-person exchange, it seemed too casual and inappropriate for a business
letter.
PC: What kinds of writing mistakes do you see most often in the workplace?
How damaging are these mistakes? Could you give a recent example?
RS: In my profession we often communicate with large businesses about the
cost of development permits for large projects. Some permit fees can be in
excess of $50,000. A missing zero in a letter estimating permit fees can make
a big difference when a business is preparing its budget. Recently, an
employee addressed a letter to a customer about a code violation. He wrote,
“You will not need a building permit to complete this work.” He intended to
write, “You will need a building permit to complete this work.” What a
difference one word made. Some delicate negotiations were necessary to
make the situation right with that customer.
PC: How is writing in the workplace different from writing for school
projects?
RS: Business writing requires you to maintain business relationships (even
when giving bad news), build and maintain company loyalty and morale, retain
customers/clients, and portray a positive image for yourself and your company.
Academic writing focuses more on its subject than on the reader’s reactions or
on the goal of cultivating a long relationship with the reader. When writing for
business purposes, we need to make sure we do not hamper business
transactions and workflow due to misuse of language, inappropriate
expressions and emotions, or lack of empathy.
2/10/2018 Introduction
https://newconnect.mheducation.com/flow/connect.html 1/9
Page 168
CHAPTER 6
Improving Readability with Style and Design
2/10/2018 Introduction
https://newconnect.mheducation.com/flow/connect.html 2/9
ESTABLISHING CREDIBILITY
PRINCIPLES OF INTERPERSONAL COMMUNICATION
PRINCIPLES FOR & TYPES OF BUSINESS MESSAGES
2/10/2018 Introduction
https://newconnect.mheducation.com/flow/connect.html 3/9
Page 169
Learning Objectives
After studying this chapter, you should be able to do the
following:
LO6.1 Describe and apply the following principles
of writing style that improve ease of reading:
completeness, conciseness, and natural
processing.
LO6.2 Explain and use navigational design to
improve ease of reading.
LO6.3 Describe and apply the components of the
reviewing stage, including a FAIR test,
proofreading, and feedback.
2/10/2018 Introduction
https://newconnect.mheducation.com/flow/connect.html 4/9
Hear Pete Cardon
explain why this
matters.
bit.ly/cardon6
WHY DOES THIS MATTER?
In Chapter 5 , we
focused on getting your
message right with the AIM
planning process. Then we
introduced the importance
of tone as you begin
formally drafting your
message. In this chapter, we
focus on style and design—
the next considerations as
you draft your message. At
this point, your entire focus
should be making your
message easy to read.
In short, your audience members—whether executives,
managers, other professionals, or clients and customers—
are typically preoccupied with many projects and
overwhelmed with messages and information. When you
make your messages easy to read, your audience is more
likely to read them carefully and understand them as you
intended.
Many of the principles in this chapter focus on simplifying
your words and sentences. This should not be confused
with oversimplifying and minimizing your message. Your
messages should contain the best of ideas with strong
support. If your message is difficult to read, however, your
ideas may not even be considered.
In this chapter, we discuss four broad goals. The first three
goals relate to writing style and include being complete,
concise, and natural. The final goal is to design your
1
2/10/2018 Introduction
https://newconnect.mheducation.com/flow/connect.html 5/9
Page 171
document for rapid navigation. Throughout the chapter, you
will find less effective and more effective examples of each
of these style and design elements. These examples come
directly from the chapter case. Make sure to skim -
Stephanie’s original difficult-to-read brochure draft (see
Figure 6.1 ) so you understand the context for the chapter
examples. By the end of the chapter, you will see the
revisions that result in the final version of the brochure (see
Figure 6.3 ).
2/10/2018 Introduction
https://newconnect.mheducation.com/flow/connect.html 6/9
FIGURE 6.1 Stephanie’s Original, Difficult-to-Read Brochure
2/10/2018 Introduction
https://newconnect.mheducation.com/flow/connect.html 7/9
Page 170
CHAPTER CASE: PROMOTING FRANCHISES AT SUNRISE GREETING CARDS AND FLOWERS
THE SITUATION
Over the past 20 years, Sunrise Greeting Cards and Flowers
has succeeded far beyond Stephanie Jorgenson’s original
expectations. Her model of high-end greeting cards, flower
arrangements, and other special-occasion gifts appealed to a
growing customer base. In fact, even with increasing
accessibility to low-end greeting cards at department stores
and free e-cards, she found that her customers had grown
more loyal and purchased more than ever.
In recent years, Stephanie has received many requests from
people to open franchises. Because she was not in a position
to expand as quickly as the market seemed to dictate, she
thought franchising would be a good option.
Six months ago, she hired a franchising consultant,
who provided her with a basic strategy and action
plan to make franchising possible. With her top management
team, she set up the basic terms for franchises.
Stephanie Jorgenson, owner and founder © Ariel Skelley/Blend Images LLC
Started her greeting
card business 20 years
ago
Has expanded to 32
stores
Wants to set up
franchises
2/10/2018 Introduction
https://newconnect.mheducation.com/flow/connect.html 8/9
One of Stephanie’s immediate goals was to produce a
brochure to explain opportunities for franchisee opportunities.
Stephanie had thought carefully about the audience for the
brochure. She wanted financially strong and ambitious
individuals. She also wanted people with a strong sense of
optimism and customer orientation. She felt that success in her
business was strongly related to genuine delight in helping
others celebrate their special moments.
In terms of message structure, she had seen a number of
brochures that she felt could be good models. Generally, they
included an introductory message from the company
president. Then, they typically contained information about
financial qualifications and application procedures. She wanted
a brochure that would be upbeat but also clear about the
strong financial position needed to qualify for a franchise.
Her plan was to distribute the brochure personally to contacts
at industry expos she attended throughout the year. She also
envisioned mailing it, placing it on the company website, and
sending it by email.
Stephanie drafted a document (see Figure 6.1 ) for the
brochure. She asked several of her colleagues for input on the
content. They all told her the same thing: “This is hard to read.”
TASK
1. How can Stephanie improve the writing style of the
document so that potential franchisees will easily read it?
(See the “Improving Ease of Reading with
Completeness ,” “Improving Ease of Reading with
Conciseness ,” and “Improving Ease of Reading with
Natural Style ” sections.)
2. How can Stephanie improve her document’s navigational
design so that potential franchisees can find important
2/10/2018 Introduction
https://newconnect.mheducation.com/flow/connect.html 9/9
pieces of information rapidly? (See the “Improving Ease of
Reading with Navigational Design ” section.)
2/10/2018 Improving Ease of Reading with Natural Style
https://newconnect.mheducation.com/flow/connect.html 1/18
Page 177
Visit http://connect.mhedu cation.com for an exercise on this topic.
Improving Ease of Reading with Natural Style
The closer you match your writing style to the way your readers think and talk, the easier it is for them to process the information you present. Ease of processing means your readers need less mental effort to understand your message, which is especially important for readers who are busy and preoccupied with other work challenges.
Several broad principles support the strategies in this section. First, people can generally process information more quickly when writers use action verbs. Second, people tend to think in a doer- action-object pattern, so using this pattern in your writing enhances comprehension. Furthermore, when the subject or doer is missing from the sentence, readers may become confused. Third, people generally process simple, short words more quickly than long, complex ones.
Use Action Verbs When Possible
2/10/2018 Improving Ease of Reading with Natural Style
https://newconnect.mheducation.com/flow/connect.html 2/18
Page 178
As a business writer, you want to project a positive, can-do, action- oriented tone whenever possible. Indeed, fostering action is the basic purpose of most workplace communication. Using action verbs focuses on the goal of coordinating action in the workplace and livens up your writing. Also, it usually reduces word count.
Typically, then, you can focus on two types of revisions to achieve more effective action verbs. First, find nouns that you can convert to action verbs. For example, have a meeting becomes meet or have a discussion becomes discuss. Second, find forms of the verb to be (e.g., be verbs such as is, are, am) and convert them to action verbs (see Table 6.8 ). For example, Sunrise is a great place to open a franchise with becomes Sunrise provides great opportunities for franchises.
2/10/2018 Improving Ease of Reading with Natural Style
https://newconnect.mheducation.com/flow/connect.html 3/18
TABLE 6.8 Using Action Verbs
Less Effective More Effective
We have made an estimate
that you will need an initial
investment of between
$290,000 and $605,000.
We estimate that you will
initially invest between
$290,000 and $605,000.
This sentence contains 17
words.
This revision contains 11 words.
Sunrise is a company with
excellent customer service.
Sunrise provides excellent
customer service.
This sentence contains 8
words.
This revision contains 5 words.
Use Active Voice One way to immediately improve your writing is to use active rather than passive voice in most sentences. Active voice and passive voice contain the following grammatical patterns:
Active voice: Doer as Subject + Verb + Object Passive voice: Object as Subject + Be Verb + Verb + Doer
(Optional)
Consider the following examples:
Active voice: Sunrise provides free training for up to three people
2/10/2018 Improving Ease of Reading with Natural Style
https://newconnect.mheducation.com/flow/connect.html 4/18
for each new store. Passive voice: Free training is provided for up to three people for
each new store.
In active voice, this sentence immediately identifies the doer (Sunrise). It then uses a strong verb (provides) and proceeds to the object (free training). In passive voice, this sentence begins with the object of the action (free training), proceeds to a weak verb (is), then employs a strong verb (provided), and leaves out the doer, thus lacking the clarity of active voice.
Using active voice in writing includes many benefits. The doer-action- object allows for faster processing because most people’s natural thinking occurs in this way. It also emphasizes the business orientation of action. Perhaps most important, it specifies the doer. Because business activities depend on accountability and coordination, knowing the identity of the doer of an action is usually important. Furthermore, writing in the active voice usually results in fewer words (see Table 6.9 ).
2/10/2018 Improving Ease of Reading with Natural Style
https://newconnect.mheducation.com/flow/connect.html 5/18
TABLE 6.9 Using Active Voice Appropriately
Less Effective (Passive Voice) More Effective (Active Voice)
A marketing plan, budgeting
plan, and break-even analysis
will be provided to you with
your active participation.
Sunrise will work directly with
you to create a marketing plan,
budgeting plan, and break-even
analysis.
This passive sentence de-
emphasizes who will create
the plan and lacks an action-
oriented tone.
The active verb construction in
this sentence helps achieve a
more engaging, action-oriented
tone.
An analysis of your chosen
location will also be provided
that includes demographics,
traffic patterns, competitors,
and a related analysis will be
given to you that contains
estimates of retail sales and
revenue.
Sunrise will use its well-
developed formula for analyzing
the demographics, traffic
patterns, local competitors, and
other factors of your chosen
location. Sunrise will also
provide you with estimates of
retail sales and revenue.
This sentence contains two
sets of passive verbs. Again, it
de-emphasizes who will
create the plan and lacks an
action-oriented tone. It is also
wordy. It contains 33 words.
These sentences clearly
identifies that Sunrise will
conduct the analyses. It is
action-oriented. It is also easier
to read. It breaks the thoughts
into two sentences of 21 and 12
words, respectively.
2/10/2018 Improving Ease of Reading with Natural Style
https://newconnect.mheducation.com/flow/connect.html 6/18
While active voice is the preferred writing style for most business writing, passive voice is sometimes better when attempting to avoid blaming others or sounding bossy. Some research reports also use passive voice to emphasize neutrality (see Table 6.10 ).
2/10/2018 Improving Ease of Reading with Natural Style
https://newconnect.mheducation.com/flow/connect.html 7/18
TABLE 6.10 Using Active Voice Appropriately
Less Effective (Active Voice) More Effective (Passive Voice)
Since you did not meet the
financial criteria, we have
denied your application for a
Sunrise franchise.
Since financial criteria were not
met, your application for a
Sunrise franchise was not
accepted at this time.
This active verb construction
emphasizes the reader’s
failures.
This passive verb construction
provides the bad news without
assigning blame or directly
pointing out failure.
You need to complete the
application forms carefully for
us to seriously consider your
application.
Application forms that are
completed carefully allow us to
better determine the merit of
your application.
This active verb construction
might be perceived as bossy
(sounds like an order) or
demeaning (implies the reader
is not smart enough to
understand basic procedures).
This passive verb construction
emphasizes the importance of
carefully completing the forms
without directly implying the
reader is likely to make
elementary mistakes.
Use Short and Familiar Words and Phrases Whenever possible, choose short, conversational, and familiar words. Using longer, less common words to “sound smart” rarely pays off. They
2/10/2018 Improving Ease of Reading with Natural Style
https://newconnect.mheducation.com/flow/connect.html 8/18
Page 179slow processing and distract from your message. They may even inadvertently send the signal that you are out of touch, quirky, or even arrogant (see Table 6.11 ).
2/10/2018 Improving Ease of Reading with Natural Style
https://newconnect.mheducation.com/flow/connect.html 9/18
TABLE 6.11 Using Short, Familiar Words and Phrases
Less Effective More Effective
Sunrise advocates that you seek
consultation with us during the
application process.
Sunrise suggests that you
seek our advice during the
application process.
Advocates is a word that is less
familiar to many readers.
Furthermore, advocates and
consultation are words that may
suggest the need for legal
counsel to some readers.
This sentence contains short,
familiar words that allow for
ease of reading.
Sunrise bestows you with many
opulent greeting cards and
singular flower arrangements
that can only be found in Sunrise
stores.
Sunrise provides you with
many upscale greeting cards
and unique flower
arrangements that can only
be found in Sunrise stores.
This sentence contains
infrequently used adjectives
(opulent, singular). These terms
sound overblown and will
confuse many readers.
This sentence contains
shorter, more familiar terms
that capture the intended
meaning.
To facilitate this course of action,
we organize a convivial annual
retreat for store owners and
managers where we collectively
To help make this happen,
we organize a fun-filled
annual retreat where store
owners and managers can
2/10/2018 Improving Ease of Reading with Natural Style
https://newconnect.mheducation.com/flow/connect.html 10/18
Page 180
discuss our mutual challenges,
solutions, and opportunities.
discuss our shared
problems, solutions, and
opportunities.
This sentence contains rarely
used or stuffy words (course of
action, convivial, collectively,
mutual) that will frustrate many
readers.
This sentence avoids stuffy,
formal-business-sounding
words (course of action,
collectively, mutual) and
replaces them with shorter,
more conversational words.
Use Parallel Language Using parallel language means that you apply a consistent grammatical pattern across a sentence or paragraph. Parallelism is most important when you use series or lists. For example, when you describe a product with three characteristics, use the same grammatical pattern for each— that is, for example, choose adjectives or nouns or verbs for all of them. When you use consistent grammatical patterns for items in lists and series, readers can process the information far more naturally and quickly (see Table 6.12 ).
2/10/2018 Improving Ease of Reading with Natural Style
https://newconnect.mheducation.com/flow/connect.html 11/18
TABLE 6.12 Using Parallel Language
Less Effective More Effective
Our customers are refined
and purchase high-end
products.
Our customers are refined and
upscale.
The two characteristics of
customers are not parallel.
They are in the following
pattern: adjective and verb–
object.
The two characteristics of
customers are parallel. They are
both adjectives.
OR
Our customers appreciate refined
craftsmanship and purchase high-
end products.
The two characteristics of
customers are parallel. They both
follow verb–object patterns.
Sunrise will work directly
with you to create a
marketing plan, develop a
budgeting plan, and break-
even analysis.
Sunrise will work directly with you
to create a marketing plan,
budgeting plan, and break-even
analysis.
2/10/2018 Improving Ease of Reading with Natural Style
https://newconnect.mheducation.com/flow/connect.html 12/18
The three items in the list
are not parallel. They are in
the following pattern: verb–
object, verb–object, noun.
The three items in the list are
parallel. They are each nouns
(each are objects of the verb
create).
OR
Sunrise will work directly with you
to create a marketing plan,
develop a budgeting plan, and
set up a break-even analysis.
The three items in the list are
parallel. They each follow verb–
object patterns.
Profit level depends on
many factors, including
choosing the right location,
market demand, square
footage, and managing the
store effectively.
Profit level depends on many
factors, including location, market
demand, square footage, and
management.
The four factors do not have
matching grammatical
patterns. They are in the
following pattern: verb–
object, noun, noun, verb–
object.
The four factors are parallel. They
are each nouns.
OR
2/10/2018 Improving Ease of Reading with Natural Style
https://newconnect.mheducation.com/flow/connect.html 13/18
Page 181
Profit level depends on many
factors, including choosing the
right location, meeting market
demands, leasing adequate store
space, and managing the store
effectively.
The four factors are parallel. They
each follow a verb–object
pattern.
Avoid Buzzwords and Figures of Speech To keep your writing natural and engaging, make sure you don’t distract your readers with overused or out-of-place words or phrases. Buzzwords, which are workplace terms that become trite because of overuse, can stir negative feelings among some readers. In Table 6.13 , you can see one list of annoying buzzwords cited in a recent survey of executives. (Dozens of such lists exist because business professionals become so agitated by these overused words.)
5
2/10/2018 Improving Ease of Reading with Natural Style
https://newconnect.mheducation.com/flow/connect.html 14/18
TABLE 6.13 The Most Annoying Buzzwords
Leverage At the end of the day
Reach out Synergy
It is what it is Solution
Viral Think outside the box
Game changer On the same page
Disconnect Customer-centric
Value-add Do more with less
Circle back Downsizing
Cutting edge Overworked
Source: “WHAT’S THE BUZZ? Survey Reveals Most Overused Workplace Terms,” online article retrieved July 2014.
Figures of speech, such as idioms and metaphors, which contain nonliteral meanings, are generally out of place or inappropriate in business writing. Because they are nonliteral, they lack the precise meanings needed in business. Also, some idioms and metaphors have become so clichéd that they have lost almost all meaning (see Table 6.14 ).
2/10/2018 Improving Ease of Reading with Natural Style
https://newconnect.mheducation.com/flow/connect.html 15/18
TABLE 6.14 Avoiding Buzzwords and Figures of Speech
Less Effective More Effective
Do you want to make your wildest dreams
come true? There are many reasons for
owning a Sunrise store.
Owning a Sunrise
store can help
you reach your
financial dreams
and satisfy your
wish to be your
own boss.
Making your wildest dreams come true is a
figure of speech that sounds unbelievable to
most readers.
This sentence is
more believable.
It avoids
exaggerated
figures of speech
but remains
extremely
positive and
future-oriented.
We also create a tight-knit group of store
owners and managers who share tricks of
the trade with one another.
We create a tight-
knit group of
store owners and
managers who
share ideas
about improving
our brand and
sales
performance.
2/10/2018 Improving Ease of Reading with Natural Style
https://newconnect.mheducation.com/flow/connect.html 16/18
Tricks of the trade is a figure of speech that
is more appro priate in oral communication.
Some readers may be unfamiliar with the
phrase. In any case, it could create
confusion.
This sentence is
more specific. It
explains what
expertise is
shared and
discussed among
owners and
managers.
To this end, we organize an annual retreat
that is a total blast for store owners and
managers and that provides synergistic,
win–win solutions and proactive approaches
to managing our stores.
To help make this
happen, we
organize a fun-
filled annual
retreat for store
owners and
managers where
they can share
and discuss
problems,
solutions, and
opportunities.
These sentences contain various figures of
speech that readers may not receive well. A
total blast is slang. Not only can slang be
misunderstood, but it can also serve as a
generation marker. Slang goes out of style
and can make you look out of date. Other
slang will highlight how young you are. The
combination of buzzwords (synergistic, win–
win, proactive) in the second sentence will
annoy some readers.
This sentence,
without the
excessive slang
and buzzwords,
is easy to read.
Readers can
rapidly process
this sentence and
relate to its tone.
2/10/2018 Improving Ease of Reading with Natural Style
https://newconnect.mheducation.com/flow/connect.html 17/18
Page 182
Avoid It Is/There Are Readers naturally want to know precisely who or what the subject of a sentence is, particularly in business writing, where specificity is so important. Most sentences that begin with it is or there are fail to provide a specific subject and generally contain more words than necessary. A message can be particularly awkward when many of the sentences begin with it is or there are. By rewording it is/there are statements, you generally liven up your writing.
One way of recognizing when to reword it is statements is to ask the question what does it refer to? If you don’t know the answer, your readers won’t either. Consider the second sentence in Table 6.15 : It is wonderful to see happy customers day in and day out. What does it refer to? Recognizing what it is requires you to think for a few seconds. By rewording the sentence, you can provide a more descriptive, concise, and natural statement: Seeing happy customers day in and day out is wonderful. After considering the examples in Table 6.15 , read the Te chnology Tips in the "Reviewing Your Message" section for ways that you can use your word processing program to further improve your writing.
2/10/2018 Improving Ease of Reading with Natural Style
https://newconnect.mheducation.com/flow/connect.html 18/18
TABLE 6.15 Avoiding It Is and There Are
Less Effective More Effective
There are many reasons for
owning a Sunrise store.
Owning a Sunrise store has
many benefits.
This sentence contains 9
words.
This sentence contains 7
words.
It is wonderful to see happy
customers day in and day out.
Seeing happy customers day in
and day out is wonderful.
This sentence contains 12
words.
This sentence contains 10
words.
It is great to be in a line of
business where there are such
extremely loyal customers.
In this line of business,
customers are extremely loyal.
This sentence contains 17
words.
This sentence contains 9
words.
2/10/2018 Improving Ease of Reading with Completeness
https://newconnect.mheducation.com/flow/connect.html 1/6
LO6.1 Describe and
apply the
following
principles of
writing style
that improve
ease of reading:
completeness,
conciseness,
and natural
processing.
Improving Ease of Reading with Completeness
Most of your messages in the workplace have a clear goal: to update your team members, to promote a service to a client, to give an assignment, and so on. Your goal of completeness means that your message provides all the information necessary to meet that purpose. Your colleagues, clients, and other contacts expect complete information so they can act on your message immediately. Otherwise, they will need to contact you to get additional information or, worse yet, ignore your message altogether. You can achieve completeness with three basic strategies: (1) providing all relevant information; (2) being accurate; and (3) being specific.
Provide All Relevant Information
2/10/2018 Improving Ease of Reading with Completeness
https://newconnect.mheducation.com/flow/connect.html 2/6
Visit http://connect.mheducati
on.com for an exercise on this
topic.
Page 172
One challenge is to judge which information is relevant for your message. After all, providing too much information can distract your readers and weigh down your document. On the other hand, not providing enough information can leave your reader wondering how to respond. The key to providing all but only relevant information is to plan, write, and review your message strategically. Repeatedly asking yourself what information is necessary for the purpose of your message will help you accomplish this.
A recent survey of corporate recruiters from 2,092 companies showed which elements of writing style are most important. Accuracy was the most sought after characteristic of writing style (95 percent), followed by clarity (75 percent), language mechanics (59 percent), conciseness (41 percent), precision (37 percent), and visual appeal (11 percent).
In Stephanie’s case, her basic purpose is to attract qualified individuals to apply for franchises. In the limited space of a two-page brochure, she wants to accomplish several objectives to encourage applications of qualified individuals: show that she is committed to their success, describe the basic business model, and explain the financial qualifications for franchisees. As long as she keeps these objectives in mind, she can ensure that the brochure contains only relevant information.
Be Accurate Accuracy is a basic objective of all business communications because your colleagues, customers, and clients base important decisions on your communications. In short, accurate information is true, correct, and exact. You should aim for accuracy in facts, figures, statistics, and word
2
2/10/2018 Improving Ease of Reading with Completeness
https://newconnect.mheducation.com/flow/connect.html 3/6
choice. Inaccuracies may result from miscalculations, misinformation, poor word choice, or simply typos (see Table 6.1 for examples). Accuracy, like specificity, strongly impacts your readers’ perceptions of your credibility. Just one inaccurate statement can lead readers to dismiss your entire message and lower their trust in your future communications as well.
2/10/2018 Improving Ease of Reading with Completeness
https://newconnect.mheducation.com/flow/connect.html 4/6
TABLE 6.1 Being Accurate
Less Effective More Effective
Your store should spend
roughly 30 percent of annual
sales on local advertising.
Your store should spend
roughly 3 percent of annual
sales on local advertising.
A typo (30 percent instead of 3
percent) implies an expense
commitment that is ten times
higher than the actual
recommendation.
The revised version contains
the corrected figure.
We estimate that you will need
an initial investment of
between $240,000 and
$425,000. The initial
investment costs include the
following: fixtures ($60,000–
$90,000); inventory ($80,000–
$190,000); store improvements
($20,000–$130,000); retail
equipment ($20,000–
$35,000); miscellaneous
expenses ($10,000–$30,000);
and an initial franchise fee
($50,000).
We estimate that you will need
an initial investment of
between $240,000 and
$525,000. The initial
investment costs include the
following: fixtures ($60,000–
$90,000); inventory ($80,000–
$190,000); store improvements
($20,000–$130,000); retail
equipment ($20,000–
$35,000); miscellaneous
expenses ($10,000–$30,000);
and an initial franchise fee
($50,000).
Incorrect calculation leads to
one of the figures being off by
The revised version contains
the corrected figure.
2/10/2018 Improving Ease of Reading with Completeness
https://newconnect.mheducation.com/flow/connect.html 5/6
Page 173
$100,000.
Be Specific Your readers expect you to be precise and avoid vagueness in nearly all business situations. The more specific you are, the more likely your readers are to have their questions answered. If you are not specific, your readers may become impatient and begin scanning and skimming for the information they want. If they can’t find that information, they are unlikely to respond to your message as you intend.
Being specific also affects the judgments your readers make about your credibility. Specific statements lead your readers to believe that you know what you’re talking about (competence), that you are not hiding anything (character), and that you want your readers to be informed (caring). Being vague, on the other hand, detracts from your credibility. See Table 6.2 for examples of less specific and more specific writing.
2/10/2018 Improving Ease of Reading with Completeness
https://newconnect.mheducation.com/flow/connect.html 6/6
TABLE 6.2 Being Specific
Less Effective More Effective
Once approved, new
Sunrise stores can be
opened quickly.
Once approved, new Sunrise stores
can typically be opened in between 3
and 12 months.
The term quickly is not
specific.
The phrase between 3 and 12 months
is specific and avoids ambiguity.
The minimum store
size is based on
location. Typically, the
minimum size is larger
in strip shopping
centers than in
shopping malls.
The minimum store size is based on
location. In shopping malls, the
minimum size should be approximately
2,500 square feet. In strip shopping
centers, the minimum size should be
approximately 3,400 square feet.
The term larger is not
specific.
By stating specific figures for square
feet, the difference is not open to
interpretation.
2/10/2018 Improving Ease of Reading with Navigational Design
https://newconnect.mheducation.com/flow/connect.html 1/10
Page 183
LO6.2 Explain and use
navigational
design to
improve ease
of reading.
Improving Ease of Reading with Navigational Design
Your primary goal for document design is making your message easy to navigate. Ask yourself these questions: How can I get my readers to see my main ideas and messages quickly? How can I make sure my readers can find the information they are most interested in? Several features will help you improve navigational design, including headings, highlighting, lists, white space, and simplicity. Later in the book, we will focus on additional ways of enhancing the appearance of your document with charts, figures, and graphics.
Use Headings In information-rich and complex messages, headings can help your readers identify key ideas and navigate the document to areas of interest. As you create headings and subheadings, be consistent in font style and formatting throughout your document. One way to be consistent with your headings is to apply formatting features available in most word processing programs. For example, in Microsoft Word, you can assign heading levels for major heads and subheads (Heading 1, Heading 2, and so on). You have many options for the formatting styles you apply, and
2/10/2018 Improving Ease of Reading with Navigational Design
https://newconnect.mheducation.com/flow/connect.html 2/10
Improving Ease of Reading with
Navigational Design
the software ensures that the formatting remains consistent throughout the document.
As you develop your headings, make sure you concisely and accurately convey the contents of a section. For example, notice the heading “Financial Requirements & Financing” in the more effective example in Table 6.16 . In contrast, the heading “Minimum Financial Requirements to Apply for a Franchise and Financing Stipulations” is likely too long for most documents. On the other hand, a subheading such as “Minimum Requirements” may not give readers accurate information about the contents of the section. Readers skimming the document for financial requirements might miss the section on the first pass. You can find more information about headings in Chapters 12 and 13 about reports.
Headings
Highlighting
Lists
White space
Simplicity
2/10/2018 Improving Ease of Reading with Navigational Design
https://newconnect.mheducation.com/flow/connect.html 3/10
TABLE 6.16 Using Headings
Less Effective More Effective
Sunrise will make the
final approval about your
proposed sites and may
suggest alternate
locations based on our
marketing formula, which
has worked successfully
in the past. As far as
financial requirements,
you must have a
minimum net worth of
$350,000, and you also
will need minimum
unencumbered assets of
between $120,000 and
$265,000. You may not
finance more than two-
thirds of the initial
investment to open the
store. You must also have
access to financing in the
range of $170,000 to
$340,000 (assuming that
you finance two-thirds of
the initial investment
costs). Confirmation of
loan, terms, and
collateral is required. You
will need to show that
you can maintain an
outside income of at
least 80 percent of your
Financial Requirements & Financing
Owning a Sunrise shop requires a
strong financial position and
evidence of the ability to finance a
new business.
Financial Requirements. Sunrise
seeks franchise owners who are in a
financially sound position. The
minimum requirements include a
total net worth of $350,000, with
unencumbered liquid assets of
between $120,000 and $265,000.
You will need to show that these
liquid assets are personal rather than
capital in a current business and
available for investment in your
Sunrise store. You will also need to
show that you can maintain an
outside income of at least 80
percent of your present income for
at least two years.
Financing. You are required to
finance less than two-thirds of the
initial investment costs. Assuming
that you finance up to two-thirds of
the initial investment costs, you will
need access to financing in the
range of $170,000 to $340,000.
Confirmation of loan, terms, and
collateral is required. Sunrise does
not provide loans.
2/10/2018 Improving Ease of Reading with Navigational Design
https://newconnect.mheducation.com/flow/connect.html 4/10
present income for a
period of at least two
years to show that you
have adequate financial
stability as you get your
business started. You will
need to show that your
liquid assets are
available for investment
and operations of your
new Sunrise Greeting
Cards and Flowers shop,
and the capital must be
from your personal
assets; capital in a
current business will not
be recognized as
available to a new store.
Sunrise does not provide
loans.
This paragraph is 198
words with far too many
numbers. Many readers
would have a hard time
locating the key
information.
Visually, these paragraphs are far
more appealing and inviting. The
headings immediately orient the
reader to the content.
Highlight Key Words and Phrases When you want to highlight ideas or phrases, consider using bold, italics, or underlining to draw and keep your readers’ attention. Typically, you will apply this type of formatting sparingly; if you use too
2/10/2018 Improving Ease of Reading with Navigational Design
https://newconnect.mheducation.com/flow/connect.html 5/10
much special formatting, your main ideas will not stand out. In general, apply only one type of formatting to a highlighted word or words (i.e., only bold or italics, not bold and italics) (see Table 6.17 ).
TABLE 6.17 Applying Formatting to Key Words and Phrases
Less Effective More Effective
Sunrise will work directly with
you to create a marketing
plan, budgeting plan, and
break-even analysis.
Sunrise will work directly with
you to create a marketing plan,
budgeting plan, and break-
even analysis.
By italicizing everything,
nothing is highlighted.
By italicizing one short phrase,
you emphasize it.
Sunrise will provide free
training for up to three people
for each new store.
Sunrise will provide free
training for up to three people
for each new store.
Applying two formatting
features (bold and underlining)
may appear overbearing.
Applying one formatting
feature (bold) is sufficient to
highlight the phrase.
2/10/2018 Improving Ease of Reading with Navigational Design
https://newconnect.mheducation.com/flow/connect.html 6/10
Page 184
Use Bulleted and Numbered Lists You will often use lists in business writing. When you set these items apart with bullets or numbers, your readers notice and remember the items more easily (see Table 6.18 ).
2/10/2018 Improving Ease of Reading with Navigational Design
https://newconnect.mheducation.com/flow/connect.html 7/10
TABLE 6.18 Using Bulleted and Numbered Lists
Less Effective More Effective
The brochure for prospective franchisees
should first and foremost show how
committed we are to the success of the
franchisee. We can do this by providing a
warm and inviting message from Stephanie
on the front of the brochure. Then we
should provide basic information that all
prospective franchisees would be
interested in, such as information about
initial investment costs and profit potential,
financial requirements and financing, our
involvement in opening a new franchise
store, and the application process. We
should also have a section about our
commitment to their success after they
open a store.
The brochure for
prospective
franchisees should
accomplish two
main goals: (1)
show our
commitment to the
success of
franchisees and (2)
provide basic
information about
becoming a
franchisee. The
brochure should
contain the
following sections:
Opening letter
from
Stephanie.
Initial
investment
costs and profit
potential.
Financial
requirements
and financing.
Sunrise
involvement in
opening a new
franchise store.
2/10/2018 Improving Ease of Reading with Navigational Design
https://newconnect.mheducation.com/flow/connect.html 8/10
Page 185
Without bullets, this paragraph contains a
lot of items that are difficult for the reader
to remember. Furthermore, it takes longer
for the reader to visualize the components
of the brochure.
With bullets, this
paragraph allows
the reader to
rapidly process
the information
and visualize the
components of the
brochure.
Furthermore, the
use of
enumeration and
bullets more
clearly
distinguishes the
overarching goals
of the brochure
and the
components of the
brochure.
Use White Space Generously Your readers will form an immediate impression about your document based on how much white space (areas without text) it has. Documents with too much text and not enough white look daunting or cluttered. On the other hand, documents with too much white
Sunrise
support after
opening a
store.
Application
process.
2/10/2018 Improving Ease of Reading with Navigational Design
https://newconnect.mheducation.com/flow/connect.html 9/10
Page 187
space may look insufficient. Many students are trained in the university setting to double-space documents. In the workplace, double-spaced documents are rare, however.
Keep It Simple Visual appeal is not the first consideration for most written business communications. Rather, the goal is to get your message across in an easy-to-read manner. As you design your document, focus first on easy navigation for your reader. Avoid formatting features that distract from the main message. See Figure 6.3 for effective use of navigational features and white space.
2/10/2018 Improving Ease of Reading with Navigational Design
https://newconnect.mheducation.com/flow/connect.html 10/10
FIGURE 6.3 Stephanie’s Final, Easier-to-Read Brochure (compare to original version in Figure 6.1 )
2/10/2018 Improving Ease of Reading with Conciseness
https://newconnect.mheducation.com/flow/connect.html 1/13
Improving Ease of Reading with Conciseness
When you write concisely, your message is far easier to read. Conciseness does not imply removing relevant information. Rather, it implies omitting needless words so that readers can rapidly process your main ideas. In response to the question “[Do you have] any thoughts on how language is used in the business world?” Clarence Otis Jr., CEO of Darden Restaurants, responded this way:
I think writing in the business world is more functional than elegant. I felt that way making the transition from law to business. Lawyers write much better. They spend a lot more time on it. In the business world, it’s less about how well you say it and more about how efficiently you say it. Otis’s primary point is that your language should be efficient. You should say as much as you can in as few words as possible. His distinction between functionality and elegance means that your primary focus is not impressing with words, but rather impressing with ideas. In this section, we describe strategies for writing concisely, including controlling paragraph length, using shorter sentences, avoiding redundancy, avoiding empty phrases, and avoiding wordy phrases.
Control Paragraph Length Before they even begin to read, readers form impressions about ease of reading by looking at paragraph length. When they see long paragraphs, they often enter skim mode—searching for certain words and ideas rather than reading. Long paragraphs can signal disorganization and even disrespect for the reader’s time.
3
2/10/2018 Improving Ease of Reading with Conciseness
https://newconnect.mheducation.com/flow/connect.html 2/13
Improving Ease of Reading with Writing
Style
Typically, paragraphs should contain 40 to 80 words. For routine messages, paragraphs as short as 20 to 30 words are common and appropriate. As the level of information and analysis grows deeper, some paragraphs will be longer. Rarely should paragraphs exceed 150 words. In a matter of seconds, you can easily check how many words are in your paragraphs with nearly all word processing software.
One primary cause of overly lengthy paragraphs is placing more than one main idea or topic in the paragraph. Your readers can process the information in your message far more easily if you create unified paragraphs in which each paragraph focuses on one idea or topic. Paragraphs with more than one idea often confuse readers. Even worse, readers may miss some ideas altogether. The process of unifying helps you control paragraph length and even tighten your business reasoning (see Table 6.3 ).
Completeness
Provide all relevant
information.
Be accurate.
Be specific.
Conciseness
Control paragraph
length.
Use short sentences.
Avoid redundancy.
Avoid empty
phrases.
Avoid wordy
prepositional
phrases.
Natural Style
Use action verbs
when possible.
Use active voice.
Use short and
familiar words and
phrases.
Use parallel
language.
Avoid buzz words
and figures of
speech.
Avoid it is/there are.
2/10/2018 Improving Ease of Reading with Conciseness
https://newconnect.mheducation.com/flow/connect.html 3/13
Visit http://connect.mhedu cation.com for an exercise on this topic.
Page 174
2/10/2018 Improving Ease of Reading with Conciseness
https://newconnect.mheducation.com/flow/connect.html 4/13
TABLE 6.3 Controlling Paragraph Length
Less Effective More Effective
As far as financial requirements, you must
have a minimum net worth of $350,000.
Also, you will need minimum
unencumbered assets of between
$120,000 and $265,000. You may not
finance more than two-thirds of the initial
investment to open the store. You must
also have access to financing in the range
of $170,000 to $340,000 (assuming that
you finance two-thirds of the initial
investment costs). Confirmation of loan,
terms, and collateral is required. You will
need to show that you can maintain an
outside income of at least 80 percent of
your present income for a period of at
least two years. This allows you to have
adequate financial stability as you get your
business started. You will need to show
that your liquid assets are available for
investment and operations of your new
Sunrise Greeting Cards and Flowers shop.
Capital must be from your personal assets;
capital in a current business will not be
recognized as available to a new store.
Sunrise does not provide loans.
Minimum financial
requirements
include a net worth
of $350,000 with
unencumbered
liquid assets of
between $120,000
and $265,000
(these financial
requirements must
be from personal
assets, not from
capital in a current
business). You will
need to show that
these liquid assets
are available for
investment in your
Sunrise store. You
will also need to
show that you can
maintain an outside
income of at least
80 percent of your
present income for
a period of at least
two years.
You are required to
finance less than
two-thirds of the
initial investment
costs. Assuming
2/10/2018 Improving Ease of Reading with Conciseness
https://newconnect.mheducation.com/flow/connect.html 5/13
that you can, you
will need access to
financing in the
range of $170,000
to $340,000.
Confirmation of
loan, terms, and
collateral is
required. Sunrise
does not provide
loans.
This paragraph contains 168 words. It also
contains excessive numerical figures.
This paragraph
contains the same
information but has
been edited for
conciseness and
divided into two
paragraphs. It
contains one
paragraph of 80
words and one
paragraph of 44
words. Altogether,
the information has
been presented in
30 fewer words.
The right to open a new Sunrise store will
be awarded based on the business plan,
market potential in your chosen area,
personal interviews, and financial criteria.
Running a Sunrise store can be extremely
The right to open a
new Sunrise store
will be awarded
based on the
business plan,
2/10/2018 Improving Ease of Reading with Conciseness
https://newconnect.mheducation.com/flow/connect.html 6/13
profitable. Once approved, new Sunrise
stores can typically be opened in 3 to 12
months. The minimum store size is based
on location. In shopping malls, the
minimum size should be approximately
2,500 square feet. In strip shopping
centers, the minimum size should be
approximately 3,400 square feet.
Currently, average annual profit per
Sunrise store is $153,000, with ranges
between $49,000 and $215,000. Profit
level depends on many factors, including
choosing the right location, market
demand, square footage, and managing
the store effectively. Typically, profits
become relatively stable after the first
three years of operation.
market potential in
your chosen area,
personal
interviews, and
financial criteria.
Once approved,
new Sunrise stores
can typically be
opened in 3 to 12
months.
Currently, average
annual profit per
Sunrise store is
$153,000, with
ranges between
$49,000 and
$215,000. Profit
level depends on
many factors,
including location,
market demand,
square footage,
and management.
Typically, profits
become relatively
stable after the first
three years of
operation.
This paragraph has two ideas or topics: (a)
awarding the right to open a store and (b)
The revised
paragraph is
broken into two
2/10/2018 Improving Ease of Reading with Conciseness
https://newconnect.mheducation.com/flow/connect.html 7/13
Page 175
average annual profit per store. This
paragraph contains 130 words.
separate, unified
paragraphs with 42
and 41 words,
respectively.
Use Short Sentences in Most Cases Like relatively short paragraphs, short sentences allow your readers to comprehend your ideas more easily. Consider Figure 6.2 , which depicts the data from a study conducted by the American Press Institute. Readers were tested on their overall comprehension based on the length of sentences. When sentences had 10 words or fewer, readers had nearly 100 percent comprehension. Once sentence lengths reached around 20 words, comprehension dropped to about 80 percent. Thereafter, comprehension dropped rapidly. Sentence lengths of 28 words resulted in just 30 percent comprehension.
4
FIGURE 6.2 Comprehension Rate and Sentence Length Source: Figure adapted from Ann Wylie, “How to Make Your Copy More Readable: Make Sentences Shorter,” Comprehension, January 14, 2009, retrieved March 3, 2012, from http://compr ehension.prsa.org/?p=217.
2/10/2018 Improving Ease of Reading with Conciseness
https://newconnect.mheducation.com/flow/connect.html 8/13
As a rule of thumb, then, for routine messages, aim for average sentence length of 15 or fewer words. For more analytical and complex business messages, you may have an average sentence length of 20 or fewer words. Of course, you will often deal with complex ideas and need to go above 20 words in some of your sentences. Use your judgment to minimize sentence length (see Table 6.4 ).
2/10/2018 Improving Ease of Reading with Conciseness
https://newconnect.mheducation.com/flow/connect.html 9/13
TABLE 6.4 Using Short Sentences
Less Effective More Effective
Our brand is strongly recognized
among our customers and is
associated with positive
characteristics such as quality
and reliability, and our customers
associate these qualities with the
special occasions in their lives.
To our customers, our brand
represents quality products
that help them celebrate
special occasions.
This sentence contains 32 words. This sentence contains the
same ideas in just 14 words.
Our team of experienced
managers will apply our well-
developed formula for analyzing
the demographics, traffic
patterns, local competitors, and
other factors of your chosen
location to provide you with
estimates of retail sales and
revenue.
Our team of experienced
managers will apply our well-
developed formula for
analyzing the demographics,
traffic patterns, local
competitors, and other
factors of your chosen
location. From this analysis,
we will provide you with
estimates of retail sales and
revenue.
This sentence contains 35 words. The less effective sentence
has been split into one 25-
word sentence and one 14-
word sentence.
2/10/2018 Improving Ease of Reading with Conciseness
https://newconnect.mheducation.com/flow/connect.html 10/13
Page 176
Sunrise has aggressively
advertised in print and radio in
regional markets in recent years,
and Sunrise has developed
excellent brand recognition with
its various advertising and
promotional materials that will
directly benefit your store, which,
of course, depends and varies on
your chosen store location.
In recent years, Sunrise has
aggressively advertised in
print and radio in regional
markets. As a result, Sunrise
brand recognition is strong.
Your store will benefit
from Sunrise regional
advertising and promotional
campaigns.
This sentence contains 45 words. The less effective sentence
has been split into three
sentences with 14, 8, and 11
words, respectively.
Avoid Redundancy One way to reduce word count and make your messages easier to read is to avoid redundancies, which are words or phrases that repeat the same meaning. For example, consider the phrase past history; history can only be past, so there’s no need to use both words. By eliminating redundancies, you can reduce overall word count (see Table 6.5 ).
2/10/2018 Improving Ease of Reading with Conciseness
https://newconnect.mheducation.com/flow/connect.html 11/13
TABLE 6.5 Avoiding Redundancy
Less Effective More Effective
To help you reach your goals, we
provide you with the products and
resources to succeed.
We provide you with the
products and resources to
succeed.
This sentence has 16 words. To
help you reach your goals and to
succeed are redundant phrases.
This sentence has 10 words.
It removes redundancy.
We organize a fun-filled annual
retreat each year for store owners
and managers to share and
discuss problems, solutions, and
opportunities with one another.
We organize a fun-filled
annual retreat for store
owners and managers to
share and discuss
problems, solutions, and
opportunities.
This sentence has 24 words.
Annual and each year are
redundant. Share and discuss
implies with one another, making
with one another redundant.
This sentence has 19 words.
It removes redundancies.
Avoid Empty Phrases Many phrases simply fill space without adding additional meaning. Many of these phrases are common in conversations but are not needed for written messages (see Table 6.6 ).
2/10/2018 Improving Ease of Reading with Conciseness
https://newconnect.mheducation.com/flow/connect.html 12/13
TABLE 6.6 Avoiding Empty Phrases
Less Effective More Effective
Needless to say, the
profitability of a store depends
on many factors.
The profitability of a store
depends on many factors.
This sentence contains 12
words.
This revision contains 9 words.
With all due respect, Sunrise
suggests other locations for
your store based on our
marketing formula.
Sunrise suggests other
locations for your store based
on our marketing formula.
This sentence contains 16
words.
This revision contains 12
words.
Avoid Wordy Prepositional Phrases Eliminating extra words allows you to get your ideas across as efficiently as possible. You will often find that you can reduce word count by 30 to 40 percent simply by converting many of your prepositional phrases into single-word verbs. Like other elements of style we have discussed already, prepositional phrases are not bad in themselves. In many cases, they are perfectly appropriate. Rather, their overuse leads to wordiness and less clarity (see Table 6.7 ).
2/10/2018 Improving Ease of Reading with Conciseness
https://newconnect.mheducation.com/flow/connect.html 13/13
TABLE 6.7 Avoiding Wordy Prepositional Phrases
Less Effective More Effective
In an effort to maximize your
profitability as a Sunrise owner,
you should be in attendance at
each annual retreat.
Attending the annual Sunrise
retreats helps you maximize
profitability.
This sentence contains 20
words.
This revision of the less
effective sentence contains 9
words.
In the business planning
process, please keep in mind
that at Sunrise, we are here for
you.
Please remember that we will
help you with business
planning.
This sentence contains 17
words.
This revision of the less
effective sentence contains 10
words.
Your Name
Date: _____
1. Identify and revise five sentences that are not complete.
Original Sentence 1:
Revised Sentence 1:
Original Sentence 2:
Revised Sentence 2:
Original Sentence 3:
Revised Sentence 3:
Original Sentence 4:
Revised Sentence 4:
Original Sentence 5:
Revised Sentence 5:
2. Identify and revise five sentences that are not concise.
Original Sentence 1:
Revised Sentence 1:
Original Sentence 2:
Revised Sentence 2:
Original Sentence 3:
Revised Sentence 3:
Original Sentence 4:
Revised Sentence 4:
Original Sentence 5:
Revised Sentence 5:
3. Identify and revise five sentences that are not natural.
Original Sentence 1:
Revised Sentence 1:
Original Sentence 2:
Revised Sentence 2:
Original Sentence 3:
Revised Sentence 3:
Original Sentence 4:
Revised Sentence 4:
Original Sentence 5:
Revised Sentence 5:
4. Explain 3 strategies (from Chapter 6) for designing the document for faster navigation.
a. Strategy 1:
b. Strategy 2:
c. Strategy 3:
5. Revise the document below. Attempt to cut the length in half. Use headings, bullets, and other design features to improve navigation.
Submit your well formatted, fully proofread response as an attachment to the assignment link in Canvas (acceptable formats are .doc or .docx).
Name your document (File/Save As): Last Name_Analyzing a Message.
Stephen Elop’s email to employees
July 17, 2014 | Microsoft News Center
Hello there,
Microsoft’s strategy is focused on productivity and our desire to help people “do more.” As the Microsoft Devices Group, our role is to light up this strategy for people. We are the team creating the hardware that showcases the finest of Microsoft’s digital work and digital life experiences, and we will be the confluence of the best of Microsoft’s applications, operating systems and cloud services.
To align with Microsoft’s strategy, we plan to focus our efforts. Given the wide range of device experiences, we must concentrate on the areas where we can add the most value. The roots of this company and our future are in productivity and helping people get things done. Our fundamental focus – for phones, Surface, for meetings with devices like PPI, Xbox hardware and new areas of innovation — is to build on that strength. While our direction in the majority of our teams is largely unchanging, we have had an opportunity to plan carefully about the alignment of phones within Microsoft as the transferring Nokia team continues with its integration process.
It is particularly important to recognize that the role of phones within Microsoft is different than it was within Nokia. Whereas the hardware business of phones within Nokia was an end unto itself, within Microsoft all our devices are intended to embody the finest of Microsoft’s digital work and digital life experiences, while accruing value to Microsoft’s overall strategy. Our device strategy must reflect Microsoft’s strategy and must be accomplished within an appropriate financial envelope. Therefore, we plan to make some changes.
We will be particularly focused on making the market for Windows Phone. In the near term, we plan to drive Windows Phone volume by targeting the more affordable smartphone segments, which are the fastest growing segments of the market, with Lumia. In addition to the portfolio already planned, we plan to deliver additional lower-cost Lumia devices by shifting select future Nokia X designs and products to Windows Phone devices. We expect to make this shift immediately while continuing to sell and support existing Nokia X products.
To win in the higher price segments, we will focus on delivering great breakthrough products in alignment with major milestones ahead from both the Windows team and the Applications and Services Group. We will ensure that the very best experiences and scenarios from across the company will be showcased on our products. We plan to take advantage of innovation from the Windows team, like Universal Windows Apps, to continue to enrich the Windows application ecosystem. And in the very lowest price ranges, we plan to run our first phones business for maximum efficiency with a smaller team.
We expect these changes to have an impact to our team structure. With our focus, we plan to consolidate the former Smart Devices and Mobile Phones business units into one phone business unit that is responsible for all of our phone efforts. Under the plan, the phone business unit will be led by Jo Harlow with key members from both the Smart Devices and Mobile Phones teams in the management team. This team will be responsible for the success of our Lumia products, the transition of select future Nokia X products to Lumia and for the ongoing operation of the first phone business.
As part of the effort, we plan to select the appropriate business model approach for our sales markets while continuing to offer our products in all markets with a strong focus on maintaining business continuity. We will determine each market approach based on local market dynamics, our ability to profitably deliver local variants, current Lumia momentum and the strategic importance of the market to Microsoft. This will all be balanced with our overall capability to invest.
Our phone engineering efforts are expected to be concentrated in Salo, Finland (for future, high-end Lumia products) and Tampere, Finland (for more affordable devices). We plan to develop the supporting technologies in both locations. We plan to ramp down engineering work in Oulu. While we plan to reduce the engineering in Beijing and San Diego, both sites will continue to have supporting roles, including affordable devices in Beijing and supporting specific US requirements in San Diego. Espoo and Lund are planned to continue to be focused on application software development.
We plan to right-size our manufacturing operations to align to the new strategy and take advantage of integration opportunities. We expect to focus phone production mainly in Hanoi, with some production to continue in Beijing and Dongguan. We plan to shift other Microsoft manufacturing and repair operations to Manaus and Reynosa respectively, and start a phased exit from Komaron, Hungary.
In short, we will focus on driving Lumia volume in the areas where we are already successful today in order to make the market for Windows Phone. With more speed, we will build on our success in the affordable smartphone space with new products offering more differentiation. We’ll focus on acquiring new customers in the markets where Microsoft’s services and products are most concentrated. And, we’ll continue building momentum around applications.
We plan that this would result in an estimated reduction of 12,500 factory direct and professional employees over the next year. These decisions are difficult for the team, and we plan to support departing team members with severance benefits.
More broadly across the Devices team, we will continue our efforts to bring iconic tablets to market in ways that complement our OEM partners, power the next generation of meetings & collaboration devices and thoughtfully expand Windows with new interaction models. With a set of changes already implemented earlier this year in these teams, this means there will be limited change for the Surface, Xbox hardware, PPI/meetings or next generation teams.
We recognize these planned changes are broad and have very difficult implications for many of our team members. We will work to provide as much clarity and information as possible. Today and over the coming weeks leaders across the organization will hold town halls, host information sharing sessions and provide more details on the intranet.
The team transferring from Nokia and the teams that have been part of Microsoft have each experienced a number of remarkable changes these last few years. We operate in a competitive industry that moves rapidly, and change is necessary. As difficult as some of our changes are today, this direction deliberately aligns our work with the cross company efforts that Satya has described in his recent emails. Collectively, the clarity, focus and alignment across the company, and the opportunity to deliver the results of that work into the hands of people, will allow us to increase our success in the future.
Regards,
Stephen
Source: https://news.microsoft.com/2014/07/17/stephen-elops-email-to-employees/
Year 2 Forecast MAPE
New Star Grocery Company | |||||||||||||
Sales | |||||||||||||
b1 | Year 2 | Customers (x) | Actual Y(t) | Forecast F(t) | Y(t) - F(t) | PE | APE | ||||||
b0 | January | 215 | |||||||||||
February | 259 | ||||||||||||
Y= b0+ b1x | March | 325 | |||||||||||
April | 354 | ||||||||||||
May | 258 | ||||||||||||
June | 199 | ||||||||||||
July | 254 | ||||||||||||
August | 299 | ||||||||||||
September | 264 | ||||||||||||
October | 198 | ||||||||||||
November | 223 | ||||||||||||
December | 261 | ME = Mean error | |||||||||||
MPE = Mean percentage error | |||||||||||||
ME | MPE | MAPE | MAPE = Mean absolute percentage error | ||||||||||
SES - MAPE
New Star Grocery Company | ||||||||||||||
Alpha | Alpha | |||||||||||||
0.15 | 0.9 | |||||||||||||
Year 2 | Sales, Y(t) | F(t) | Y(t) - F(t) | PE | APE | F(t) | Y(t) - F(t) | PE | APE | |||||
January | ||||||||||||||
February | ||||||||||||||
March | ||||||||||||||
April | ||||||||||||||
May | ||||||||||||||
June | ||||||||||||||
July | ||||||||||||||
August | ME = Mean error | |||||||||||||
September | MPE = Mean percentage error | |||||||||||||
October | MAPE = Mean absolute percentage error | |||||||||||||
November | ||||||||||||||
December | ||||||||||||||
ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||||||
ME | MPE | MAPE | ME | MPE | MAPE | |||||||||
Scenario: You are a consultant for the Diligent Consulting Group (DCG). You have completed the first assignment, developing and testing a forecasting method that uses Linear Regression (LR) techniques (Module 2 Case). However, the consulting manager at DCG wants to try a different forecasting method as well. Now you decide to try Single Exponential Smoothing (SES) to forecast sales.
Using this Excel template: Data chart for BUS520 SLP 2 , do the following:
Calculate the MAPE for Year 2 Linear Regression forecast (use the first spreadsheet tab labeled “Year 2 Forecast – MAPE”).
Calculate forecasted sales for Year 2 using SES (use the second spreadsheet tab labeled “SES – MAPE”). Use 0.15 and 0.90 alphas.
Compare the MAPE calculated for the LR forecast (#1 above) with the MAPEs calculated using SES.
Then write a report to your boss in which you discuss the results obtained above. Using calculated MAPE values, make a recommendation concerning which method appears to be more accurate for the Year 2 data: SES or Linear Regression.
SLP Assignment Expectations
Analysis
Conduct accurate and complete SES analysis in Excel. You may also check the following link for your reference: https://support.office.com/en-US/article/data-analysis-7e71735c-c471-47e1-84ef-a8c23dc3098b
Written Report
· Provide a brief introduction to/background of the problem.
· Complete a written analysis that supports your Excel analysis, discussing the assumptions, rationale, and logic used to complete your SES forecast.
· Give complete, meaningful, and accurate recommendation(s) relating to whether LR or SES is more accurate in predicting sales.
· Write clearly, simply, and logically. Use double-spaced, black Verdana or Times Roman font in 12 pt. type size.
· Have an introduction at the beginning to introduce the topics and use keywords as headings to organize the report.
· Avoid redundancy and general statements such as "All organizations exist to make a profit." Make every sentence count.
· Paraphrase the facts using your own words and ideas, employing quotes sparingly. Quotes, if absolutely necessary, should rarely exceed five words.
· Upload both your written report and Excel file to the SLP 2 Dropbox .
Scenario:
You are a consultant for the Diligent Consulting Group (DCG). You have completed the first
assignment, developing and testing a forecasting method that uses Linear Regression (LR) techniques
(Module 2 Case). However, the consulting manager at DCG wants to
try a different forecasting method as
well. Now you decide to try Single Exponential Smoothing (SES) to forecast sales.
Using this Excel template:
Data chart for BUS520 SLP 2
, do the following:
Calculate the MAPE for Year 2 Linear Regression forecast (use the first spreadsheet tab labeled “Year 2
Forecast
–
MAPE”).
Calculate forecasted sales for Year 2 using SES (use the second spreadsheet tab labeled “SES
–
MAPE”).
Use 0.15 and 0.90 alphas.
Comp
are the MAPE calculated for the LR forecast (#1 above) with the MAPEs calculated using SES.
Then write a report to your boss in which you discuss the results obtained above. Using calculated MAPE
values, make a recommendation concerning which method appear
s to be more accurate for the Year 2
data: SES or Linear Regression.
SLP Assignment Expectations
Analysis
Conduct accurate and complete SES analysis in Excel. You may also check the following link for your
reference:
https://support.office.com/en
-
US/article/data
-
analysis
-
7e71735c
-
c471
-
47e1
-
84ef
-
a8c23dc3098b
Written Report
·
L
ength requirements:
2
-
3 pages minimum
(not including Cover and Re
ference
pages).
NOTE:
You must submit 2
-
3 pages of
written discussion and analysis.
This means that
you should avoid use of tables and charts as “space fillers.”
·
Provide a brief introduction to/background of the problem.
·
Complete a written analysis that
supports your Excel analysis, discussing the assumptions,
rationale, and logic used to complete your SES forecast.
·
Give complete, meaningful, and accurate recommendation(s) relating to whether LR or SES is
more accurate in predicting sales.
·
Write clearly,
simply, and logically. Use double
-
spaced, black Verdana or Times Roman font in 12
pt. type size.
·
Have an introduction at the beginning to introduce the topics and use keywords as headings to
organize the report.
·
Avoid redundancy and general statements such
as "All organizations exist to make a profit." Make
every sentence count.
·
Paraphrase the facts using your own words and ideas, employing quotes sparingly. Quotes, if
absolutely necessary, should rarely exceed five words.
·
Upload both your written report an
d Excel file to the SLP 2 Dropbox .
Scenario: You are a consultant for the Diligent Consulting Group (DCG). You have completed the first
assignment, developing and testing a forecasting method that uses Linear Regression (LR) techniques
(Module 2 Case). However, the consulting manager at DCG wants to try a different forecasting method as
well. Now you decide to try Single Exponential Smoothing (SES) to forecast sales.
Using this Excel template: Data chart for BUS520 SLP 2, do the following:
Calculate the MAPE for Year 2 Linear Regression forecast (use the first spreadsheet tab labeled “Year 2
Forecast – MAPE”).
Calculate forecasted sales for Year 2 using SES (use the second spreadsheet tab labeled “SES – MAPE”).
Use 0.15 and 0.90 alphas.
Compare the MAPE calculated for the LR forecast (#1 above) with the MAPEs calculated using SES.
Then write a report to your boss in which you discuss the results obtained above. Using calculated MAPE
values, make a recommendation concerning which method appears to be more accurate for the Year 2
data: SES or Linear Regression.
SLP Assignment Expectations
Analysis
Conduct accurate and complete SES analysis in Excel. You may also check the following link for your
reference: https://support.office.com/en-US/article/data-analysis-7e71735c-c471-47e1-84ef-a8c23dc3098b
Written Report
Length requirements: 2 - 3 pages minimum (not including Cover and Reference
pages). NOTE: You must submit 2 - 3 pages of written discussion and analysis. This means that
you should avoid use of tables and charts as “space fillers.”
Provide a brief introduction to/background of the problem.
Complete a written analysis that supports your Excel analysis, discussing the assumptions,
rationale, and logic used to complete your SES forecast.
Give complete, meaningful, and accurate recommendation(s) relating to whether LR or SES is
more accurate in predicting sales.
Write clearly, simply, and logically. Use double-spaced, black Verdana or Times Roman font in 12
pt. type size.
Have an introduction at the beginning to introduce the topics and use keywords as headings to
organize the report.
Avoid redundancy and general statements such as "All organizations exist to make a profit." Make
every sentence count.
Paraphrase the facts using your own words and ideas, employing quotes sparingly. Quotes, if
absolutely necessary, should rarely exceed five words.
Upload both your written report and Excel file to the SLP 2 Dropbox .
Scenario: You are a consultant who works for the Diligent Consulting Group. Your client, the New Star Grocery Company, believes that there may be a relationship between the number of customers who visit the store during any given month (“customer traffic”) and the total sales for that same month. In other words, the greater the customer traffic, the greater the sales for that month. To test this theory, the client has collected customer traffic data over the past 12-month period, and monthly sales for that same 12-month period (Year 1).
Case Assignment
Using the customer traffic data and matching sales for each month of Year 1, create a Linear Regression (LR) equation in Excel, assuming all assumptions for linear regression have been met. Use the Excel template provided (see “Module 2 Case – LR –Year 1” spreadsheet tab), and be sure to include your LR chart (with a trend line) where noted. Also, be sure that you include the LR formula within your chart.
After you have developed the LR equation above, you will use the LR equation to forecast sales for Year 2 (see the second Excel spreadsheet tab labeled “Year 2 Forecast”). You will note that the customer has collected customer traffic data for Year 2. Your role is to complete the sales forecast using the LR equation from Step 1 above.
After you have forecast Year 2 sales, your Professor will provide you with 12 months of actual sales data for Year 2. You will compare the sales forecast with the actual sales for Year 2, noting the monthly and average (total) variances from forecast to actual sales.
To complete the Module 2 Case, write a report for the client that describes the process you used above, and that analyzes the results for Year 2. (What is the difference between forecast vs. actual sales for Year 2—by month and for the year as a whole?) Make a recommendation concerning how the LR equation might be used by New Star Grocery Company to forecast future sales.
Data: Download the Module 2 Case template here: Data chart for BUS520 Case 2 . Use this template to complete your Excel analysis.
Assignment Expectations
Excel Analysis
Conduct accurate and complete Linear Regression analysis in Excel. Use Excel support to find information on linear regression in Excel: https://support.office.com/en-us/Search/results?query=linear+regression
Written Report
· Provide a brief introduction to/background of the problem.
· Your written (in Word) analysis should discuss the logic and rationale used to develop the LR equation and chart.
· Provide complete, meaningful, and accurate recommendation(s) concerning how the New Star Grocery Company might use the LR equation to forecast future sales. (For example, how reliable is the LR equation in predicting future sales?) What other recommendations do you have for the client?
· Write clearly, simply, and logically. Use double-spaced, black Verdana or Times Roman font in 12 pt. type size.
· Have an introduction at the beginning to introduce the topics and use keywords as headings to organize the report.
· Avoid redundancy and general statements such as "All organizations exist to make a profit." Make every sentence count.
· Paraphrase the facts using your own words and ideas, employing quotes sparingly. Quotes, if absolutely necessary, should rarely exceed five words.
· Upload both your written report and Excel file to the case 2 Dropbox.
Here are some guidelines on how to build critical thinking skills.
· Emerald Group Publishing. (n.d.). Developing Critical Thinking. Retrieved from http://www.emeraldinsight.com/learning/study_skills/skills/critical_thinking.htm
Scenario:
You are a consultant who works for the Diligent Consulting Group. Your client, the New Star
Grocery Company, believes that there may be a relationship between the number of customers who visit
the store during any given month (“customer traffic”) and the
total sales for that same month. In other
words, the greater the customer traffic, the greater the sales for that month. To test this theory, the client
has collected customer traffic data over the past 12
-
month period, and monthly sales for that same 12
-
m
onth period (Year 1).
Case Assignment
Using the customer traffic data and matching sales for each month of Year 1, create a Linear Regression
(LR) equation in Excel, assuming all assumptions for linear regression have been met. Use the Excel
template provided (see “Module 2 Case
–
LR
–
Year 1”
spreadsheet tab), and be sure to include your LR
chart (with a trend line) where noted. Also, be sure that you include the LR formula within your chart.
After you have developed the LR equation above, you will use the LR equation to forecast sales for Year
2
(see the second Excel spreadsheet tab labeled “Year 2 Forecast”). You will note that the customer has
collected customer traffic data for Year 2. Your role is to complete the sales forecast using the LR equation
from Step 1 above.
After you have forecas
t Year 2 sales, your Professor will provide you with 12 months of actual sales data
for Year 2. You will compare the sales forecast with the actual sales for Year 2, noting the monthly and
average (total) variances from forecast to actual sales.
To complet
e the Module 2 Case, write a report for the client that describes the process you used above,
and that analyzes the results for Year 2. (What is the difference between forecast vs. actual sales for Year
2
—
by month and for the year as a whole?) Make a recom
mendation concerning how the LR equation
might be used by New Star Grocery Company to forecast future sales.
Data:
Download the Module 2 Case template here:
Data chart for BUS520 Case 2
. Use this template to
complete your Excel analysis.
Assignment Expectations
Excel Analysis
Conduct accurate and
complete Linear Regression analysis in Excel. Use Excel support to find information
on linear regression in Excel:
https://support.office.com/en
-
us/Search/
results?query=linear+regression
Written Report
·
Length requirements:
4
–
5 pages minimum
(not including Cover and Reference
pages).
NOTE:
You must submit 4
–
5 pages of
written discussion and analysis
.
This means that
you should avoid use of tables and charts a
s “space fillers.”
·
Provide a brief introduction to/background of the problem.
·
Your written (in Word) analysis should discuss the logic and rationale used to develop the LR
equation and chart.
·
Provide complete, meaningful, and accurate recommendation(s) con
cerning how the New Star
Grocery Company might use the LR equation to forecast future sales. (For example, how
reliable is the LR equation in predicting future sales?) What other recommendations do you
have for the client?
·
Write clearly, simply, and logica
lly. Use double
-
spaced, black Verdana or Times Roman font in 12
pt. type size.
·
Have an introduction at the beginning to introduce the topics and use keywords as headings to
organize the report.
·
Avoid redundancy and general statements such as "All organizat
ions exist to make a profit." Make
every sentence count.
·
Paraphrase the facts using your own words and ideas, employing quotes sparingly. Quotes, if
absolutely necessary, should rarely exceed five words.
·
Upload both your written report and Excel file to th
e case 2 Dropbox.
Scenario: You are a consultant who works for the Diligent Consulting Group. Your client, the New Star
Grocery Company, believes that there may be a relationship between the number of customers who visit
the store during any given month (“customer traffic”) and the total sales for that same month. In other
words, the greater the customer traffic, the greater the sales for that month. To test this theory, the client
has collected customer traffic data over the past 12-month period, and monthly sales for that same 12-
month period (Year 1).
Case Assignment
Using the customer traffic data and matching sales for each month of Year 1, create a Linear Regression
(LR) equation in Excel, assuming all assumptions for linear regression have been met. Use the Excel
template provided (see “Module 2 Case – LR –Year 1” spreadsheet tab), and be sure to include your LR
chart (with a trend line) where noted. Also, be sure that you include the LR formula within your chart.
After you have developed the LR equation above, you will use the LR equation to forecast sales for Year 2
(see the second Excel spreadsheet tab labeled “Year 2 Forecast”). You will note that the customer has
collected customer traffic data for Year 2. Your role is to complete the sales forecast using the LR equation
from Step 1 above.
After you have forecast Year 2 sales, your Professor will provide you with 12 months of actual sales data
for Year 2. You will compare the sales forecast with the actual sales for Year 2, noting the monthly and
average (total) variances from forecast to actual sales.
To complete the Module 2 Case, write a report for the client that describes the process you used above,
and that analyzes the results for Year 2. (What is the difference between forecast vs. actual sales for Year
2—by month and for the year as a whole?) Make a recommendation concerning how the LR equation
might be used by New Star Grocery Company to forecast future sales.
Data: Download the Module 2 Case template here: Data chart for BUS520 Case 2. Use this template to
complete your Excel analysis.
Assignment Expectations
Excel Analysis
Conduct accurate and complete Linear Regression analysis in Excel. Use Excel support to find information
on linear regression in Excel: https://support.office.com/en-us/Search/results?query=linear+regression
Written Report
Length requirements: 4–5 pages minimum (not including Cover and Reference
pages). NOTE: You must submit 4–5 pages of written discussion and analysis. This means that
you should avoid use of tables and charts as “space fillers.”
Provide a brief introduction to/background of the problem.
Your written (in Word) analysis should discuss the logic and rationale used to develop the LR
equation and chart.
Provide complete, meaningful, and accurate recommendation(s) concerning how the New Star
Grocery Company might use the LR equation to forecast future sales. (For example, how
reliable is the LR equation in predicting future sales?) What other recommendations do you
have for the client?
Write clearly, simply, and logically. Use double-spaced, black Verdana or Times Roman font in 12
pt. type size.
Have an introduction at the beginning to introduce the topics and use keywords as headings to
organize the report.
Avoid redundancy and general statements such as "All organizations exist to make a profit." Make
every sentence count.
Paraphrase the facts using your own words and ideas, employing quotes sparingly. Quotes, if
absolutely necessary, should rarely exceed five words.
Upload both your written report and Excel file to the case 2 Dropbox.
Mod 2 Case - LR - Year 1
New Star Grocery Company | Insert chart here | ||||||||||||
Year 1 | Customers | Sales ($000) | Number | Month | Customers (x) | Sales (y) | XY | X2 | Y2 | ||||
January | 185 | 230 | 1 | January | |||||||||
February | 241 | 301 | 2 | February | |||||||||
March | 374 | 310 | 3 | March | |||||||||
April | 421 | 389 | 4 | April | |||||||||
May | 425 | 421 | 5 | May | |||||||||
June | 259 | 300 | 6 | June | |||||||||
July | 298 | 318 | 7 | July | |||||||||
August | 321 | 298 | 8 | August | |||||||||
September | 215 | 202 | 9 | September | |||||||||
October | 282 | 265 | 10 | October | |||||||||
November | 235 | 312 | 11 | November | |||||||||
December | 300 | 298 | 12 | December | |||||||||
Totals | 0 | 0 | - 0 | - 0 | - 0 | ||||||||
Mean | 0 | 0.00 | |||||||||||
X-bar | Y-bar | ||||||||||||
b1 | ERROR:#DIV/0! | ||||||||||||
b0 | ERROR:#DIV/0! | ||||||||||||
Y= b0+ b1x |
Year 2 Forecast
New Star Grocery Company | ||||||||||
Sales | ||||||||||
b1 | ERROR:#DIV/0! | Year 2 | Customers (x) | Actual Y(t) | Forecast F(t) | Variance | ||||
b0 | ERROR:#DIV/0! | January | 215 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||
February | 259 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||||
Y= b0+ b1x | March | 325 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
April | 354 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||||
May | 258 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||||
June | 199 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||||
July | 254 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||||
August | 299 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||||
September | 264 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||||
October | 198 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||||
November | 223 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||||
December | 261 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||||
Totals | 259.08 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||

Get help from top-rated tutors in any subject.
Efficiently complete your homework and academic assignments by getting help from the experts at homeworkarchive.com