A retailer that uses Dynamics 365 Supply Chain Management is conducting master planning runs with 300,000 items in a single planned order run on average.
Optimizations are needed to improve performance. Most of the items in the master planning runs do not have dependencies on the other items.
Planning multiple items together in a single group will help with performance.
You need to configure the system to increase performance.
Which configuration should you use? A. Number of tasks in a helper bundle B. Number of threads C. Use of cache D. Time fences E. Number of orders in a firming bundle.
A company uses Dynamics 365 Supply Chain Management.
Sales of an item doubles during the holiday season. You plan to revise the minimum coverage proposal of the item.
You need to update the item's new minimum quantity in safety stock journal lines.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point. A. Update the Multiplication factor field. Calculate the minimum proposal for the inventory level. B. Update the New minimum quantity value to match the value in the Calculated minimum quantity field. C. Select the Service level. Calculate the minimum proposal for the inventory level. D. Select the Use the calculated minimum quantity as the new minimum quantity parameter option. Calculate the minimum proposal for the inventory level.
You are the planner for a distribution company.
You observe an increase in planned orders for item C0001. You must track the source for these planned orders and break them out based on their demand. You are not concerned with safety stock maximums for this item.
You need to ensure that the master planning batch job will create a unique planned purchase order for every new demand requirement for C0001.
Which coverage code should you use? A. Manual B. Period C. Min/Max D. Requirement.
SIMULATION -
You are a functional consultant for a company named Contoso Entertainment System USA (USMF).
You need to regenerate a master plan named DynPlan for item number D0023.
To complete this task, sign in to Dynamics 365 portal. You specify the planning method in the Master planning run dialog box. To open this dialog box, go to Master planning > Master planning > Run > Master planning, or select Run in the Master planning workspace.
Regeneration -
The regeneration planning method deletes existing planned orders, unless they are firmed. It generates new planned orders, based on all the requirements.
Regeneration is the only planning method that is available for static plans.
✑ Changes in supply are considered. These changes include changes in the forecast.
✑ This method respects the Period coverage code.
✑ This method supports product substitution functionality (PI).
Select DynPlan in the Master Plan field.
Select Regeneration in the Planning Method field.
Enter D0023 in the Item Number field. Enter D0023 in the Item Number field.
DRAG DROP -
A manufacturing company is setting up a new warehouse.
The warehouse must store a product that is currently stored in another warehouse.
You need to create new item coverage for the warehouse.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place: 6-3-2-1 3-1-2-4 4-5-3-1 2-3-1-4.
A company operates a chain of retail coffee shops and a distribution center. Each coffee shop and the distribution center are distinct warehouses.
Cups and lids are replenished from a single distribution center.
You need to configure store replenishment for coffee cup lids.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point. A. Set the coverage plan by dimension for warehouse on the Storage dimension group. B. Set the minimum item coverage to the safety stock quantity. Set the maximum to the maximum quantity of stock to reorder above the safety stock quantity. C. Set the minimum item coverage to the safety stock quantity. Set the maximum item coverage to 0. D. Create a coverage group assignment for the item. E. Set the minimum item coverage to 0. Set the maximum item coverage to the number of lids to keep on hand.
HOTSPOT -
A company uses Dynamics 365 Supply Chain Management to sell consumer electronics to retailers across North America.
An inventory manager needs to view purchase orders by different periods of time for all warehouses.
If there are insufficient orders for expected demand, the manager must create new purchase or transfer orders to meet the demand versus the current on-hand inventory that is already allocated for future demand.
The company also needs to keep a surplus of 5 percent of inventory for unexpected demand.
You need to identify a solution to meet these requirements.
Which feature should you use for each requirement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area: 4-2 1-2 3-4 2-1.
A company uses planning optimization in Dynamics 365 Supply Chain Management. Automatic firming is enabled.
Some of the planned purchase orders are not being firmed as expected. The inventory planners therefore need to manually process planned purchase orders.
You need to include the planned purchase orders in automatic firming.
What are two possible configurations you can use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point. A. Lead Time B. Automatic firming time fence (days) C. Requirements Date D. Freeze time fence on master plan.
A company uses Dynamics 365 Supply Chain Management.
The company is consistently short on inventory for a group of produced finished good items. This creates customer service issues.
You need to ensure that production orders are automatically created when inventory is low.
Which two actions should you perform? Each answer represents a partial solution.
NOTE: Each correct selection is worth one point. A. Update the item maximum. B. Update the item minimum. C. Set Capable to Promise. D. Create a safety stock journal. E. Create a transfer journal.
A company uses planning optimization in Dynamics 365 Supply Chain Management.
A planning optimization job is triggered by mistake from the user interface. The planning optimization job is running with incorrect runtime filters.
You need to resolve the issue.
What should you do? A. Cancel the job from the plan history. B. Cancel the job from the dialog box. C. Disable the environment add-in. D. Cancel the planning optimization fit analysis.
DRAG DROP -
A company implements Dynamics 365 Supply Chain Management.
The company needs to improve the reliability of their forecasting data.
You need to implement demand forecasting to meet the requirements.
What should you do? To answer, drag the appropriate actions to the correct requirements. Each action may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place: 1-5-2 1-2-4 3-2-4 2-3-5.
DRAG DROP -
A company is implementing Dynamics 365 Supply Chain Management.
You need to determine which planning engine meets each business requirement.
Which planning engine should you use for each requirement? To answer, drag the appropriate planning engines to the correct requirements. Each planning engine may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:
2-2-1 1-2-2 2-1-2.
DRAG DROP -
A company uses Dynamics 365 Supply Chain Management with master planning.
The company needs to enable planning optimization functionality to improve master planning processes.
You need to advise which prerequisites the company must fulfill to enable planning optimization.
What must the company do? To answer, drag the appropriate types to the correct prerequisites. Each type may be used once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place: 1-2-2 2-1-2 2-1-1 1-2-1.
DRAG DROP -
A manufacturing company uses Dynamics 365 Supply Chain Management.
You must update the safety stock level for raw materials.
You need to calculate and process minimum coverage proposals based on data from historical transactions.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place: 1-3-2 1-2-3 3-2-4 4-2-5.
HOTSPOT -
A company implements Dynamics 365 Supply Chain Management.
You complete the prerequisites to implement the master planning optimization.
You need to configure the planning optimization feature.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area: 1-3 2-1 2-3 4-4.
HOTSPOT -
A company that has three legal entities is implementing Dynamics 365 Supply Chain Management.
One legal entity supplies the other two legal entities as customers with inventory. Intercompany master planning must be set up and run in the least amount of time.
You need to configure the system to meet the requirements.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area: 1-1 2-1 3-3 1-3.
HOTSPOT -
You are configuring the period templates that are used for inventory inquiries. Today's date is November 3, 2020.
The period templates configuration is shown in the following graphic. You set the value for the Direction field to backward. 4-2 1-2 3-4 2-3.
HOTSPOT -
A client uses master planning in Dynamics 365 Supply Chain Management.
The client wants to make sure that the item coverage groups are configured properly.
You need to validate the configurations.
Which configurations should you validate for each scenario? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area: 1-3 2-3 1-4 3-2.
HOTSPOT -
A company uses Dynamics 365 Supply Chain Management for master planning in manufacturing processes.
Master planning runs have increased in processing time over the past month.
You need to identify the impact of configuration changes on performance from a single location.
Which objects should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
2-1 1-2 3-4.
You use Dynamics 365 Supply Chain Management to manage inventory.
Multiple forms are currently required to make insights against inventory supply metrics for an item actionable.
You need to use the supply schedule form to streamline operations.
Which three objects can you use to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point. A. Transfer orders B. Safety stock journals C. Scheduled Kanban D. Production orders E. Demand forecast.
HOTSPOT
-
A company uses Dynamics 365 Supply Chain Management for inventory management in a single warehouse.
The warehouse is experiencing vendor supply issues with several specific groups of products. The demand and supply for products needs to be viewed for the warehouse using a master planning model for different periods of time.
You need to view the information in a single location.
Which configuration should you use for each requirement?
To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point. 3-4 1-2 3-2 2-1.
DRAG DROP
-
A manufacturing company uses Dynamics 365 Supply Chain Management.
You must review the safety stock level for raw materials.
You need to calculate the minimum coverage proposals based on standard deviation.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. 1-3-5 2-3-4 3-1-5 2-3-1.
A manufacturing company uses Dynamics 365 Supply Chain Management.
The procurement manager updates the minimum stock levels by using the safety stock journal. The manager encounters a setup error while calculating the proposal for the minimum inventory level by using the service level option.
You need to identify the cause of the error.
What is the cause of the error? A. The Multiplication factor value was left blank. B. Safety stock journal lines were created by including the current month’s transactions. C. The Use the calculated minimum quantity as the new minimum quantity option was not used. D. The Lead time margin value was left blank. E. The Calculate standard deviation option was not used while creating the journal lines.
A company uses the built-in Dynamics 365 Supply Chain Management master planning engine. Planned orders are automatically firming and are firmed during the current week.
You need to reconfigure the system for the new Planning Optimization master planning engine.
What should you change? A. firming time fence to one week B. firming time fence to lead-time plus one week C. open orders' firming date to be the requirement date D. firming time fence to be longer than the lead time E. firming time fence to 0.
A company uses Dynamics 365 Supply Chain Management master planning. The company plans to run master planning throughout the day. Planning Optimization is not configured.
The company administrator reports that they are not able to configure any master planning features or enable master planning in Dynamics 365.
You need to implement Planning Optimization.
What should you do first? A. Place the environment into maintenance mode. B. Deallocate the current environment. C. Enable the Planning Optimization configuration key. D. Set the value of the Use Planning Optimization field to yes. E. Activate the Planning Optimization license.
HOTSPOT
-
A manufacturing company uses Dynamics 365 Supply Chain Management. The company plans to move to the new Planning Optimization functionality.
Several processes are no longer operating as expected.
You need to identify any missing functionality and the number of records impacted.
Which tool should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point. 3-4 1-2 2-4 3-2.
HOTSPOT
-
A company uses Dynamics 365 Supply Chain Management. The company plans to implement master planning.
You need to configure the master planning solution to perform master planning runs in the middle of each day instead of at the end of each day.
Which solution component should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point. 2-3-1 2-3-4 1-3-4 4-1-2.
A company is implementing Dynamics 365 Supply Chain Management. The company frequently uses consigned inventory.
The company wants to minimize entry time for the inventory.
You must configure the default settings for consignment replenishment lines.
Which three options can you configure? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point. A. Default site B. Multiple order quantity C. Stopped D. Standard order quantity E. Default warehouse.
DRAG DROP
-
A company is implementing Dynamics 365 Supply Chain Management.
The company wants to configure the quality orders and nonconformances for the following tasks:
• Recording timesheets associated with repair costs
• Documenting outcomes of test results
• Creating a certificate of analysis
You need to configure the features for these tasks.
What should you configure? To answer, drag the appropriate features to the correct tasks. Each feature may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
2-1-1 2-2-1 1-2-2 1-2-1.
A company uses Dynamics 365 Supply Chain Management. The company implements master planning.
The company reports delays in the supply chain that have resulted in late deliveries for products. You must simulate several broad delays across all products in the supply chain when calculating lead times. Daily planning for items must not be impacted.
You need to configure the system.
What should you configure? A. Planned orders B. Receipt margins C. Master plans D. Coverage groups E. Released products.
A company uses Dynamics 365 Supply Chain Management.
The company classifies and tracks products based on how useful they are for achieving their business goals. Certain product classifications are important in relation to inventory controls and margins. Other classifications have a small profit margin and are less important for inventory variances.
The classification configuration must feed into existing classification reports and system logic.
You need to configure the products for the classifications.
Where should you configure the classifications? A. Unreleased product variant B. Released product variant C. Product attributes D. Unreleased product E. Released product.
A company uses Dynamics 365 Supply Chain Management. The company provides warehouse workers with handheld devices to perform inventory operations.
Periodic inventory audits are required due to the frequent theft of some inventory items from a warehouse. Some inventory has been fully depleted. On-hand inventory quantities of other items are consistently incorrect.
You need to configure the system to automatically create cycle-counting work.
Which two methods can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point. A. threshold parameters B. work pool C. cycle count plan D. work policies E. inventory journals.
A company implements Dynamics 365 Supply Chain Management. The company uses the demand forecasting service to generate a statistical baseline forecast for one allocation key at a time.
The process takes too long to complete.
You need to ensure better performance of the service.
What should you configure? A. Storage account name B. Storage account key C. Custom storage account D. Request response mode.
DRAG DROP
-
A company uses Dynamics 365 Supply Chain Management. The company implements master planning.
The company identifies several supply chain issues.
You need to configure safety margins for the company.
Which type of safety margin should you use? To answer, drag the appropriate safety margin types to the correct issues. Each safety margin type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
2-3-1 1-2-3 3-2-1 1-3-2.
DRAG DROP
-
A company is implementing Dynamics 365 Supply Chain Management.
The company requires that historical transactional data from the current system be used to determine future inventory needs. Transactions that fall outside of a standard deviation must be excluded.
You need to configure the system to meet the requirements.
What should you configure? To answer, drag the appropriate configurations to the correct requirements. Each configuration may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point. 1-3 2-3 1-2 3-1.
A company uses planning optimization in Dynamics 365 Supply Chain Management.
A new item is set up for production with a bill of materials (BOM) and is included in planning optimization.
You need to identify the planning output for the item.
What are two parts of the output? Each answer represents a partial solution.
NOTE: Each correct selection is worth one point. A. warning B. production order C. purchase order D. action message.
DRAG DROP
-
A company is implementing Dynamics 365 Supply Chain Management for new warehouse management operations.
A three-tier workflow is being implemented for planned order approval. It is anticipated that a few days will need to be added to process the new planned orders.
During the yearly renegotiation of pricing, contractual lead times rather than the actual lead times are used. Vendor score card analysis shows that certain vendors are often late in their shipments from their contractual lead time dates.
Shipping delays to customers are likely for the next three months while the new warehouse operations are adopted.
You need to configure safety margins to account for the new system processes.
Which safety margin should you use for each process? To answer, drag the appropriate safety margins to the correct processes. Each safety margin may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point. 4-2-1 1-2-4 2-3-1 3-2-4.
DRAG DROP
-
A company uses Dynamics 365 Supply Chain Management to manage procurement operations.
A purchasing clerk must process a purchasing request from an offshore vendor with the landed cost.
You need to explain the steps needed to perform this process.
Which five actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
4-3-1-7-6 2-1-3-4-5 4-3-1-5-6 1-2-5-6-3.
Case study -
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study -
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background -
School of Fine Art is a distribution company that sells school supply items to primary and secondary schools. These include items such as pens, pencils, paper, notebooks, chalk, desks, acrylic paints, blackboards, dry erase markers, and whiteboard paint. Due to increased demand for colored pencils, lead times are longer for these pencils. School of Fine Art plans to expand sales into this market.
School of Fine Art plans to implement Dynamics 365 Supply Chain Management to manage the business.
Current environment. Company structure
School of Fine Art consists of two legal entities.
Primary company -
• Located in Dublin, Ireland.
• Has a single named warehouse.
• Is the primary distribution center for both companies.
Second company -
• Is located in Glasgow, Scotland.
• Includes the following warehouses: Glasgow1, Glasgow2.
○ Glasgow1 is used primarily to supply items regionally.
○ Glasgow2 serves as local storage for vendor-owned inventory and bulk storage for School of Fine Art's inventory.
Current environment. General processes
School of Fine Art uses a combination of spreadsheets and paper forms to manage the business.
• All sales, purchases, and inventory are tracked in spreadsheets that are password protected by managers.
• Managers frequently share spreadsheet passwords so that other users can make edits on their behalf. Inventory quantities and values are unreliable.
• The spreadsheets are often incorrectly updated, have entry errors, and broken formulas for calculations.
• Purchase order receipts, picking lists, packing slips, and invoices are all handwritten on pre-printed, three-part forms.
• Late summer is the company's busiest time. During this time, workers are typically on the warehouse floor or making rush deliveries to schools to meet last-minute needs.
Current environment. Inventory and warehousing
• School of Fine Art values inventory by using FIFO costing methods.
• Inventory in the warehouses cannot be distinguished as available inventory or inventory that is sold to a customer and waiting to be picked. This creates inventory inflation during cycle counts and later shortages because warehouse workers count items that are already promised to customers and waiting to be shipped.
• Glasgow2 space is fully allocated to vendors.
• Due to space constraints, school orders for photocopiers are shipped from the vendor to the school.
• Crayons are stored as separate item numbers depending on whether they are in a box or a case. This creates issues when counting inventory to determine the total number of crayons in stock.
• Lack of inventory controls has led to shortages on sales orders, creating backorders and unhappy schools.
• Inventory is ordered quarterly due to the seasonality of the business.
• Items can change annually based on popular sizes, colors, and styles for each new school season. The creation of the different configurations is a manual process, which creates so much overhead that temporary workers are brought in to do the data entry.
Current environment. Purchasing -
• Reordering is manually managed by the buyers looking at the seasonal spikes for the start of the school year, slowing around the end-of-year holidays until the following school year.
• Pens are readily available products that are rarely discounted for sale.
• Photocopiers are only available for sale on the Glasgow region.
• Photocopy paper and construction paper are ordered by the pallet into Dublin1 and must be broken down into smaller sizes. The pallets are typically broken down and then split between what stays in Dublin1 and what is shipped to Glasgow1.
• Chalk and blackboards are slower sellers, so many vendors do not carry these items. School of Fine Art purchases these products from a single vendor. There are no alternative vendors available.
• School of Fine Art agrees to purchase a new line of smartboards from a vendor. The agreed-upon smartboard purchase prices will have a cost price per 55-inch, 75-inch, or 85-inch smartboard.
• The company purchases pencils for the following warehouses:
○ Glasgow1:
• standard pencils from Vendor A
• colored pencils from Vendor B
○ Dublin1:
• standard pencils from Vendor A
• colored pencils from Vendor A
• As whiteboard paint grows in popularity, so does the demand. This causes supply shortages. Whiteboard paint is ordered six months in advance.
Current environment. Customer sales
• The company contractually agrees to prices for some items with schools prior to the start of each school year.
• Schools may order bulk cases of products and choose to distribute further breakdowns, such as a case of crayons, which are then distributed to classrooms by the box.
• Pens do not require contracts with schools because they are low margin and do not have supply chain shortages.
• Painting supplies such as acrylic paint, canvases, and easels do not require a special contract and are sold at regular list price to all schools.
• Schools that offer painting classes are part of a program that provides special pricing on the painting supplies.
• Chalk and blackboards are ordered less frequently than they were in past years. Schools are choosing to use whiteboard paint, which is a lower cost than ordering and installing the whiteboards.
Requirements. Customers and sales
• The system must have the ability to limit product purchase amounts by a single school to prevent stock shortages for other schools.
• Schools are obligated to purchase the agreed amount for specific items per the school year.
• Customer service must be able to easily enter items for sales orders and identify stock shortages.
• Sales of whiteboard paint must be limited so that one school does not buy all the inventory and force backorders for other schools.
• Schools must agree to the amount of whiteboard paint they will purchase for the whole school year.
Requirements. Inventory costing -
• Inventory must have associated costs except for the vendor storage in Glasgow2.
• The vendor storage must still contain quantities but not include cost in inventory valuations.
• At the end of each month, the costing manager must be able to identify how many items will not be fully settled.
• Annual configuration changes to items must be automatically created where possible.
• The company must be able to track costs for colored pencils and standard pencils separately.
Requirements. Inventory -
• Warehouse workers must be able to use their mobile phones and the mobile app to take calls and create transactions in the warehouse.
• The desks must use a single item number and barcode regardless of year manufactured and the vendor.
• Water-based paints from the vendor must be received in pails.
• Acrylic paint must be managed by batches and expiration dates.
• Pencils must be categorized as colored pencils or standard pencils. The individual colors of each colored pencil (such as red, green, and blue) will not be tracked.
• The creation of unique smartboard items must be kept to a minimum.
Issues -
• WarehouseWorker1 works in Glasgow2. The worker receives a request to ship pallets of paper from the warehouse to Glasgow1 and Dublin1. WarehouseWorker1 must create the shipments in the system to transfer the pallets of paper from Glasgow1 to Dublin1.
• The number of backorders for desks has increased. Customer service representatives struggle to select a desk item number that has inventory on hand. The desks are the same item, but the manufacturer vendor and year differ.
• A school calls customer service to report that its photocopier is broken. The school needs expedited shipment of a replacement.
• A school that is part of the special paint program reports that a sale price on canvas last month was a better price than its paint program price. The school requests a price adjustment.
• A school reports that different shipments of acrylic paints are slightly different in color.
• The sales team decides to have a flash sale on pens for one month only. The person entering the Sales order line should be able to communicate the information to the customer on the Sales order line.
• Schools are reporting that chalk and blackboards are broken upon receipt. A worker in Dublin1 opens some cases of these products in the warehouse and finds that they are also broken. You must implement processes to enforce inventory inspection for a percentage of each purchase order line received. You must block all inventory for a purchase order line if the inspection fails.
You need to set up the manufacturer and year for the desks.
What should you configure first? A. attribute type B. variant C. friendly name D. item type E. attribute definition.
HOTSPOT
-
Case study
-
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
-
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background
-
School of Fine Art is a distribution company that sells school supply items to primary and secondary schools. These include items such as pens, pencils, paper, notebooks, chalk, desks, acrylic paints, blackboards, dry erase markers, and whiteboard paint. Due to increased demand for colored pencils, lead times are longer for these pencils. School of Fine Art plans to expand sales into this market.
School of Fine Art plans to implement Dynamics 365 Supply Chain Management to manage the business.
Current environment. Company structure
School of Fine Art consists of two legal entities.
Primary company
-
• Located in Dublin, Ireland.
• Has a single named warehouse.
• Is the primary distribution center for both companies.
Second company
-
• Is located in Glasgow, Scotland.
• Includes the following warehouses: Glasgow1, Glasgow2.
○ Glasgow1 is used primarily to supply items regionally.
○ Glasgow2 serves as local storage for vendor-owned inventory and bulk storage for School of Fine Art's inventory.
Current environment. General processes
School of Fine Art uses a combination of spreadsheets and paper forms to manage the business.
• All sales, purchases, and inventory are tracked in spreadsheets that are password protected by managers.
• Managers frequently share spreadsheet passwords so that other users can make edits on their behalf. Inventory quantities and values are unreliable.
• The spreadsheets are often incorrectly updated, have entry errors, and broken formulas for calculations.
• Purchase order receipts, picking lists, packing slips, and invoices are all handwritten on pre-printed, three-part forms.
• Late summer is the company's busiest time. During this time, workers are typically on the warehouse floor or making rush deliveries to schools to meet last-minute needs.
Current environment. Inventory and warehousing
• School of Fine Art values inventory by using FIFO costing methods.
• Inventory in the warehouses cannot be distinguished as available inventory or inventory that is sold to a customer and waiting to be picked. This creates inventory inflation during cycle counts and later shortages because warehouse workers count items that are already promised to customers and waiting to be shipped.
• Glasgow2 space is fully allocated to vendors.
• Due to space constraints, school orders for photocopiers are shipped from the vendor to the school.
• Crayons are stored as separate item numbers depending on whether they are in a box or a case. This creates issues when counting inventory to determine the total number of crayons in stock.
• Lack of inventory controls has led to shortages on sales orders, creating backorders and unhappy schools.
• Inventory is ordered quarterly due to the seasonality of the business.
• Items can change annually based on popular sizes, colors, and styles for each new school season. The creation of the different configurations is a manual process, which creates so much overhead that temporary workers are brought in to do the data entry.
Current environment. Purchasing
• Reordering is manually managed by the buyers looking at the seasonal spikes for the start of the school year, slowing around the end-of-year holidays until the following school year.
• Pens are readily available products that are rarely discounted for sale.
• Photocopiers are only available for sale on the Glasgow region.
• Photocopy paper and construction paper are ordered by the pallet into Dublin1 and must be broken down into smaller sizes. The pallets are typically broken down and then split between what stays in Dublin1 and what is shipped to Glasgow1.
• Chalk and blackboards are slower sellers, so many vendors do not carry these items. School of Fine Art purchases these products from a single vendor. There are no alternative vendors available.
• School of Fine Art agrees to purchase a new line of smartboards from a vendor. The agreed-upon smartboard purchase prices will have a cost price per 55-inch, 75-inch, or 85-inch smartboard.
• The company purchases pencils for the following warehouses:
○ Glasgow1:
• standard pencils from Vendor A
• colored pencils from Vendor B
○ Dublin1:
• standard pencils from Vendor A
• colored pencils from Vendor A
• As whiteboard paint grows in popularity, so does the demand. This causes supply shortages. Whiteboard paint is ordered six months in advance.
Current environment. Customer sales
• The company contractually agrees to prices for some items with schools prior to the start of each school year.
• Schools may order bulk cases of products and choose to distribute further breakdowns, such as a case of crayons, which are then distributed to classrooms by the box.
• Pens do not require contracts with schools because they are low margin and do not have supply chain shortages.
• Painting supplies such as acrylic paint, canvases, and easels do not require a special contract and are sold at regular list price to all schools.
• Schools that offer painting classes are part of a program that provides special pricing on the painting supplies.
• Chalk and blackboards are ordered less frequently than they were in past years. Schools are choosing to use whiteboard paint, which is a lower cost than ordering and installing the whiteboards.
Requirements. Customers and sales
• The system must have the ability to limit product purchase amounts by a single school to prevent stock shortages for other schools.
• Schools are obligated to purchase the agreed amount for specific items per the school year.
• Customer service must be able to easily enter items for sales orders and identify stock shortages.
• Sales of whiteboard paint must be limited so that one school does not buy all the inventory and force backorders for other schools.
• Schools must agree to the amount of whiteboard paint they will purchase for the whole school year.
Requirements. Inventory costing
• Inventory must have associated costs except for the vendor storage in Glasgow2.
• The vendor storage must still contain quantities but not include cost in inventory valuations.
• At the end of each month, the costing manager must be able to identify how many items will not be fully settled.
• Annual configuration changes to items must be automatically created where possible.
• The company must be able to track costs for colored pencils and standard pencils separately.
Requirements. Inventory
-
• Warehouse workers must be able to use their mobile phones and the mobile app to take calls and create transactions in the warehouse.
• The desks must use a single item number and barcode regardless of year manufactured and the vendor.
• Water-based paints from the vendor must be received in pails.
• Acrylic paint must be managed by batches and expiration dates.
• Pencils must be categorized as colored pencils or standard pencils. The individual colors of each colored pencil (such as red, green, and blue) will not be tracked.
• The creation of unique smartboard items must be kept to a minimum.
Issues
-
• WarehouseWorker1 works in Glasgow2. The worker receives a request to ship pallets of paper from the warehouse to Glasgow1 and Dublin1. WarehouseWorker1 must create the shipments in the system to transfer the pallets of paper from Glasgow1 to Dublin1.
• The number of backorders for desks has increased. Customer service representatives struggle to select a desk item number that has inventory on hand. The desks are the same item, but the manufacturer vendor and year differ.
• A school calls customer service to report that its photocopier is broken. The school needs expedited shipment of a replacement.
• A school that is part of the special paint program reports that a sale price on canvas last month was a better price than its paint program price. The school requests a price adjustment.
• A school reports that different shipments of acrylic paints are slightly different in color.
• The sales team decides to have a flash sale on pens for one month only. The person entering the Sales order line should be able to communicate the information to the customer on the Sales order line.
• Schools are reporting that chalk and blackboards are broken upon receipt. A worker in Dublin1 opens some cases of these products in the warehouse and finds that they are also broken. You must implement processes to enforce inventory inspection for a percentage of each purchase order line received. You must block all inventory for a purchase order line if the inspection fails.
You must configure pen flash sale prices.
What should you configure? To answer, select the appropriate option in the answer area.
NOTE: Each correct selection is worth one point. 3-1 1-3 2-3 3-2.
HOTSPOT
-
Case study
-
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
-
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background
-
School of Fine Art is a distribution company that sells school supply items to primary and secondary schools. These include items such as pens, pencils, paper, notebooks, chalk, desks, acrylic paints, blackboards, dry erase markers, and whiteboard paint. Due to increased demand for colored pencils, lead times are longer for these pencils. School of Fine Art plans to expand sales into this market.
School of Fine Art plans to implement Dynamics 365 Supply Chain Management to manage the business.
Current environment. Company structure
School of Fine Art consists of two legal entities.
Primary company
-
• Located in Dublin, Ireland.
• Has a single named warehouse.
• Is the primary distribution center for both companies.
Second company
-
• Is located in Glasgow, Scotland.
• Includes the following warehouses: Glasgow1, Glasgow2.
○ Glasgow1 is used primarily to supply items regionally.
○ Glasgow2 serves as local storage for vendor-owned inventory and bulk storage for School of Fine Art's inventory.
Current environment. General processes
School of Fine Art uses a combination of spreadsheets and paper forms to manage the business.
• All sales, purchases, and inventory are tracked in spreadsheets that are password protected by managers.
• Managers frequently share spreadsheet passwords so that other users can make edits on their behalf. Inventory quantities and values are unreliable.
• The spreadsheets are often incorrectly updated, have entry errors, and broken formulas for calculations.
• Purchase order receipts, picking lists, packing slips, and invoices are all handwritten on pre-printed, three-part forms.
• Late summer is the company's busiest time. During this time, workers are typically on the warehouse floor or making rush deliveries to schools to meet last-minute needs.
Current environment. Inventory and warehousing
• School of Fine Art values inventory by using FIFO costing methods.
• Inventory in the warehouses cannot be distinguished as available inventory or inventory that is sold to a customer and waiting to be picked. This creates inventory inflation during cycle counts and later shortages because warehouse workers count items that are already promised to customers and waiting to be shipped.
• Glasgow2 space is fully allocated to vendors.
• Due to space constraints, school orders for photocopiers are shipped from the vendor to the school.
• Crayons are stored as separate item numbers depending on whether they are in a box or a case. This creates issues when counting inventory to determine the total number of crayons in stock.
• Lack of inventory controls has led to shortages on sales orders, creating backorders and unhappy schools.
• Inventory is ordered quarterly due to the seasonality of the business.
• Items can change annually based on popular sizes, colors, and styles for each new school season. The creation of the different configurations is a manual process, which creates so much overhead that temporary workers are brought in to do the data entry.
Current environment. Purchasing
• Reordering is manually managed by the buyers looking at the seasonal spikes for the start of the school year, slowing around the end-of-year holidays until the following school year.
• Pens are readily available products that are rarely discounted for sale.
• Photocopiers are only available for sale on the Glasgow region.
• Photocopy paper and construction paper are ordered by the pallet into Dublin1 and must be broken down into smaller sizes. The pallets are typically broken down and then split between what stays in Dublin1 and what is shipped to Glasgow1.
• Chalk and blackboards are slower sellers, so many vendors do not carry these items. School of Fine Art purchases these products from a single vendor. There are no alternative vendors available.
• School of Fine Art agrees to purchase a new line of smartboards from a vendor. The agreed-upon smartboard purchase prices will have a cost price per 55-inch, 75-inch, or 85-inch smartboard.
• The company purchases pencils for the following warehouses:
○ Glasgow1:
• standard pencils from Vendor A
• colored pencils from Vendor B
○ Dublin1:
• standard pencils from Vendor A
• colored pencils from Vendor A
• As whiteboard paint grows in popularity, so does the demand. This causes supply shortages. Whiteboard paint is ordered six months in advance.
Current environment. Customer sales
• The company contractually agrees to prices for some items with schools prior to the start of each school year.
• Schools may order bulk cases of products and choose to distribute further breakdowns, such as a case of crayons, which are then distributed to classrooms by the box.
• Pens do not require contracts with schools because they are low margin and do not have supply chain shortages.
• Painting supplies such as acrylic paint, canvases, and easels do not require a special contract and are sold at regular list price to all schools.
• Schools that offer painting classes are part of a program that provides special pricing on the painting supplies.
• Chalk and blackboards are ordered less frequently than they were in past years. Schools are choosing to use whiteboard paint, which is a lower cost than ordering and installing the whiteboards.
Requirements. Customers and sales
• The system must have the ability to limit product purchase amounts by a single school to prevent stock shortages for other schools.
• Schools are obligated to purchase the agreed amount for specific items per the school year.
• Customer service must be able to easily enter items for sales orders and identify stock shortages.
• Sales of whiteboard paint must be limited so that one school does not buy all the inventory and force backorders for other schools.
• Schools must agree to the amount of whiteboard paint they will purchase for the whole school year.
Requirements. Inventory costing
• Inventory must have associated costs except for the vendor storage in Glasgow2.
• The vendor storage must still contain quantities but not include cost in inventory valuations.
• At the end of each month, the costing manager must be able to identify how many items will not be fully settled.
• Annual configuration changes to items must be automatically created where possible.
• The company must be able to track costs for colored pencils and standard pencils separately.
Requirements. Inventory
-
• Warehouse workers must be able to use their mobile phones and the mobile app to take calls and create transactions in the warehouse.
• The desks must use a single item number and barcode regardless of year manufactured and the vendor.
• Water-based paints from the vendor must be received in pails.
• Acrylic paint must be managed by batches and expiration dates.
• Pencils must be categorized as colored pencils or standard pencils. The individual colors of each colored pencil (such as red, green, and blue) will not be tracked.
• The creation of unique smartboard items must be kept to a minimum.
Issues
-
• WarehouseWorker1 works in Glasgow2. The worker receives a request to ship pallets of paper from the warehouse to Glasgow1 and Dublin1. WarehouseWorker1 must create the shipments in the system to transfer the pallets of paper from Glasgow1 to Dublin1.
• The number of backorders for desks has increased. Customer service representatives struggle to select a desk item number that has inventory on hand. The desks are the same item, but the manufacturer vendor and year differ.
• A school calls customer service to report that its photocopier is broken. The school needs expedited shipment of a replacement.
• A school that is part of the special paint program reports that a sale price on canvas last month was a better price than its paint program price. The school requests a price adjustment.
• A school reports that different shipments of acrylic paints are slightly different in color.
• The sales team decides to have a flash sale on pens for one month only. The person entering the Sales order line should be able to communicate the information to the customer on the Sales order line.
• Schools are reporting that chalk and blackboards are broken upon receipt. A worker in Dublin1 opens some cases of these products in the warehouse and finds that they are also broken. You must implement processes to enforce inventory inspection for a percentage of each purchase order line received. You must block all inventory for a purchase order line if the inspection fails.
You need to configure the vendor pricing for pencils.
What should you do? To answer, select the appropriate option in the answer area.
NOTE: Each correct selection is worth one point. 3-3 1-2 2-3 3-2.
HOTSPOT
-
Case study
-
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
-
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background
-
School of Fine Art is a distribution company that sells school supply items to primary and secondary schools. These include items such as pens, pencils, paper, notebooks, chalk, desks, acrylic paints, blackboards, dry erase markers, and whiteboard paint. Due to increased demand for colored pencils, lead times are longer for these pencils. School of Fine Art plans to expand sales into this market.
School of Fine Art plans to implement Dynamics 365 Supply Chain Management to manage the business.
Current environment. Company structure
School of Fine Art consists of two legal entities.
Primary company
-
• Located in Dublin, Ireland.
• Has a single named warehouse.
• Is the primary distribution center for both companies.
Second company
-
• Is located in Glasgow, Scotland.
• Includes the following warehouses: Glasgow1, Glasgow2.
○ Glasgow1 is used primarily to supply items regionally.
○ Glasgow2 serves as local storage for vendor-owned inventory and bulk storage for School of Fine Art's inventory.
Current environment. General processes
School of Fine Art uses a combination of spreadsheets and paper forms to manage the business.
• All sales, purchases, and inventory are tracked in spreadsheets that are password protected by managers.
• Managers frequently share spreadsheet passwords so that other users can make edits on their behalf. Inventory quantities and values are unreliable.
• The spreadsheets are often incorrectly updated, have entry errors, and broken formulas for calculations.
• Purchase order receipts, picking lists, packing slips, and invoices are all handwritten on pre-printed, three-part forms.
• Late summer is the company's busiest time. During this time, workers are typically on the warehouse floor or making rush deliveries to schools to meet last-minute needs.
Current environment. Inventory and warehousing
• School of Fine Art values inventory by using FIFO costing methods.
• Inventory in the warehouses cannot be distinguished as available inventory or inventory that is sold to a customer and waiting to be picked. This creates inventory inflation during cycle counts and later shortages because warehouse workers count items that are already promised to customers and waiting to be shipped.
• Glasgow2 space is fully allocated to vendors.
• Due to space constraints, school orders for photocopiers are shipped from the vendor to the school.
• Crayons are stored as separate item numbers depending on whether they are in a box or a case. This creates issues when counting inventory to determine the total number of crayons in stock.
• Lack of inventory controls has led to shortages on sales orders, creating backorders and unhappy schools.
• Inventory is ordered quarterly due to the seasonality of the business.
• Items can change annually based on popular sizes, colors, and styles for each new school season. The creation of the different configurations is a manual process, which creates so much overhead that temporary workers are brought in to do the data entry.
Current environment. Purchasing
• Reordering is manually managed by the buyers looking at the seasonal spikes for the start of the school year, slowing around the end-of-year holidays until the following school year.
• Pens are readily available products that are rarely discounted for sale.
• Photocopiers are only available for sale on the Glasgow region.
• Photocopy paper and construction paper are ordered by the pallet into Dublin1 and must be broken down into smaller sizes. The pallets are typically broken down and then split between what stays in Dublin1 and what is shipped to Glasgow1.
• Chalk and blackboards are slower sellers, so many vendors do not carry these items. School of Fine Art purchases these products from a single vendor. There are no alternative vendors available.
• School of Fine Art agrees to purchase a new line of smartboards from a vendor. The agreed-upon smartboard purchase prices will have a cost price per 55-inch, 75-inch, or 85-inch smartboard.
• The company purchases pencils for the following warehouses:
○ Glasgow1:
• standard pencils from Vendor A
• colored pencils from Vendor B
○ Dublin1:
• standard pencils from Vendor A
• colored pencils from Vendor A
• As whiteboard paint grows in popularity, so does the demand. This causes supply shortages. Whiteboard paint is ordered six months in advance.
Current environment. Customer sales
• The company contractually agrees to prices for some items with schools prior to the start of each school year.
• Schools may order bulk cases of products and choose to distribute further breakdowns, such as a case of crayons, which are then distributed to classrooms by the box.
• Pens do not require contracts with schools because they are low margin and do not have supply chain shortages.
• Painting supplies such as acrylic paint, canvases, and easels do not require a special contract and are sold at regular list price to all schools.
• Schools that offer painting classes are part of a program that provides special pricing on the painting supplies.
• Chalk and blackboards are ordered less frequently than they were in past years. Schools are choosing to use whiteboard paint, which is a lower cost than ordering and installing the whiteboards.
Requirements. Customers and sales
• The system must have the ability to limit product purchase amounts by a single school to prevent stock shortages for other schools.
• Schools are obligated to purchase the agreed amount for specific items per the school year.
• Customer service must be able to easily enter items for sales orders and identify stock shortages.
• Sales of whiteboard paint must be limited so that one school does not buy all the inventory and force backorders for other schools.
• Schools must agree to the amount of whiteboard paint they will purchase for the whole school year.
Requirements. Inventory costing
• Inventory must have associated costs except for the vendor storage in Glasgow2.
• The vendor storage must still contain quantities but not include cost in inventory valuations.
• At the end of each month, the costing manager must be able to identify how many items will not be fully settled.
• Annual configuration changes to items must be automatically created where possible.
• The company must be able to track costs for colored pencils and standard pencils separately.
Requirements. Inventory
-
• Warehouse workers must be able to use their mobile phones and the mobile app to take calls and create transactions in the warehouse.
• The desks must use a single item number and barcode regardless of year manufactured and the vendor.
• Water-based paints from the vendor must be received in pails.
• Acrylic paint must be managed by batches and expiration dates.
• Pencils must be categorized as colored pencils or standard pencils. The individual colors of each colored pencil (such as red, green, and blue) will not be tracked.
• The creation of unique smartboard items must be kept to a minimum.
Issues
-
• WarehouseWorker1 works in Glasgow2. The worker receives a request to ship pallets of paper from the warehouse to Glasgow1 and Dublin1. WarehouseWorker1 must create the shipments in the system to transfer the pallets of paper from Glasgow1 to Dublin1.
• The number of backorders for desks has increased. Customer service representatives struggle to select a desk item number that has inventory on hand. The desks are the same item, but the manufacturer vendor and year differ.
• A school calls customer service to report that its photocopier is broken. The school needs expedited shipment of a replacement.
• A school that is part of the special paint program reports that a sale price on canvas last month was a better price than its paint program price. The school requests a price adjustment.
• A school reports that different shipments of acrylic paints are slightly different in color.
• The sales team decides to have a flash sale on pens for one month only. The person entering the Sales order line should be able to communicate the information to the customer on the Sales order line.
• Schools are reporting that chalk and blackboards are broken upon receipt. A worker in Dublin1 opens some cases of these products in the warehouse and finds that they are also broken. You must implement processes to enforce inventory inspection for a percentage of each purchase order line received. You must block all inventory for a purchase order line if the inspection fails.
You must configure the acrylic paint requirements.
What should you configure? To answer, select the appropriate option in the answer area.
NOTE: Each correct selection is worth one point.
1-1 1-2 2-2 2-1.
Case study -
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study -
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background -
School of Fine Art is a distribution company that sells school supply items to primary and secondary schools. These include items such as pens, pencils, paper, notebooks, chalk, desks, acrylic paints, blackboards, dry erase markers, and whiteboard paint. Due to increased demand for colored pencils, lead times are longer for these pencils. School of Fine Art plans to expand sales into this market.
School of Fine Art plans to implement Dynamics 365 Supply Chain Management to manage the business.
Current environment. Company structure
School of Fine Art consists of two legal entities.
Primary company -
• Located in Dublin, Ireland.
• Has a single named warehouse.
• Is the primary distribution center for both companies.
Second company -
• Is located in Glasgow, Scotland.
• Includes the following warehouses: Glasgow1, Glasgow2.
○ Glasgow1 is used primarily to supply items regionally.
○ Glasgow2 serves as local storage for vendor-owned inventory and bulk storage for School of Fine Art's inventory.
Current environment. General processes
School of Fine Art uses a combination of spreadsheets and paper forms to manage the business.
• All sales, purchases, and inventory are tracked in spreadsheets that are password protected by managers.
• Managers frequently share spreadsheet passwords so that other users can make edits on their behalf. Inventory quantities and values are unreliable.
• The spreadsheets are often incorrectly updated, have entry errors, and broken formulas for calculations.
• Purchase order receipts, picking lists, packing slips, and invoices are all handwritten on pre-printed, three-part forms.
• Late summer is the company's busiest time. During this time, workers are typically on the warehouse floor or making rush deliveries to schools to meet last-minute needs.
Current environment. Inventory and warehousing
• School of Fine Art values inventory by using FIFO costing methods.
• Inventory in the warehouses cannot be distinguished as available inventory or inventory that is sold to a customer and waiting to be picked. This creates inventory inflation during cycle counts and later shortages because warehouse workers count items that are already promised to customers and waiting to be shipped.
• Glasgow2 space is fully allocated to vendors.
• Due to space constraints, school orders for photocopiers are shipped from the vendor to the school.
• Crayons are stored as separate item numbers depending on whether they are in a box or a case. This creates issues when counting inventory to determine the total number of crayons in stock.
• Lack of inventory controls has led to shortages on sales orders, creating backorders and unhappy schools.
• Inventory is ordered quarterly due to the seasonality of the business.
• Items can change annually based on popular sizes, colors, and styles for each new school season. The creation of the different configurations is a manual process, which creates so much overhead that temporary workers are brought in to do the data entry.
Current environment. Purchasing -
• Reordering is manually managed by the buyers looking at the seasonal spikes for the start of the school year, slowing around the end-of-year holidays until the following school year.
• Pens are readily available products that are rarely discounted for sale.
• Photocopiers are only available for sale on the Glasgow region.
• Photocopy paper and construction paper are ordered by the pallet into Dublin1 and must be broken down into smaller sizes. The pallets are typically broken down and then split between what stays in Dublin1 and what is shipped to Glasgow1.
• Chalk and blackboards are slower sellers, so many vendors do not carry these items. School of Fine Art purchases these products from a single vendor. There are no alternative vendors available.
• School of Fine Art agrees to purchase a new line of smartboards from a vendor. The agreed-upon smartboard purchase prices will have a cost price per 55-inch, 75-inch, or 85-inch smartboard.
• The company purchases pencils for the following warehouses:
○ Glasgow1:
• standard pencils from Vendor A
• colored pencils from Vendor B
○ Dublin1:
• standard pencils from Vendor A
• colored pencils from Vendor A
• As whiteboard paint grows in popularity, so does the demand. This causes supply shortages. Whiteboard paint is ordered six months in advance.
Current environment. Customer sales
• The company contractually agrees to prices for some items with schools prior to the start of each school year.
• Schools may order bulk cases of products and choose to distribute further breakdowns, such as a case of crayons, which are then distributed to classrooms by the box.
• Pens do not require contracts with schools because they are low margin and do not have supply chain shortages.
• Painting supplies such as acrylic paint, canvases, and easels do not require a special contract and are sold at regular list price to all schools.
• Schools that offer painting classes are part of a program that provides special pricing on the painting supplies.
• Chalk and blackboards are ordered less frequently than they were in past years. Schools are choosing to use whiteboard paint, which is a lower cost than ordering and installing the whiteboards.
Requirements. Customers and sales
• The system must have the ability to limit product purchase amounts by a single school to prevent stock shortages for other schools.
• Schools are obligated to purchase the agreed amount for specific items per the school year.
• Customer service must be able to easily enter items for sales orders and identify stock shortages.
• Sales of whiteboard paint must be limited so that one school does not buy all the inventory and force backorders for other schools.
• Schools must agree to the amount of whiteboard paint they will purchase for the whole school year.
Requirements. Inventory costing -
• Inventory must have associated costs except for the vendor storage in Glasgow2.
• The vendor storage must still contain quantities but not include cost in inventory valuations.
• At the end of each month, the costing manager must be able to identify how many items will not be fully settled.
• Annual configuration changes to items must be automatically created where possible.
• The company must be able to track costs for colored pencils and standard pencils separately.
Requirements. Inventory -
• Warehouse workers must be able to use their mobile phones and the mobile app to take calls and create transactions in the warehouse.
• The desks must use a single item number and barcode regardless of year manufactured and the vendor.
• Water-based paints from the vendor must be received in pails.
• Acrylic paint must be managed by batches and expiration dates.
• Pencils must be categorized as colored pencils or standard pencils. The individual colors of each colored pencil (such as red, green, and blue) will not be tracked.
• The creation of unique smartboard items must be kept to a minimum.
Issues -
• WarehouseWorker1 works in Glasgow2. The worker receives a request to ship pallets of paper from the warehouse to Glasgow1 and Dublin1. WarehouseWorker1 must create the shipments in the system to transfer the pallets of paper from Glasgow1 to Dublin1.
• The number of backorders for desks has increased. Customer service representatives struggle to select a desk item number that has inventory on hand. The desks are the same item, but the manufacturer vendor and year differ.
• A school calls customer service to report that its photocopier is broken. The school needs expedited shipment of a replacement.
• A school that is part of the special paint program reports that a sale price on canvas last month was a better price than its paint program price. The school requests a price adjustment.
• A school reports that different shipments of acrylic paints are slightly different in color.
• The sales team decides to have a flash sale on pens for one month only. The person entering the Sales order line should be able to communicate the information to the customer on the Sales order line.
• Schools are reporting that chalk and blackboards are broken upon receipt. A worker in Dublin1 opens some cases of these products in the warehouse and finds that they are also broken. You must implement processes to enforce inventory inspection for a percentage of each purchase order line received. You must block all inventory for a purchase order line if the inspection fails.
You need to provide the information for the costing manager.
What should you do first? A. Check cost prices. B. Check for open quantities. C. Close and adjust cancellation. D. View close settlements.
|
