A manufacture is producing three types of pliers – economy, standard and deluxe – with this “unit information”
Economy Standard Deluxe
Selling Price $3.00 Selling Price $4.00 Selling Price $5.00
Metal Required- 3 oz Metal Required 7oz Metal Required 6 oz
Time Required- 10min Time Required 12 min Time Required 15 min
There is no limit on the amount of metal he can use – he only has 1,400 ounces of metal. There is also no limit on the minutes of labor he can use- he only has 4,000 minutes of labor. Each ounce of metal costs $0.04 and each minute of labor costs $0.20. The manufacturer wants to make the most money he could make and he defines his “profit” as “total revenue” which is price X quantity, less the ‘cost of resources’
A) Build a “influence chart” ( with mathematical Operators adn Shapes) that shows the influence among these items:
PROFIT COST OF LABOR USED
METAL USED UNIT SELLING PRICE
LABOR USED QUANTITY MADE
TOTAL REVENUE METAL PER UNIT
MINUTES PER UNIT COST PER OUNCE
COST OF RESOURCES USED COST PER MINUTE
COST OF METAL USED
B) Indicate it the items are: dependent variables (DV), independent variables ( IND.V), intermediate variables ( INT.V.) or constants (C).
C) Show in a spreadsheet the manufacturing process.
D) Use Whats Best or Microsoft Solver for the Problem.
