Math Problem Statement

Question 1 17.0 points possible (graded, results hidden) Beverly is the procurement manager at CyberGuard and is currently working on a bidding process to supply three electronic components for their flagship product, the SkyEyes4, an autonomous drone for surveillance purposes. Five local suppliers submitted their proposals for sourcing all three components: The camera, gyroscopes, and data transmission systems. Based on the latest meeting with the forecasting team, the components requirement for the upcoming season are: Table 1: Demand in units Component Demand in Units Camera 5037 Gyroscope 4670 Data Transmission System (DTS) 3620

In preparation for analyzing all five bids, she gathered all available data below. Table 2: Suppliers' cost per unit of each component Supplier A Supplier B Supplier C Supplier D Supplier E Camera 15 15 20 19 13 Gyroscope 23 19 24 15 20 DTS 18 14 18 15 29 Table 3-Suppliers' capacity per component Supplier A Supplier B Supplier C Supplier D Supplier E Camera 3500 3000 1900 4000 3000 Gyroscope 4000 2500 3000 2500 1900 DTS 2500 1900 4000 3000 2500 What's the minimum purchasing cost Beverly would get for the SkyEyes4 required components? Round your answer to the nearest integer

Question 2 17.0 points possible (graded, results hidden) Supplier A is very reliable. The company has never encountered any availability issues or quality complaints with this supplier. Beverly wants to explore the option of buying at least 50% of each of the three components from Supplier A and evaluate the impact of this decision on the total procurement cost. Note that Beverly can't purchase half a component. When calculating the above-mentioned 50% round the corresponding value to the nearest integer.

What would be the minimum purchasing cost in this scenario? Round your answer to the nearest integer.

Question 3 8.5 points possible (graded, results hidden) After meeting with the quality lead Russell and the general manager Jean to analyze all suppliers' financial and technical information, the team determines that they are all similarly qualified to supply all three components, so the Question 2 scenario won't proceed and Beverly is back to the original model. Concerned about the service level and the SkyEyes4 production being time-sensitive due to its high demand, she decided to implement the on-time delivery as a key component of the bid evaluation. If normalizing a 5- day lead time as the on-time service level, she estimates that any extra day would cost an additional 5% per day over the bid price for each unit of the corresponding component. Also, based on the plants' idle capacity, receiving the products earlier would represent a cost reduction of 5% per day over the bid price for each unit of the corresponding components. After a few phone calls, Beverly prepares Table 4 to include in her analysis. Table 4: Suppliers' lead time per component Camera Gyroscope DTS Supplier A Supplier B Supplier C Supplier D Supplier E 6 8 3 5 10 5 3 2 7 5 5 3 1 5 5 What's the minimum LOS-adjusted cost in this model? Round your answer to the nearest integer Question 4 8.5 points possible (graded, results hidden) What's the ACTUAL minimum total purchasing cost in this LOS-adjusted model? Round your answer to the nearest integer

Solution

Ask a new question for Free

By Image

Drop file here or Click Here to upload

Math Problem Analysis

Mathematical Concepts

Linear Programming
Optimization
Cost Minimization
Supply Chain Management

Formulas

Cost = Σ (Cost per unit * Number of units purchased)
Demand = Σ (Units purchased from all suppliers)
Capacity constraint: Units purchased <= Supplier capacity

Theorems

Linear Programming Theorem
Simplex Method

Suitable Grade Level

Undergraduate