Scenario: Michael is in early days of business. He is fulfilling orders from his office by...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Scenario: Michael is in early days of business. He is fulfilling orders from his office by his employees. He has 4 products: 2 colours and 2 sizes. Let's assume that customers call in and place orders. Each product is only supplied by one supplier (ie One-to-many relationship - this is simpler, if we wish to set up differently, it is much more complicated). Prior to this, he was using one spreadsheet for tracking inventory (see example in Moodle): - SKU1 - Inventory QTY - Location -SKU2 - Inventory QTY - Location -SKU3 - Inventory QTY - Location - SKU4-Inventory QTY - Location When he placed POs he added stock once it arrived at his office. When customers placed orders, he deducted inventory once he packed the order in the mailer. Now that we have done process redesign using implementation of technology - je we have developed a Microsoft Access Database for managing inventory and managing other pertinent business processes, your job is to document a step by step guide on this new process. Assignment Criteria: Form a cross functional team: you may work in small groups, it is beneficial to assign each person to a different role in Michael's company (ie purchaser, warehouse worker). Role play and use the different perspectives in order to do the below task. Multiple perspectives allow for better process development and no gaps in the process. Develop two (2) processes (ie checklists) for the following procedures when using the Microsoft Access Database: 1. Reordering Inventory and Purchasing Process - using knowledge of the end to end Procurement process and the database system that is created in Microsoft Access in order to track when to place a reorder for a product (ie is inventory on hand below minimum stock level). create a checklist of activities for Michael's company. a. List 1) the activity (ensure the description is clear) as well as 2) who (what role) it's assigned to and 3) list the frequency of the overall process flow (ie who and how often does the minimum stock level query get reviewed?) b. TIP: In your list of activities ensure there is nothing left out, even activities of "x person communicates to x person when this happens". Remember a lot of activities fall outside of using Microsoft Access and require people to execute. For example: i. Develop the PO contract ii. Send the PO contract to the supplier iii. Communicate to the supplier weekly iv. Communicate the ETA with the warehouse staff v. Update the received date in the system..... etc 2. Customer Order and Distribution Process - create a checklist of activities for the end to end process from when a customer places an order, to documenting, packing, shipping that order. a. List 1) the activity (ensure the description is clear) as well as 2) who (what role) it's assigned to and 3) list the frequency as well for relevant activities (ie who and how often does the minimum stock level query get reviewed? Scenario: Michael is in early days of business. He is fulfilling orders from his office by his employees. He has 4 products: 2 colours and 2 sizes. Let's assume that customers call in and place orders. Each product is only supplied by one supplier (ie One-to-many relationship - this is simpler, if we wish to set up differently, it is much more complicated). Prior to this, he was using one spreadsheet for tracking inventory (see example in Moodle): - SKU1 - Inventory QTY - Location -SKU2 - Inventory QTY - Location -SKU3 - Inventory QTY - Location - SKU4-Inventory QTY - Location When he placed POs he added stock once it arrived at his office. When customers placed orders, he deducted inventory once he packed the order in the mailer. Now that we have done process redesign using implementation of technology - je we have developed a Microsoft Access Database for managing inventory and managing other pertinent business processes, your job is to document a step by step guide on this new process. Assignment Criteria: Form a cross functional team: you may work in small groups, it is beneficial to assign each person to a different role in Michael's company (ie purchaser, warehouse worker). Role play and use the different perspectives in order to do the below task. Multiple perspectives allow for better process development and no gaps in the process. Develop two (2) processes (ie checklists) for the following procedures when using the Microsoft Access Database: 1. Reordering Inventory and Purchasing Process - using knowledge of the end to end Procurement process and the database system that is created in Microsoft Access in order to track when to place a reorder for a product (ie is inventory on hand below minimum stock level). create a checklist of activities for Michael's company. a. List 1) the activity (ensure the description is clear) as well as 2) who (what role) it's assigned to and 3) list the frequency of the overall process flow (ie who and how often does the minimum stock level query get reviewed?) b. TIP: In your list of activities ensure there is nothing left out, even activities of "x person communicates to x person when this happens". Remember a lot of activities fall outside of using Microsoft Access and require people to execute. For example: i. Develop the PO contract ii. Send the PO contract to the supplier iii. Communicate to the supplier weekly iv. Communicate the ETA with the warehouse staff v. Update the received date in the system..... etc 2. Customer Order and Distribution Process - create a checklist of activities for the end to end process from when a customer places an order, to documenting, packing, shipping that order. a. List 1) the activity (ensure the description is clear) as well as 2) who (what role) it's assigned to and 3) list the frequency as well for relevant activities (ie who and how often does the minimum stock level query get reviewed?
Expert Answer:
Answer rating: 100% (QA)
Process 1 Reordering Inventory and Purchasing Process 1 Query Inventory Levels Activity Description Check if the inventory level is below the minimum ... View the full answer
Related Book For
International Marketing And Export Management
ISBN: 9781292016924
8th Edition
Authors: Gerald Albaum , Alexander Josiassen , Edwin Duerr
Posted Date:
Students also viewed these general management questions
-
Syzygy Apparel, located in Cyberjaya Malaysia, sells sweatshirts, sweatpants, and T-shirts. They have defined their mission as being a provider of high-quality sweat and T-shirt apparel using 100%...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Why is there currently an even greater need for effective employee communications?
-
What are some of the main challenges the Web poses for knowledge discovery?
-
Mills Company prepared the following balance sheet at the beginning of 2016: Balance Sheet January 1, 2016 At the end of 2016, Mills prepared the following statement of cash flows: Statement of Cash...
-
Discuss the importance of communication in managing a technology change. What roadblocks might an organization face if it fails to create a good communication plan?
-
Kurts Hardware Store advertises and sells snow blowers each season. The following table provides the annual demand, level of advertising, in dollars, and snowfall, in inches, for the past eight...
-
Car A costs $10.37 per 100 miles to drive, while car B costs $6.66 per 100 miles to drive. How much more would car A cost to drive 550 miles? Car A costs $ more to drive 550 miles. (Type an integer...
-
What is the pH ot the oquivalonce point in the btration of a 17.4 mt sample of a 0.455 M oguoous hydrocyanic acid solution with a 0,364 M aqueous barium hydroxide solution? pH =
-
Define the term relevant range.
-
What is meant by the term cost?
-
Why is utilization management so important in a capitated environment?
-
Explain the features and provide examples of fixed and variable costs.
-
How does the time period affect the estimation of fixed and variable costs?
-
Lennard- Jones potential diagrams, also called intermolecular potential energy diagrams, illustrate the relationship between the potential energy of a molecule as the distance between the two nuclei...
-
Create an appropriate display of the navel data collected in Exercise 25 of Section 3.1. Discuss any special properties of this distribution. Exercise 25 The navel ratio is defined to be a persons...
-
Find a company exporting its products under the same brand name in all (or most) markets and a company that uses a variety of brands. How do these companies differ and are these the reasons for...
-
Mrs Kubo is the mother of an autistic child who fortunately was diagnosed when still very young. In order to help him develop word skills when he was still a small baby, Mrs Kubo started cutting out...
-
Export motives may be classified as internal or external, and reactive or proactive. What is meant by these terms with respect to export marketing? Give examples of each of the combinations of export...
-
Enter the following transactions of an antiques shop in the accounts and extract a trial balance as at 31 March 2017. 2017 March 1 Started in business with 8,000 in the bank. 2 Bought goods on time...
-
Record the following details relating to a carpet retailer for the month of November 2017 and extract a trial balance as at 30 November 2017. 2017 Nov 1 Started in business with 15,000 in the bank. 3...
-
Record the following transactions for the month of January of a small finishing retailer, balance-off all the accounts, and then extract a trial balance as at 31 January 2016. 2016 Jan 1 Started in...
Vehicle Mileage Log Book Mileage Record Book For Business 1st Edition - ISBN: B0CMQ5QBB9 - Free Book
Study smarter with the SolutionInn App