Executive Summary



PRODUCTION & OPERATIONS MANAGEMENT AUDITTARGET- ORGANIZATION: Memory Express Group 3 Kwan Tung Chiao (Tony)100197243tony.chiao@John Chu (John)100164850john.chu3@Jervis Huynh (Jervis)100209821jervis.huynh@Raymond Lam (Raymond)100213638raymond.lam@Yuko Miyazaki (Yuko)100250489yuko.miyazaki@Kent Yung (Kent)100179151kent.yung@ ENTR 3130 – R10 SUMMER 2011PRODUCTION & OPERATIONS MANAGEMENTInstructor: Vasile ZamfirescuStatement #2We the undersigned declare that the work performed for this project and the contents of this report represent only original work of or by the members of the team, any material from other sources has been clearly referenced and credited in the report, and the report is not acquired from third parties nor recycled from another project in another course, whether at Kwantlen or elsewhere. More generally, we declare that the work performed for this project and the contents of this report comply fully with our signed Statements of Academic Integrity and with the provisions of Kwantlen policy C.8. Kwan Tung (Tony) ChiaoJohn ChuJervis HuynhRaymond LamYuko MiyazakiKent YungExecutive SummaryThe following is a presentation of the POM audit of Memory Express Inc. The focal point of this report surrounds the nine issues regarding Memory Express’s promotions and operations management techniques. In order to help reduce the overall cost, improve the quality of products and services at Memory Express, we chose to look into operational aspects such as: ProductivityProject ManagementProcess DesignForecastingLayout DesignSupply Chain ManagementQuality ManagementInventory ManagementProduct DesignBy carefully analyzing the aspect of the company’s operations, we identified the benefits and downfalls of their current system. As such, we are able to identify areas where ME performs well, and areas that need improvement. After considering the circumstances that surround each operational aspect, we researched and recommended some operational systems that will improve the overall performance of Memory Express.We analyzed Productivity by calculating sales per square feet, sales per labour dollars, and sales per labour hour. By analyzing this, we found and recommend that the company focus on these main product groups that account for most of the sales.Our team examined a recent small scale gaming tournament hosted by the company and its weak points and shortcomings. We strongly recommend the utilization of project management tools to such as MS Project 2011 and Mindmap 4.0 to identify critical points to save on cost, time, and labour.In the area of process design, we mapped out a specific service process and identified a step that could result in loss of sales. By changing certain steps in the process, the company can lessen the amount of loss sales and improve customer satisfaction.After our primary research, we found that the company relies on qualitative techniques. We suggest that in addition to the current forecasting technique that the company utilizes quantitative techniques such as exponential smoothing to allow a more accurate forecast.We looked at existing layout design at the Richmond location and have analyzed its utilization based on its floor space and volume of the warehouse. Our team recommends the company utilizes the excess floor space to increase the sales per square feet plotting. For utilization in warehouse volume, we encourage the company to build a second level for more floor space.In our primary research, our team has focused on Sony’s laptops. We analyzed the current supply-chain management as well as reverse logistics. In order to increase profit margin, our team suggests ME to reduce costs such as transportation, storage and labour. We also suggest the company to stimulate its e-commerce sales as it does not involve labour costs.We looked into how the company ensures the products and services reach the company’s standards, and found that the company does an exceptional job focusing on quality by providing continuous employee development.For inventory management, we looked at how ME counts inventory, accounts for shrinkage and how their inventory is stored. For inventory counting, ME uses a min/max inventory replenish system that has a target level of inventory of four weeks and a low (reorder point) of two weeks of inventory. We found this method of inventory counting to be effective for ME because it will always have inventory in stock with this method and therefore prevents any loss of sales. As for shrinkage, the most obsolete items are promoted and put on sale most frequently to avoid obsolescence.In product design, we looked at Memory Express’ in-house brand Velocity. We conducted a survey of about 40 people, and based on the survey’s result, we recommend ME to apply a house of quality method towards their Velocity products. It uses a planning matrix to relate what customers want and how a firm can meet those expectations.Our team believes that the audit conducted revealed areas of operations management where Memory Expressed excelled at, as well as areas that may benefit from a review. With the implementation of project management tools, the recommendations outlined in this report will effectively improve the operational efficiency of the company as well as reduce its operating costs. Table of Contents TOC \o "1-3" \h \z \u Executive Summary PAGEREF _Toc300084901 \h 2Target-Organization: Memory Express (ME) PAGEREF _Toc300084902 \h 7Company Description PAGEREF _Toc300084903 \h 7Contact PAGEREF _Toc300084904 \h 8Business Functions PAGEREF _Toc300084905 \h 8Business Strategy PAGEREF _Toc300084906 \h 8Organizational Structure PAGEREF _Toc300084907 \h 9Product Design PAGEREF _Toc300084908 \h 9Product Strategy PAGEREF _Toc300084909 \h 10Product Development Cycle to Date PAGEREF _Toc300084910 \h 10New Product Idea PAGEREF _Toc300084911 \h 10Screening PAGEREF _Toc300084912 \h 10Revisions PAGEREF _Toc300084913 \h 11Sourcing and Production PAGEREF _Toc300084914 \h 11Critique & Recommendations PAGEREF _Toc300084915 \h 11Forecasting PAGEREF _Toc300084916 \h 12Is it used? What is done? PAGEREF _Toc300084917 \h 12Industry or Firm Specific Issues PAGEREF _Toc300084918 \h 12Critique & Recommendations PAGEREF _Toc300084919 \h 12Productivity PAGEREF _Toc300084920 \h 13Is it defined? PAGEREF _Toc300084921 \h 13Is it measured? PAGEREF _Toc300084922 \h 13Industry or Firm-specific Issues PAGEREF _Toc300084923 \h 13Critique & Recommendations PAGEREF _Toc300084924 \h 14Project Management PAGEREF _Toc300084925 \h 14Introduction PAGEREF _Toc300084926 \h 14Cost Plan PAGEREF _Toc300084927 \h 15Risk Management Plan PAGEREF _Toc300084928 \h 15Staffing Plan PAGEREF _Toc300084929 \h 15Communications Plan PAGEREF _Toc300084930 \h 15Critique & Recommendations PAGEREF _Toc300084931 \h 16Process Design PAGEREF _Toc300084932 \h 16Issues PAGEREF _Toc300084933 \h 17Critique & Recommendations PAGEREF _Toc300084934 \h 17Layout Design PAGEREF _Toc300084935 \h 18Existing Situation PAGEREF _Toc300084936 \h 18Competitor PAGEREF _Toc300084937 \h 18Analysis PAGEREF _Toc300084938 \h 19Constraints PAGEREF _Toc300084939 \h 19Opportunities PAGEREF _Toc300084940 \h 19Critique & Recommendations PAGEREF _Toc300084941 \h 19Supply-Chain Management PAGEREF _Toc300084942 \h 20Introduction PAGEREF _Toc300084943 \h 20Current Supply-chain Process PAGEREF _Toc300084944 \h 20Reverse Logistics PAGEREF _Toc300084945 \h 21Make or Buy Decision PAGEREF _Toc300084946 \h 22Industry or Firm-specific Issues PAGEREF _Toc300084947 \h 22Critique & Recommendations PAGEREF _Toc300084948 \h 22Transportation PAGEREF _Toc300084949 \h 23Storage PAGEREF _Toc300084950 \h 23Labour PAGEREF _Toc300084951 \h 23E-commerce Sales PAGEREF _Toc300084952 \h 23Quality Management PAGEREF _Toc300084953 \h 23Quality Culture PAGEREF _Toc300084954 \h 24Quality Standards PAGEREF _Toc300084955 \h 24Critique & Recommendations PAGEREF _Toc300084956 \h 25Inventory Management PAGEREF _Toc300084957 \h 25Competitor Analysis PAGEREF _Toc300084958 \h 25Analysis PAGEREF _Toc300084959 \h 26Reorder Point PAGEREF _Toc300084960 \h 27Critique & Recommendations PAGEREF _Toc300084961 \h 27Action Plan PAGEREF _Toc300084962 \h 28Works Cited PAGEREF _Toc300084963 \h 29Exhibits PAGEREF _Toc300084964 \h 30Exhibit A: Organization Chart for Richmond Store PAGEREF _Toc300084965 \h 30Exhibit B: House of Quality For Hard Drive Enclosure PAGEREF _Toc300084966 \h 31Exhibit C: House of Quality Survey Data PAGEREF _Toc300084967 \h 32Exhibit D: Raw Data from Memory Express PAGEREF _Toc300084968 \h 32Exhibit E: Forecasting Summary PAGEREF _Toc300084969 \h 33Exhibit F – Raw Data for Productivity PAGEREF _Toc300084970 \h 38Exhibit G – Service Productivity PAGEREF _Toc300084971 \h 39Exhibit H: Work Breakdown Schedule PAGEREF _Toc300084972 \h 40Exhibit I: Store Layout Plan PAGEREF _Toc300084973 \h 41Exhibit J: Supply-chain Management of Sony Laptops PAGEREF _Toc300084974 \h 42Exhibit K: Reverse Logistics of Returned Products PAGEREF _Toc300084975 \h 43Exhibit L: Summary of Meetings PAGEREF _Toc300084976 \h 44First Meeting PAGEREF _Toc300084977 \h 44Second Meeting PAGEREF _Toc300084978 \h 44Third Meeting PAGEREF _Toc300084979 \h 45Exhibit M: ABC Classification - Inventory Shrinkage PAGEREF _Toc300084980 \h 46Exhibit N: Shrinkage Pareto PAGEREF _Toc300084981 \h 47Exhibit O: MS Project Gantt Chart PAGEREF _Toc300084982 \h 48Exhibit P: MS Project Schedule PAGEREF _Toc300084983 \h 49Target-Organization: Memory Express (ME)Memory ExpressRichmond BC4975 NO. 3 RDRichmond, BC V6X 2C3Ph.:(604) 304-0200Fax: (604) 304-0302Website: DescriptionMemory express (ME) was founded in 1996 by Mr. Minh Ngo. It has established a leadership position as the premier destination for computer products and services. Starting from a humble beginning, they have grown into a multi-million dollar company with seven retail locations spread across Canada.Memory Express offers a variety of computer products and services, as well as other electronic devices. The company also offers a consulting service to provide suggestions and solutions for customers.ME carries a full line of computers (desktop and laptop), monitors, parts and accessories for people who want to buy new or upgrade an older system. In addition, customers can purchase home electronics, portable electronic devices, software, games and toys.The company’s website includes an extensive online catalog, so customers can shop from home. A person who plans to build a new computer from the ground up can use the online System Configurator to create and save a list of component parts, and the price of each; the online Rebate Center helps customers download the correct documents to request their rebate.ME makes great effort to provide the best service to every customer on their every visit. The company’s goal is to deliver the right product in a timely manner every time they complete a transaction. ME’s goal and mission is to provide the best customer service possible to build a lasting relationship with their customers. “If a customer doesn’t return after purchasing from us, we don’t deserve their business”- Minh Ngo, 2011.The company’s total annual revenue is over $100 million and there atleast 219 employees in the company. In the Richmond location, there are 29 employees and the annual sales were approximately $6 - 7 million.NAICS Code: 443120 (Computer and Software Stores)ContactMinh NgoDamian CheytanovCEO and OwnerStore ManagerMinh.ngo@Damian.cheytanov@Business FunctionsMemory Express’ main business functions include retail and online sales of consumer electronics including computers, photo imaging, and home electronics.The intended targets of this production and operations management audit of ME are:Project ManagementQuality ManagementProduct DesignProcess designDemand ForecastingProductivity Inventory ManagementSupply Chain ManagementLayout DesignBusiness StrategyMemory Express' strategy is to have the lowest prices between all its competitors at all times. This strategy allowed them to be the market leader in other areas such as Calgary and Edmonton. While only a fresh company here in BC, their long-term goal is to become the market leader in BC topping Future Shop and Best Buy. With the price match policy at ME, customers are encouraged to purchase the product from ME at the competitor's price plus 25% off of the difference between ME and the competitor's price. Even if the company were to sell products at a loss, in the short term this strategy allows ME to move inventory, which also stops their competitor from moving their own inventory.While ME is set to lose money on the price matched sales, they are able to gain a significant market share, and gain more bargaining power with its suppliers. The price match strategy allows ME to benefit from competitor’s sales promotion, which allows the company to save in advertising costs. By showing its ability to move inventory, this allows ME to negotiate with suppliers for better prices than their competitors. With the inventory being provided at a lower cost, ME is placed in a position where it can provide better prices than its competitors and still earn a good margin on each sale. By accomplishing this, ME plans to successfully gain market share, and then control the market.The purpose of this whole strategy is to slowly capture the market in a specific area, gain bargaining power, control the market and kill off their anizational StructureThe company is headed by Minh Ngo and his brother Chieu Ngo (Exhibit L: Summary of Meetings). Between the two of them, they manage the Purchasing, IT, Development, HR and Accounting department. The purchasing department consists of seven purchasers each in-charge of specific group of items. The IT department is made up of one IT developer, and one web developer and designer. While this department is in-charge of improving the website, it is the purchaser’s responsibility to update the product list on the website. The development department is in responsible for scouting new locations and the development of new store locations. The last department consists of one person handling the responsibilities of both HR and Accounts Receivable. On a store level, the organizational structure consists of the store manager and the staff. All the sales representatives are full-time employees are cross-trained to be able handle various responsibilities. The sales representatives are not assigned to specific departments, but rather they are encouraged to sell any product they wish to sell. The sales representatives are also considered as customer service representatives, technicians and RMAs. Exhibit A illustrates the organization structure of the Richmond store.Product DesignThe primary objective of Memory Express is to deliver quality products and exceptional customer service during, and after the initial sale. The company’s founder, Minh Ngo stated that ME will do whatever possible to ensure a customer is satisfied, even if it means selling an item below cost.It is the company’s goal to deliver the right product in a timely manner each time they complete a transaction. Memory Express’ goal and mission is to provide the best customer service possible to build a lasting relationship with their customers. Ve- Minh Ngo, 2011.Product StrategyMemory Express’ product strategy is unconventional in the industry. The product strategy is to list products at a higher price than the competitor and encourage customers to price-match with competitors. Memory Express will match the competition’s price and offer another 25% off the difference of the prices. This strategy gives the consumers a sense of satisfaction that they were able to find the best deal on the market.Product Development Cycle to DateWith Memory Expresses’ product design process, we will be examining the design of a LCD TV wall mount from idea realization to final retail.New Product IdeaThe creation of a new “Velocity” product (ME’s in-house brand) is initiated when management discovers an opportunity to introduce competitively priced accessories such as external hard drive enclosures, desktop computer cases, and TV mounting units. When the market for a 3rd party, affordable yet high quality TV mounting unit was discovered, management gave the task of designing 3d mock-ups of the product to a team of designers based in China. This team is provided with a list of specifications such as style, weight, capacity and materials. In some cases, products are simply designed with the help of an already existing blueprint a manufacture already owns. Options can be added or subtracted to a “base” product much like a car and can be customized at a price, dramatically reducing the costs of designing a product from scratch.ScreeningWhen a product has to be designed from the ground up, such as the Velocity TV unit, designers send multiple 3-D rendered designs (Auto-Cad) to the CEO for approval. The concepts that do not fit the criteria are sent back for rework. Memory Express does not have a dedicated screening team due to the relatively low number of self-designed products. Minh explained that it would not be cost effective to employ a dedicated team for these tasks. Instead, they use a panel of experts during screening. Experienced sales people in relevant departments, managers, the designer, and the CEO get together and discuss designs and specs until one is approved.RevisionsMany revisions may take place before final specifications and designs are finalized. When a design is approved, it moves on to the next stage of finding a manufacturer that can produce the product to specifications.Sourcing and ProductionProduction and manufacturing are usually outsourced to a factory in China. There are a variety of manufactures capable of producing these types of products. However, their pricing fluctuates depending on the complexity of the product, and the materials and labor involved. Minh often chooses the manufacturer with a portfolio containing a similar product. Minh also requires that the company shows a good track record for delivering products on time, on budget and according to specs. Prices are often negotiable depending on size of the batch order. Minh usually purchases one container full of these products to save on shipping. Inventory is stored at the warehouses connected to retail locations.Critique & RecommendationsBased on our review of their product design process, our team recommends that ME applies the house of quality method in designing the specifications of their Velocity products.The House of Quality is a diagram, resembling a house, used for defining the relation between customer desires in the product and the firm’s production capabilities. It uses a planning matrix to relate what customers want and how a firm can meet those expectations and needs. Exhibit B shows an example of a House of Quality for the Velocity Hard drive enclosures. A survey was conducted on Survey Monkey to discover customer wants and needs when in the market for a hard drive enclosure, of the 40 respondents, six customer wants were identified and categorized by according to their importance. Of the sample of 40 people, the top six characteristics are the following:Plug-n-PlayShock ResistanceHard Drive CoolingSleek DesignUSB 3.0Low NoiseThe vertical section of the House of Quality displays the firm’s technical capabilities. Memory Express outsources its manufacturing and has the ability to make technical changes to designs and specifications without large capital investment as manufacturing is not conducted in house.Three of the competitors’ products were also chosen as a comparison to the Velocity product. Each product was examined to determine how well they matched up to the customer’s wants. The results indicate that the Velocity product lags behind the competition in terms of USB 3.0 capacities and low operating noise, both are characteristics that customers cited they considered very important to them when making a purchase. It is recommended that ME re-evaluates its future hard drive enclosure products and emphasize on low noise and USB 3.0 capabilities as it is currently lacking when compared to Western Digital and HP products. The link to the survey can be found at the following address: . Please see Exhibit C for survey results.ForecastingIs it used? What is done?Currently, Memory Express (ME) uses qualitative forecasting methods to forecast monthly demands. “Jury of Executive opinion” is used for qualitative forecasting, however, ME does not utilize any quantitative forecasting. Due to the fact the Richmond location was just recently opened in October, they do not have sufficient data to predict an annual forecast. Although ME has been established since 1996, this is the first store located in British Columbia. With all factors considered, ME currently has to rely on its experience in other areas to forecast demands in BC.Industry or Firm Specific IssuesMemory Express needs to implement additional forecasting methods to reduce its costs. There is also a need to utilize forecasting techniques in areas such as inventory, purchasing and personnel hiring. Furthermore, it can extend its short-term forecasting to medium and/or long-term range forecasting.Critique & RecommendationsMemory Express should utilize quantitative analysis in addition to the technique that they are currently using. It helps with monthly, quarterly, or yearly forecasting of sales, and also cash flow for the company. According to the data from ME (Exhibit D: Raw Data from Memory Express), we chose and conducted a forecast of demands for ME’s five major product lines for the next five months. Laptops, Hard drives, Cameras, Monitors and Televisions are the five top selling product lines. The company will be able to predict the sales forecast more accurately if it implements quantitative approaches, such as line-trend models and exponential smoothing models.Three different levels of smoothing constants were analyzed in order to determine the best one for the forecast, such as ɑ = 0.1, ɑ = 0.2, and 0.5. Based on the MAPE, the better smoothing constants for the four product lines (Laptops, Hard drives, Cameras and Monitors) are ɑ = 0.0 (derived through optimized option in Excel), and ɑ =0.5 for Televisions. (Exhibit E: Forecasting Summary)As the store just opened last year, Memory Express still needs to use “Jury of Executive opinion” method in addition to the quantitative methods stated above as this will improve the accuracy of the said forecasts.ProductivityIs it defined?Since Memory Express is a retail store, the company defines its productivity through service. Although ME sells its own brand products (Velocity), its components are outsourced to China. These components are then transferred to the store for final assembly. It takes three business days to assemble a computer from ordering to completion by one employee. Since these products are being outsourced, it is difficult to measure the production productivity for ME.Is it measured? ME’s goal is to gain customer satisfaction. According to ME, it uses the numbers of customer helped to measure its productivity in service. Variables such as the average time of waiting for service, average time for checkout, average time for completion of transaction are measures that ME tries to improve on. Industry or Firm-specific IssuesAs the Richmond store is relatively new, ME has been trying to attract as many customers as possible. ME wants to build a positive relationship with the customers and gain a positive reputation. This results in increasing future sales opportunities for returning customers. However, there are other ways to measure its productivity in service effectively. For measuring service productivity effectively, there are three key variables:Sales amount or the numbers of units sold over labour hoursSales amount or the numbers of units sold over labour dollar amountsSales amount or the numbers of units sold over square feet for each product lineCritique & RecommendationsBased on the data provided by ME (Exhibit F – Raw Data for Productivity), we conducted different approaches to measure the productivity in service for the company. We recommended that ME should also measure the service productivity in terms of key variables, such as labour cost, labour hours, and square feet of each product line. (Exhibit G – Service Productivity)The most profitable product line is laptops in terms of labour hour and labour cost. The camera department is the next most productive product line. In terms of sales per square feet for each product line, hard drives are the most productive. Therefore, ME should examine why different product lines are more productive than others. In addition to increasing sales revenue, ME should also look at other product lines such as computer monitors and televisions because of the lower productivity. To help increase the productivity of these product lines, ME could offer promotions such as packaging a free media player or extended warranty along with the purchases.Project ManagementIntroductionThe project we have chosen to audit is a tournament style competitive gaming event hosted by Memory Express. This event took place in store on Saturday, July 2nd, 2011 between the times of 12pm to 9pm. Participants were required to register online or in person prior to the event for a fee of ten dollars. The maximum capacity for the tournament was set at 100 participants, but only 60 registrants applied. The main objectives of this project were to designate an area of the store for eight computers, acquire sponsorships, find employees to set up the computer software and equipment, and promote the event.The project was assigned to one project manager, Mr. Damian Cheytanov, who was responsible for the completion of the project and emceeing the event. The event’s scope is determined by listing what resources, procedures, time, and money ME needs to reach the final result. Based on the information provided to us, we have divided their project in to the following plans (Exhibit H: Work Breakdown Schedule). This Work Breakdown Schedule was created in MindMap 4.0 to show the major tasks and sub-tasks associated with planning this LAN tournament. (Exhibit O: LAN Tournament Gantt Chart)Cost PlanMajority of the budget needed to run this tournament was be funded by sponsorships. There were three major sponsors (Gigabyte, Intel, and Nvidia) acquired by Memory Express who provided all the required computer equipment and software, as well as the prizes given to the participants. Risk Management PlanDelivery of computer equipment from sponsors will be most critical. To ensure this risk is minimized, computer equipment will be delivered only five days prior to the event and stored in the store’s warehouse. Computers, along with the tournament software, will be installed and tested two days prior to the event. After each round during the tournament, a continual process of supervision will be conducted by the company’s IT specialist.Staffing PlanThe tasks needed to complete this project required three additional employees. Prior to the event, one employee was responsible for all the media channels for advertising. She was assigned to market the event through YouTube, Facebook, Twitter, and online forums.The second employee was responsible for setting up all the required computer equipment on the day of the event. He was also responsible for ensuring all the computer equipment was functioning properly after each round. The remaining employee and the project manager were responsible for accommodating the sponsorship partners and the registered munications PlanBased on our observation, the project manager, Damian Cheytanov was responsible for informing the employees whom were involved prior and during the event of any changes.During our team’s observation of the event we have noted several issues regarding unforeseen activities which happened during the tournament. The event exceeded the allotted time because of the project group did not take into consideration the setup times in between each round. The team also made a mistake in underestimating the time needed to complete each group. There was a significant amount of idle time experienced by inactive participates in between rounds. Participants were also required to stand because there was no seating available. During the course of the tournament, there was one significant complication where the server connection repeatedly disconnected. This problem repeatedly affected the game play and delayed the turnaround time between each round. The server was restarted each time which resulted in several minutes of idle time. There was no contingency plan on handling this issue therefore no additional servers were available to back up the system.Critique & RecommendationsBased on our team’s audit, the ME gaming tournament project was managed using informal project planning tools. The project was developed and executed based on the experience of the management team on similar events hosted in the past. We believe that using a formal proposal as a guideline and other impromptu techniques may not necessarily be the most effective method to handle this project. Although this event was on a smaller scale (60 participants, eight computers, four sponsors, three additional staff), our team believes that Memory Express’ ad hoc approach may not be ideal. By using project management software such as Microsoft Project 2011 (Exhibit G: MS Project 2011- ME’s Tournament Project) ME can effectively prepare with the complexity of larger future projects. Because, currently Memory Express does not employ any software programs such as MS Project and MindMap 4.0 to facilitate the planning process. It is recommended that Memory Express utilize MS Project and MindMap 4.0 to break down the major tasks and sub-tasks that need to be completed.MS Project can generate Gantt Charts which can show:Display project activities and their sequential relationshipEstimate of how long the project will takeIndication of which activities are most critical to timely project completionIndication of how long any activity can be delayed without delaying the projectIn summation, the use of these programs can greatly reduce the costs and downtime of projects. An example of these programs can be found in Exhibit H. Exhibit H shows a WBS and MS Project file for the LAN Party tournament.Process DesignThe value added process our team focused on is the process of a customer ordering a Velocity computer online to the delivery of the final computer system. The process describes the transformation of individual parts into a final computer system for the customer. Individual parts include CPUs, memory, hard drives, cases, optical drives, motherboards, power supplies, sound cards, video cards and cooling fans. When the customer places an order online, the online sales department receives the order and checks the computer system for stock levels. If the computer system is in stock, the customer’s order status is updated to “Ready to ship” or “Ready to pick up” depending on the customer’s delivery preference. However, when the computer is out of stock, ME creates a bill of materials and identifies which components are missing and which are on hand. The out-of-stock parts are ordered from their respective manufactures and have a lead time of approximately three days. The parts that are in stock are sent to the in-house assembly department and installed onto the motherboard. The Velocity case is also wired and prepared for final installation. When the ordered parts arrive, they are sent to the assembly department to be installed onto the motherboard. The computer is then put through a “Burn-in test” which lasts for a duration of six hours. During this phase, the computer is tested for operation temperatures, memory read and write tests, and video card performance.If the computer operates with zero failure or error during this test, the computer is packaged and depending on the customer’s preference, is either shipped by ground or picked up in store.However, if the computer shows one or more failures, the computer is analyzed in the assembly department to determine point of failure. The defective parts are replaced and retested. The computer is again reassembled and a Burn-in test is once again conducted. If the computer passes the Burn-in test, the computer is packaged and marked ready to ship. The defective parts are sent back to the manufacturers for RMA. ME will call the customer one week after their computer has been received to ensure the product is functioning correctly and ensure that the customer is satisfied with the product.IssuesThe major issue in this process occurs when a component is found not in stock and not ready to ship. Due to the competition of e-commerce, the customer may choose to purchase the system elsewhere if the computer is needed urgently. Another issue our team has identified is the transit time of parts when they are unavailable. The required time to order and receive the parts in the current process is approximately three days, which customers may feel is too long especially if they require the PC immediately.Critique & RecommendationsIn order to reduce the transit time and avoid stock outs, ME should change the way it manages and orders inventory to properly respond to the demand for Memory Express’ custom build PCs. To prevent stock outs, ME should increase the minimum carrying quantity for each component so that components are in stock at all times. However, ME should be careful with setting this amount as computer components quickly become outdated in a short period of time.Layout DesignExisting SituationMemory Express has one store in British Columbia located in Central Richmond. The store is approximately 23,500 square feet in size and opened in October 2010. Upon observation, the facility is designed to cater to a high capacity of customers and have several departments such as laptops, desktop computers, televisions and showrooms, computer peripherals and software. Store layout is shown in Exhibit I: Store Layout Plan.Customers have certain expectations on store layout when they enter a store; these expectations are listed below.Simple store layoutGreetings and quick response timeProper illuminationClean and tidyProperly labeled inventory on display shelving unitsAdequate spacing between aislesDifferent categories/departmentsCameras and accessoriesTelevision and showroomsLaptops and accessoriesDesktop computers and monitorsComputer peripherals and softwareCompetitorNCIX is one of the main competitors to Memory Express. It is an established company in BC and has six stores across the lower mainland. NCIX’s stores are significantly smaller and have different layouts.They carry a large variety of products but only display a small amount in-store. Online sales comprise approximately 70% of their total sales, and 30% come from in-store sales. NCIX’s reliance on store layout is not as important as Memory Express because its quantity of online transactions is much larger than in-store transactions.AnalysisBecause one of ME goals is giving customers an exceptional first impression on store layout, the facility has plenty of space between aisles and has few display shelving units. The management team has made a managerial decision on choosing an impressive layout over optimizing revenue per square foot.ConstraintsMemory Express wants to differentiate from its competitor, NCIX, and it has chosen to differentiate itself by having a different store layout in order to impress its customers. By achieving this, ME has chosen to increase spacing between displayed products and increase spacing between aisles.Since Memory Express carries a large variety of product lines, they are unable to display every single product on their shelves. This is due to limited space on existing shelves and the large amount of inventory.In addition, computing hardware technology changes rapidly, and products may become obsolete after certain time. Carrying variety of products has created a burden for ME.OpportunitiesAs Memory Express rents a large facility, there is room to place additional shelving units in their store if they decide to display other merchandise. Existing layout has plenty of space between aisles and this can be utilized.The ME management team has an accurate professional judgment in predicting trend of products. Also, they have the power to decide which product(s) to display in-store from time to time.Critique & RecommendationsIn order to maximize space in store, ME should consider reducing the amount of space in between displayed units. The store manager can also reduce space in each aisle and utilize this additional space by adding extra shelving units.The company should consider expanding their online sale services so that they do not need to rely heavily on the store’s layout. The owner should also consider building an additional floor inside the facility which could provide more space for the purpose of displaying products.In regards of inventory, the management team may give up the least profitable products and display products with the highest earn-turns. In addition, the company may also take off the obsolete items from display shelving units and leave the newest units on the shelves.Supply-Chain ManagementIntroductionAs mentioned in “Company Description”, Memory Express offers a wide range of computer products to consumers, and the company currently purchases these products from different manufacturers. Without an efficient and reliable system for getting inventories from manufacturers (suppliers), ME will not be able to compete with its competitors.According to our research, we have identified a few competitors within a radius of one kilometer of the company’s Richmond retail location – NCIX, Future Shop, Best Buy, and some small retail stores. Because of the amount of competitors in Central Richmond, any consumer who cannot find their intended product to purchase from ME can easily purchase it from any other competitors. A well developed supply-chain system is a big issue, thus, supply-chain management is essential, applicable, and important to the company.Current Supply-chain ProcessIn our audit, we have picked laptops manufactured by Sony as an example. Sony is one of the suppliers of Memory Express, and the supply-chain management of its product between Sony and ME is shown in Exhibit J: Supply-chain Management of Sony Laptops.Sony has factories all over Asia for the purposes of manufacturing parts and assembling parts into finished goods. It has a good reputation on reliability of delivery and has the ability to maintain the level of inventory manufactured due to its large manufacturing plants located in Asia. Other ME suppliers, such as Acer and Toshiba, are also proven in delivery of products and amount of inventory supplied due to the fact that they are large corporations and have established humongous factories all over the world.Most suppliers manufacture their product parts in Asia, transport parts to China, assemble final products in China, and ship them to their worldwide warehouses. As ME locates in British Columbia, Alberta and Manitoba, Canada, it gets products from manufacturer’s North America warehouses.As we have investigated, ME’s current supply-chain process takes around 1-week from the time of placing an order to receiving final products from manufacturers, and this excludes the time of manufacturing. The cost per unit under the current process is approximately $600. It could be broken down to unit cost of $595 (including delivering, manufacturing, and shipping and handling) and holding cost of $5. This number is derived from ME’s average inventory cost.For products under ME’s brand Velocity, it would take approximately one month for the entire supply-chain process. This includes manufacturing the products and filling the container. These products include ME customized TV stand, hard drive case and computer case.Reverse LogisticsIf a customer returns a product, the process of reverse logistics begins. This covers all products that are covered by warranty. The reverse logistics process is shown in Exhibit K: Reverse Logistics of Returned Products.When a customer returns a product to ME declaring there is a problem, the product would be taken care of by a customer service representative (CSR). The CSR will then examine the product in-house and take appropriate actions after.If it is customer’s fault, CSR would return the original product to the customer.If a problem is found and can be fixed in-house, CSR would estimate a due date and repair and return the product back to the customer.If a problem is found and cannot be fixed in-house, CSR would give a new product (the same model) to the customer.CSR would then send that product back to manufacturer, both defective and non-defective, and the manufacturer would send a new product to ME. This process takes approximately 1 week.ME pays for shipping and handling cost if the product is returned within 30 days since the purchase; customer pays for shipping and handling cost if the product is returned after 30 days but within a year since the purchase.Make or Buy DecisionME retails computers and related goods, and it does not make these products. Instead, the company purchases the goods from different manufacturers. There are a few reasons why ME chooses to buy instead of making.Currently, there are adequate number of suppliers for computers and computer peripherals, and this increases the level of competition between suppliers. This results in higher quality of products and lower cost of goods.Another reason why the company buys instead of makes is because of the supplier’s specialization in manufacturing computers and its components. Manufacturing a computer requires a lot of machinery and technology, and ME does not have sufficient knowledge (technology), skills and capital assets to make components in a finished product.Thus, it is difficult for the company to make computer products itself, and buying finished goods from manufacturers is the best option the company can have.If the company must make products themselves, it will have to spend money on research and development, machines, facility, utility, workforce, supervising staff, materials, insurance and transportation.Industry or Firm-specific IssuesAlthough purchasing finished goods from reliable manufacturers has its benefits, there are some disadvantages. Since there are only a few manufacturers, the firm does not have much bargaining power; the firm has high cost of goods sold. As a result, this would ultimately reduce the profit margin of the firm.According to the statistic report from Industry Canada, the pre-tax profit margin in the computer retailing industry was 4.1% in 2009. Having a low profit margin reduces the competitiveness of ME among other competitors.Moreover, the firm is only involved in a small part of the whole supply-chain process. There are not much actions ME can take to reduce the cost of final goods purchased except the holding cost and part of the transportation cost.Critique & RecommendationsDue to the fact that ME is an electronic and appliances retailing company, the firm is unable to cut down costs in manufacturing process. However, in terms of supply chain management, ME can reduce costs within the firm’s control and stimulate sales generated by e-commerce. Under the current structure, costs ME can reduce are transportation, storage and labour.TransportationIn a short to intermediate term perspective, ME can find a logistics company that provides the cheapest service as there are thousands of logistics companies available in the market.For long-term planning, ME may establish long-term relationships or contracts with one or more logistics companies and negotiate for a cheaper service charge. The firm can also set up its own logistics department and hire staff to perform the work. However, the cost of setting up a logistics department is costly, and long-term costs could be cheaper or more costly than outsourcing depending on the market and economy.StorageFor intermediate-term planning, the firm may order and store more inventory in the warehouse. This could help spreading out the fixed cost of storage.For long-term planning, the company can optimize warehouse space by adding shelves above existing ones, adding shelves beside existing ones, or reducing existing storage area and transforming it into other uses.LabourFor short-term planning, ME could reduce labour cost by rescheduling existing timetables in receiving dock, reducing wages or benefits per employee, hiring part-time employees instead of full-time employees, or laying off existing receiving dock employees.For long-term planning, the firm could reorganize its process for receiving and stocking inventory. The firm could reorganize its storage area to a flow-shop like layout which would help to increase efficiency. Also, the firm may be able to reduce the amount of labour after reorganization due to a smoother layout.E-commerce SalesIn the current supply-chain process, there are two ways to deliver merchandises to consumers – in-store retailing and e-commerce. In-store retailing involves labour while e-commerce does not, and this results a less costly supply-chain in e-commerce. In order to increase profit margin of merchandises in terms of supply-chain management, ME should stimulate sales in e-commerce as it does not involve labour.Quality ManagementMemory Express (ME) intends to deliver quality products and services at competitive prices. As a retail company, one of the main concerns that ME has is customer service. Customer service at ME is evaluated in the form of responsiveness, timeliness, results, reliability, integrity and trust. One of their goals is to “get it right the first time, get it right on time, get it right every time.” By achieving this goal, they could provide exceptional customer service exceeding customer’s expectations.To ensure customers get the best quality products, ME offers 7-days “no question asked” return policy, a 30-days exchange policy, 30-days limited warranty on clearance items and 1-year limited warranty on new items. By having such policies in place, customers may enjoy products they purchased without having to deal with the manufacturers.In order to provide high quality computers and related accessories, suppliers must ensure their products meet the basic requirement for performance. For example, computers should work efficiently throughout its useful life and should perform for a reasonable amount of time.Quality CultureTo ensure employees provide the best customer services in comparison to their competitors, the company treats its employees as family members and provides a work environment which has flexible hours and welcoming atmosphere. This environment allows sales reps and floor managers to continuously improve the overall customer service process. This method values the input of those directly involved with the customers resulting in a continuous feedback cycle. This environment enables employees and ME the ability to dedicate their expertise to provide exceptional service.Quality StandardsIn order to provide the customer with quick and reliable services, all members of Memory Express are being tested on their knowledge of computers and related products. Before each employee is hired, his or her knowledge on computer and computer components would be tested. Store managers would prepare and ask this applicant a set of questions about product parts, performance, and prices. If the applicant passes this test, he or she will be hired.Employees must identify the best option for customers based on limited information. This would require employees having sufficient knowledge on computers and accessories. The employee is encouraged to take adequate training courses and gain knowledge on products and parts.In addition, before ME accepts responsibility to repair a manufacturer’s product line, the company requires the manufacturer certify ME’s employees for repairing products. Repair technicians at ME are required to take training which takes place once every three months at ME’s head office for one day. Various technicians from the manufacturers are brought in to facilitate these training sessions. ME is responsible for the costs of training. If there is a disagreement between ME and manufacturer on this subject matter, ME would choose not to carry the manufacture’s product line as this requires customers to deal with manufacturers directly. This ensures the company provides quality customer services.ME provides quality products to customers by having high expectations of its suppliers. Suppliers of ME are required to ensure that the defect rate is within an acceptable range. From past experience, the company has an average yearly defect rate of around 6% on its products. As mentioned above in “Quality Definition”, the company takes care of warranties and will deal with manufacturers if necessary.If a product is covered under warranty, the firm examines and repairs the product if necessary. However, the firm would send back the product if repair technicians are unable to fix the product defect product to the supplier/manufacturer. If the company discovers a shipment has a defect rate of 10% or higher, they would call back all the items sold and require the supplier(s) to replace and send another shipment.Critique & RecommendationsAfter closely examining the company’s existing policies and related activities to ensure quality standards, we concluded that ME has excellent system in place and therefore does not require any changes in the near future.Inventory ManagementCompetitor AnalysisME counts two product groups of inventory per day. They continuously update their inventory and account for shrinkage. For a comparison, Future Shop does a full inventory count for all their products once every 3 months. Memory Express (Daily Inventory Count)ProsConsLow costDoes not take accurate screenshot of all inventoryTakes less time to countComplex schedule for inventory count for different product groupsUpdates inventory every dayLess chance of error due to low inventory count per dayFuture Shop (Quarterly Inventory Count)ProsConsInventory count done in one dayHigh cost to hire additional workers to countAccurate snapshot of inventory for that dayMore chance of error due to higher inventory countInventory count must be completed in one nightTakes a long time to trace or detect theft due to long inventory count cycle (quarterly)From this inventory count comparison, it shows ME has a better inventory count model because it is less costly and it updates certain product groups inventory daily. ME would also detect shrinkage immediately during the inventory count, whereas Future Shop would only detect that shrinkage during their quarterly inventory count period.AnalysisCurrently ME has a total inventory of $40 million across their seven stores in Western Canada. ME does not have a centralized warehouse but instead have a warehouse in each of their stores. For the Richmond Store, the total size of the warehouse is 7,000 square feet to hold their inventory. By having a large warehouse in back of each store, ME has quick access to all of their inventory, and all the shipments are directly delivered to their store. It also saves ME additional leasing costs if they had a central warehouse to store their entire inventory. For highly obsolescent items such as laptops, video cards and motherboards, these items are promoted and placed on sale more frequently. ME tries to keep a low inventory count for these particular items in order to account for its obsolescence. ME has a shrinkage rate of 1.5% for all the locations, which totals $600,000. This is a relatively low number compared to industry standards. Based on an interview of a Best Buy employee, their shrinkage for the store in Cambie/Broadway location was $200,000 per year. Shrinkage costs include; customer or employee theft, damaged goods or missing goods. Based on a quote given by Minh Ngo, Laptop memory, flash memory and hard drives contributed most to shrinkage. Our team conducted an ABC classification based on the shrinkage annual dollar value (Exhibit M: ABC Classification - Inventory Shrinkage). Laptop memory, flash memory, hard drives and computer accessories were classified in A with a total of 71%. Games/DVDs, and GPS were classified as B with a total of 18%; cameras and headphones were classified as C with a total of 11%.ME uses a Min/Max system for inventory control. ME sets a minimum stock (reorder point) at two weeks in order to allocate the time it takes for their new shipment to arrive. Their minimum stock is set at two weeks, and their maximum is set at four weeks of stock. Whenever ME stock level reaches the minimum stock point, an automatic reorder is placed to meet their target level of quantity.Min / Max Inventory Replenish SystemProsConsSimple method and easy to implementHigh chance of holding excess inventoryRush shipments not neededObsolescence Stock outs don’t occur oftenHigh inventory holding costsAlways have inventory on handReorder PointFor example, ME sells approximately 180 monitors per month. For a particular model, “Samsung 20inch LCD monitor” we calculated a ROP of 13.93 units. Samsung 20 inch LCD MonitorROPDemand726.22/yearWorking days365/yeard =1.99UnitsLead time7DaysROP13.93 unitsCritique & RecommendationsSince ME just opened their first store in British Columbia, recommending a centralized warehouse would not be beneficial to ME. If ME plans to expand in BC, a centralized warehouse in between Alberta and BC would be needed in order to accommodate all the inventory for the stores. Currently, their inventory management is performing reasonably well based on their shrinkage rates and inventory controls. By monitoring their inventory levels for high obsolescence items, they are able to avoid items becoming obsolete or damaged. Because their employees are “paid well” according to Minh, the shrinkage rate is lower compared to its competitors such as Best Buy. Since ME does not use a quantitative forecasting system, their Min / Max inventory replenish system is used to control their inventory stocks. This method works really well for ME because they always have stock in their store for any particular item at any given time.Action PlanBased on our research and recommendations, we suggest ME to reevaluate some of its weaker operational activities with an emphasis on:Project ManagementForecastingProduct DesignTo effectively implement some of the formal POM tools we have suggested, ME should set goals and explore each for ease of use, cost, and benefits to the company. ME will need to impose a time frame, and implementation plan which outlines the level of both management and staff. This plan should also take into consideration the training costs, times and controls to monitor the operations of the newly integrated policies or tools. In the short-term, ME should delegate two managers to learn how to use Microsoft Project. Since MS Project is an effective and easy tool to use, this will allow managers to have a great organizational tool for planning future projects. In addition to current forecasting method of Jury of Executive Opinion, ME should take salespersons opinions in consideration as they deal with customers in daily and have a clearer sight on product’s demand. ME should also use exponential smoothing and MAPE in order to have a more accurate forecast result. Lastly, ME could apply the house of quality to every new product ME makes in-house. By doing so, the company could meet customer requirements. In conclusion, ME has done an excellent job maintaining their operational policies. If the company will consider our recommendation and action, we believe ME can minimize their capital and opportunity cost.Works CitedAll about calgary. (n.d.). Retrieved May 23, 2011, from business.listing/608/memory_express.html BIBLIOGRAPHY Cheytanov, D. (2011, May 27). Store Manager. (E. group, Interviewer)Dean, J. (n.d.). The Laptop Trail. Retrieved May 22, 2011, from Wall Street Journal: , M. (2011). About us. Retrieved May 3, 2011, from Governenment Canada. (2009). Retrieved July 13, 2011, from Industry Canada: , M. (2011, May 15). CEO. (J. Chu, Interviewer)Nuss, R. (2010, March 2). Laptop Commodity Chain. Retrieved June 9, 2011, from Personal.psu: Minh. (2011, June 28). CEO. (E. group, Interviewer)Simplifying Min/Max. (2010, April 8). Retrieved June 14, 2011, from Drive You Success: 's Inside Your Laptop. (2007, March 14). Retrieved June 4, 2011, from PC Magazine: A: Organization Chart for Richmond Store-108140535560Exhibit B: House of Quality For Hard Drive EnclosureExhibit C: House of Quality Survey DataExhibit D: Raw Data from Memory ExpressSales QLaptopHDDCameraMonitor TV??????Oct1315764916341Nov1465957617844Dec1165284019037Jan1365494918233Feb1185526117531Mar1406655017532 Apr1435757118552May1216425815343June1335786219260??????Total118452605161593373# of mo99999Ave /mo131.56584.4457.33177.0041.44Exhibit E: Forecasting Summary Forecasting for LaptopsSales QLaptopα = 0.1α = 0.2α = 0.5α = 0.0 (opt)Oct131Nov146131.22131.22131.22131.22Dec116133.07134.99142.53131.44Jan136131.56131.25126.55131.67Feb118132.25132.44130.92131.89Mar140130.93129.22120.88132.11Apr143132.03131.47131.64132.33May121133.42134.34141.36132.56June133132.36131.69130.13132.78July132.61132.03131.23133.00Aug132.79132.11130.90133.22Sep132.97132.19130.57133.44Oct133.16132.26130.23133.67Nov133.34132.34129.90133.89MAD10.4611.2414.679.85MSE11.6712.4416.1911.06MAPE8.14%8.75%11.43%7.65%Forecasting Constants (Optimized)?Level (Alpha)0.000Trend (Beta)0.999Holt's Exponential?Mean Abs Err9.85Root Mean Sq Err11.06Mean Abs Per% Err7.65%Forecasting Data[ST_DataSet1]LevelTrendForecastErrorOct-2010131.0000131.000.22Nov-2010146.0000131.220.22131.2214.78Dec-2010116.0000131.440.22131.44-15.44Jan-2011136.0000131.670.22131.674.33Feb-2011118.0000131.890.22131.89-13.89Mar-2011140.0000132.110.22132.117.89Apr-2011143.0000132.330.22132.3310.67May-2011121.0000132.560.22132.56-11.56Jun-2011133.0000132.780.22132.780.22Jul-2011133.00Aug-2011133.22Sep-2011133.44Oct-2011133.67Nov-2011133.89Forecasting for Hard DrivesSales QHDDα = 0.1α = 0.2α = 0.5α = 0.0 (opt)Oct576Nov595576.22576.22576.22576.22Dec528578.51580.95590.53576.44Jan549573.36569.22548.55576.67Feb552570.59563.22538.17576.89Mar665568.21558.57537.94577.11Apr575578.33581.71626.09577.33May642578.41581.96612.39577.56June578585.81597.95646.45577.78July586.00597.15614.36578.00Aug586.97600.34616.50578.22Sep587.93603.53618.64578.44Oct588.90606.72620.77578.67Nov589.87609.91622.91578.89MAD35.4737.0446.4734.33MSE46.5448.8259.9744.68MAPE5.9%6.1%7.8%5.7%Forecasting Constants (Optimized)?Level (Alpha)0.000Trend (Beta)0.000Holt's Exponential?Mean Abs Err34.33Root Mean Sq Err44.68Mean Abs Per% Err5.70%Forecasting Data[ST_DataSet2]LevelTrendForecastErrorOct-2010576.0000576.000.22Nov-2010595.0000576.220.22576.2218.78Dec-2010528.0000576.440.22576.44-48.44Jan-2011549.0000576.670.22576.67-27.67Feb-2011552.0000576.890.22576.89-24.89Mar-2011665.0000577.110.22577.1187.89Apr-2011575.0000577.330.22577.33-2.33May-2011642.0000577.560.22577.5664.44Jun-2011578.0000577.780.22577.780.22Jul-2011578.00Aug-2011578.22Sep-2011578.44Oct-2011578.67Nov-2011578.89Forecasting for CamerasSales QCameraα = 0.1α = 0.2α = 0.5α = 0.0 (opt)Oct49Nov7650.4450.4450.4450.44Dec4054.7058.0271.0652.04Jan4954.7856.1655.6053.49Feb6155.7056.1950.7254.94Mar5057.7858.8056.8556.45Apr7158.4758.3452.7057.90May5861.3262.6865.7059.45June6262.5563.3663.7860.95July64.0564.6564.3762.46Aug65.6166.2265.8563.96Sep67.1767.7867.3365.47Oct68.7269.3568.8266.98Nov70.2870.9170.3068.48MAD9.4410.3813.518.77MSE12.0412.8216.6211.57MAPE16.3%18.4%24.7%14.8%Forecasting Constants (Optimized)?Level (Alpha)0.003Trend (Beta)1.000Holt's Exponential?Mean Abs Err8.77Root Mean Sq Err11.57Mean Abs Per% Err14.79%Forecasting Data[ST_DataSet3]LevelTrendForecastErrorOct-201049.000049.001.44Nov-201076.000050.521.5250.4425.56Dec-201040.000052.001.4852.04-12.04Jan-201149.000053.471.4753.49-4.49Feb-201161.000054.961.4954.946.06Mar-201150.000056.431.4756.45-6.45Apr-201171.000057.941.5157.9013.10May-201158.000059.441.5059.45-1.45Jun-201162.000060.951.5160.951.05Jul-201162.46Aug-201163.96Sep-201165.47Oct-201166.98Nov-201168.48Forecasting for MonitorsSales QMonitor α = 0.1α = 0.2α = 0.5α = 0.0 (Opt)Oct163Nov178166.22166.22166.22166.22Dec190170.74172.27178.28169.44Jan182176.20180.22193.24172.67Feb175180.37185.05193.91175.89Mar175183.37187.11186.01179.11Apr185185.99188.28179.32182.33May153189.33191.08182.39185.56June192188.78185.39160.58188.78July192.21188.91177.03192.00Aug195.32191.11177.76195.22Sep198.44193.31178.50198.44Oct201.55195.51179.24201.67Nov204.66197.70179.98204.89MAD11.3912.6816.3910.64MSE15.7116.6118.5914.76MAPE6.7%7.5%9.3%6.2%Forecasting Constants (Optimized)?Level (Alpha)0.000Trend (Beta)0.000Holt's Exponential?Mean Abs Err10.64Root Mean Sq Err14.76Mean Abs Per% Err6.23%Forecasting Data[ST_DataSet1]LevelTrendForecastErrorOct-2010163.0000163.003.22Nov-2010178.0000166.223.22166.2211.78Dec-2010190.0000169.443.22169.4420.56Jan-2011182.0000172.673.22172.679.33Feb-2011175.0000175.893.22175.89-0.89Mar-2011175.0000179.113.22179.11-4.11Apr-2011185.0000182.333.22182.332.67May-2011153.0000185.563.22185.56-32.56Jun-2011192.0000188.783.22188.783.22Jul-2011192.00Aug-2011195.22Sep-2011198.44Oct-2011201.67Nov-2011204.89Forecasting for TelevisionsSales QTVα = 0.1α = 0.2α = 0.5α = 0.0 (opt)Oct41Nov4443.1143.1143.1143.11Dec3745.3245.4445.8945.79Jan3346.5245.5641.5642.27Feb3147.0744.3535.2538.44Mar3247.2142.4630.0335.79Apr5247.2840.7228.4235.47May4349.3843.7843.5148.17June6050.3244.4046.4246.97July52.9548.9259.7857.43Aug54.6250.3266.3459.54Sep56.2951.7272.9061.65Oct57.9653.1179.4763.76Nov59.6354.5186.0365.87MAD9.359.177.788.11MSE10.6010.5410.709.38MAPE25.6%23.5%17.6%19.4%Forecasting Constants?Level (Alpha)0.500Trend (Beta)0.500Holt's Exponential?Mean Abs Err7.777Root Mean Sq Err10.698Mean Abs Per% Err17.62%Forecasting Data[ST_DataSet2]LevelTrendForecastErrorOct-201041.000041.0002.111Nov-201044.000043.5562.33343.1110.889Dec-201037.000041.4440.11145.889-8.889Jan-201133.000037.278-2.02841.556-8.556Feb-201131.000033.125-3.09035.250-4.250Mar-201132.000031.017-2.59930.0351.965Apr-201152.000040.2093.29628.41823.582May-201143.000043.2533.17043.506-0.506Jun-201160.000053.2116.56446.42313.577Jul-201159.776Aug-201166.340Sep-201172.904Oct-201179.469Nov-201186.033Exhibit F – Raw Data for ProductivityTotal sales for major 5 product linesProduct LinesTotal Sales (7 months)Avg $/monthAvg $/unitLaptop $ 570,000 $ 81,428.57 $618.89HDD $ 358,000 $ 51,142.86 $87.50Camera $ 300,000 $ 42,857.14 $747.56Monitors $ 252,000 $ 36,000.00 $203.33TV $ 230,000 $ 32,857.14 $793.33Capacity of the storeAreaSquare feetWarehouse7,000Service area2,000Floor space14,500 Total Sq. ft.23,500 Square feet for major product linesColumn1Proportion of sq. ft.Square ft.Laptops4.37%634 Hard drives1.45%210 Cameras2.92%423 Monitors3.63%526 Televisions17.30%2,509 Other product lines15.38%2,230 Aisle54.95%7,968 TOTAL100%14,500 Exhibit G – Service Productivity1. Sales $/ labour hour(per month)Labour information12staff /day8hours / dayProduct Lines# of sales repsMonthly salesProductivity/labour hoursLaptops3$81,429$3,392.86Hard drives3$51,143$2,130.95Cameras2$42,857$2,678.57Monitors2$36,000$2,250.00Televisions2$32,857$2,053.57TOTAL12$244,286$12,505.952. Sales $/ labor cost(per month)Labour information12staff /day8hours / day$15/hourProduct Lines# of sales repsMonthly salesProductivity/labour costLaptops3$81,429$226.19Hard drives3$51,143$142.06Cameras2$42,857$178.57Monitors2$36,000$150.00Televisions2$32,857$136.90TOTAL12$244,286$833.733. Sales $/square ft. (per month)Product LinesMonthly SalesProductivity / sq. ft. Laptops$81,429$128.51Hard drives$51,143$243.25Cameras$42,857$101.22Monitors$36,000$68.40Televisions$32,857$13.10-240665286385Exhibit H: Work Breakdown ScheduleExhibit I: Store Layout PlanExhibit J: Supply-chain Management of Sony LaptopsExhibit K: Reverse Logistics of Returned ProductsExhibit L: Summary of MeetingsFirst MeetingName:Mr. Minh Ngo– CEO & OwnerMr. Damian Cheytano– Store ManagerDate:May 15th, 2011Location:Memory Express Store in Richmond, BCSummary:This was our first formal face-to-face meeting with Mr. Ngo and Mr. Cheytanov. In our conversation our team enquired about the overview of the company and various information related to our POM audit. Memory Express graciously provided us with information in regards to the company’s organizational structure, business functions, refund and return policies, price-matching policy, and layout. Mr. Ngo agreed to continuous provide us exclusive information about the inner workings of the company and appointed Mr. Cheytanov as our contact when he is unavailable and out of the province.Second MeetingName:Damian Cheytanov– Store ManagerDate:May 27th, 2011Location:Memory Express Store in Richmond, BCSummary:Our team had a face-to-face interview with Memory Express’ store manager Damian Cheytanov. In the interview, our team acquired information about ME’s business strategy, forecasting and productivity data for their top five product lines. Unfortunately, we found out that they did not do any quantitative forecasting, but instead used a jury of executive opinion forecasting. For productivity, we learned that they did not manufacture their own branded products, but instead outsourced it to a company in China. We also inquired about project management regarding the opening of the Richmond store. We learned that the opening of the store was anticipated for May 2010, but delays caused by a flood in the store pushed the opening to Oct 2010. For quality management, ME claimed that the products they received from their suppliers must have a 10% return rate or less or else ME would request for a new batch. For product design, ME had a team of designers for a television stand branded under Velocity. Once the design was approved by Minh, the specifications for the TV stand would be sent to China for manufacturing. Third MeetingName:Minh Ngo– CEO & OwnerDate:July 28, 2011Method:Phone InterviewSummary:Our team had a phone interview with the CEO of Memory Express, Minh Ngo. In our conversation, we asked him questions regarding inventory management, layout, supply-chain management and related issues in the firm.For inventory management, we discussed about total inventory, shrinkage, obsolete inventory and inventory model. Minh said that their shrinkage rate was 1.5% across the seven stores of Memory Express. When we asked Minh how the shrinkage rate was so low, Minh said that the employees were satisfied in working with Memory Express and because they were “paid well”. For supply-chain management, Minh discussed that their Velocity branded products were outsourced to Asia and it took approximately 1 month for the product to arrive to each store. Depending on where the products were manufactured and size of the order, it would take from 1 week to 1 month to arrive in Memory Express warehouse.The items are delivered directly to each store’s warehouse because they do not have a centralized warehouse to store their products. Each store places its own order and is independent. For customer returns, the ME employee inspects, tests and returns the product from the customer to the manufacturer if necessary. ME is responsible for the shipping costs and it takes approximately one week for the product to return back to the retail location. Exhibit M: ABC Classification - Inventory ShrinkageItemAverage Unit CostUnits LostAnnual Dollar Value% of Total ADVLaptop memory$30800$24,00034%A95256667571%Flash Memory$10950$9,50014%Hard Drives$75125$9,37513%Computer Accessories$15475$7,12510%Games/Dvds$20325$6,5009%B1016012636518%GPS$10060$6,0009%Cameras$25020$5,0007%C47625011%Headphones$3090$2,7004%Total70,200100%Exhibit N: Shrinkage ParetoExhibit O: MS Project Gantt ChartExhibit P: MS Project Schedule ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download