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 System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

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

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions