A foundry that specializes in producing custom blended alloys has received an order for 1 000...

A foundry that specializes in producing custom blended alloys has received an order for 1 000 kg of an alloy containing at least 5% chromium and not more than 50% iron. Four types of scrap which can be easily acquired can be blended to produce the order. The cost and metal characteristics of the four scrap types are given below: Scrap type Item 1 2 3 4 Chromium 5% 4% - 8% Iron 40% 80% 60% 32% Cost per kg R6 R5 R4 R7 The purchasing manager has formulated the following LP model: Minimise COST = 6M1 + 5M2 + 4M3 + 7M4 subject to 0,05M1 + 0,04M2 + 0,08M4 ≥ 50 (CHRM) 0,40M1 + 0,80M2 + 0,60M3 + 0,32M4 ≤ 500 (IRON) M1 + M2 + M3 + M4 = 1000 (MASS) and all variables ≥ 0, where Mi = number of kg of scrap type i purchased, i=1,2,3,4. (a) Solve this model using LINGO or SOLVER. (b) Write down the foundry's optimal purchasing plan and cost. Based on your LINDO or SOLVER solution answer the following questions by using only the initial printout of the optimal solution. (This means that you may not change the relevant parameters in the model and do reruns.) (c) How good a deal would the purchasing manager need to get on scrap type 1 before he would be willing to buy it for this order? (d) Upon further investigation, the purchasing manager finds that scrap type 2 is now being sold at R5,40 per kg. Will the purchasing plan change? By how much will the cost of purchasing the metals increase? (e) The customer is willing to raise the ceiling on the iron content in order to negotiate a reduction in the price he pays for the order. How should the purchasing manager react to this? (f) The customer now specifies that the alloy must contain at least 6% chromium. Can the purchasing manager comply with this new specification? Will the price charged for the order change?

Solutions

Expert Solution

Sol:- (a) The output using SOLVER

(b)

Formula:-

Sensitivity Report

Colby Messinger answered 1 year ago

Next > < Previous

Related Solutions

Question 1 [35 marks] A foundry that specializes in producing custom blended alloys has received an...

Question 1 [35 marks] A foundry that specializes in producing custom blended alloys has received an order for 1 000 kg of an alloy containing at least 5% chromium and not more than 50% iron. Four types of scrap which can be easily acquired can be blended to produce the order. The cost and metal characteristics of the four scrap types are given below: Scrap type Item 1 2 3 4 Chromium 5% 4% - 8% Iron 40% 80% 60%...

Question 1 [35 marks] A foundry that specializes in producing custom blended alloys has received an...

Question 1 [35 marks] A foundry that specializes in producing custom blended alloys has received an order for 1 000 kg of an alloy containing at least 5% chromium and not more than 50% iron. Four types of scrap which can be easily acquired can be blended to produce the order. The cost and metal characteristics of the four scrap types are given below: Scrap Type Item 1 2 3 4 Chromium 5% 4% - 8% Iron 40% 80% 60%...

Question 1 [35 marks] A foundry that specializes in producing custom blended alloys has received an...

#1 The Dorilane Company specializes in producing a set of wood patio furniture consisting of a...

#1 The Dorilane Company specializes in producing a set of wood patio furniture consisting of a table and four chairs. The set enjoys great popularity, and the company has ample orders to keep production going at its full capacity of 4,200 sets per year. Annual cost data at full capacity follow: Direct labor $ 91,000 Advertising $ 102,000 Factory supervision $ 67,000 Property taxes, factory building $ 18,000 Sales commissions $ 60,000 Insurance, factory...

1. A Scrap metal dealer has received a bulk order from a customer for a supply...

1. A Scrap metal dealer has received a bulk order from a customer for a supply of at least 2000 kg of scrap metal. The consumer has specified that at least 1000 kgs of the order must be high quality copper that can be melted easily and can be used to produce tubes. Further, the customer has specified that the order should not contain more than 200 kgs of scrap which are unfit for commercial purposes. The scrap metal dealer...

1- Special Order Pope Company manufactures a variety of hiking boots and has received a special...

1- Special Order Pope Company manufactures a variety of hiking boots and has received a special one-time-only order from a new customer. Pope has sufficient idle capacity to accept the special order to manufacture 500 pairs of boots at a price of $45.00 per pair. Pope’s normal selling price is $65.00 per pair of boots. Variable manufacturing costs are $35.00 per pair and fixed manufacturing costs are $12.00 a pair. Pope’s variable selling expense for its normal line of boots...

Peak Bikes, a national bicycle manufacturing company that specializes in producing off-road bicycles (mountain bikes), has...

Peak Bikes, a national bicycle manufacturing company that specializes in producing off-road bicycles (mountain bikes), has hired you as an outside consultant. Peak Bikes currently has 170 both full-time and part-time employees. The firm’s management is organized as follows: Frontline managers: Oversee bike production and production staff. This is the part of the company that actually manufacturers the bicycles. Middle-level managers: Manage frontline managers, track performance versus company’s goals and strategy, and report to top level managers Top-level managers: Set...

Dec.Dec. 1 CosmoCosmo contributed $ 20 comma 000$20,000 cash in exchange for capital. 2 Received $...

Dec.Dec. 1 CosmoCosmo contributed $ 20 comma 000$20,000 cash in exchange for capital. 2 Received $ 2 comma 600$2,600 cash from customers for services performed. 5 Paid $ 250$250 cash for office supplies. 9 Performed services for a customer and billed the customer for services rendered, $ 2 comma 500$2,500. 10 Received $ 700$700 invoice for utilities due in two weeks. 15 Paid for advertising in the local paper, $ 475$475. 20 Paid utility invoice received on Dec.Dec. 10. 25...

Vines Ltd produces custom machine parts on a job order basis. The company has two direct...

Vines Ltd produces custom machine parts on a job order basis. The company has two direct product cost categories: direct materials and direct labour. In the past, indirect manufacturing costs were allocated to products using a single indirect cost pool, allocated based on direct labour hours. The indirect cost rate was $115 per direct labour hour. The managers of Vines Ltd decided to switch from a manual system to software programs that release materials and signal machines when to begin...

Carney Corporation has received a request for a special order of 4,000 units of product F65...

Carney Corporation has received a request for a special order of 4,000 units of product F65 for $27.60 each. Product F65's unit product cost is $25.80, determined as follows: Direct labor is a variable cost. The special order would have no effect on the company's total fixed manufacturing overhead costs. The customer would like modifications made to product F65 that would increase the variable costs by $4.00 per unit and that would require an investment of $20,000 in special molds...

Subjects