INSTRUCTIONS Covering Chapter 10See the attached PDF file Homework #6 is due by Sunday (Day 7).Compl ...

---

INSTRUCTIONS Covering Chapter 10See the attached PDF file Homework #6 is due by Sunday (Day 7).Complete each homework assignment in two (2) parts.First, complete the mathematical requirements for each assigned question and subpart in a separate Excel tab. Save your file as HW #[x] - LastName, FirstInitial.xlsx. So, for HW #6 Jane Doe should save her Excel file as "HW 6 - Doe, J.xlsx".Second, complete the narrative description requirements of the assignment in a Word document. Complete the narrative in the Word document. When the question asks for calculations, make reference to the appropriate tab in the Excel file for reference. You may also copy and paste a picture or spreadsheet link within the body of the narrative as well. Save your file as HW #[x] - LastName, FirstInitial.docx. So, for HW #6 Jane Doe should save her Word file as "HW 6 - Doe, J.docx".Submit your files through the BlackBoard assignment to receive credit. Show mathematical steps in detail to receive full credits Refer to rubric Homework Assignment Video Link #1 Homework Assignment Video Link #2 Criteria Exemplary Accomplished Developing Beginning Model Formulas 9 to 10 pointsModels are appropriately and accurately formula driven 6 to 8 pointsModels are appropriately and accurately formula driven (1 to 2 errors) 3 to 5 pointsModels are formula driven but have several errors in the formulas (3 to 5 errors) 0 to 2 pointsModels are not formula drive. Numbers that should be formula driven are typed in cells. Numerous errors in the formulas (6+ errors) Model Accuracy 9 to 10 pointsModels are appropriately and accurately formula driven. Correct answers on virtually all aspects of the models (1 to 2 errors) 6 to 8 pointsModels are appropriately and accurately formula driven. Answer are correct on most aspects of the models (3 to 5 errors) 3 to 5 pointsModels are appropriately and accurately formula driven. Answer are correct on some aspects of the models (6 to 8 errors) 0 to 2 pointsModels are not formula drive. Answers are typed into cells. Few answers are correct in the models (9+ errors) Model/Spreadsheet Formatting 17 to 20 pointsEasy to understand and follow the logic of the model. Cells are appropriately color coded to highlight cell meanings. Excel sheets are appropriately named by problem number. 12 to 16 points2 to 3 deficiencies 6 to 11 points4 to 5 deficiencies 0 to 5 points6+ deficiencies Narrative Discussion 9 to 10 pointsuestions are answered in narrative form (where appropriate). Complete sentences, proper grammar, and professional language are used where appropriate/necessary. 6 to 8 pointsMost questions are answered in narrative form (where appropriate). Mostly complete sentences, proper grammar, and professional language are used where appropriate/necessary (2 to 3 deficiencies) 3 to 5 pointsSome questions are answered in narrative form (where appropriate). Limited use of complete sentences, proper grammar, and professional language (4 to 5 deficiencies) 0 to 2 pointsQuestions are not answered in narrative form (where appropriate). Complete sentences, proper grammar, and professional language are not used. Spreadsheet answers are not described, only the spreadsheet itself is referenced (6+ deficiencies) BUS542 - Homework 6.pdf