A machine part to be fabricated may be made from alloy of either of two metals. There is an order for 10,000 units. Metal A costs 3 pesos per kg, while Metal B costs 9 pesos per kg. If Metal A is used, the material per unit weighs 110 grams; for metal B, 30 grams. When metal A is used, 50 units can be produced per hour; for metal B, 80 units per hour. Metal B fabrication requires the aid of a tool costing P1,000, which will be useless after the 10,000 units are finished. The machine operator's wage is P50 per hour. If all other costs are identical, determine which material will be more economical to finish the 10,000-unit order. How much is the total cost difference between the use of metal A and metal B?

A machine part to be fabricated may be made from alloy of either of two metals. There is an order for 10,000 units. Metal A costs 3 pesos per kg, while Metal B costs 9 pesos per kg. If Metal A is used, the material per unit weighs 110 grams; for metal B, 30 grams. When metal A is used, 50 units can be produced per hour; for metal B, 80 units per hour. Metal B fabrication requires the aid of a tool costing P1,000, which will be useless after the 10,000 units are finished. The machine operator's wage is P50 per hour. If all other costs are identical, determine which material will be more economical to finish the 10,000-unit order. How much is the total cost difference between the use of metal A and metal B?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
A factory has two stations, station X and station Y. There are two different types of units, flow units A, and flow units B. The table below includes details about how long each unit type spends at each station: Flow Unit A Flow Unit B Station X 6 min 5 min Station Y 15 min 4 min The demand rate: Flow units A: 10 units per hour. Flow units B: 15 units per hour There are 4 machines at station X and 2 machine at station Y. What is the flow rate for unit B?
The Electrocomp Corporation manufactures two electrical products: air conditioners and large fans. The assembly process for each is similar in that both require a certain amount of wiring and drilling. Each air conditioner takes 3 hours of wiring and 2 hours of drilling. Each fan must go through 2 hours of wiring and 1 hour of drilling. During the next production period, 240 hours of wiring time are available and up to 140 hours of drilling time maybe used. Each air conditioner sold yields a profit of $25. Each fan assembled may be sold for a $15 profit. Formulate and solve this LP production mix situation to find the best combination of air conditioners and fans that yields the highest profit. Use the corner point graphical approach
A company manufactures both mountain bikes and trail bikes. The cost of materials for a mountain bike is $60, and the cost of materials for a trail bike is $40. The cost of labor to manufacture a mountain bike is $80, and the cost of labor to manufacture a trail bike is $60. During a week in which the company has budgeted $1,800 for materials and $2,500 for labor, how many mountain bikes does the company plan to manufacture? mountain bikes
Dalton Desk makes two different types children's desks: a regular model (R) and a deluxe model (D) with an extra shelf for book storage. Both types of desks go through Daltons' three production departments: fabrication, assembly, and packing/shipping, but required a different number of minutes in each department. For example, the regular desk needs 60 minutes of fabrication time, 45 minutes of assembly, and 15 minutes in packing & shipping. The deluxe model needs 120 minutes of fabrication time, 60 minutes in assembly, and 20 minutes in packing & shipping. Dalton has 850 hours of production time available in fabricating department, 450 hours available in its assembly department, and 200 hours available in its packaging and shipping department. Dalton reports unit profits of $6 and $8 for its regular and deluxe desks, respectively. What is the objective function? What is the fabrication constraint? What is the assembly constraint?What is the Shipping and Packing constraint?
A machine shop manufactures two types of bolts. The bolts require time on each of the three groups of machines, but the time required on each group differs, as shown in the table below. Type I Type IIMachine 1 0.2 min 0.2 minMachine 2 0.6 min 0.2 minMachine 3 0.04 min. 0.08 min Production schedules are made up one day at a time. In a day, 300, 720, and 100 minutes are available, respectively, on these machines. Type I bolts sell for 15¢ and type II bolts for 20¢. (a) How many of each type of bolt should be manufactured per day to maximize revenue?(b) What is the maximum revenue?(c) Suppose the selling price of type I bolts began to increase. Beyond what amount would this price have to increase before a different number of each type of bolts should be produced to maximize revenue?
A small scale industry manufactures electrical regulators, with a small group of semi-skilled workers both male and female. Due to limitations in space and finance, the number of workers employed cannot exceed 11 and their total salary cannot be more than Rs60, 000 per month. The male workers are paid Rs.6000 per month while the female workers are paid Rs. 5000 per month. It has been found that the male workers are swifter and since they are willing to work overtime, they contribute Rs.10, 000 per month as compared to Rs.8500 from their female counterparts. Apart from their salary, food coupons are provided: 6 coupons to per male employee and 5 coupons to per female employee. However, the total maximum amount of coupons that can be distributed are only 90. a) Formulate the model and find out how many male and female members should the company employ so as to maximize their contribution? b) If they make the female compensation equal to their male counterpart, should there be…
Schmidt Industries makes four different snake traps; the Harlan, the Gaylen, the Leah, and the Matthew. The Harlan sells for $200 and has $40 in parts and $40 in labor; the Gaylen sells for $150 and requires $30 in parts and $30 in labor; the Leah sells for $100 and has $20 in parts and $20 in labor, and the Matthew sells for $75 but requires only $10 of parts and $10 of labor. Schmidt Industries has four machines (we'll call them A, B, C, and D for convenience) that are used in the production of each of these products. Each of these machines is available for 40 hours a week and there is no setup time required when shifting from the production of one product to any other. The processing requirements to make one unit of each product are shown in the table. Processing Time on Each Machine in Minutes Model Machine A Machine B Machine C Machine D Harlan 10 15 15 5 Gaylen 10 10 10 10 Leah 5 10 15 10…
The Electrocomp Corporation manufactures two electrical products: air conditioners and large fans. The assembly process for each is similar in that both rquire a certain amount of wiring and drilling. Each air condtioner takes 3 hours of wiring and 2 hours of drilling. During the next production period, 240 hours of wiring time are available, and up to 140 hours of drilling time may be used. Each air conditioner sold yieds a profit of $25. Each fan assembled may be sold for a $15 profit. Formulate the best combination of air conditioners and fans that yiedls the highest profit. Use the corner point graphical approach.
You are thinking of making your home more energy efficient by replacing some of the light bulbs with compact fluorescent bulbs and insulating part or all of your exterior walls. Each compact fluorescent light bulb costs $4 and saves you an average of $2 per year in energy costs, and each square foot of wall insulation costs $1 and saves you an average of $0.20 per year in energy costs.† Your home has 50 light fittings and 1,500 square feet of uninsulated exterior wall. You can spend no more than $1,600 and would like to save as much per year in energy costs as possible. How many compact fluorescent light bulbs and how many square feet of insulation should you purchase? (If an answer does not exist, enter DNE.) compact fluorescent light bulbs bulbsinsulation sq ft How much will you save in energy costs per year? $
A small firm makes three similar products, which all follow the same three-step process, consisting of milling, inspection, and drilling. Product A requires 12 minutes of milling, 5 minutes forinspection, and 10 minutes of drilling per unit; product B requires 10 minutes of milling, 4 minutesfor inspection, and 8 minutes of drilling per unit; and product C requires 8 minutes of milling, 4minutes for inspection, and 16 minutes of drilling. The department has 20 hours available duringthe next period for milling, 15 hours for inspection, and 24 hours for drilling. Product A contributes$2.40 per unit to profit, product B contributes $2.50 per unit, and product C contributes $3.00 perunit. Determine the optimal mix of products in terms of maximizing contribution to profits for theperiod. Then, find the range of optimality for the profit coefficient of each variable.
Solve the question below using the attached excel templates with formulas for renting both slow and fast copies (labeled in the excel tabs). Question: The Decision Sciences Department is trying to determine whether to rent a slow or a fast copier. The department believes that an employee’s time is worth $15 per hour. The slow copier rents for $4 per hour, and it takes an employee an average of 10 minutes to complete copying. The fast copier rents for $15 per hour, and it takes an employee an average of six minutes to complete copying. On average, four employees per hour need to use the copying machine. (Assume the copying times and interarrival times to the copying machine are exponentially distributed.) Which machine should the department rent to minimize expected total cost per hour?