[SOLVED] Dexter pored over the table of data

Dexter pored over the table of data he had compiled using inputs from purchasing, internal inventory managers, accounting, and Disco (Dexter’s Chicken’s purchasing co-op and sole distributor). He hoped that he had enough information to make a well-founded decision regarding whether, and how, to invest in the product traceability initiative he and Disco had been discussing.
Dexter’s Chicken was a popular restaurant chain with about 250 stores located throughout the Southeast United States. While sales growth had been steady, Dexter (the owner of the company) was concerned about the large capital investments the company had been making in inventories to support sales growth. In addition to adding stores, Dexter’s had frequently been adding new menu items, including limited-time-offer (LTO) items as a way to attract new customers. These tactics were common in the quick service restaurant (QSR) industry, as growing competition continued to put pressure on prices and QSR chains fiercely fought for market share. However, slowly rising inflation on produce, dairy, and other food items threatened to shrink profit margins, and the costs of inventory were becoming more and more noticeable as a major sink of funds.
Because of the recent Food Modernization Act, along with a number of highly publicized food-borne illness incidents, QSR firms were becoming much more concerned about food safety and recalls. These demands necessitated greater levels of traceability in QSR supply chains. Traceability is the ability of food service partners to quickly verify the history, location, and usage of product. It requires coordinated efforts of trading partners to collect and maintain product information that supports batch/ lot or serial number visibility of the product’s movement through distribution channels. Practically speaking, building traceability for QSR firms usually meant making heavy investments in setting product identification standards, installing scanning technology, and developing data management systems. These investments would be required at least at Dexter’s distributors and in the back office receiving areas of its stores.

Information from supply chain sources
Dexter’s Chicken systemwide annual sales……………………………………….….... $450,000,000
Annual budget for purchasing organization, including salaries, IT support, equipment, supplies, and overhead (purchasing estimates about 35% of total expenses are spent on placing and receiving orders)…………………………………………………………………..………………………….… $75,000,000
Number of orders placed per year for an average item................................... 20
Total number of SKUs at Dexter’s Chicken……………………………….....………….17, 500
Total annual purchasing spend (COGS)…………………………………………………..$250,000,000
Average cost of purchased items……………………………………………………………..$10 per unit
Estimated carrying cost (including spoilage and waste)………………………....... 80% of unit cost per year
Total annual inventory carrying cost for all items (30% is for safety stock)… $109,375,000

Dexter wanted to make sure that he considered all the costs and benefits of pursuing the traceability option. It seemed as though the industry was moving in this direction, and he did not want to fall behind. However, Disco estimated that it would need to raise prices by 3 percent across the board in order to install scanners, systems, and training required to support the traceability initiative. Dexter estimated that required investments in his own restaurant stores would total $1–1.5 million, but he expected that inventory management costs should actually go down. Automation and more accurate inventory information provided by scanning and tracking would cut down on uncertainties in the deliveries and availability of items in the stores. Shelf life was a big issue in stores, with food spoilage rates of up to 40 percent. Better traceability might also significantly lower the cost and improve the accuracy of product recalls, should a quality problem arise. Finally, a growing number of consumers wanted to know the provenance (origins) of the foods that they ate, causing Dexter to wonder if there might be some positive brand benefits from traceability investments.

Required:
1. Should Dexter go ahead with the traceability initiative? How much should he be willing to invest in technology and training to implement new processes?
2. What else can be done to reduce inventory costs at Dexter’s Chicken?

Question: Dexter pored over the table of data