联系我们： 手动添加方式: 微信>添加朋友>企业微信联系人>13262280223 或者 QQ: 1483266981
这是一篇作业是Excel商业决策建模的一个Case Study Assignment
Case 2: Targus Purchasing and Distribution Plan
For more than thirty-five years, Targus has been implementing purposeful solutions – from laptop bags to tablet cases to peripherals and universal docking stations. Recently, they have designed a UV Keyboard cleaner in the form of an LED Desktop Disinfection Light. This UV light-based bacteria buster sits between a computer screen and keyboard and automatically blasts the keys with UV light every hour to rid it of mould, bacteria, fungus and viruses. Each cleanse takes five minutes and motion sensors ensure the light only comes on when users aren’t using the keyboard to prevent potentially harmful UV exposure. This is a new discovery that has proven its efficacy in preventing the spread of COVID-19 and other infectious agents.
They have recently launched the product in the Australian market and this has taken the market by storm. Orders have been pouring in and whilst this is a good problem, it also poses a significant challenge for the company to meet the customers’ demands in a timely manner. In particular, their major distributors in Adelaide, Brisbane, Perth and Sydney have already placed a monthly standing order for 15000, 25000, 35000 and 40000 units of the LED Desktop Disinfection Lamp, respectively.
With the current Covid situation, production runs have been adversely impacted and the company has sourced some manufacturers in China, Hong Kong and Taipei to keep up with the orders.
Table 1 below shows the monthly purchasing contracts that Targus Australia has signed with these manufacturing companies. These contracts require Targus Australia to place a minimum order quantity of the LED Desktop Disinfection Lamps each month for a guaranteed price. The table also shows the maximum quantity that each manufacturer can supply.