10. DoubleSet Company is a manufacturing organization that produces two products, Trinidad and Maser. The manufacturing process for each product is basically a two-step operation involving three employees. Bob performs a preliminary manufacturing step on Machine A for each of the two products produced in the DoubleSet Company. It takes him 5 minutes to complete a product on Machine A. Naomi then operates Machine B for 20 minutes to complete each Trinidad product. Similarly, Luis operates Machine C for 20 minutes to complete each Maser product. All three employees work 8-hour days. Thus, they each have 480 minutes of daily processing time available to them (8 hours X 60 min- utes). Assume now that both products provide $100 of throughput per product. The table below describes the setup necessary to perform an LP solution for DoubleSet Company. Minutes Minutes per per Trinidad Maser Total Minutes Trinidads produced Masers produced Trinidad throughput Maser throughput Total throughput $100 $100 Machine A Machine B Machine C Daily Ceiling 480 480 480 20 20 Required: Input the data above into an LP software such as Microsoft ExcelTM and compute the optimal answer and sensitivity analysis. Identify the bottleneck(s) from the LP solution. 10. DoubleSet Company is a manufacturing organization that produces two products, Trinidad and Maser. The manufacturing process for each product is basically a two-step operation involving three employees. Bob performs a preliminary manufacturing step on Machine A for each of the two products produced in the DoubleSet Company. It takes him 5 minutes to complete a product on Machine A. Naomi then operates Machine B for 20 minutes to complete each Trinidad product. Similarly, Luis operates Machine C for 20 minutes to complete each Maser product. All three employees work 8-hour days. Thus, they each have 480 minutes of daily processing time available to them (8 hours X 60 min- utes). Assume now that both products provide $100 of throughput per product. The table below describes the setup necessary to perform an LP solution for DoubleSet Company. Minutes Minutes per per Trinidad Maser Total Minutes Trinidads produced Masers produced Trinidad throughput Maser throughput Total throughput $100 $100 Machine A Machine B Machine C Daily Ceiling 480 480 480 20 20 Required: Input the data above into an LP software such as Microsoft ExcelTM and compute the optimal answer and sensitivity analysis. Identify the bottleneck(s) from the LP solution