Category: Business and Management

Scenario/Summary
Excel is a great tool that allows businesses to analyze data and make important decisions. In this lab, you will be using Microsoft Excel to complete some basic business intelligence tasks for Adventure Works Cycles, a fictional company that manufactures metal and composite bicycles for sale to commercial distributors in North America, Europe, and Asia. Adventure Works also sells bicycles and related products direct to consumers over the internet. Adventure Works is a multinational company headquartered in Bothell, Washington. The company is currently seeking to expand its market share by targeting high-volume customers, expanding availability of products on the web, and lowering production costs.
You have been hired as a data analyst for the company. Adventure Works managers have requested that you analyze 3 years of sales and cost data to help them answer specific business questions. In the course of this analysis, you will perform the following in Excel.
Importing, cleaning, and converting data
Table analysis
Pivot tables
What if analysis
Step 1: Importing, Cleaning, and Converting Data
Adventure Works has supplied you with sales data extracted from their corporate database in the form of a text file. In this section, you will import, clean, and convert the data to prepare it for analysis.
Download and save the file AdventureWorksOrders.txtLinks to an external site.. Be sure to save the file rather than opening it directly from this link (it will not open in Excel because it is a text file). If you are not given the option of saving the file when you click on the link, right-click it and select Save Link As or Save Target As.
For this lab, you may use your own copy of Microsoft Excel 2016 or 2019 or you may use Excel 2019 in the Azure virtual lab environment. You are recommended to use the virtual lab to become familiar with it, as it will be required for some future labs. You should definitely use the virtual lab if your own copy of Excel is not the 2016 or higher version or if you are not using the Microsoft Windows operating system (the version of Excel for the Mac OS is significantly different from the version for Windows).
If you will be using the virtual lab environment, log into it as directed in the Lab Resources section above and copy the AdventureWorksOrders.txt to your local computer. Desktop or Documents is recommended. The File can then be copied into the Azure Virtual Lab environment.
Launch Excel 2016 or 2019 and create a new blank workbook.
Using the Get External Data From Text command on the Data tab of the ribbon, import the data from the AdventureWorksOrders.txt file into Excel. The file is a delimited file in comma separated value (CSV) format.
Rename the worksheet containing the imported data to sales data. Saving in Azure lab environment will allow you to copy the file from Excel in Azure and paste to your Desktop or Documents folder.
Format the worksheet professionally, making sure that column headings are bolded, all dollar values are formatted as currency, and column widths are set appropriately.
Clean the data by spell-checking all appropriate columns and deleting any rows containing missing observations, outliers, or duplicate entries.
Add a column titled OrderTotal that uses a formula to calculate the total price for each order based on the UnitPrice and OrderQty columns.
Add a column titled FullName that contains the customer’s full name by concatenating the FirstName and LastName columns.
Add a column titled OrderCategory that categorizes orders as large, medium, or small based on the OrderTotal, with large orders having OrderTotal greater than $1,500, medium orders having an OrderTotal between $500 and $1,500, and small orders having an OrderTotal less than $500.
Save the workbook using the file name Lab1_yourlastname.xlsx. If you are using the virtual lab environment, you can then copy and paste the file to your local computer to prepare for submission.
Note: Save your work before continuing on to Step 2!
Step 2: Table Analysis
Adventure Works management would like to examine individual orders for two specific product models: the Mountain-500 in the United States and the Touring-3000 in Australia. They would also like to see how their sales break down by product category and by country. In this section, you will accomplish this using table analysis techniques, including filtering, sorting, subtotals, and charts.
Make a copy of the Sales Data worksheet, naming it Mountain-500 U.S. Orders.
Convert the data to a table.
Filter the table to show only orders where the country is United States and the ProductModel is Mountain-500.
On your own, make another copy of the Sales Data worksheet, naming it Touring-3000 Australia Orders.
Convert the data to a table and filter to show only orders where the country is Australia and the ProductModel is Touring-3000.
Make another copy of the Sales Data worksheet, naming it Sales by Product Category.
Convert the data to a table and sort A–Z by ProductCategory.
Convert the data back to a normal range and add subtotals to show the sum of OrderTotal for each product category. Group to hide the individual orders and show only the subtotals for each product category.
Create a pie chart showing how total sales are distributed by product category, making sure the chart has a descriptive title and that the pie slices are clearly labeled. Place the chart to the right of the table near the top of the worksheet.
On your own: Perform a similar analysis using subtotals and a pie chart to show how sales are distributed by country. Do this on another worksheet named Sales by Country.
Save the workbook file.
Note: Save your work before continuing on to Step 3!
Step 3: Pivot Tables
Adventure Works management would like to see a more in-depth analysis of sales by country within each product category and subcategory, with the ability to drill down to see sales of specific product models within a subcategory when desired. In this section, you will use pivot tables and pivot charts to accomplish this.
Create a pivot table based on the Sales Data worksheet, placing the pivot table on a new worksheet named Sales Pivot by Product Country. Choose ProductCategory for the Filter, ProductSubcategory and ProductModel for the Rows, Country for the Columns, and Sum of OrderTotal for the Values.
Initially, set the ProductCategory filter to (All) and collapse the row fields so that only the product subcategory totals are shown, with none of the detail for the product models within the subcategories.
Create a stacked column pivot chart based on this pivot table. Give the chart a descriptive title and ensure all categories and data sets are clearly labeled. Place the chart to the right of the pivot table near the top of the worksheet.
Explore the data by changing the filter setting to look at each product category and expanding or collapsing rows to look at product model details within specific categories. Please return the pivot table and chart to their initial settings before submitting the assignment.
On your own, construct a different pivot table and chart based on your own choices of fields to analyze. Use at least one filter field, at least two row fields, at least one column field, and at least one value field. At least three of these five field choices must be different from the fields used in the first pivot table (for example, you could choose to still use ProductCategory for the filter and Country for the columns, but you would then need to make different field choices for the rows and values). You may use the same or a different chart type. Place your pivot table and chart together on a new worksheet, and give the worksheet tab a descriptive name. Save the workbook file.
Note: Save your work before continuing on to Step 4!
Step 4: What-If Analysis
Adventure Works management is considering various pricing options for its most popular bike model, the Mountain-200. In this section, you will perform a what-if analysis to predict revenues, costs, and profits for this model under different conditions, using one-variable data tables, two-variable data tables, and scenarios.
Add a new blank worksheet to the workbook, and name it Mountain-200 What-If.
Starting in cell A1, enter the following as the baseline model for your analysis.
What-If Analysis for Mountain-200 Cost and Pricing
Unit Price $2,300
Quantity Sold 100
Revenue (Enter formula to calculate based on Unit Price and Quantity Sold)
Variable Cost per Unit $630
Total Variable Cost (Enter formula to calculate based on Quantity Sold and Variable Cost per Unit)
Fixed Cost $60,000
Total Cost (Enter formula to calculate based on Total Variable Cost and Fixed Cost)
Gross Profit (Enter formula to calculate based on Revenue and Total Cost)
Assign meaningful names to the cells in the right column using the labels in the left column.
On the same worksheet, create a one-variable data table that varies the Unit Price from $2,000 to $2,500 in increments of $50 and shows the corresponding values for revenue, total cost, and gross profit. Apply conditional formatting to highlight gross profit values greater than $120,000.
On the same worksheet, create a two-variable data table that varies the unit price from $2,000 to $2,500 in increments of $50 and also varies the quantity sold from 75 to 125 in units of 5, showing the corresponding values for gross profit. Apply conditional formatting to highlight gross profit values greater than $120,000.
On your own, create a one-variable data table that varies the variable cost per unit from $500 to $750 by increments of $25, showing corresponding values for total cost and gross profit.
On your own, create a two-variable data table that varies the variable cost per unit from $500 to $750 by increments of $25, and varies the fixed cost from $50,000 to $70,000 by increments of $2,000, showing the corresponding values of gross profit.
Using the scenario manager, create three scenarios named high, midrange, and economy, with the values shown below for the changing cells.
Changing Cell High Midrange Economy
Unit Price $2,550 $2,300 $2,050
Quantity Sold 90 100 110
Variable Cost per Unit $565 $630 $695
Generate a scenario summary report for the above scenarios, with revenue, total cost, and gross profit as the result variables. Place the scenario summary report worksheet immediately after the Mountain-200 What-If worksheet in the workbook. j.
Save the workbook file.

Based on YOUR knowledge and observation, Identify an industry in which expansionist strategy has generally been followed by most firms in the past. Under which conditions will it be better for a firm to follow the wait-and-see strategy rather than the expansionist strategy? Then identify a firm or an industry that has done so successfully. 
Please support your opinions, for example,  using your knowledge, experience, understanding/reasoning, observation, real-world examples/cases, and/or other sources.
Please use at least 2 online resources, and provide a link/source to those online resources (e.g., news, cases, etc. etc.) 

Task Details:
You are required to select a (ONE) real-life company and explore its expansion option globally. The company can be based anywhere but must have (already) internationalized and you would be looking to expand it to a new country. For example, Commonwealth Bank is an Australian company, that has internationalized to various countries and you would like to expand it to a new country– you can go to their website and read in detail. Since I have mentioned this company as an example you CANNOT do the assessment on it. Students should consider the following prompts to complete the report.
What mode of entry is suitable for the company?
Which strategy would suit considering the competitive pressure?
What legal and ethical issues should be considered?
Using theories to explain the above is highly encouraged.
The structure of the report can be as follows:
1. Introduction
Purpose,
Country/company background,
Limitations/assumptions.
2. Body/Discussion
This section can have sub-headings as you wish (may use the suggested prompts).
3. Conclusion
Summary of what you have discussed in the previous sections and the conclusion drawn henceforth. 
Word Limit: 2500
References and appendices are not counted in the word limit. In-text citations are counted in the word limit. References and in-text citations must be presented in APA style
Presentation requirements: 
Follow the report format. You may include a title page, table of contents, executive summary and others.
All assignments MUST be submitted with size 12 font, Times New Roman theme font and with double spacing.
Notes:
The references to be utilised in completing this assessment can be sourced from peer-reviewed academic journals (atleast 10), books, and websites. If you are unaware of these platforms, please touch base with the library.
Submission Details:
Compile the cover sheet and the assessment file together as ONE document,
Use the submission link on Moodle to upload the file,
Retain the email upon submission for evidence purposes.
SUBMISSIONS MUST BE IN A WORD DOCUMENT FORMAT

You can use the thesis thats in the attachments just rewrite it and make it better and also do the assigment in the file
Turnitin™
This assignment will be submitted to Turnitin™.
Instructions
Each of the Body Paragraphs of an essay consist of a topic sentence, supporting details and evidence, and a concluding sentence. This week you will build the body paragraphs of your essay.
Begin with the topic you wrote about in the Week 2 Discussion.
Revise and edit the topic sentences from the Week 3 Assignment.
Use the topic sentences to begin each of the three body paragraphs.
Add at least 2-3 sentences of supporting details and/or evidence to each of the three body paragraphs.
Research your topic in Google Scholar and/or in the Trefry Library.
Try to add a fact or statistic to each body paragraph. 
When use the ideas of other authors, make sure you add citations and a Works Cited page (see Course Content).
Do not use direct quotes. We are focusing on paraphrasing ideas from outside sources in this class.
If you need to add an in other words or a for example or an in other words sentence to explain a point of evidence, please do so. 
Add a concluding/transition sentence for each body paragraph.
Revise and edit the three body paragraphs.
While you must submit all three paragraphs in one MSWord document, choose only one of the body paragraphs for feedback. Please add the thesis statement to the top of the document and hand it all in by 11:59 PM EST Sunday, Week 4. 
Check out the rubric here.
ILO.IS.B2; ILO.AL.B2; ILO.DL.B2; ILO.DL.B3; ILO.DL.B4; ILO.DL.B5
CO1; CO2; CO3; CO4; CO5
Due on Jun 2, 2024 11:59 PM
Attachments
Week 4 Sample Assignment.docx (15.48 KB)
Download All Files

*****PLEASE READ ALL DIRECTIONS AND OPEN ALL FILES*****
MT435M1-1: Examine the business concepts of quality management and lean systems.
Quality management is a critical aspect of an organization’s success. In today’s highly competitive business environment, organizations must continuously strive to improve the quality of their products and services to stay ahead of their competitors. Lean system is centered on continuous improvement and strives for perfection. It encourages organizations to constantly evaluate their processes to drive efficiency.
Directions
In this assignment, you will apply critical thinking to the application of designing and implementing a quality management and lean system for a manufacturing company. The system should aim to improve the company’s efficiency, reduce waste, and ensure that the products meet the customers’ expectations. 
The informative essay will have a minimum of three full pages in which you specifically address the parts listed below. Make sure to include separate title and reference pages, use standard paragraph structure, double spacing, 12-point Times Roman font, and follow all other current APA style guidelines. Conduct research from credible sources, the Library, and your textbook to support your responses. Three references are required for the assignment. 
You can select an operations management environment of your choosing; however, ensure it is realistic and applicable, reflecting good judgment, business sense, and critical thinking skills. Consider the following topics and follow the instructions below, remembering to complete all parts of the assignment.
Instructions:
Develop a quality management plan that outlines the processes, procedures, and quality standards that will be implemented in the company.
Develop a lean implementation plan that will be used to reduce waste and improve efficiency in the manufacturing processes.
Describe the impact of three quality pioneers and their contribution to quality management.
Deliverables:
A written paper summarizes the implementation of the quality management and lean system plan and describes the impact of three quality pioneers.
Minimum Submission Requirements
This assignment should be a separate MS Word document, preferably in the most current.
In .docx file format.
In addition to the current APA style title page and reference page, ensure your paper covers the assigned topics, focusing on quality. The following items provide additional guidance as to writing expectations.
Respond to the questions in a thorough manner, providing specific examples of concepts, topics, definitions, and other elements asked for in the questions. Your paper should be highly organized, logical, and focused.
It must be written in Standard English, demonstrating exceptional content, organization, style, grammar, and mechanics.
Your paper should provide a clearly established sustained viewpoint and purpose.
Your writing should be well-ordered, logical, and unified, as well as original and insightful.
Ensure your paper uses current APA style for content, with properly indented paragraphs and a minimum of three full pages covering the assigned topics to the appropriate depth.
A separate page at the end of your research paper should contain a list of references, in current APA style. Use your textbook, the Library, and the Internet for credible research.
Ensure you have at a minimum three quality references supporting your work: defining words, or using dictionaries, wikis, or encyclopedias, does not count as a quality reference, or meet university standards for credible online research.
Be sure to cite in-text citations where appropriate and reference all sources. Your sources and content should follow proper APA style. Review the current APA style found at the Writing Center. The Writing Center can be accessed in Academic Tools. Select APA Central, then “Write” at the bottom of the page. It should include a title page, double-spaced, in Times New Roman 12-point font, correct citations, Standard English with no spelling or punctuation errors, and correct references on the references page.
Plagiarism
Plagiarism is an act of academic dishonesty. It violates the University’s Code of Student Conduct, and the offense is subject to disciplinary action. You are expected to be the sole author of your work. Use of another person’s work or ideas must be accompanied by specific citations and references. Whether the action is intentional or not, it still constitutes plagiarism.

The Topic for the dissertation is upto you im goin to uploaf a list of options my tutor gave me you can pick from or chose your own topic aslong as its business management related and you let me know so i can inform my tutor. This order is for only half of the dissertation chapters 1-3 (4000 words) and parts 4-6 will be the next assignnent after this it will be 8800 words at max in the end. The assignmnet brief will have more details and i will upload a sample paper. Any other questions feel free to ask.  The image file is the list of topics but you can pick your to aslong as it relevant. Thank you

Using the theories and concepts of consumer behavior covered in AMB200 course, explain why consumers tend to apply more rational approach in making consumption decisions involving expensive products or services. Your essay should be approximately 300 words (+/- 10%). You must demonstrate adequate understanding of the theories covered in class and integrate relevant literature resources. Use 2 to 3 literature sources. Your essay should be brief and precise.

I want to write a essay about ( is digital currency the future) please follow the instructions below.

Expository Essay, you can use the links as sources.  
First Link:  https://smallbusiness.com/product-development/best-u-s-cities-to-test-market-a-national-product/
Second link: https://wallethub.com/edu/metro-areas-that-most-and-least-resemble-the-us/6109

Turnitin™
This assignment will be submitted to Turnitin™.
Instructions
You have noticed that employee conflict is still not conducive to the organizational behavior you envision. Consider your audience is all managers and HR. Present your workflow plan to identify conflict early, bring all parties together for discussion, and conclude with a win-win solution for everyone. Your workflow should include comments so others can implement it.
Length: Workflow of 2-3 pages
References: Include a minimum of 5 scholarly resources.
The completed assignment should address all of the assignment requirements, exhibit evidence of concept knowledge, and demonstrate thoughtful consideration of the content presented in the course. The writing should integrate scholarly resources, reflect academic expectations and current APA standards
I have included some references that the instructor included with the assignment.