Using the Microsoft Excel File BicycleForPivotV01.xls, answer the following questions: 1. What were the Grand Total Net
Question:
Using the Microsoft Excel File BicycleForPivotV01.xls, answer the following questions: 1. What were the Grand Total Net Sales for the Entire Organization? (documentation: text) 2. What were the Internet Net Sales for Munich Bike Store Sales Organization and for City bike (CB) Material Group? (documentation: text) 3. What were the Wholesale Net for Munich Bike Store Sales Organization and for City bike (CB) Material Group, and for M6 Hardtrail 18" Material? (documentation: text) 4. Show a report for Internet Net Sales, for City bike (CB) Material Group, only in 2007, and for the months of Jan, Feb, and March? (documentation: print screen) 5. Show a report for Wholesales sales by Material Group, only in 2007, and for ALL months. In this report show the Revenues, Net Sales, Contribution Margin ("Net Sales" - "Cost Of Goods Sold"), and Margin Ratio ("Contribution Margin" / "Net Sales". (documentation: print screen) Submit a document which contains print screens of your answers.
This is the link to the file and Im hoping the embed works
https://docs.google.com/spreadsheets/d/e/2PACX-1vQ5VYt6hwyoBMvSRTINlWNnaWiVw0Pes_v3NywUWjmU0NO1dJRxAfWPu_WTle3W5w/pubhtml
Auditing and Assurance services an integrated approach
ISBN: 978-0132575959
14th Edition
Authors: Alvin a. arens, Randal j. elder, Mark s. Beasley