Question
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
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. Note: Save your work before continuing on to Step 5! Step 5: Opinion Paper and Submit 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started