9. Topic 4, Adventure Works Cycles (Case 2)
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 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.
HOTSPOT
You need to configure the solution to replace the Excel spreadsheet.
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.