Tab 1: #1. Using the 1st tab of the starter file and Goal Seek. Set the initial field values to: Unit Cost: $6.00 If our goal is for the Contribution Margin Percent to be 54%, Invoke Goal Seek so as to figure out what the Sales Price (changing cell) is and the answer is $ #2. Using the 1st tab of the starter file and Goal Seek Set the initial field values to: Sales Price: $13.00 If our goal is for the Contribution Margin Percent to be 53%, Invoke Goal Seek so as to figure out what the Unit Cost must be (changing cell) and as a result, the automatically re-calculated Contribution Margin is $_ Tab 2 - Monthly Payments #3. Using the 2nd tab of the starter file (1-variable data table) complete these steps and answer the question: Prime the 1-variable table (Col F &G) for the 2 values (Monthly Payment and Total Payments) Set the Loan Conditions to the following: • Down Payment: $1,000 • APR: 5.0% • Term (in Years): 5 • Loan Amount: 30,000 NOW create the 1-variable data table (Col F &G) so as to populate the whole thing and then answer this question: If the APR is 7.00% - the monthly payment is #4. Using the 2nd tab of the starter file (1-variable data table) complete these steps and answer the question: Prime the 1-variable table (Col F &G) for the 2 values (Monthly Payment and Total Payments) Set the Loan Conditions to the following: • Down Payment: $2000 • APR: 6.0% • Term (in Years): 6 • Loan Amount: 40,000 NOW create the 1-variable data table (Col F &G) so as to populate the whole thing and then answer this question: If the APR is 7.50% - the monthly payment is Tab 2-Total Payments #5. Using the 2nd tab of the starter file (1-variable data table) complete these steps and answer the question: Prime the 1-variable table (Col F &G) for the 2 values (Monthly Payment and Total Payments) Set the Loan Conditions to the following: • Down Payment: $1,000 • APR: 5.0% • Term (in Years): 5 • Loan Amount: 30,000 NOW create the 1-variable data table (Col F &G) so as to populate the whole thing and then answer this question: If the APR is 7.00% - the total payments are #6. Using the 2nd tab of the starter file (1-variable data table) complete these steps and answer the question: Prime the 1-variable table (Col F &G) for the 2 values (Monthly Payment and Total Payments) Set the Loan Conditions to the following: • Down Payment: $2000 • APR: 6.0% • Term (in Years): 6 • Loan Amount: 40,000 NOW create the 1-variable data table (Col F &G) so as to populate the whole thing and then answer this question: If the APR is 6.25% - the total payments are Tab 3 - Monthly Payments #7. Using the 3rd tab of the starter file (2-variable data table) complete these steps and answer the question: Prime the 2-variable table (Cols E-I) for the Monthly Payment amount Set the Loan Conditions to the following: • Down Payment: $25,000 • APR: 5.25% • Term (in Years): 30 • Loan Amount: 175,000 NOW create the 2-variable data table (Cols E-I) so as to populate the whole thing and then answer this question: If the APR is 6.75% and the term is 120 (months) - the monthly payment is #8. Using the 3rd tab of the starter file (2-variable data table) complete these steps and answer the question: Prime the 2-variable table (Cols E-I) for the Monthly Payment amount Set the Loan Conditions to the following: • Down Payment: $11,000 • APR: 4.85% • Term (in Years): 20 • Loan Amount: 225,000 NOW create the 2-variable data table (Cols E-I) so as to populate the whole thing and then answer this question: If the APR is 8.85% and the term is 360 (months) - the monthly payment is Tab 4 - Total Payments #9. Using the 3rd tab of the starter file (2-variable data table) complete these steps and answer the question: Prime the 2-variable table (Cols E-I) for the Total Payments amount (cell C9) Set the Loan Conditions to the following: • Down Payment: $20,000 • APR: 5.50% • Term (in Years): 25 • Loan Amount: 200,000 NOW create the 2-variable data table (Cols E-I) so as to populate the whole thing and then answer this question (which SHOULD already be there from the previous question you just got) and HINT: If you see all # signs - that means the # is TOO BIG to display so just widen those columns. If the APR is 9.50% and the term is 240 (months) - the total payments made is #10. Using the 3rd tab of the starter file (2-variable data table) complete these steps and answer the question: Prime the 2-variable table (Cols E-I) for the Total Payments amount (cell C9) Set the Loan Conditions to the following: • Down Payment: $20,000 • APR: 5.50% • Term (in Years): 25 • Loan Amount: 200,000 NOW create the 2-variable data table (Cols E-I) so as to populate the whole thing and then answer this question (which SHOULD already be there from the previous question you just got) and HINT: If you see all # signs - that means the # is TOO BIG to display so just widen those columns. If the APR is 9.00% and the term is 360 (months) - the total payments made is/n Assignment Instructions Decision support systems (DSSS): Are computer-based information systems that combine models and data in an attempt to solve semi-structured and some unstructured problems with extensive user involvement. Objectives: Upon completion of this lesson, you will be able to: • Know what DSS stands for • Understand what DSS's are and what they can do for you • Identify the different categories of DSS's . . Understand how selected DSS tools within Excel work Demonstrate the use of the DSS tools within Excel by completing the assigned Homework Activity Step 1 - The 01_start_here.pdf is a copy of the slides about the excel dss tools for your convenience. Step 2 - Download the 02_dss_what_ifs_and_data_tables excel file so you can practice using the tools. Step 3 - Watch these Videos: Excel Goal Seek Links to an external site. Excel Data Tables Links to an external site. Excel Scenario Manager Links to an external site. Excel Solver Links to an external site. NOW that you have not only watched all the mini-lectures and hopefully tried it yourself to really understand what/where/how and so forth to master using that particular DSS tool...you are NOW better prepared to attempt the DSS Homework Assignment which has you using/doing ALL these tools! If you are using a MAC - Excel Solver behaves TOTALLY different and I'm not a Mac expert. My best advice is either figure it out on your Mac so you can say you DID or head to any campus computer lab using the PC version of Office wherein the instructions above will more closely match exactly how it works or appears (which is also true for ALL the other Excel DSS tools). Step 4 - Download 03_homework_starter_file and open it in excel Step 5 - Work through the attached worksheet (04) and submit it along with the excel file once you are completed. If you do not save the excel file AFTER you have done the calculations necessary for you to get the answers you will receive no more than half credit. MAKE SURE TO FILL OUT THE ANSWER SHEET. THAT'S WHERE I'LL BE LOOKING AT YOUR ANSWERS. Additional resources for assignment 01_start here.pdf Download 01_start_here.pdf 02 dss what ifs and data Tables.xlsx Download 02_dss_what_ifs_and_data_Tables.xlsx 03 homework starter file.xlsx Download 03_homework_starter_file.xlsx 04_homework_instructions_and_answer_sheet.docx/n/n