Assume you have a four-column matrix named BoltStock25 containing information about quarter-inch-diameter bolts your company has in stock. The first column contains the bolt length The second column contains the number in stock The third column contains the minimum stock that should be maintained (based on usage) The fourth column contains the maximum number allowed in stock (based on storage space). You wish to determine how many bolts of each type to order according to the following guidelines: If the number in stock falls to less than the minimum stock desired plus 50 for any specific length, more of that length should be ordered. All orders must be in multiples of 100 of any specific length. The current stock plus the number ordered for a specific length must not exceed the maximum allowable stock. When an order is placed for a specific length, the total stock should then be as close as possible to the maximum allowed stock. You may assume that the maximum stock allowed is always at least 150 more than the minimum stock desired. Create a new two-column matrix BoltOrder25. The first column should contain the lengths of all bolts that will be ordered. The second column will contain the number of each length to be ordered. Example: One row of BoltStock25 contains [3, 219, 175, 900]. Since the number in stock (219) is less than 50 more than the minimum stock desired (175), more should be ordered to bring the total as close to 900 as possible. This means 600 should be ordered, bringing the total to 819.
Assume you have a four-column matrix named BoltStock25 containing information about quarter-inch-diameter bolts your company has in stock. The first column contains the bolt length The second column contains the number in stock The third column contains the minimum stock that should be maintained (based on usage) The fourth column contains the maximum number allowed in stock (based on storage space). You wish to determine how many bolts of each type to order according to the following guidelines: If the number in stock falls to less than the minimum stock desired plus 50 for any specific length, more of that length should be ordered. All orders must be in multiples of 100 of any specific length. The current stock plus the number ordered for a specific length must not exceed the maximum allowable stock. When an order is placed for a specific length, the total stock should then be as close as possible to the maximum allowed stock. You may assume that the maximum stock allowed is always at least 150 more than the minimum stock desired. Create a new two-column matrix BoltOrder25. The first column should contain the lengths of all bolts that will be ordered. The second column will contain the number of each length to be ordered. Example: One row of BoltStock25 contains [3, 219, 175, 900]. Since the number in stock (219) is less than 50 more than the minimum stock desired (175), more should be ordered to bring the total as close to 900 as possible. This means 600 should be ordered, bringing the total to 819.
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter11: Database Performance Tuning And Query Optimization
Section: Chapter Questions
Problem 21P: Problems 1721 are based on the following query: SELECT V_CODE, V_NAME, V_CONTACT, V_STATE FROM...
Related questions
Question
Assume you have a four-column matrix named BoltStock25 containing information about quarter-inch-diameter bolts your company has in stock.
- The first column contains the bolt length
- The second column contains the number in stock
- The third column contains the minimum stock that should be maintained (based on usage)
- The fourth column contains the maximum number allowed in stock (based on storage space).
You wish to determine how many bolts of each type to order according to the following guidelines:
- If the number in stock falls to less than the minimum stock desired plus 50 for any specific length, more of that length should be ordered.
- All orders must be in multiples of 100 of any specific length.
- The current stock plus the number ordered for a specific length must not exceed the maximum allowable stock.
- When an order is placed for a specific length, the total stock should then be as close as possible to the maximum allowed stock.
- You may assume that the maximum stock allowed is always at least 150 more than the minimum stock desired.
Create a new two-column matrix BoltOrder25.
- The first column should contain the lengths of all bolts that will be ordered.
- The second column will contain the number of each length to be ordered.
Example: One row of BoltStock25 contains [3, 219, 175, 900]. Since the number in stock (219) is less than 50 more than the minimum stock desired (175), more should be ordered to bring the total as close to 900 as possible. This means 600 should be ordered, bringing the total to 819.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage