Required information
Skip to question[The following information applies to the questions displayed below.]
Lab Insight: Apply the same base scenario as Lab 13-7 to Alt Lab 13-7, but now vary the fixed costs from 500 to 3,000 (in increments of 250) and vary sales price from $5 to $50 (increments of $5) to see how profitability varies. A reminder to use the same Excel dataset from Lab 13-7 Data.xlsx for this Alt Lab.
Required:
- Determine how sensitive the profits are with changing assumptions of the numbers of units sold and level of variable costs per unit.
- Apply conditional formatting to the differing levels of profitability in the data table.
Ask the Question: How sensitive are company profitability levels given assumptions on the number of units sold, unit sales prices, and fixed and variable costs?
Master the Data: Open a new file in Excel. There is no other data file provided.
Software needed
- Excel
- Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)
Data: For this Alternate Lab access your completed 13-7 Static Data file. If you did not complete the Static Lab, you can access the Data file here: Lab 13-7 Data.xlsx
Perform the Analysis: Refer to Lab 13-7 Alternate in the text for instructions and Lab 13-7 steps for each the of lab parts.
Upload the Word or PDF document containing your Lab screenshots using the button below.
Note: Please submit your file attachment response in one of the approved file formats; Word file (.doc or .docx), Excel file (.xls or .xlsx), or PDF. To submit photo or image files please paste them into Word or PDF. Consult with your instructor as needed on their preferred file attachment format.
Take a screenshot of your completed profitability analysis, paste it into a Word document named “Alt Lab 13-7 SS.doc” and label the screenshot Submission 1.