©BRAINBARTER EXAM SOLUTIONS 2024/2025
ALL RIGHTS RESERVED.
PL500 Exaam Study Guide.
Case Study 1: Contoso Pharmaceuticals
Background
Contoso Pharmaceuticals distributes specialty pharmaceuticals, ingredients, and raw materials
throughout North America. The company has 33 offices and 12 warehouses across the US,
Mexico, and Canada. As their customers' needs grow in sophistication, Contoso wants to delight
customers with breakthrough products, exceptional service, and on-time delivery of materials.
They want to automate time consuming and manual processes that are prone to error. Contoso
wants to consolidate and automate ordering and fulfillment processes. - answer✔• The
company has a fleet of 500 delivery trucks. The company has 150 drivers and uses third-party
contractors to deliver goods.
• The company has 400 warehouse workers and 30 finance clerks.
• Contoso has 85 sales representatives and 50 customer service representatives. Sales
representatives spend most of their time on the road visiting customers or prospects.
• The IT department consists of four system administrators and six system analysts.
1|Page
, ©BRAINBARTER EXAM SOLUTIONS 2024/2025
ALL RIGHTS RESERVED.
Current environment
Overview
Contoso Pharmaceuticals has a custom enterprise resource management (ERP) system. It is
difficult to integrate other applications and services with the system. Office staff manually key
in purchase orders, customer orders, and invoices after they receive a scan or hard copy of an
agreement.
Applications
• The company uses a custom supplier management system named SMSApps that runs on each
user's workstation. The system is costly to run and maintain. SMSApp does not have an API.
• Sales representatives manage customer requests by using Dynamics 365 Sales.
• Contoso has Microsoft Power Platform development, user acceptance testing (UAT), and
production environments.
• Administrators create one Accounts Payable (AP) mailbox for each environment to support
testing.
• The use of a DLP policy and Desktop Flow development is specified as part of the automation
requirements.
Business process
2|Page
, ©BRAINBARTER EXAM SOLUTIONS 2024/2025
ALL RIGHTS RESERVED.
1.Sales representatives create quotes by using a Microsoft Word document template. The
template
allowsrepresentativestoincludeproductquantity,andcostestimationdetailsthatwillbeneededto
fulfil an order. The representative converts quotes to a PDF file and emails the file to the
customer for approval.
2. The sales representative alerts the finance team about the new order and emails the finance
team a copy of the quote for processing.
3. The finance teamprints the quote and manually creates a purchase order (PO) into SMSApp
to request materials from a known and trusted vendor.
4. The SMSApp distributes the PO to stakeholders. The system sends a copy to a shared finance
team mailbox.
5. Once a PO is fulfilled by a vendor, the system sends an email to the finance mailbox. The
finance team releases an order to the warehouse. - answer✔6. Materials are shipped from the
vendor to one of Contoso's warehouses. Warehouse workers enter key information from the
waybill into SMSApp. The materials are unloaded and racked in the warehouse until they are
shipped to customers.
7. Upon checking for new daily orders in SMSApp, they see an open order is pending that is
awaiting the newly received materials
8. The Warehouse worker loads an order onto a truck for delivery and marks the order as
complete in SMSApp.
3|Page
, ©BRAINBARTER EXAM SOLUTIONS 2024/2025
ALL RIGHTS RESERVED.
9. Sales representatives provide fulfillment status and tracking information for orders.
10. A finance clerk prepares an invoice and sends the invoice to the customer by email. The
clerk sends a copy of the email to the shared AP mailbox.
11. The AP team monitors the shared mailbox to confirm that the customer has paid the
invoice.
Requirements
Functional requirements
• Large volume orders must be processed before other orders.
• Invoices must be cross-checked with received items against packing slip for shipments.
• The finance team must be able to analyze patterns in transactional data to conduct fraud
prevention activities.
• You must automate the process of entering data about incoming orders into SMSApp.
• The solution must follow the principle of least privilege.
Purchase Order Quantity flow
• You must create an unmanaged solution to update purchase order details in SMSApp. The
flow must use a manual trigger.
• Members of Accounts Payable team will be testers for the solution. They must be able to
access the Purchase Order Quantity flow. - answer✔Flow for processing invoice data
4|Page
ALL RIGHTS RESERVED.
PL500 Exaam Study Guide.
Case Study 1: Contoso Pharmaceuticals
Background
Contoso Pharmaceuticals distributes specialty pharmaceuticals, ingredients, and raw materials
throughout North America. The company has 33 offices and 12 warehouses across the US,
Mexico, and Canada. As their customers' needs grow in sophistication, Contoso wants to delight
customers with breakthrough products, exceptional service, and on-time delivery of materials.
They want to automate time consuming and manual processes that are prone to error. Contoso
wants to consolidate and automate ordering and fulfillment processes. - answer✔• The
company has a fleet of 500 delivery trucks. The company has 150 drivers and uses third-party
contractors to deliver goods.
• The company has 400 warehouse workers and 30 finance clerks.
• Contoso has 85 sales representatives and 50 customer service representatives. Sales
representatives spend most of their time on the road visiting customers or prospects.
• The IT department consists of four system administrators and six system analysts.
1|Page
, ©BRAINBARTER EXAM SOLUTIONS 2024/2025
ALL RIGHTS RESERVED.
Current environment
Overview
Contoso Pharmaceuticals has a custom enterprise resource management (ERP) system. It is
difficult to integrate other applications and services with the system. Office staff manually key
in purchase orders, customer orders, and invoices after they receive a scan or hard copy of an
agreement.
Applications
• The company uses a custom supplier management system named SMSApps that runs on each
user's workstation. The system is costly to run and maintain. SMSApp does not have an API.
• Sales representatives manage customer requests by using Dynamics 365 Sales.
• Contoso has Microsoft Power Platform development, user acceptance testing (UAT), and
production environments.
• Administrators create one Accounts Payable (AP) mailbox for each environment to support
testing.
• The use of a DLP policy and Desktop Flow development is specified as part of the automation
requirements.
Business process
2|Page
, ©BRAINBARTER EXAM SOLUTIONS 2024/2025
ALL RIGHTS RESERVED.
1.Sales representatives create quotes by using a Microsoft Word document template. The
template
allowsrepresentativestoincludeproductquantity,andcostestimationdetailsthatwillbeneededto
fulfil an order. The representative converts quotes to a PDF file and emails the file to the
customer for approval.
2. The sales representative alerts the finance team about the new order and emails the finance
team a copy of the quote for processing.
3. The finance teamprints the quote and manually creates a purchase order (PO) into SMSApp
to request materials from a known and trusted vendor.
4. The SMSApp distributes the PO to stakeholders. The system sends a copy to a shared finance
team mailbox.
5. Once a PO is fulfilled by a vendor, the system sends an email to the finance mailbox. The
finance team releases an order to the warehouse. - answer✔6. Materials are shipped from the
vendor to one of Contoso's warehouses. Warehouse workers enter key information from the
waybill into SMSApp. The materials are unloaded and racked in the warehouse until they are
shipped to customers.
7. Upon checking for new daily orders in SMSApp, they see an open order is pending that is
awaiting the newly received materials
8. The Warehouse worker loads an order onto a truck for delivery and marks the order as
complete in SMSApp.
3|Page
, ©BRAINBARTER EXAM SOLUTIONS 2024/2025
ALL RIGHTS RESERVED.
9. Sales representatives provide fulfillment status and tracking information for orders.
10. A finance clerk prepares an invoice and sends the invoice to the customer by email. The
clerk sends a copy of the email to the shared AP mailbox.
11. The AP team monitors the shared mailbox to confirm that the customer has paid the
invoice.
Requirements
Functional requirements
• Large volume orders must be processed before other orders.
• Invoices must be cross-checked with received items against packing slip for shipments.
• The finance team must be able to analyze patterns in transactional data to conduct fraud
prevention activities.
• You must automate the process of entering data about incoming orders into SMSApp.
• The solution must follow the principle of least privilege.
Purchase Order Quantity flow
• You must create an unmanaged solution to update purchase order details in SMSApp. The
flow must use a manual trigger.
• Members of Accounts Payable team will be testers for the solution. They must be able to
access the Purchase Order Quantity flow. - answer✔Flow for processing invoice data
4|Page
