1 / 43

QRB 501 Inspiring Innovation- tutorialrank.com

For more course tutorials visit<br>www.tutorialrank.com<br><br>QRB 501 Apply Week 2 Comparison Shopping Worksheet Comparison Shopping<br> <br>Background <br>Choose a product or service that you would like to purchase <br>

Nicholsons92
Download Presentation

QRB 501 Inspiring Innovation- tutorialrank.com

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. QRB 501 Apply Week 2 Comparison Shopping Worksheet Comparison Shopping For more course tutorials visit www.tutorialrank.com QRB 501 Apply Week 2 Comparison Shopping Worksheet Comparison Shopping Background Choose a product or service that you would like to purchase for your office or yourself: ______________ Search the internet to find three providers who have different prices for the product or service: a. b. c. Product Description

  2. 1. Describe in 2 to 4 sentences the product or service you wish to purchase. 1. Indicate the amount of money in dollars that you have budgeted to pay for the product or service: $_________________ Product Comparison 1. Complete the chart below with information from your research. Name of Provider Link to Website Price of Product 1. Compare in a total of 260 words the product or service offered on each website. Website Method of Delivery Warranties Tax Rates Extra Components/Services Other Differences a. b.

  3. Calculations 1. Suppose each of these products/services has a 30% markup based on selling price. Calculate each supplier's cost for the product/service.[Hint: First find the markup in dollars, then use the formula Price=Cost + Markup to find the supplier's cost.] Website a: (name) Website b: (name) Website c: (name) Supplier’s Cost: $ $ $ 1. Now that you have calculated the cost of the product, use that information to calculate the percentage markup based on cost. [Hint: Percentage markup based on cost is = (Price-Cost)/Cost.] Website a: (name) Website b: (name) Website c: (name) Percentage Markup: % % % 1. Calculate the percentage difference between the price you would like to pay and the price of the product/service. Remember, this percentage will be positive if the price of the product or service is lower than the price you would like to pay. If the price is over-

  4. budget then there will be a negative number. If the price is under budget then there will be a positive number. [Hint: To calculate the percentage difference, you should use the formula: (Budget - Price)/Budget.] Website a: (name) Website b: (name) Website c: (name) Percentage Difference: % % % Analysis 1. Write a 175- to 350-word analysis of which product you would select for purchase. Keep in mind that your purchase decision does not necessarily have to be the product with the lowest cost but you should support your decision with information from your analysis. ********************************************* QRB 501 Apply Week 3 Data Analytics Problem Set Excel Template For more course tutorials visit www.tutorialrank.com QRB 501 Apply: Data Analytics Problem Set Excel® Template WEEK 3 Resources: Data Analytics Problem Set Excel® Template, Excel® 2016 Essential Training

  5. 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 your answers in the highlighted spaces. Click the Assignment Files tab to submit your assignment. ********************************************* QRB 501 Apply Week 4 Income and Mortgages Mind Map For more course tutorials visit www.tutorialrank.com QRB 501 Apply: Income and Mortgages Mind Map WEEK 4 Explore three different Internet sites for providers of home mortgages or consumer credit. Create a 350-word mind map in which you explain the differences in the mortgages or credit terms and which would be best for you. Include the following:What are the terms of the mortgage or credit agreement?

  6. What are the differences in the different choices for this type of credit agreement? Analyze in 175 to 350 words the choice that is best for you and why. Click on the Assignment Files tab to submit your Mind Map. ********************************************* QRB 501 Apply Week 5 Quantitative Techniques in Financial Valuation For more course tutorials visit www.tutorialrank.com QRB 501 Apply: Quantitative Techniques in Financial Valuation Problem Set WEEK 5 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. Click the Assignment Files tab to submit your assignment.

  7. ********************************************* QRB 501 Apply Week 6 Balance Sheets and Income Statements For more course tutorials visit www.tutorialrank.com QRB 501 Apply: Balance Sheets and Income Statements WEEK 6 Complete the Balance Sheets and Income Statement document. Complete parts A and B of this exercise. Examples can be found in Chapter 21 of your textbook. Be sure to notice that Part A is a balance sheet and Part B is an income statement. Also, be sure to note that the most recent year is shown on the left in these financial statements. Formulas and examples for interpretation of results can be found in Table 21-1 of your textbook or the last worksheet tab of this file. Click on the Assignment Files tab to submit your document. *********************************************

  8. QRB 501 Assignment Week 1 Practice Concepts and Basic Data Analysis For more course tutorials visit www.tutorialrank.com QRB 501 Assignment Week 1 Practice Concepts and Basic Data Analysis Use the internet to find one example of each of the following graphs: • Line graph • Bar graph (horizontal or vertical bars are acceptable) • Pie graph • Suppose you were presenting these graphs to a group of people (clients, co-workers, friends, etc.) who are not mathematically savvy. Create a 7- to 10-slide presentation with speaker notes that provides a non-technical explanation of each graph. Remember, you are addressing people who probably do not like or understand mathematical terms. For each graph, include the following:Screenshot of your graph. • For the line graph, what are the labels on the horizontal and vertical axes?

  9. • For the bar graph, what labels are on the bars? What is being measured in this graph? (Hint: look at the axis label.) • For the pie graph, what is the title, in other words, what is it measuring? • How would you improve each graph if at all? Is anything missing, misleading, or perhaps just wrong with this graph? • What would be the appropriate measure(s) for central tendency (mean, median, mode) to display with each graph? • What measure of dispersion (range, standard deviation) would be best? • Provide a reference citation for the source of your graph so your facilitator can find the graph online. Note: sometimes information changes from day to day on websites, hence the reason for the required screenshot in first bullet point above. Note: If you are having difficulty finding graphs here are a few places to consider looking: • Your online utility bill • Your fitness app • A dashboard at your office • U.S. Government websites such as: o The Bureau of Labor Statistics o The Bureau of Economic Analysis o The Consumer Financial Protection Bureau

  10. o A scholarly article in the University Llibrary o Business, finance, and money management websites Click the Assignment Files tab to submit your assignment. ********************************************* QRB 501 Entire Course (No Final Guide) For more course tutorials visit www.tutorialrank.com Tutorial Purchased: 4 Times, Rating: A This Tutorial contains an Excel file for Quiz and Practice Set which can be used to solve for any change in values QRB 501 Week 1 Quiz QRB 501 Week 1 Practice Set QRB 501 Week 2 Learning Team Case Studies (5-2 and 6-2) (New) QRB 501 Week 2 Practice Problem Set (with Excel File)

  11. QRB 501 Week 2 Quiz (New, With Excel File) QRB 501 Week 3 Practice Problem Set (with Excel File) QRB 501 Week 3 Quiz (New, With Excel File) QRB 501 Week 3 Learning Team Case Studies (8-3 and 9-1) (New) QRB 501 Week 3 Individual Assignment The Business Side of Standard Deviation (2 PPT) QRB 501 Week 4 Individual Assignment Math in Economics (2 Papers) QRB 501 Week 4 Team Assignment Standard Deviation Abstract (New) QRB 501 Week 5 Practice Problem (New) QRB 501 Week 5 Quiz (New) QRB 501 Week 5 Learning Team Case Studies (21-1 and 21-2) (New) QRB 501 Week 6 Team Assignment Quality Management and Quality Control QRB 501 Week 6 Learning Team Capital Budgeting Case Study (New)

  12. QRB 501 Week 2 Learning Team Assignment Inventory Systems Summary QRB 501 Week 2 DQ 1 QRB 501 Week 2 DQ 2 QRB 501 Week 2 Summary QRB 501 Week 3 Individual Assignment Forecasting with Indices QRB 501 Week 3 Learning Team Assignment Inventory Proposal Part I QRB 501 Week 3 DQ 1 QRB 501 Week 3 DQ 2 QRB 501 Week 3 Summary QRB 501 Week 4 Learning Team Assignment Inventory Proposal Part II QRB 501 Week 4 DQ 1 QRB 501 Week 4 DQ 2 QRB 501 Week 4 Summary QRB 501 Week 5 Learning Team Assignment Inventory Proposal Part III QRB 501 Week 5 DQ 1

  13. QRB 501 Week 5 DQ 2 QRB 501 Week 5 Summary QRB 501 Week 6 Learning Team Assignment Executive Management Presentation QRB 501 Week 6 DQ 1 QRB 501 Week 6 DQ 2 QRB 501 Week 6 Summary ********************************************* QRB 501 Entire Course For more course tutorials visit www.tutorialrank.com QRB 501 Assignment Week 1 Practice Concepts and Basic Data Analysis QRB 501 Apply Week 2 Comparison Shopping Worksheet QRB 501 Apply Week 3 Data Analytics Problem Set Excel Template

  14. QRB 501 Apply Week 4 Income and Mortgages Mind Map QRB 501 Apply Week 5 Quantitative Techniques in Financial Valuation QRB 501 Apply Week 6 Balance Sheets and Income Statements 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

  15. 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 QRB 501 Week 4 DQ 2 QRB 501 Week 5 DQ 1 QRB 501 Week 5 DQ 2 QRB 501 Week 6 DQ 1 QRB 501 Week 6 DQ 2 *********************************************

  16. QRB 501 Final Exam Guide (New 2019 Score 29 30) For more course tutorials visit www.tutorialrank.com Jorge makes a simple discount note with a face value of $6000.00, a term of 240 days, and a 10% discount rate. Find the discount. Discount: $394.52 Discount: $0.00 Discount: $600.00 Discount: $400.00 The following test scores were recorded for a student: 79, 74, 72, 68, 74, 60, 70. Find the mean, median, and mode. •

  17. mean: 72, median: 68, mode: 74 • mean: 72, median: 71, mode: 79 • mean: 71, median: 68, mode: 79 • mean: 71, median: 72, mode: 74 3. Megan Hughes deposits $2300 in an account that pays simple interest. When she withdraws her money 8 months later, she receives $2484.00. What rate of interest did the account pay? Round to the nearest whole percent. 12% per year ********************************************* QRB 501 Week 1 DQ 1 (UOP Course)

  18. For more course tutorials visit www.tutorialrank.com Tutorial Purchased: 4 Times, Rating: A 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 company’s capital, its return on investment, gross margin percentage, break-even point, or what percent of a population would be willing to buy its product? ********************************************* QRB 501 Week 1 DQ 2 (UOP Course) For more course tutorials visit www.tutorialrank.com Tutorial Purchased: 4 Times, Rating: A

  19. 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? ********************************************* QRB 501 Week 1 Fundamental Quantitative Concepts Exercises For more course tutorials visit www.tutorialrank.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.

  20. 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. How many pounds of apples did he purchase? The formula for the installment price of an item purchased with financing is Installment price = Total of installment payments + Down payment. The formula can be written in symbols as I = T + D. Wallpaper costs $12.97 per roll and a kitchen requires 9 rolls. What is the cost of the wallpaper needed to paper the kitchen? Wilson’s Auto, Inc., has 37 employees and a weekly payroll of $10,878. If each employee makes the same amount, how much does each make? Jacob Kennedy borrowed $30,000 to start up his consulting business. The loan had a simple interest rate of 6.2% for 3 years. Use the formula I = PRT to find the amount of interest he will pay on the loan. I = interest; P = principal; R = rate (expressed as a decimal 0.062); T = time in years

  21. A car odometer increased from 37,580.3 to 42,719.6. What was the increase? A number decreased from 486 to 104. Find the amount of decrease. A number increased from 224 to 336. Find the percent of increase. A number decreased from 250 to 195. Find the rate of decrease. ********************************************* QRB 501 Week 2 DQ 1 (UOP Course) For more course tutorials visit www.tutorialrank.com Tutorial Purchased: 3 Times, Rating: A+ 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?

  22. ********************************************* QRB 501 Week 2 DQ 2 (UOP Course) For more course tutorials visit www.tutorialrank.com Tutorial Purchased: 3 Times, Rating: A+ DQ2-Week 2: Please respond to this discussion question by Saturday (Day 5): Access board.org/economics/ConsumerConfidence.cfm. 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? http://www.conference- This is an *********************************************

  23. QRB 501 Week 2 Team Assignment Equations and Percentage Cases For more course tutorials visit www.tutorialrank.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

  24. Find the total square footage that requires painting for the bedroom and the living/dining room, and then find 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. Using your answer to question 1, determine the total number of gallons required and total cost for paint, by rounding up to the nearest gallon. Question 3 Using a painting rate of 150 square feet per hour (including prep time), a labor rate of $20 per hour, and a desired profit margin of 30% (or 0.3), calculate the total labor cost, profit margin, and final bid price for this painting job—including the total paint cost from question 2. Refer to the Chapter 6 Case Study 6-3 on Page 224 of your text. Answer the following questions. ********************************************* QRB 501 Week 3 DQ 1 (UOP Course) For more course tutorials visit www.tutorialrank.com Tutorial Purchased: 3 Times, Rating: A+

  25. 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? ********************************************* QRB 501 Week 3 DQ 2 (UOP Course) For more course tutorials visit www.tutorialrank.com Tutorial Purchased: 3 Times, Rating: A+ DQ2-Week 3: Please respond to this discussion question by Saturday (Day 5):

  26. What is the purpose of using correlation analysis? How might correlation analysis be used in business decisions or in strategy formulation and implementation? analysis be misused to explain a cause-and-effect relationship? How might correlation ********************************************* QRB 501 Week 3 Mathematics of Buying and Selling Exercises For more course tutorials visit www.tutorialrank.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.

  27. 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. What is the cost and the amount of markup of a sign? Lowe’s reduced a Maytag dishwasher 12.563%. If the dishwasher was priced at $398, find the amount of markdown and the reduced price. Fresh Food Market pays $0.25 per pound for 300 pounds of apples. On average, 5% of the apples will spoil before they sell. Find the selling price per pound needed to obtain a 180% markup on cost. Find the net price of the PC software SystemWorks that lists for $70 and has a discount rate of 12%. Use the system of complements. Dylan Murphy currently receives a trade discount series of 5/10/10 on merchandise purchased from a furniture company. He is negotiating with another furniture manufacturer to purchase similar furniture of the same quality. The first company lists a dining room table and six chairs for $1,899. The other company lists a similar set for $1,800 and a trade discount series of 5/5/10. Which deal is better? PlumbingStore.com buys one model of tankless water heater that has a list price of $395. The trade discount is 18%. What is the trade discount and net price of the heater? Federated Department Stores received an invoice dated April 18 that shows a billing for $3,848.96 with terms 2/10, 1/15, n/30. Find the cash discount and net amount if the invoice is paid within 15 days but after 10 days. Office Max purchased office furniture in the amount of $89,517 and was invoiced with terms of 2/10, n/30. Cash strapped at the time, Office Max

  28. decided to make a partial payment of $50,000 within 10 days. How much should be credited to its account? What is the outstanding balance? Curves Fitness Center received an invoice for $3,097.15 that was dated September 8 with terms of 3/15 ROG. The goods being invoiced arrived on September 12. By what date must the invoice be paid to get the cash discount? How much should be paid? ********************************************* QRB 501 Week 3 Team Assignment Trade and Cash Discount Cases For more course tutorials visit www.tutorialrank.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.

  29. 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 ********************************************* QRB 501 Week 4 Data Analytics Problem Set For more course tutorials visit www.tutorialrank.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

  30. 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 your answers in the highlighted spaces. Format your paper consistent with APA guidelines. Fifty business students were given a project to complete. The bar graph below shows the number of days it took the students to complete the assignment. The bar graph below shows the Quarterly Dollar Volume of Batesville Tire Company. Refer to the bar graph below and answer the questions. The line chart below shows data for Automobile Gasoline Mileage Comparisons for full-size and compact cars. Refer to the chart and answer the questions. The line chart below shows Dale Crosby's Salary History. Refer to this chart and answer the questions. The pie chart below shows the family budget. Refer to the chart and answer the following questions. The bar chart shows the distribution of tax dollars. Refer to the chart and answer the following questions.

  31. The Canmark Research Center Airport Customer Satisfaction Survey uses an online questionnaire to provide airlines and airports with customer satisfaction ratings for all aspects of the customers’ flight experience (airportsurvey website, July 2012). After completing a flight, customers receive an e-mail asking them to go to the website and rate a variety of factors, including the reservation process, the check-in process, luggage policy, cleanliness of gate area, service by flight attendants, food/beverage selection, on-time arrival, and so on. A five-point scale, with Excellent, Very Good, Good, Fair, and Poor, is used to record customer ratings. Assume that passengers on a delta Airlines flight from Myrtle beach, South Carolina, to Atlanta, Georgia, provided the following ratings for the question, “Please rate the airline based on your overall experience with this flight.” The sample ratings are shown below. The data below shows the total sales per day of the week by four salespersons. Use Microsoft Excel to construct a line chart (graph)showing total sales by the days of the week for Happy's Gift Shoppe. Use Excel to find the mean, median, and mode of the scores given below. After your MBA, you are employed as a business analyst for a company that makes household products, which are sold by part-time salespersons who work during their spare time. The company has four salespersons employed. Let us denote these salespersons by A, B, C, and D. The sales records (in dollars) for the past 6 weeks for these four salespersons are shown in the table below. The data below shows personal income for Quarters 2014: II - 2015: III in millions of dollars, seasonally adjusted at annual rate. Construct a pie chart (circle graph) showing the distribution of market share using the data below. The data represents the percent dollar market of comics and magazine sales for September (Rounded to the nearest whole percent).

  32. ********************************************* QRB 501 Week 4 DQ 1 (UOP Course) For more course tutorials visit www.tutorialrank.com Tutorial Purchased: 1 Times, Rating: No rating 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? ********************************************* QRB 501 Week 4 DQ 2 (UOP Course) For more course tutorials visit www.tutorialrank.com

  33. Tutorial Purchased: 1 Times, Rating: No rating 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*((1+i)^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 ((1+i)^n), which creates a new formula where the fv is multiplied by the reciprocal of the original: fv*(1/((1+i)^n))=pv. Select an interest rate and number of periods—be sure your numbers are different from other students who already answered this question—to calculate the present value of $100 received in the future. What would the value of $100 in the future be today given the interest rate and number of periods you selected? *********************************************

  34. QRB 501 Week 5 DQ 1 (UOP Course) For more course tutorials visit www.tutorialrank.com Tutorial Purchased: 1 Times, Rating: No rating 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? ********************************************* QRB 501 Week 5 DQ 2 (UOP Course) For more course tutorials visit www.tutorialrank.com

  35. Tutorial Purchased: 1 Times, Rating: No rating 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. ********************************************* QRB 501 Week 5 Quantitative Techniques in Financial Valuation Problem Set For more course tutorials visit www.tutorialrank.com

  36. 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 of $1,200 for three years at a simple interest rate of 5% per year. How much money will you pay after three years? Find the maturity value of a loan of $1,750 for 28 months at 9.8% simple interest per year. Find the simple interest rate of a loan of $5,000 that is made for three years and requires $1,762.50 in interest. A loan of $16,840 is borrowed at 9% simple interest and is repaid with $4,167.90 interest. What is the duration of the loan?

  37. How much money is borrowed if the interest rate is 9.25% simple interest and the loan is made for 3.5 years and has $904.88 interest? Find the ordinary and exact interest for a loan of $1000 at a 5% annual interest rate. The loan was made on March 15 and is due May 15. Find the bank discount and proceeds using ordinary interest for a loan to Michelle Anders for $7,200 at 8.25% annual simple interest from August 8 to November 8. What is the effective interest rate of a simple discount note for $8,000, at an ordinary bank discount rate of 11%, for 120 days? What is the effective interest rate for the first year for a loan of $20,000 for three years if the interest is compounded quarterly at a rate of 12%? Tim Bowling has $20,000 invested for three years at a 5.25% annual rate compounded daily. How much interest will he earn? The Holiday Boutique would like to put away some of the holiday profits to save for a planned expansion. A total of $8,000 is needed in three years. How much money in a 5.2% three-year certificate of deposit that is compounded monthly must be invested now to have the $8,000 in three years? Jamie Juarez needs $12,000 in 10 years for her daughter’s college education. How much must be invested today at 2% annual interest compounded semiannually to have the needed funds? ********************************************* QRB 501 Week 5 Team Assignment Financial Valuation (Time-Value of Money) Cases

  38. For more course tutorials visit www.tutorialrank.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 5–10 years from now. Barry wants to compare the difference between investing now and investing later. A financial advisor who spoke to Barry suggested that a Roth IRA (Individual Retirement Account) would be a good investment for him to start.

  39. 1. If Barry purchases a $2,000 Roth IRA when he is 25 years old and expects to earn an average of 6% per year compounded annually over 35 years (until he is 60), how much will accumulate in the investment? 2. If Barry doesn’t put the money in the IRA until he is 35 years old, how much money will accumulate in the account by the time he is 60 years old using the same return of 6%? How much less will he earn because he invested 10 years later? 3. Barry knows that the interest rate is critical to the speed at which your investment grows. For instance, if $1 is invested at 2% compounded annually, it takes approximately 34.9 years to double. If $1 is invested at 5% compounded annually, it takes approximately 14.2 years to double. Determine how many years it takes $1 to double if invested at 10% compounded annually; at 12% compounded annually. 4. At what interest rate would you need to invest to have your money double in 10 years if it is compounded annually? Abdol Akhim has just come from a Personal Finance class where he learned that he can determine how much his savings will be worth in the future. Abdol is completing his two-year business administration degree this semester and has been repairing computers in his spare time to pay for his tuition and books. Abdol got out his savings records and decided to apply what he had learned. He has a balance of $1,000 in a money market account at First Savings Bank, and he considers this to be an emergency fund. His instructor says that he should have 3–6 months of his total bills in an emergency fund. His bills are currently $700 a month. He also has a checking account and a regular savings account at First Savings Bank, and he will shift some of his funds from those accounts into the emergency fund. One of Abdol’s future goals is to buy a house. He wants to start another account to save the $8,000 he needs for a down payment.

  40. 1. How much interest will Abdol receive on $1,000 in a 365-day year if he keeps it in the money market account earning 1.00% compounded daily? 2. How much money must Abdol shift from his other accounts to his emergency fund to have four times his monthly bills in the account by the end of the year? 3. Abdol realizes he needs to earn more interest than his current money market can provide. Using annual compounding on an account that pays 5.5% interest annually, find the amount Abdol needs to invest to have the $8,000 down payment for his house in 5 years. 4. Is 5.5% a realistic rate for Abdol to earn in a relatively short-term investment of 5 years, particularly at his bank? At 45 years of age, Seth figured he wanted to work only 10 more years. Being a full-time landlord had a lot of advantages: cash flow, free time, being his own boss—but it was time to start thinking toward retirement. The real estate investments that he had made over the last 15 years had paid off handsomely. After selling a duplex and paying the associated taxes, Seth had $350,000 in the bank and was debt-free. With only 10 years before retirement, Seth wanted to make solid financial decisions that would limit his risk exposure. Fortunately, he had located another property that seemed to meet his needs— a well maintained four-unit apartment. The price tag was $250,000, well within his range, and the apartment would require no remodeling. Seth figured he could invest the other $100,000, and between the two hoped to have $1 million to retire on by age 55. 1. Seth read an article in the local newspaper stating the real estate in the area had appreciated by 5% per year over the last 30 years. Assuming the article is correct, what would the future value of the $250,000 apartment be in 10 years?

  41. 2. Seth’s current bank offers a 1-year certificate of deposit account paying 2% compounded semiannually. A competitor bank is also offering 2%, but compounded daily. If Seth invests the $100,000, how much more money will he have in the second bank after one year, due to the daily compounding? 3. After looking at the results from questions 1 and 2, Seth realizes that a 2% return in a certificate of deposit will never allow him to reach his goal of $1 million in 10 years. Presuming his apartment will indeed be worth $400,000 in 10 years, compute the future value of Seth’s $100,000 investment using a 10%, 15%, and 20% return compounded semiannually for 10 years. Will any of these rates of return allow him to accomplish his goal of reaching $1 million by age 55? 4. A friend of Seth’s who is a real estate developer needs to borrow $80,000 to finish a development project. He is desperate for cash and offers Seth 18%, compounded monthly, for 2.5 years. Find the future value of the loan. 5. After purchasing the apartment, Seth receives a street, sewer, and gutter assessment for $12,500 due in 2 years. How much would he have to invest today in a CD paying 2%, compounded semiannually, to fully pay the assessment in 2 years? ********************************************* QRB 501 Week 6 DQ 1 (UOP Course) For more course tutorials visit www.tutorialrank.com Tutorial Purchased: 1 Times, Rating: No rating

  42. 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. ********************************************* QRB 501 Week 6 DQ 2 (UOP Course) For more course tutorials visit www.tutorialrank.com Tutorial Purchased: 1 Times, Rating: No rating DQ2-Week 6: Please respond to this discussion question by Saturday (Day 5):

  43. What skills do managers need today? Are these skills different from management skills of 50 years ago? Why? ********************************************* QRB 501 Week 6 Signature Assignment Case 1 and Case 2 For more course tutorials visit www.tutorialrank.com Assignment Steps Case 1: Scenario: Cloud Data Services (CDS), headquartered in Memphis, provides information technology services, specifically application hosting services in the cloud for several clients in the southern United States. CDS hosts software applications on their network servers. While CDS has achieved great success and customers rate CDS's services highly, lately, some customers have been complaining about downtime on one of the primary network servers. The given dataset, found in the Signature Assignment Excel®Template, contains the downtime data for the month of November. Use the data analytics skills learned in Week 3 and analyze the downtime data.

More Related