Integrated Computer Application - Optimize Capacity Plan and Time Series Forecasting
DueMar 13 by
11:59pm
Points37.5
Submittinga text entry box or a file upload
Objective:
Create a worksheet in Microsoft Excel to evaluate Nike's manufacturing and logistics strategy for its major retail customers in Canada. This assignment will help you become familiar with entering text and data, using cell references, adjusting column widths, and formatting cell font colors in Excel.
Instructions:
Set Up the Worksheet:
Open Microsoft Excel and create a new workbook.
Save the workbook as "Nike_Manufacturing_Logistics_Strategy_LastName_FirstName.xlsx".
Enter Text and Data:
Create the following sections in the worksheet:
When you change the font color of a cell’s contents, you choose from standard and theme colors. See below. Move your mouse over the colors to see their names. Notice that the name of each theme color also includes a designation of text, background, or accent. In addition to the color and expected use there is a percentage of brightness. Therefore a single Theme Colors can have interesting names like Tan, Background 2, Darker 25% or Red, Accent 2, Lighter 40%.
Change A2 to the standard color red.
Change the row labels in cells A3 through A7, each to a different theme color that you choose.
Change the name of the worksheet from Sheet1 to Capacity.
Save and close your workbook.
3. Submit your Excel workbook to the assignment in Canvas.
By completing this assignment, you will enhance your skills in Microsoft Excel and gain a better understanding of how to organize and analyze data effectively for business logistics.
15to >13.0 pts
All Requirements MetProvides comprehensive, accurate, and relevant information that fully addresses all aspects of the assignment. Demonstrates a deep understanding of the topic.blank
13to >7.0 pts
Most Requirements MetProvides accurate and relevant information that addresses most aspects of the assignment. Demonstrates a good understanding of the topic._4526
7to >6.0 pts
Some Requirements MetProvides some accurate and relevant information, but may miss key aspects or lack detail. Demonstrates a basic understanding of the topic._9370
6to >4.0 pts
Few Requirements MetProvides limited or partially accurate information that addresses few aspects of the assignment. Demonstrates limited understanding of the topic._4859
4to >0 pts
Minimum Requirements MetProvides minimal or inaccurate information. Fails to address the assignment requirements. Demonstrates little to no understanding of the topic.blank_2
This area will be used by the assessor to leave comments related to this criterion.
pts
/
15 pts
--
This criterion is linked to a Learning OutcomeClarity_2170
12.5to >10.0 pts
All Requirements MetIdeas are clearly and logically organized. Language is precise and easy to understand. No grammatical or spelling errors._8989
10to >7.0 pts
Most Requirements MetIdeas are mostly clear and organized. Language is generally easy to understand. Few grammatical or spelling errors._8272
7to >5.0 pts
Some Requirements MetIdeas are somewhat clear but may be occasionally disorganized. Language is understandable but may include several grammatical or spelling errors._3444
5to >3.0 pts
Few Requirements MetIdeas are unclear or disorganized. Language is difficult to understand. Numerous grammatical or spelling errors._3606
3to >0 pts
Minimum Requirements MetIdeas are very unclear and disorganized. Language is very difficult to understand. Pervasive grammatical or spelling errors._5382
This area will be used by the assessor to leave comments related to this criterion.
pts
/
12.5 pts
--
This criterion is linked to a Learning OutcomeFormat_8378
10to >8.0 pts
All Requirements MetConsistently uses proper formatting guidelines (according to the assignment instrutions) throughout the document. Professional appearance._5923
8to >5.0 pts
Most Requirements MetMostly uses proper formatting guidelines with minor inconsistencies. Generally professional appearance._1946
5to >4.0 pts
Some Requirements MetUses some proper formatting guidelines but with noticeable inconsistencies. Appearance could be more professional._6698
4to >2.0 pts
Few Requirements MetUses few proper formatting guidelines. Document lacks a professional appearance._5034
2to >0 pts
Minimum Requirements MetUses improper formatting guidelines. Document is unprofessional in appearance._3848
This area will be used by the assessor to leave comments related to this criterion.
pts
/
10 pts
--
This criterion is linked to a Learning OutcomeDescription of criterion