Design a decision support system

Assignment Help Management Theories

Reference no: EM131005138

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? Your submission must be a minimum of two pages, double-spaced

Reference no: EM131005138

Questions Cloud

Specify a short-run total variable cost function : Suppose you are to specify a short-run total variable cost (STVC) function for a nursing home. Please list the independent variables (up to 5) and explain why they are included. In addition, define the impact of each independent variable on the STVC.

Prepare the appropriate entries for both western soya : Prepare the appropriate entries for both Western Soya and Rhone-Metro on December 31, 2012 (the second rent payment and depreciation).

What is the maximum average grade the student : A student taking economics, statistics, and finance has decided to spend 9 hours per week studying. The objective is to maximize the average grade, which means maximizing the total grade in the three courses. How should the student allocate her time?..

Discuss prevalence information for gender differences : Provide overall prevalence information. Discuss prevalence information for ethnic differences. Discuss prevalence information for gender differences

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:

Costs and benefits of outsourcing it : Analyze all of the costs and benefits of outsourcing IT, and present at least four well-supported reasons why the company should keep the department. Using all of your knowledge up to this point and any external sources necessary, create a present..

What percentage of customers must maintained to ensure good : Good People is currently selling beer for $3 per pint. The marginal cost of a pint is $.50. If we raise the price of the beer to $5, what percentage of customers must be maintained to ensure Good People at least stays even with the proposed price inc..

How big five personality test be useful in clinical way : Explain how the Big Five Personality test could be useful in a clinical way? This will probably require a little research

Determine how fast the oil is leaking from the tanker : It currently has a 50 m radius, and the radius is increasing at 0.05 m per second. Your job, as the tanker's captain, is to determine how fast the oil is leaking from the tanker.

User Account

All Pages