Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please use this link for the necessary data in Excel - https://unweagles-my.sharepoint.com/:x:/g/personal/cldumoulin_students_unwsp_edu/EW2iJrP8TrFPppohh19dX34BslOhvqOxUaujb5l9KCcfTw?e=BRZRGY 3. Vice President of Operations: I need some data on our profitability on
Please use this link for the necessary data in Excel -
https://unweagles-my.sharepoint.com/:x:/g/personal/cldumoulin_students_unwsp_edu/EW2iJrP8TrFPppohh19dX34BslOhvqOxUaujb5l9KCcfTw?e=BRZRGY
3. Vice President of Operations: "I need some data on our profitability on each job this month. Can you tell me the total revenue generated by each job? Then, what are the totals of direct materials, direct labor, and manufacturing overhead for each job? What is the gross profit generated by each job? Which job generated the most gross profit? Which job generated the least gross profit?" 4. Sales Team Director: "It's time to conduct monthly reviews of our sales team members' performance. Could you please provide some data telling me the total revenue generated by each sales rep? Which sales rep generated the most revenue? Who generated the least? How much of each sales rep's revenue is generated from facilities in Canada? From facilities in the United States? How much of each sales rep's revenue is generated by each of the facilities within each country?** ^Hint: Sort the pivot table by gross profit. *Hint: Use a filter in the pivot table. Check Figures 1. CFO Pivot Table: Cell 87 should be $(429,680) 2. Production Mgr Pivot Table: G/L #4501 - Manufacturing overhead should be $(74,461) for the Ontario facility 3. VP of Ops Pivot Table: Cell F936 should be $1,293 4. Sales Team Dir Pivot Table: Sophia Payne's Ontario revenues should equal $151,580 Communication Just as important as generating accurate data is communicating it clearly. Once you have gathered the requested information from the pivot tables, prepare a slide deck (PowerPoint, Google Slides, etc.) summarizing the answers to these questions in a visual manner. Your slide deck should have a title slide separating each of the four sections (each section should be addressed to the respective member of management. Be creative in your presentation: use tables, graphs, infographics, etc. to visually present the information requested. You should incorporate at least three different types of visuals throughout your slides. All of their questions should be addressed. Submission Your final submission should include an Excel file with five tabs: an original data tab and one tab for each of the four pivot tables. Also submit your slide deck as an attachment or as a link. If submitting a link, please provide access to both Professor Olsen (ceolsen@ unwsp.edu) and the course TA, Caleb Merwin (camerwin@students. unwsp.edu). Adopted from Case MA-4300, Accounting is Analytics: https://accountingisanalytics.com/case-ma-4300-ivy-corporation-excel/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