Use the table below to answer the following question(s) by invoking the binary constraints on the...
Use the table below to answer the following question(s) by invoking the binary constraints on the variables using the standard Solver. Below is the spreadsheet for a project selection model: Project Selection Model Data 4 Project 1 Project 2 Project 3 Project 4 Project 5 Available Resources $160,000 $250,000 $175,000 $150,000 $225,000 $45,000 $70,000 $28,000 $52,000 $55,000 $175,000 В 16 11 Expected Return 15 (NPV) Cash 16 requirements Personnel 7 requirements 8 19 Model 10 111 Project selection decisions 12...
B IA Project Selection Model 2 3 Data 4 Project 1 Project 2 Project 3 Project 4 Project 5 Available Resources 5 $160,000 $200,000 $125,000 $150,000 $225,000 16 $45,000 $70,000 $28,000 $52,000 $65,000 $175,000 17 4 2 6 4 10 Expected Return (NPV) Cash requirements Personnel requirements 8 19 Model 10 11 Project selection decisions 12 Cash Used 13 Personnel Used 14 Return What is the total return obtained from all five projects? $650,000 $700,000 $550,000 $860,000
QUESTION 1 Use the information below to answer the following question(s). Consider the following spreadsheet for an outsourcing decision model. utsourcing Decision Model Data Manufactured in-house ixed cost Unit variable cost 60,000 130 Purchased from supplier Unit cost 10 165 12 Demand volume 13 14 Model 15 16 1,000 otal manufacturing cost Total purchased cost 18 19 Difference 20 Decision We assume that the production (demand) volume is normally distributed with a mean of 1,000 and a standard deviation of...
QUESTION 80 Use the table below to answer the following question(s). Remington Textiles has a mill that produces three types of fabrics on a make-to-order basis. The mill operates on a 24/7 basis. The key decision facing the plant manager is about the type of loom needed to process each fabric during the coming 12 weeks to meet demands for the three fabrics and not exceed the capacity of the looms in the mill. Two types of looms are used:...