2. The making of rivet holes in structural steel members can be done by two methods.The first method consists of laying out the position of the holes in the members andusing a drill press costing Php 30,000. The machinist is paid Php 20 per hour and hecan drill 30 holes per hour.The second method makes use of a multiple-punch machine costing Php 27,500. Thepunch operator is paid Php 18 an hour and he can punch out 4 holes every minute.This method also requires an expense of Php 0.70 per hole to set the machine.a. If all other costs are assumed equal, what is the total cost for each machine for6,000 holes, assuming that the total cost of each machine is charged to theseholes?b. For how many holes will the costs be equal?

Answered: Image /qna-images/answer/427ae819-a8d5-46e8-9208-48c27310b97d.jpg

Answered: a. II all other costs are assumed…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

A young engineer is considering establishing his own small company.An investment of Php 100,000 will be required which must be recovered in 15years . It is estimated that sales will be Php 150,000 per year and thatoperating expenses will be as follows:Material Php 40,000 per yearLabor Php 70,000 per yearOverhead Php 10,000 + 10% of sales/yearSelling expenses Php 5,000/yearThe young engineer will give up his regular job paying Php 150,000 per yearand devote full time to the operation of the business. This will result indecreasing labor by Php 10,000 per year , material cost by Php 7000 peryear, and overhead cost by Php 8000 per year. If the young engineer expectsto earn at least 20% on his capital, should he invest ?
For a table manufacturing company, selling price for a table is $183.00 per Unit, Variable cost is $25.00 per Unit, rent is $3,380.00 per month and insurance is $296.00 per month. Company wants to expand its business and improve the table quality, it wants to increase the selling price for a table to $254.00 per Unit, Variable cost to $43.00 per Unit, bigger area will have rent $5,235.00 per month and insurance is $362.00 per month At what point will the company be indifferent between the current mode of operation and the new option?
IndahKiat has a daily budget of 320 hours of labor and 350 units of raw material to manufacture two products. If necessary, the company can employ up to 10 hours daily of overtime labor hours at the additional cost of RM2 an hour. It takes 1 labor hour and 3 units of raw material to produce one unit of product 1, and 2 labor hours and 1 unit of raw material to produce 1 unit of product 2. The profit per unit of product 1 is RM10, and that of product 2 is RM12. Let x1 and x2 define the daily number of units produced of product 1 and product 2, and x3 the daily hours of overtime used. The LP model is then given as Max z = 10x1 + 12x2 – 2x3 subject to x1 + 2x2 – x3 £ 320 (Labor hours) 3x1 + x2 £ 350 (Raw material) x3 £ 10 (Overtime) x1, x2, x3 ³ 0. Required 1. Determine the optimal solution. 2. Identify the optimal inverse matrix.
A gold mining area in Lanao contains on average 1 ounce of gold per ton. Two methods of processing are available; method a cost 1.5m per ton and recovers 90% of gold: method b cost 1.3m per ton and recovers 80% of the gold. If gold can be sold for 2.4m per ounce which method is better and by how much
A company manufactures two products X1 and X2 on three machines A, B, and C. X1 require 1 hour on machine A and 1 hour on machine B and yields a revenue of Php 30. Product X2 requires 2 hours on machine A and 1 hour on machine B and 1 hour on machine C and yields revenue of PhP 50. In the coming planning period the available time of three machines A, B, and C are 2000 hours, 1500 hours and 600 hours respectively. Find the optimal product mix. Use MS Excel Solver.
Manny Billard Real Estate Company has PHP 2 million available for the purchase of new rental property. After an initial screening, Billard reduced the investment alternatives to townhouses and apartment buildings. Each townhouse can be purchased for PHP 282,000, and five are available. Each apartment building can be purchased for PHP 400,000, and the developer will construct as many buildings as Billard wants to purchase. Billard property manager can devote up to 140 hours per month to these new properties; each townhouse is expected to require 4 hours per month, and each apartment building is expected to require 40 hours per month. The annual cash flow, after deducting mortgage payments and operating expenses, is estimated to be PHP10,000 per townhouse and PHP15,000 per apartment building. How many townhouses would have left (unpurchased) if Billard will go for the optimal solution?
A wood products firm uses available time at the end of each week to make goods for stock.Currently, two products on the list of items are produced for stock: a chopping board and a knifeholder. Both items require three operations: cutting, gluing, and finishing. The manager of thefirm has collected the following data on these products.TIME PER UNIT (MINUTES)Item Profit/Unit Cutting Gluing FinishingChopping board $2 1.4 5 12Knife holder $6 0.8 13 3The manager has also determined that, during each week, 56 minutes are available for cutting, 650minutes are available for gluing, and 360 minutes are available for finishing.a. Determine the optimal quantities of the decision variables if the goal is to maximize profit.b. Which resources are not completely used by your solution? How much of each resource isunused?
2. As part of a quality improvement initiative, Consolidated Electronics employees complete a three-day training program on teaming and a two-day training program on problem solving. The manager of quality improvement has requested that at least 8 training programs on teaming and at least 10 training programs on problem solving be offered during the next six months. In addition, senior-level management has specified that at least 25 training programs must be offered during this period. Consolidated Electronics uses a consultant to teach the training programs. During the next quarter, the consultant has 84 days of training time available. Each training program on teaming costs $10,000 and each training program on problem solving costs $8000. a. Formulate a linear programming model that can be used to determine the number of training programs on teaming and the number of training programs on problem solving that should be offered in order to minimize total cost. b. Determine the optimal…
SIMPLEX METHOD A factory makes tennis rackets and cricket bats. A tennis racket takes 1.5 hours of machine time and 3 hours of craftsman’s time in its making while a cricket bat takes 3 hour of machine time and 1 hour of craftsman’s time. In a day, the factory has the availability of not more than 42 hours of machine time and 24 hours of craftsman’s time. If the profit on a racket and on a bat is Php 20.00 and Php 10.00 respectively, find the maximum profit of the factory when it works at full capacity.
Green Vehicle Inc., manufactures electric cars and small delivery trucks. It has just opened a new factory where the C1 car and the T1 truck can both be manufactured. To make either vehicle, processing in the assembly shop and in the paint shop are required. It takes 1/40 of a day and 1/75 of a day to paint a truck of type T1 and a car of type C1 in the paint shop, respectively. It takes 1/45 of a day to assemble either type of vehicle in the assembly shop. A T1 truck and a C1 car yield profits of $275 and $225, respectively, per vehicle sold. The aim of the objective function for Green Vehicle Inc. should be to Maximize the objective value. The optimum solution is: Number of trucks to be produced per day = nothing (round your response to two decimal places).
Green Vehicle Inc., manufactures electric cars and small delivery trucks. It has just opened a new factory where the C1 car and the T1 truck can both be manufactured. To make either vehicle, processing in the assembly shop and in the paint shop are required. It takes 1/25 of a day and 1/60 of a day to paint a truck of type T1 and a car of type C1 in the paint shop, respectively. It takes 1/45 of a day to assemble either type of vehicle in the assembly shop. A T1 truck and a C1 car yield profits of $300 and $220, respectively, per vehicle sold. The optimum solution is: Number of trucks to be produced per day = ? (round your response to two decimal places).
Green Vehicle Inc., manufactures electric cars and small delivery trucks. It has just opened a new factory where the C1 car and the T1 truck can both be manufactured. To make either vehicle, processing in the assembly shop and in the paint shop are required. It takes 1/25 of a day and 1/60 of a day to paint a truck of type T1 and a car of type C1 in the paint shop, respectively. It takes 1/45 of a day to assemble either type of vehicle in the assembly shop. A T1 truck and a C1 car yield profits of $300 and $220, respectively, per vehicle sold. The aim of the objective function for Green Vehicle Inc. should be to Maximize the objective value. Part 2 The optimum solution is: Number of trucks to be produced per day = ? enter your response here

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

a. II all other costs are assumed equal, what is the total cost for each machine for 6,000 holes, assuming that the total cost of each machine is charged to these holes? b. For how many holes will the costs be equal?