Free MB-330 Exam Braindumps
Microsoft Dynamics 365 Supply Chain Management Questions 106–110 (page: 23)

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:
Adventure Works Cycles is a high-end bicycle manufacturer in North America. The company sells 40 standard models as well as 100 limited-edition models per year to boutique retailers domestically.
Adventure Works has had the most success with the limited-edition bicycles. These bicycles have high margins, high demand, and a strong following with the younger generation biking community.
Current environment:

Technology
During a recent global pandemic, the sales of bicycles increased enormously. To support this growth, Adventure Works is going to invest in Dynamics 365 Supply Chain Management to standardize and streamline operations. Operations are currently managed with a custom enterprise resource planning (ERP) system and Microsoft Excel worksheets that address ERP product gaps.
Many processes are still maintained in Excel worksheets and then loaded into the ERP application.
Adventure Works wants to implement only those Dynamics 365 features that are areas of future investment for Microsoft, even if it means they implement fewer features.
Bicycles
Bicycle models can either be standard or made in a limited-edition release.

Bicycles are built based on a single item number that can have different sizes and frame styles. The sizes are XS, S, M, L, and XL. The frame styles are Male, Female, and Unisex.
The size and frame style combinations have different prices and barcodes.

All other bicycle properties are informational only.

Information-only properties do not have standardization or validation, which makes it easy to mistype data during product entry and difficult to identify mistakes.
Some limited-edition bicycles are not properly marked as limited edition in the current product management system due to the yes/no key indicator defaulting to no. This causes significant issues with item searching and reporting on the different bicycle models.
Limited-edition bicycles
The most recent limited-edition models include integrated face mask holders and extra storage containers welded to the bicycle frame.
The bicycles are restricted to one purchase per retailer per week.

The bicycles are announced on social media and are available for sale to retailers on the same day they are announced.
Customers can buy the bicycles at retailers shortly after they are announced.

The bicycles are sometimes available only through charity auctions.

Sales
Due to the global pandemic, it is difficult to keep products in stock. Retailers are buying as much inventory as possible each week.
Retailers email their sales to Adventure Works. The sales team in charge of each retailer manually enters the information into a shared Excel worksheet.
Retailers are required to submit one consolidated sales order by Wednesday every week so that the

Adventure Works fulfillment team can organize and adjust sales order quantities based on availability.
Retailers are invoiced every three to five weeks. Adventure Works uses a manual process for invoicing. The increased volume of purchases makes it difficult to keep up with invoicing.
To accommodate the demand for the Adventure Works limited-edition bicycles, the sales team enters orders for these items for fulfillment as soon as they appear on the SKU list.
Retailers can sometimes bypass Adventure Works order restriction policy.
When this happens, it creates additional work for the fulfillment team.
Outbound
Finished bicycles are assigned a unique code to identify and track each bicycle.

Each bicycle that is picked for an outbound order is transferred to a quality control bench where it undergoes a 21-point mechanical inspection.
Bicycles that pass the mechanical inspection have their unique bicycle identification number recorded in the completed inspection list. The number is also recorded in the shipping manifest for customers to be able to verify that the bicycle that was tested is the one that they received.
If a bicycle does not pass the mechanical inspection, the bicycle is moved to a quarantine location and another bicycle is picked and tested as a replacement for the order.
Inventory
Replenishment is simple but manual. It is currently all handled in Excel.

Every bicycle part for each standard model has a line in an Excel worksheet.

Adventure Works wants each storage space in the warehouse to be filled to capacity with the current products.
The team knows how many bill of materials (BOM) items can fit in the spaces without overflowing.

BOM items that make up the bicycles have different storage capacities.

Adventure Works uses Excel worksheets to make decisions about planned orders by period based on the supply and demand for finished bicycles.
Wheels
There are four types of wheels for all the bicycle models.

Customers often order a spare tire.

Wheels sometimes just disappear from the warehouse storage.

Adventure Works purchases wheels from only one manufacturer.

Master planning
There is no formal master planning process.


Replenishment activities occur weekly.

Requirements
Bicycles
All BOM items used the manufacturing process must be configured as unique products in Dynamics 365

Supply Chain Management.
The following manufactured bicycles' properties must be configured in Dynamics 365 Supply Chain

Management:
· Size: XS. S, M, L, XL
· Frame style: Men, Women, Unisex
· Limited edition: [Blank], No, Yes
· Year: 2010-2020
· Manufacturer's
Note: Free form text up to 250 characters
· Rear suspension travel: 130 millimeters, 150 millimeters
· Full suspension: No, Yes
Sales
Limited-edition bicycles must be systematically restricted to one bicycle per sales order. Overrides must not be allowed.
Retailers must automatically be invoiced once a month in a consolidated invoice for all delivered sales orders.
Limited-edition model bicycles must not be allowed for inclusion on sales orders until the bicycles' official release date.
Outbound
A bicycle's unique identification number must systematically be created as part of the standardized business process.
Bicycles must be pulled from a bin location in a First In, First Out (FIFO) inventory model and moved to a packing station.
Inventory
Overflow of any bicycle parts in the warehouse must be prevented, except for wheels.

System-generated recommendations to adjust Adventure Works' on-hand stock of wheels based on historical trends must be provided.
BOM items must be replenished before they run out. There must always be quantity available on-hand.

The system must maintain all inventory requirements through automated processes.

Master planning (MRP)
The tool that replaces the Excel worksheet must be able to show the supply and demand for the product family of finished bicycles and BOMs by period in a single screen. This single form screen will also be used for general supply and demand inquiry only and not require intensive processing tasks. Inquiries to this form may result in non-system decisions and not with creating any planned orders.
The tool must allow for the creation of new planned production, sales, purchase, and transfer orders.

The MRP solution must have the best performance possible and allow for planned orders to be run in the middle of the day.
Planned orders that will not be firmed must not be changed. Adventure Works wants to be able to reference the planned orders later against any manual orders created until they feel more comfortable with the system.
Once Adventure Works is comfortable with the numbers that the system recommends, Adventure Works wants to implement a mechanism to fully automate the generation of orders.

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:

Trey Research is a multinational manufacturer of health and dietary supplements based in Seattle, Washington. The company is experiencing a rapid expansion not only in its supplements but as a lifestyle brand that also sells apparel. The supplements and apparel businesses operate independently but manufacture and operate in the same legal entity.

Current environment:


Current environment:
. Technology

Trey Research is migrating from an outdated, on-premises version of Dynamics AX to Dynamics 365 Supply Chain Management. The company wants to retain a lot of its current data structures and processes but adopt new efficiencies when the benefit is obvious. The company uses a third-party e-commerce site that is custom developed by an internal developer.

Current environment:
. Items

Product numbering

All items are numbered by using a smart numbering format: [Product SKU+Size+Color+Style]. For reporting, items are queried for sales and inventory reports by using the first six digits of the item number or until the first dash is encountered.

· A t-shirt could be 01001-S-Red for item 1001 in a size small with the color red. · A single energy drink could be 02001-12oz or 02001-20oz for the different sizes that product 02001 is sold in.

Product attributes

· All clothing shares the same set of product attributes.
· Supplements may share the same Product SKU but can have different attributes for the different size, color, or style variations of the product.

· Product attributes that are unnecessary for an item should be excluded from the item.

Pricing

· All items always have a default price. This price will not expire. · An item will have four different prices created for it every month, one for each customer tier, as detailed later in this section. The pricing expires at the end of the month. If no special pricing is created, the default item price will be used.
· The monthly sales price in which the additional price breaks are determined is based on the estimated cost of the manufactured items.
· Customers are categorized into four pricing tiers (A, B, C, and D) based on sales volume over the past 12 months.
· Customers can negotiate special pricing for items in 30-day, 60-day, and 90-day increments. Quantity restrictions may be placed, depending on the item discount and promotion. · Promotional pricing is not used today. Pricing is restricted to monthly prices and customer-specific contract pricing.

Cost

Items use a FIFO costing model today in their current Dynamics AX 2009 environment; however, using the FIFO costing method has created problems.

Current environment:
. Warehouse and inventory

· Warehouse requirements are simplistic. There is only one site. The site has two warehouses. · Trey Research needs to make sure that any energy drinks and nutritional supplements are manufactured and packaged with the highest standards. Trey Research automatically inspects products when all products are reported as finished. All products are inspected again when the items are picked. · Energy drinks require independent tests to check for dents in packaging, carbonation levels, and fill level. · Nutritional supplements require separate tests for packaging, expiration date, product seal, and product labeling.
· Government compliancy and consistency testing are handled outside of the Enterprise Resource Planning (ERP) system.
· Resalable products are placed on one of two racks in the warehouse.

Requirements


Requirements: Technology

· Trey Research will integrate all pricing and discount capabilities to its e-commerce website.


Requirements: Items

· Reporting on products should be streamlined as much as possible. · The item numbering does not have to equate to the actual item number. · The future costing methods adopted must be commonly accepted for manufacturers. · Inventory costing should be done after a full inventory valuation is complete. It should take into consideration the direct materials, direct labor, and overhead that goes into an item. · Any costing method used needs the ability to track cost records about an item, cost categories, and calculation formulas for indirect costs.
· The profitability for nutritional supplements manufacturing processes needs to be expressed in terms of the cost categories for routing operations and the calculation formulas for manufacturing overheads. · If a vendor can no longer deliver the raw materials for the energy drinks due to supply chain issues, the costs for using an alternative vendor to source the raw materials should be used to determine the impact on profits. · Apparel items will not be upgraded to the new costing method until after the go-live date due to resourcing and implementation limitations from the apparel team.


Requirements: Pricing

· Trey Research plans to do promotional pricing. Certain products will receive special pricing during the hours of extreme sporting events that Trey Research sponsors. Before or after the event, normal pricing will resume.


Requirements:
White labeling

· Trey Research wants to start white labeling its products under the brands of major nutritional retail store brands. These products would only be sold to specific customers. · Trey Research will provide and maintain a 'Compare to' price for customers to use to compare the white- labeled products. This Compare to price will also be the default item price for the customer if the customer accidentally lets a contract price expire.
· The configuration of these restrictions must be applied automatically when creating new products for those customers.


Requirements: Warehouse and inventory

· If products in the warehouse must be blocked from transactions for a specific reason, such as a health and safety review, warehouse users should be able to block the products quickly from the ERP system. · All product quality tests should be processed in a uniform and consistent manner. · Creation of any quality processes for products inbound to the warehouse, from the production line, or outbound from the warehouse to consumers should be automatically created to facilitate execution.
· Testing requirements:
Requirement 1: 100 percent of all nutritional supplements and 50 percent of all energy drinks must be tested when production orders are completed. After a product is in testing, 100 percent of all tests must be completed.
Requirement 2: 75 percent of all nutritional supplements and energy drinks should be tested against their required tests during an outbound process.
Damaged products must be placed in one of four bins (based on product type) during the inspection process. You must define quarantine zones to optimize product visibility throughout the testing process.

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:

Trey Research is a multinational manufacturer of health and dietary supplements based in Seattle, Washington. The company is experiencing a rapid expansion not only in its supplements but as a lifestyle brand that also sells apparel. The supplements and apparel businesses operate independently but manufacture and operate in the same legal entity.

Current environment:


Current environment:
. Technology

Trey Research is migrating from an outdated, on-premises version of Dynamics AX to Dynamics 365 Supply Chain Management. The company wants to retain a lot of its current data structures and processes but adopt new efficiencies when the benefit is obvious. The company uses a third-party e-commerce site that is custom developed by an internal developer.

Current environment:
. Items

Product numbering

All items are numbered by using a smart numbering format: [Product SKU+Size+Color+Style]. For reporting, items are queried for sales and inventory reports by using the first six digits of the item number or until the first dash is encountered.

· A t-shirt could be 01001-S-Red for item 1001 in a size small with the color red. · A single energy drink could be 02001-12oz or 02001-20oz for the different sizes that product 02001 is sold in.

Product attributes

· All clothing shares the same set of product attributes.
· Supplements may share the same Product SKU but can have different attributes for the different size, color, or style variations of the product.

· Product attributes that are unnecessary for an item should be excluded from the item.

Pricing

· All items always have a default price. This price will not expire. · An item will have four different prices created for it every month, one for each customer tier, as detailed later in this section. The pricing expires at the end of the month. If no special pricing is created, the default item price will be used.
· The monthly sales price in which the additional price breaks are determined is based on the estimated cost of the manufactured items.
· Customers are categorized into four pricing tiers (A, B, C, and D) based on sales volume over the past 12 months.
· Customers can negotiate special pricing for items in 30-day, 60-day, and 90-day increments. Quantity restrictions may be placed, depending on the item discount and promotion. · Promotional pricing is not used today. Pricing is restricted to monthly prices and customer-specific contract pricing.

Cost

Items use a FIFO costing model today in their current Dynamics AX 2009 environment; however, using the FIFO costing method has created problems.

Current environment:
. Warehouse and inventory

· Warehouse requirements are simplistic. There is only one site. The site has two warehouses. · Trey Research needs to make sure that any energy drinks and nutritional supplements are manufactured and packaged with the highest standards. Trey Research automatically inspects products when all products are reported as finished. All products are inspected again when the items are picked. · Energy drinks require independent tests to check for dents in packaging, carbonation levels, and fill level. · Nutritional supplements require separate tests for packaging, expiration date, product seal, and product labeling.
· Government compliancy and consistency testing are handled outside of the Enterprise Resource Planning (ERP) system.
· Resalable products are placed on one of two racks in the warehouse.

Requirements


Requirements: Technology

· Trey Research will integrate all pricing and discount capabilities to its e-commerce website.


Requirements: Items

· Reporting on products should be streamlined as much as possible. · The item numbering does not have to equate to the actual item number. · The future costing methods adopted must be commonly accepted for manufacturers. · Inventory costing should be done after a full inventory valuation is complete. It should take into consideration the direct materials, direct labor, and overhead that goes into an item. · Any costing method used needs the ability to track cost records about an item, cost categories, and calculation formulas for indirect costs.
· The profitability for nutritional supplements manufacturing processes needs to be expressed in terms of the cost categories for routing operations and the calculation formulas for manufacturing overheads. · If a vendor can no longer deliver the raw materials for the energy drinks due to supply chain issues, the costs for using an alternative vendor to source the raw materials should be used to determine the impact on profits. · Apparel items will not be upgraded to the new costing method until after the go-live date due to resourcing and implementation limitations from the apparel team.


Requirements: Pricing

· Trey Research plans to do promotional pricing. Certain products will receive special pricing during the hours of extreme sporting events that Trey Research sponsors. Before or after the event, normal pricing will resume.


Requirements:
White labeling

· Trey Research wants to start white labeling its products under the brands of major nutritional retail store brands. These products would only be sold to specific customers. · Trey Research will provide and maintain a 'Compare to' price for customers to use to compare the white- labeled products. This Compare to price will also be the default item price for the customer if the customer accidentally lets a contract price expire.
· The configuration of these restrictions must be applied automatically when creating new products for those customers.


Requirements: Warehouse and inventory

· If products in the warehouse must be blocked from transactions for a specific reason, such as a health and safety review, warehouse users should be able to block the products quickly from the ERP system. · All product quality tests should be processed in a uniform and consistent manner. · Creation of any quality processes for products inbound to the warehouse, from the production line, or outbound from the warehouse to consumers should be automatically created to facilitate execution.
· Testing requirements:
Requirement 1: 100 percent of all nutritional supplements and 50 percent of all energy drinks must be tested when production orders are completed. After a product is in testing, 100 percent of all tests must be completed.
Requirement 2: 75 percent of all nutritional supplements and energy drinks should be tested against their required tests during an outbound process.
Damaged products must be placed in one of four bins (based on product type) during the inspection process. You must define quarantine zones to optimize product visibility throughout the testing process.

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:

Trey Research is a multinational manufacturer of health and dietary supplements based in Seattle, Washington. The company is experiencing a rapid expansion not only in its supplements but as a lifestyle brand that also sells apparel. The supplements and apparel businesses operate independently but manufacture and operate in the same legal entity.

Current environment:


Current environment:
. Technology

Trey Research is migrating from an outdated, on-premises version of Dynamics AX to Dynamics 365 Supply Chain Management. The company wants to retain a lot of its current data structures and processes but adopt new efficiencies when the benefit is obvious. The company uses a third-party e-commerce site that is custom developed by an internal developer.

Current environment:
. Items

Product numbering

All items are numbered by using a smart numbering format: [Product SKU+Size+Color+Style]. For reporting, items are queried for sales and inventory reports by using the first six digits of the item number or until the first dash is encountered.

· A t-shirt could be 01001-S-Red for item 1001 in a size small with the color red. · A single energy drink could be 02001-12oz or 02001-20oz for the different sizes that product 02001 is sold in.

Product attributes

· All clothing shares the same set of product attributes.
· Supplements may share the same Product SKU but can have different attributes for the different size, color, or style variations of the product.

· Product attributes that are unnecessary for an item should be excluded from the item.

Pricing

· All items always have a default price. This price will not expire. · An item will have four different prices created for it every month, one for each customer tier, as detailed later in this section. The pricing expires at the end of the month. If no special pricing is created, the default item price will be used.
· The monthly sales price in which the additional price breaks are determined is based on the estimated cost of the manufactured items.
· Customers are categorized into four pricing tiers (A, B, C, and D) based on sales volume over the past 12 months.
· Customers can negotiate special pricing for items in 30-day, 60-day, and 90-day increments. Quantity restrictions may be placed, depending on the item discount and promotion. · Promotional pricing is not used today. Pricing is restricted to monthly prices and customer-specific contract pricing.

Cost

Items use a FIFO costing model today in their current Dynamics AX 2009 environment; however, using the FIFO costing method has created problems.

Current environment:
. Warehouse and inventory

· Warehouse requirements are simplistic. There is only one site. The site has two warehouses. · Trey Research needs to make sure that any energy drinks and nutritional supplements are manufactured and packaged with the highest standards. Trey Research automatically inspects products when all products are reported as finished. All products are inspected again when the items are picked. · Energy drinks require independent tests to check for dents in packaging, carbonation levels, and fill level. · Nutritional supplements require separate tests for packaging, expiration date, product seal, and product labeling.
· Government compliancy and consistency testing are handled outside of the Enterprise Resource Planning (ERP) system.
· Resalable products are placed on one of two racks in the warehouse.

Requirements


Requirements: Technology

· Trey Research will integrate all pricing and discount capabilities to its e-commerce website.


Requirements: Items

· Reporting on products should be streamlined as much as possible. · The item numbering does not have to equate to the actual item number. · The future costing methods adopted must be commonly accepted for manufacturers. · Inventory costing should be done after a full inventory valuation is complete. It should take into consideration the direct materials, direct labor, and overhead that goes into an item. · Any costing method used needs the ability to track cost records about an item, cost categories, and calculation formulas for indirect costs.
· The profitability for nutritional supplements manufacturing processes needs to be expressed in terms of the cost categories for routing operations and the calculation formulas for manufacturing overheads. · If a vendor can no longer deliver the raw materials for the energy drinks due to supply chain issues, the costs for using an alternative vendor to source the raw materials should be used to determine the impact on profits. · Apparel items will not be upgraded to the new costing method until after the go-live date due to resourcing and implementation limitations from the apparel team.


Requirements: Pricing

· Trey Research plans to do promotional pricing. Certain products will receive special pricing during the hours of extreme sporting events that Trey Research sponsors. Before or after the event, normal pricing will resume.


Requirements:
White labeling

· Trey Research wants to start white labeling its products under the brands of major nutritional retail store brands. These products would only be sold to specific customers. · Trey Research will provide and maintain a 'Compare to' price for customers to use to compare the white- labeled products. This Compare to price will also be the default item price for the customer if the customer accidentally lets a contract price expire.
· The configuration of these restrictions must be applied automatically when creating new products for those customers.


Requirements: Warehouse and inventory

· If products in the warehouse must be blocked from transactions for a specific reason, such as a health and safety review, warehouse users should be able to block the products quickly from the ERP system. · All product quality tests should be processed in a uniform and consistent manner. · Creation of any quality processes for products inbound to the warehouse, from the production line, or outbound from the warehouse to consumers should be automatically created to facilitate execution.
· Testing requirements:
Requirement 1: 100 percent of all nutritional supplements and 50 percent of all energy drinks must be tested when production orders are completed. After a product is in testing, 100 percent of all tests must be completed.
Requirement 2: 75 percent of all nutritional supplements and energy drinks should be tested against their required tests during an outbound process.
Damaged products must be placed in one of four bins (based on product type) during the inspection process. You must define quarantine zones to optimize product visibility throughout the testing process.

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.