Techsoft, a leading technology company specializing in graphics processing, has just developed a new version of their Vision graphics card. The card is 10% smaller than its predecessor and is breaking new ground in cost as it is projected to sell at half the price of its current card. The need for faster, more affordable graphics cards that can be networked to scale according to processing needs has driven both the lower selling prices and the demand for processing higher than ever before. The issue Techsoft faces now is that its supply chain costs are now proportionally a much larger percentage of the overall graphics card selling price.

Changing Landscape

The technology industry evolves rapidly, and each day an unsold graphics card or another piece of advanced hardware loses value as new chips and versions are researched, released, and retired. Techsoft is an OEM and sells to other manufacturers and distributors. For the Vision graphics card, in particular, all sales are included in other consumer and industrial products and are not to be sold directly to consumers themselves. The challenge is with rapidly changing products in the market and intense competition, Techsoft has to compete on not only the functionality front but cost as well. Due to this, its current supply chain cost is unacceptable when the cost of the card itself has been reduced by 50%. Techsoft expects innovation in all aspects of its business beyond just R&D. Therefore, Management has requested that your team investigate ways to reduce the per-card supply chain costs as much as possible.

Incumbent Suppliers

Techsoft currently has four significant suppliers for its raw materials. Techsoft has been looking to bring down its supplier expenses through consolidation to just two suppliers. Flexit has been Techsoft’s oldest partner and has been recently awarded the Electronic Industry award for its pioneering work in maintaining its quality standards. Techsoft has been the largest customer for Worldcomm, which has always provided Techsoft with the best prices. Worldcomm has even designed its processes to provide flexibility in its services to cater to the changing demands of Techsoft. Maxo Inc has been recently audited by ISO and has provided a few observations that could put its eligibility for renewal of its ISO 9001 certification at risk. Nanotech is a relatively new supplier with innovative processes and customer service, which initially attracted Techsoft to contract.

Current Supply Chain Operations

Techsoft produces all its products at its manufacturing units in Singapore and South Germany. They must continue with their current manufacturing units as the capital expense and risk to intellectual property are too high to consider outsourcing to reduce costs. Techsoft does not foresee any changes to production capacity or set-up costs at this time. The lead time for order processing and Quality Assurance activity is two days, and the lead time for manufacturing can be assumed to be one week.

Techsoft manages all of its transportation and warehousing from pre-production to final storage. The company uses a third-party shipper to deliver the Vision cards directly to customers. As the Vision card is just one of many products that Techsoft creates, the company doesn’t intend to adjust its transportation practices from factory to warehouse as it’s been optimized for the existing mix of products. Techsoft currently supplies the North American market from its manufacturing plant in Singapore. The plant in Germany caters to the European market.

During the seven weeks from the initial order, Techsoft’s customers often have the luxury to change their volumes and specifications multiple times. Each vision card remains in the Singapore warehouse for seven weeks, whereas the actual order details are typically locked in by 2-3 weeks before production.

In North America, Techsoft does not have warehouses to store finished inventory; instead, they have a docking location for the immediate shipping of finished goods. From its California docking location, Techsoft directly ships the cards to customers as soon as the chips arrive. This docking location is conveniently located for easy access by ship and air.

Overall, Techsoft’s most significant concern is to retain its high quality and balance the overall availability and inventory as the technology industry, particularly the graphics card industry, changes rapidly.

Looking to the Future

Techsoft plans to pilot this supply chain reduction program for its Singapore unit. In preparation, Techsoft has started engaging all of its 200 customers affected by the pilot program through interviews and questionnaires. It aims to gain insights into desired customer engagement levels that can impact the supply chain and associated costs.

With respect to this pilot program, Techsoft has asked for your teams’ help to determine which aspects of the supply chain provide opportunities to reduce costs and by how much. A few data exhibits are attached to help assess the supply chain costs and potential savings.

Week	Actual Graphics Cards Sales
	Category A (95%)	Category B (90%)
Week 1	187	96	283
Week 2	187	186	373
Week 3	140	167	307
Week 4	159	136	295	1258
Week 5	146	177	323
Week 6	157	101	258
Week 7	179	159	338
Week 8	186	168	354	1273
Week 9	139	98	237
Week 10	170	137	307
Week 11	164	185	349
Week 12	186	127	313	1206
	166.7	144.8	311.4166667

What is the average number of products sold in the last 12 weeks?

What was the trend of total and category A and B sales in the previous quarter? (Plot the graph)

What can be concluded from the trend lines and R-squared value of the charts?

What are the implications if the trend is negative or positive?

Can Technosoft meet future customer demand in categories A and B?

Can the suppliers supply raw materials for current and future demand (assuming demand patterns remain the same)

Based on your analysis, does Technosoft face oversupply or undersupply?

please do it in excel also

Answer rating: 100% (QA)

Sure I can help you with that Average number of products sold in the last 12 weeks The average number of products sold in the last 12 weeks is 1667 wi... View the full answer