It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.
Review the resources listed below to prepare for this week's assignment. Before reviewing these resources, read through the assignment instructions so you know what you will be expected to do with this material.
Hearne, S. (2011). Basic math refresher, 2nd edition.: Everyday math for everyday people. https://ebookcentral.proquest.com/lib/ncent-ebooks/reader.action?docID=4873630&ppg=118
This course textbook chapter reviews proportions and ratios with percentages. The chapter models how to use percentages to solve word problems (with answers).
Hearne, S. (2011). Basic math refresher, 2nd edition.: Everyday math for everyday people. https://ebookcentral.proquest.com/lib/ncent-ebooks/reader.action?docID=4873630&ppg=133
This course textbook chapter reviews proportions and ratios with percentages. The chapter models how to use percentages to solve word problems (with answers).
Wang, M. (2018). Key Concepts of Intermediate Level Math. Victoria, B.C.: BCcampus. http://solr.bccampus.ca:8001/bcc/file/1760cf89-318c-473c-b1d2-5320c85cede3/1/OTB195-01-Key%20Concepts%20of%20Intermediate%20Level%20Math%20-%20March%202020.pdf
This unit reviews mixtures, concentration, and business word problems. It includes a self-test for practice (with “Answers for self-tests” in the appendix.
Khan Academy. (2008). Introduction to interest. YouTube. Retrieved from: https://youtu.be/GtaoP0skPWc
In this video, you will learn how interest is effectively a rent on money and the difference between simple interest and compound interest is calculated on a loan.
Girvin, M. (2018). Trade discounts, series discounts, net cost equivalents & wholesale cost. ExcelisFun. YouTube. Retrieved from: https://youtu.be/a-hy-_tIifU
In this video, you will learn how to calculate Trade Discounts (Single and Series) in order to calculate a Wholesale Cost. You will learn about business terms, VLOOKUP, and IF Functions to automate calculations.
Girvin, M. (2014). Formulas for quarters, fiscal quarters & fiscal years. ExcelisFun. YouTube. Retrieved from: https://youtu.be/SD7hyPRXdRo
In this video, you will learn how to create budgets for the quarter by using the CEILING and MONTH functions. Fiscal Quarters using LOOKUP, MONTH, IF, MONTH, CEILING, YEAR, and Boolean Math.
Girvin, M. (2009). Summarize monthly sales with daily transactional dates - 5 method. ExcelisFun. YouTube. Retrieved from: https://youtu.be/Gq_-UTSEwOE
In this video, you will learn about Pivot Tables, the SUMIF, COUNTIF, SUMPRODUCT functions. Also, how SUMIF and COUNTIF cannot handle arrays and so the solution means that we must add an extra column and use the MONTH, YEAR, and TEXT functions. How to construct a SUMPRODUCT formula that requires two dates from only one date.
Girvin, M. (2009). March end quarterly comparative report - pivot table. ExcelisFun. YouTube. Retrieved from: https://youtu.be/nVXicRtV9JU
In this video, you will learn how to use a Pivot Table to create a Report that shows the differences in Sales between Quarters and how to create quarters in a Pivot Table that has a year-end March 31. Pivot Table trick on Group Dates by Quarter and Year.
Girvin, M. (2017). Sales per working day by month formulas for three year dynamic report. ExcelisFun. YouTube. Retrieved from: https://youtu.be/bqUh-1elA24
In this video, you will learn how to create a three-year Sales per Working Day by Month Report Where the Date Table lists the Working Days and the Sales Table will be updated with new data regularly.