Design a decision support system

Assignment Help Basic Computer Science

Reference no: EM13964610

The owner of a hardware store wants to design a decision support system to predict how many and which type of nails she should sell and what information she needs to do so. The scenario is described below:

Consider that you offer six types of nails and can make as many as you need of each. These are:

4-inch nails
3.5-inch nails
3-inch nails
2.5-inch nails
2-inch nails
1.5-inch nails

The cost of making each type of nail depends on the size of the nail. The costs and selling prices are listed in the table below, along with the weights. The nails will be sold in boxes of up to 30. There must be no more than 10, but no less than five, of each of three types of nails in each box. The nails in each box should weigh no more than 20 ounces. You're looking for the combination with the highest profit using a trial-and-error method. A spreadsheet would be helpful for completing this project. You'll most likely find that you identify some promising paths to follow right away and will concentrate on those to reach the best one.

NAIL	WEIGHT (in ounces)	COST (in cents)	SELLING PRICE (cents)
4-inch	1.00	4.0	8
3.5-inch	0.85	3.5	6
3-inch	0.70	3.0	5
2.5-inch	0.50	2.5	4
2-inch	0.25	2.0	3
1.5-inch	0.10	1.5	2

Justify at least three different considerations you looked at while attempting to come up with the most profitable solution. What would go into such a system if you were the owner of the store and your business profits were at stake

Reference no: EM13964610

Questions Cloud

Find shortest paths from src to all vertices : Bellman-ford Algorithm Given a graph and a source vertex src in graph, find shortest paths from src to all vertices in the given graph. The graph may contain negative weight edges.

Find the electric ?eld, e2, the electric displacement : Find the surface density of bound charge on both sides of the boundary between media 1 and 2, and on both sides of the boundary between media 2 and 3.

What factors are argued to influence marginal revenue : What factors are argued to influence marginal revenue (MR) for each franchise? Explain the expected relationships between each factor (variable) and the MR.

Problem regarding the dynamic programming : Dynamic Programming ( 0-1 Knapsack Problem) Given weights and values of n items, put these items in a knapsack of capacity W to get the maximum total value in the knapsack.

Design a decision support system : The owner of a hardware store wants to design a decision support system to predict how many and which type of nails she should sell and what information she needs to do so. The scenario is described below:

Find out the mass of the air in a room 3.00m by 4.00m : Find out the mass of the air in a room 3.00m by 4.00m by 5.00m given that the temperature is 200 C at atmospheric pressure (1atm = 101000 Pa)

Identify which of the above is nominal, ordinal, interval : Bob, who is different in many ways measures time in days, with 0 corresponding to his birth date. The day before his birth is -1 , the day after his birth is +1 and so on

Define the income and substitution effects of a wage change : Define the income and substitution effects of a wage change on hours of labor supply. Explain and show graphically the derivation of this individual's labor supply curve.

Is the scale of measurement nominal, ordinal, interval : Summary of the problem: Give a brief description of the variable and whether the scale of measurement is nominal, ordinal, interval, or ratio, and why. Explain what it means to say that this variable is "normally distributed." Then, define probabi..

User Account

All Pages