Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Pacific Air is an airline company. They have implemented an e-procurement system to automate the purchasing and payment processes. You are a reporting analyst,

image text in transcribedimage text in transcribedimage text in transcribed

Pacific Air is an airline company. They have implemented an e-procurement system to automate the purchasing and payment processes. You are a reporting analyst, and the director of procurement has asked you to analyze the purchasing data to get visibility to supplier performance and purchasing internal controls. You extract the purchasing data from the eProcurement system for 2021 and create a dashboard with the following visualizations: 1. 2. 3. 4. Total PO vs Percentage of Returns by Supplier - This is a dual axis chart showing the purchase order by supplier as a bar chart and the percentage of returns per supplier as a line chart. Average Delivery Time vs Invoice Discrepancy % by Supplier - This is a dual axis chart showing the average delivery time by supplier as a bar chart and the invoice discrepancy per supplier as a line chart. The delivery time is calculated as the number of days between the goods received date and the purchase order date. An invoice discrepancy is when the invoice total is greater than the purchase order total. Invoice Total Trend in 2021 This is a stacked area chart showing the invoice totals by supplier for each month. Potential Split Orders Count vs Average PO Total - This is a dual axis chart showing the average purchase order total compared to the count of purchase orders. The results show the purchase orders that potentially have split orders committed. A potential split order is determined if there are two more purchase orders submitted by the same buyer within the same week and the purchase orders total more than $100,000. Hint: Use the WEEK function in Tableau and WEEKNUM function in Power Bl.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Belverd E. Needles, Marian Powers

11th edition

1133769314, 053847601X, 9781133715023, 978-1133769316, 1133715028, 978-0538476010

More Books

Students also viewed these Accounting questions

Question

a sales and administration budget using the information provided.

Answered: 1 week ago