Spreadsheet for use in answering question.   Which vendor wo…

Spreadsheet for use in answering question.   Which vendor would you choose?  You are the buyer for a federal department and need to buy a gross (144) of widgets. These can be purchased from multiple firms.  Your only mandatory requirement for the successful winner of this RFQ is that they are qualified to sell widgets. You would prefer to buy Canadian-made widgets though you realize that trade restrictions open up the supply market to vendors from those countries with which Canada has a trade agreement.  Your department has not met the mandatory minimum requirement for 5% of all contracts going to indigenous vendors and year-end is fast approaching. You will be using a weighting model to score these vendors based on the following weights: Criteria Weight Criteria Weight Price 30% Lead time 10% Indigenous ownership 5% Female ownership 5% Warranty 10% Quality 20% Sustainability 10% Innovation 10% Your team has scored the six contenders as follows.  You can use the attached spreadsheet to enter the data and do your calculations.  Please upload it to the quiz.  If you send it to me via email (something I don’t want), it must be sent within 2 minutes of the submission time of your quiz.  If it shows up later, I won’t accept it.   Alpha Widgets Prices 3/5 Delivery lead time 4/5 Widget qualified – Yes Indigenous ownership – No Female ownership – No  Canadian ownership – Yes Warranty – 2/5 Quality and fitness for purpose – 4/5 Sustainability – 3/5 Industry innovation – 4/5 Brilliant Widgets Prices 4/5 Delivery lead time 3/5 Widget qualified – Yes Indigenous ownership – No  Female ownership – Yes Canadian ownership – No (American) Warranty – 3/5 Quality and fitness for purpose – 3/5 Sustainability – 2/5 Industry innovation – 3/5 Creative Widgets Prices 2/5 Delivery lead time 5/5 Widget qualified – No Indigenous ownership – Yes Female ownership – No Canadian ownership – Yes Warranty – 4/5 Quality and fitness for purpose – 4/5 Sustainability – 4/5 Industry innovation 4/5  Delightful Widgets  Prices 3/5 Delivery lead time 3/5 Widget qualified – Yes  Indigenous ownership – No Female ownership – No Canadian ownership – Yes Warranty – 4/5 Quality and fitness for purpose – 5/5 Sustainability – 4/5 Industry innovation – 2/5 Excellent Widgets Prices 5/5 Delivery lead time 2/5 Widget qualified – Yes Indigenous ownership – Yes Female ownership – No Canadian ownership – No (American) Warranty – 2/5 Quality and fitness for purpose – 3/5 Sustainability – 3/5 Industry innovation – 2/5 Fantastic Widgets  Prices 1/5 Delivery lead time 5/5 Widget qualified – No Indigenous ownership – No Female ownership – No Canadian ownership – Yes Warranty – 4/5 Quality and fitness for purpose – 3/5 Sustainability – 4/5 Industry innovation 4/5

Jailhouse Rock is a boutique hotel with a theme based on Elv…

Jailhouse Rock is a boutique hotel with a theme based on Elvis Presley’s song and movie from the 1950s.  With the rush to open, JR decided to outsource food service to Slammer & Klink, an institutional food service.  S&K were expensive, but JR didn’t have the time to put together a good RFQ.  Imagine their surprise when six months after opening, the CEO of S&K, Stan Slammer left the firm he had founded.  He was known as a visionary and philanthropist and gave ex-cons a chance by hiring them.  Costs had risen considerably in the year since Slammer had quit.  JR’s management team refused to deal with this problem perhaps because some of the expected operating metrics were inconveniently left out of the contract.  Not only were costs rising but the quality of the food was dropping.  What is happening with Jailhouse Rock and Slammer & Klink?  Relate examples in this mini-case to the concepts. 

An adult client with a history of allergies comes to the cli…

An adult client with a history of allergies comes to the clinic complaining of difficulty breathing while working in his yard. The nurse notes the following physical exam findings: tachypnea, use of accessory neck muscles, prolonged exhalation, intercostal retractions, decreased breath sounds, and wheezes bilaterally. These objective findings are consistent with?