QRB 501 NERD Education Specialist /qrb501nerd.com

1
QRB 501 NERD Education Specialist /qrb501nerd.com
2
QRB 501 NERD Education Specialist /qrb501nerd.com
QRB 501 Entire Course (No Final Guide) FOR MORE
CLASSES VISIT www.qrb501nerd.com   QRB 501 Week 1
Fundamental Quantitative Concepts Exercises QRB
501 Week 2 Team Assignment Equations and
Percentage Cases QRB 501 Week 3 Mathematics of
Buying and Selling Exercises QRB 501 Week 3 Team
Assignment Trade and Cash Discount Cases QRB 501
Week 4 Data Analytics Problem Set QRB 501 Week 5
Quantitative Techniques in Financial Valuation
Problem Set QRB 501 Week 5 Team Assignment
Financial Valuation (Time-Value of Money) Cases
QRB 501 Week 6 Signature Assignment QRB 501
Week 2 DQ 1 QRB 501 Week 2 DQ 2 QRB 501 Week 3
DQ 1 QRB 501 Week 3 DQ 2 QRB 501 Week 4 DQ 1
3
QRB 501 NERD Education Specialist /qrb501nerd.com
QRB 501 Final Exam Guide (100 Score, with Excel
File) FOR MORE CLASSES VISIT www.qrb501nerd.com
  This Tutorial contains an Excel file which can
be used to solve for any change in values 1) What
A-Pane Inc. sells windows for 101.12 each after
a markup of 33.35. Find the cost of a window and
the markup as a percent of selling price 2) Solve
the problem. Round amounts to the nearest cent
and percents to the nearest tenth of a percent
Markup 5.02 Selling Price 88.41. Find the
cost and the rate of markup based on cost.
3) Solve the problem. Round to the nearest cent
or tenth of a percent. James page works in a
local music store where he sells guitars for
159.13 each. If he maintains a markup of 64.2
on selling price, what is the cost of guitar to
James? 4) Find the percent increase ( or
decrease) in net sales from last year to this
year for the income statement. Round your answer
to the nearest tenth. 5) For the month ending
june 30, TriCounty Nursery has net sales of
237,000, cost of goods sold of 114,000 and
operating expenses of 53,000.
4
QRB 501 NERD Education Specialist /qrb501nerd.com
QRB 501 Week 1 DQ 1 FOR MORE CLASSES
VISIT www.qrb501nerd.com   DQ1-Week 1 Please
respond to this discussion question by Thursday
(Day 3) In management, how important is it to
learn to use mathematics to solve problems? How
valuable is an MBA degree without the ability to
identify and calculate the cost of a companys
capital, its return on investment, gross margin
percentage, break-even point, or what percent of
a population would be willing to buy its product?
5
QRB 501 NERD Education Specialist /qrb501nerd.com
QRB 501 Week 1 DQ 2 FOR MORE CLASSES
VISIT www.qrb501nerd.com   DQ2-Week 1 Please
respond to this discussion question by Saturday
(Day 5) When using the formula NI U
(P-VCu) - FC, in which order must you complete
the calculation? Why does the order of operations
matter?
6
QRB 501 NERD Education Specialist /qrb501nerd.com
QRB 501 Week 1 Fundamental Quantitative Concepts
Exercises FOR MORE CLASSES VISIT www.qrb501nerd.
com   Purpose of Assignment The purpose of this
assignment is for students to learn how to use
Microsoft Excel for solving formulas. Managers
and staff need to work with percentages daily in
professional settings. Skills such as finding the
percentage increase/decrease and using Excel to
convert from decimals to percentages and vice
versa have become necessary. This assignment
provides students with the practice of such
fundamental quantitative concepts. Assignment
Steps Resources Fundamental Quantitative
Concepts Exercises Excel Template Save the
Fundamental Quantitative Concepts Exercises
Excel Template to your computer. Read the
instructions on the first tab. Complete the ten
Excel exercises. A scale drawing of an office
building is not labeled, but indicates 0.25 inch
5 feet. On the drawing, one wall measures 2
inches. How long is the actual wall? Marcus James
purchased 2,500 pounds of produce. Records
indicate he purchased 800 pounds of potatoes, 150
pounds of broccoli, and 390 pounds of tomatoes.
He also purchased apples.
7
QRB 501 NERD Education Specialist /qrb501nerd.com
QRB 501 Week 2 DQ 1 FOR MORE CLASSES
VISIT www.qrb501nerd.com   DQ1-Week 2 Please
respond to this discussion question by Thursday
(Day 3) What is forecasting? What information is
forecasted at your organization? Which
forecasting methods are used at your
organization? What information at your
organization is not currently being forecasted
that could be forecasted to increase productivity
or decrease waste?
8
QRB 501 NERD Education Specialist /qrb501nerd.com
QRB 501 Week 2 DQ 2 FOR MORE CLASSES
VISIT www.qrb501nerd.com   DQ2-Week 2 Please
respond to this discussion question by Saturday
(Day 5) Access http//www.conference-board.org/ec
onomics/ConsumerConfidence.cfm. This is an index
based on how people feel about the economy. All
indexes are created in a similar fashion. A base
is first selected. In this case, the base was
1985 and set at 100. Thus, if the index was at
57.2 in May 2008, and in October 1992 the index
was at 54.6, are people feeling better or worse
in 2008 than they did in 1992? If the index was
at 62.8 in April 2008, what does that mean for
May 2008?
9
QRB 501 NERD Education Specialist /qrb501nerd.com
QRB 501 Week 2 Team Assignment Equations and
Percentage Cases FOR MORE CLASSES
VISIT www.qrb501nerd.com   Purpose of Assignment
The purpose of this assignment is to provide
students an opportunity to apply the concepts of
equations and percentages covered in Ch. 5 and 6
to integrated case studies. Assignment Steps
Resources Equations and Percentage Cases Excel
Template, Excel 2016 Essential Training Save the
Equations and Percentage Cases Excel Template to
your computer. Read the instructions on the first
tab. Complete the two Excel cases located in the
template. Click the Assignment Files tab to
submit your assignment. Refer to the Chapter 5
Case Study 5-1 on Page 187 of your text. Answer
the following questions. Question 1 Find the
total square footage that requires painting for
the bedroom and the living/dining room, and then
?nd the total square footage for the entire
painting job assuming two coats of paint.
Question 2 One gallon of paint will cover 350
square feet and costs 35, and each surface will
require two coats.
10
QRB 501 NERD Education Specialist /qrb501nerd.com
QRB 501 Week 3 DQ 1 FOR MORE CLASSES
VISIT www.qrb501nerd.com   DQ1-Week 3 Please
respond to this discussion question by Thursday
(Day 3) Why are graphs and charts used to
represent information? What distinguishes a
histogram from a bar chart? What are some
examples of grouped and ungrouped data? What
would be the most appropriate graphical
representation to show the dispersion of new home
prices in a particular area? Why?
11
QRB 501 NERD Education Specialist /qrb501nerd.com
  QRB 501 Week 3 DQ 2 FOR MORE CLASSES
VISIT www.qrb501nerd.com   DQ2-Week 3 Please
respond to this discussion question by Saturday
(Day 5) What is the purpose of using correlation
analysis? How might correlation analysis be used
in business decisions or in strategy formulation
and implementation? How might correlation
analysis be misused to explain a cause-and-effect
relationship?  
12
QRB 501 NERD Education Specialist /qrb501nerd.com
QRB 501 Week 3 Mathematics of Buying and Selling
Exercises FOR MORE CLASSES VISIT www.qrb501nerd.
com   Purpose of Assignment The purpose of the
assignment is to provide students an opportunity
to use Microsoft Excel to practice the concepts
of trade discounts, invoicing, markups, and
markdowns. Assignment Steps Resources
Mathematics of Buying and Selling Exercises
Excel Template, Excel 2016 Essential Training
Save the Mathematics of Buying and Selling
Exercises Excel Template to your computer. Read
the instructions on the first tab. Complete the
ten exercises located in the template. Click the
Assignment Files tab to submit your assignment.
Nordstrom plans to mark up a Brahmin Croc
Embossed Laptop Case 130.50 over cost, which is
a 58 markup based on the cost. Find the cost,
the selling price, and the rate of the selling
price. Ronin Copies marks up signs that sell for
49. The markup is 80 based on the selling price.
13
QRB 501 NERD Education Specialist /qrb501nerd.com
QRB 501 Week 3 Team Assignment Trade and Cash
Discount Cases FOR MORE CLASSES
VISIT www.qrb501nerd.com   Purpose of Assignment
The purpose of this assignment is to provide
students an opportunity to apply the concepts of
trade and cash discounts covered in Ch. 8 to
integrated case studies. Assignment Steps
Resources Trade and Cash Discount Cases Excel
Template Save the Trade and Cash Discount Cases
Excel Template to your computer. Read the
instructions on the first tab. Complete the two
Excel cases located in the template. Click the
Assignment Files tab to submit your assignment.
Case 8.1 Chapter 8 Page 305 of your text Text
Business Math, Eleventh Edition Case 8.1 Image
Manufacturing's Rebate Offer Case 8.3 Chapter 8
Page 306/307 of your text Text Business Math,
Eleventh Edition Case 8.3 The Artist's Palette
14
QRB 501 NERD Education Specialist /qrb501nerd.com
QRB 501 Week 4 Data Analytics Problem Set FOR
MORE CLASSES VISIT www.qrb501nerd.com   Purpose
of Assignment The purpose of this assignment is
to provide students opportunities to reinforce
the fundamental topics in data analytics. Through
this assignment, students will learn how to read
information from bar charts, pie charts, line
charts, and frequency distributions. Students
will also use Microsoft Excel's pivot table
functionality to create frequency distributions,
bar charts, and pie charts. The assignment also
includes evaluating basic descriptive statistics
using Microsoft Excel. Assignment Steps
Resources Data Analytics Problem Set Excel
Template, Excel 2016 Essential Training Save the
Data Analytics Problem Set Excel Template to
your computer. Read the instructions on the first
tab. Complete the twelve exercises located in the
template and record
15
QRB 501 NERD Education Specialist /qrb501nerd.com
QRB 501 Week 4 DQ 1 FOR MORE CLASSES
VISIT www.qrb501nerd.com   DQ1-Week 4 Please
respond to this discussion question by Thursday
(Day 3) How do you apply the time value of money
concept to make decisions in your personal life?
How might you use the Time Value of Money concept
as a quantitative reasoning tool in business?
16
QRB 501 NERD Education Specialist /qrb501nerd.com
QRB 501 Week 4 DQ 2 FOR MORE CLASSES
VISIT www.qrb501nerd.com   DQ2-Week 4 Please
respond to this discussion question by Saturday
(Day 5) Often in personal finance we want to
know what our 1 investment today will be worth
in 20 years. In business however, there is more
concern with answering the question, If I
receive 100 in 5 years, what is that worth
today? To answer this question, modify the
formula fv pv((1i)n) and use the reciprocal.
Simply stated, the reciprocal of a number is 1
divided by the number the reciprocal of 10, for
example, is 1/10. In the formula above, we divide
both sides by ((1i)n), which creates a new
formula where the fv is multiplied by the
reciprocal of the original fv(1/((1i)n))pv.
Select an interest rate and number of periodsbe
sure your numbers are different from other
students who already answered this question
17
QRB 501 NERD Education Specialist /qrb501nerd.com
QRB 501 Week 5 DQ 1 FOR MORE CLASSES
VISIT www.qrb501nerd.com   DQ1-Week 5 Please
respond to this discussion question by Thursday
(Day 3) Does all statistical data have a mean,
median, or mode? Why? When is the mean the best
measure of central tendency? When is the median
the best measure of central tendency?
18
QRB 501 NERD Education Specialist /qrb501nerd.com
QRB 501 Week 5 DQ 2 FOR MORE CLASSES
VISIT www.qrb501nerd.com   DQ2-Week 5 Please
respond to this discussion question by Saturday
(Day 5) What is the middle? If we have student
scores of 4.0, 3.7, 3.7, 3.7, and 1.0, the
average would be 3.2, whereas both the median and
the mode would be 3.7. Is one of them truly in
the middle? How dispersed is this list? That is,
how much do the scores vary from the middle?
Consider a routine task you do daily. Which
matters most, the average time it takes to
complete the task or the most frequent amount of
time? How much does the time spent on the task
vary? How would you go about finding the middle
of the process.
19
QRB 501 NERD Education Specialist /qrb501nerd.com
  QRB 501 Week 5 Quantitative Techniques in
Financial Valuation Problem Set FOR MORE
CLASSES VISIT www.qrb501nerd.com   Purpose of
Assignment The purpose of this assignment is to
provide students an opportunity to practice and
learn the time-value of money concepts covered
during Week 4. Students will understand how to
evaluate future values, present values, interest
rates, and time periods for financial
investments. Assignment Steps Resources
Quantitative Techniques in Financial Valuation
Problem Set Excel Template Save the Quantitative
Techniques in Financial Valuation Problem Set
Excel Template to your computer. Read the
instructions on the first tab. Complete the
twelve exercises located in the template and
record your answers in the highlighted spaces.
Format your paper consistent with APA guidelines.
Find the interest paid on a loan
20
QRB 501 NERD Education Specialist /qrb501nerd.com
QRB 501 Week 5 Team Assignment Financial
Valuation (Time-Value of Money) Cases FOR MORE
CLASSES VISIT www.qrb501nerd.com   Purpose of
Assignment The purpose of this assignment is to
provide students an opportunity to apply the
concepts of time value of money covered in Ch. 13
to integrated case studies. Assignment Steps
Resources Financial Valuation (Time-Value of
Money) Cases Excel Template Save the Financial
Valuation (Time-Value of Money) Cases Excel
Template to your computer. Read the instructions
on the first tab. Complete the three cases
located in the template. Click the Assignment
Files tab to submit your assignment. Barry
learned in an online investment course that he
should start investing as soon as possible. He
had always thought that it would be smart to
start investing after he finishes college and
when his salary is high enough to pay the bills
and to have money left over. He projects that
will be 510 years from now. Barry wants to
compare the difference between i
21
QRB 501 NERD Education Specialist /qrb501nerd.com
QRB 501 Week 6 DQ 1 FOR MORE CLASSES
VISIT www.qrb501nerd.com   DQ1-Week 6 Please
respond to this discussion question by Thursday
(Day 3) What are the elements of a decision? How
does statistical decision theory differ in
conditions of certainty and uncertainty? When
making a decision, can doing nothing be a valid
alternative? Why? Please remember to cite your
sources.
22
QRB 501 NERD Education Specialist /qrb501nerd.com
QRB 501 Week 6 DQ 2 FOR MORE CLASSES
VISIT www.qrb501nerd.com   DQ2-Week 6 Please
respond to this discussion question by Saturday
(Day 5) What skills do managers need today? Are
these skills different from management skills of
50 years ago? Why?
23
QRB 501 NERD Education Specialist /qrb501nerd.com
QRB 501 Week 6 Signature Assignment FOR MORE
CLASSES VISIT www.qrb501nerd.com   About Your
Signature Assignment This signature assignment is
designed to align with specific program student
learning outcome(s) in your program. Program
Student Learning Outcomes are broad statements
that describe what students should know and be
able to do upon completion of their degree. The
signature assignment may be graded with an
automated rubric that allows the University to
collect data that can be aggregated across a
location or college/school and used for program
improvements. Purpose of Assignment The purpose
of this assignment is for students to synthesize
the concepts learned throughout the course,
provide students an opportunity to build critical
thinking skills, develop businesses and
organizations, and solve problems that require
data. Assignment Steps Note Although you will be
studying the concept of CPI in more detail in
your future ECO/561 class, for
24
QRB 501 NERD Education Specialist /qrb501nerd.com