They have a magnificent team. These people are always kind and willing to listen to your concerns or issues. Better yet, your assignment is always ready before the time, they usually send you a draft to double-check before they finalize your paper.
Review all the analyses performed for this lab activity, and write a one-page opinion paper summarizing at least two key findings that you believe are significant for Adventure Works Cycles, and making at least two recommendations for actions that management should take in response. Your paper should be in APA format, professionally written, and should be free of grammatical errors, typos, and misspellings. Save your paper in a Microsoft Word file named Lab1_yourlastname_Paper.docx.
I already did this part on excel:
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.
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 file to your virtual home drive (the F: drive in the virtual environment, labeled with your DSI number). See the Lab Resources section on the Introduction & Resources area under Modules > Course Resources page for tutorials on accessing the Citrix virtual lab environment, installing the required Citrix receiver software, finding and launching applications, and copying files to and from your virtual home drive.
NOTE: Save your work before continuing on to Step 2!
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.
NOTE: Save your work before continuing on to Step 3!
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.
NOTE: Save your work before continuing on to Step 4!
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.
a. Add a new blank worksheet to the workbook, and name it Mountain-200 What-If.
b. Starting in cell A1, enter the following as the baseline model for your analysis.
What-If Analysis for Mountain-200 Cost and PricingUnit Price $ 2,300Quantity Sold 100Revenue (Enter formula to calculate based on Unit Price and Quantity Sold)Variable Cost per Unit $630Total Variable Cost(Enter formula to calculate based on Quantity Sold and Variable Cost per Unit)Fixed Cost$60,000Total 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)
c. Assign meaningful names to the cells in the right column, using the labels in the left column.
d. 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.
e. 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 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.
f. 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.
g. 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.
h. Using the scenario manager, create three scenarios named high, midrange, and economy, with the values shown below for the changing cells.
Changing CellHighMidrangeEconomyUnit Price $2,550 $2,300 $2,050Quantity Sold 90 100 110Variable Cost per Unit $565 $630 $695
i. 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.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more