Question: Appendix B This case has you do a deeper analysis of the valuation and allocation assertion for Inventory. Open the Tableau packaged workbook called Inventory

Appendix B This case has you do a deeper analysis of the valuation and allocation assertion for Inventory. Open the Tableau packaged workbook called "Inventory Case" Click on Sheet 1 and call it Visualization 1. Calculate a new variable called Margin o Right click underneath the measures (the green variables in the Tables pane) and select Create Calculated Field o Name the field 'Margin' o The equation should be ([Sales Price1 from the Shipping section minus Unit Cost from the Inventory section])*Ship Quantity from the Shipping section. Press OK. Hint: make sure you include the parentheses around the price minus cost expression, otherwise your margin will be incorrectly calculated and incorrectly summed later on! Drag "Product Number1" from the Shipping portion into the Columns field. Drag "Ship Quantity" from the Shipping portion into the Rows field. Click on Show Me and change the view to Packed Bubbles. Drag and drop "Margin" onto the "Color" section of the "Marks" tab

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!