The owner of a machine shop is planning to expand bypurchasing some new machines-presses and lathes. Theowner has estimated that each press purchased will increaseprofit by P5000 per day and each lathe will increase profit byP7500 daily. The number of machines the owner canpurchase is limited by the cost of the machines and theavailable floor space in the shop. The machine purchaseprices and space requirements are as follows:Required FloorSpace (m2).Purchase PricePress1.4P400,000Lathe2.8200,000The owner has a budget of P2,200,000 for purchasingmachines and 22 square meters of available floorspace. a. Formulate an integer programming model to determinehow many of each type of machine to purchase tomaximize the daily increase in profit.b. Solve the model formulated in part (a) without integerrequirements. What are the optimal solution for the press andthe lathe machines? What is the optimal profit?c. Round the press and lathe values found in part (b). Is thesolution feasible? Why?d. Truncate the press and lathe values found in part (b) (i.edrop the fractional part of each value). Is the solutionfeasible? Why?e. Add integer requirements to the model you constructed inpart (b). What is the optimal profit and what are the optimalnumber of press and lathe machines?

Note: - As we can answer up to three subparts we will answer the first three subparts(a, b, and c)…

Answered: The owner of a machine shop is planning…

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

. The Newcoat Painting Company has for some time been experiencing high demand for its automobile repainting service. Because it has had to turn away business, management is concerned that the limited space available to store cars awaiting painting has cost them in lost revenue. A small vacant lot next to the painting facility has recently been made available for rental on a long-term basis at a cost of $10 per day. Management believes that each lost customer costs $20 in profit. Current demand is estimated to be 21 cars per day with exponential interarrival times (including those turned away), and the facility can service at an exponential rate of 24 cars per day. Cars are processed on a FCFS basis. Waiting space is now limited to 9 cars but can be increased to 20 cars with the lease of the vacant lot.Newcoat wants to determine whether the vacant lot should be leased. Management also wants to know the expected daily lost profit due to turning away customers if the lot is leased. Only…
The Ace Manufacturing Company has orders for three similar products. Orders (units) Product Min A s.t. B с 1 Three machines are available for the manufacturing operations. All three machines can produce all the products at the same production rate. However, due to varying defect percentages of each product on each machine, the unit costs of the products vary depending on the machine used. Machine capacities for the next week and the unit costs are shown below. Machine 2 3 LB A C B с 1 Product 112₂ 3 Machine 1 Capacity Machine 2 Capacity Machine 3 Capacity 2,200 Product A Orders Product C Orders 400 xij≥0 for all i, j. 1,400 Product B Orders Capacity (units) 1,500 1,500 Use the transportation model to develop the minimum cost production schedule for the products and machines. (a) Show the linear programming formulation. (Let XA1 be the number of units of product A produced by machine 1, X;; be the number of units of product i produced by machine j, etc.) 1,100 $1.00 $1.30 $1.10 1 $1.20…
The school cafeteria can make pizza for approxi- mately $0.30 a slice. The cost of kitchen use and cafeteria staff runs about $200 per day. The Pizza Den nearby will deliver whole pizzas for $9 each. The cafeteria staff cuts the pizza into eight pieces and serves them in the usual cafeteria line. With no cooking duties, the staff can be reduced by half, for a fixed cost of $75 per day. Should the school cafeteria make or buy itspizzas?
Problem 4 A bakery needs to evaluate two oven solutions for its renovations. It is currently considering two possible ovens, a small one for $1,250 and a large one for $2,500. Its operating requirements are as follows Item Small Oven Large Oven 50 Batch size (units) Processing time (min/unit) Cleaning time (min) Heating time (min) 125 0.5 20 30 10 15 According to operating instructions, both the small and large ovens must be cleaned after each batch and properly heated before each batch can be processed. The bakery estimates the demand for the next few years to remain steady at 300,000 units per year. Currently, the company operates 8 hours a day (with no overtime allowed) and 300 days a year. a. Calculate the daily production capacity of each oven (small and large). b. How many of the small ovens are needed to meet the production demand? What is the total cost? c. How many of the large ovens are needed to meet the production demand? What is the total cost? d. Calculate the rate of…
DJA Trucking Co. owns several truck used in hauling crushed stones from three different plants to three road projects in Pampanga. The contractor in charge of the project gives the company the ff. Projec A B C F/T X Y Z Requirement per week 150 175 140 A B P100 P200 150 175 200 500 C P75 225 125 Plants X Y Z Available per week 145 160 160 Compute for the optimal hauling schedule and the total transportation costs. (Use stepping stone and Least Cost Method (minimum entry method))
Cairney, Incorporated manufactures a specialized part used in internal combustion engines. The annual demand for the part is 249,000 units. The facility has a practical capacity of 264,000 units annually. The company leased the current facility because facilities capable of manufacturing the unit require machines that can produce 66,000 units each. The annual cost of the facility is $1,013,760. The variable cost of a part is $4. Required: What cost per unit should the cost system report to facilitate management decision making? Note: Round your answer to 2 decimal places. What is the cost of excess capacity? cost per unit cost of excess capacity
A machine is currently broken and not working . To fix the machine , 4 robotic processors of the brand DURIO with capacity of 39 teraflops must be replaced , and 27 special gears must be deeply cleaned by a mechanic . The purchase of the DURIO robotic processors is a problem that must be solved : the company that makes the DURIO processors is no longer existent , since they went to out - of - business last year . So a new supplier must be found , and quickly . Company ROGA - TED is offering to manufacture such processors for you . They manufacture similar robotic processors but for different capacities : they have never made a 39 teraflop processor before . However , ROGA - TED announces that they will manufacture it for you , if you can provide a fair estimation of the price for the robotic processors . In your company's records , you see that these robotic processors were never replaced before , and so there is no pre - existing data for the price of such items . However , you find…
Charles Lackey operates a bakery in Idaho Falls,Idaho. Because of its excellent product and excellent loca-tion, demand has increased by 25% in the last year. On far toomany occasions, customers have not been able to purchasethe bread of their choice. Because of the size of the store, nonew ovens can be added. At a staff meeting, one employeesuggested ways to load the ovens differently so that moreloaves of bread can be baked at one time. This new processwill require that the ovens be loaded by hand, requiring addi-tional manpower. This is the only thing to be changed. If thebakery makes 1,500 loaves per month with a labor produc-tivity of 2.344 loaves per labor-hour, how many workers willLackey need to add? (Hint: Each worker works 160 hours permonth.)
13.2 A company manufactures component parts for machine tools in North America and ships them to Southeast Asia for assembly and sale in the local market. The components are shipped by sea, transit time averages 6 weeks, and the shipping costs $2700 per shipment. The company is considering moving the parts by air at an estimated cost of $7500; the shipment taking 2 days to get there. If inventory in transit for the shipment costs $125 per day, should they ship by air?
EFE company manufactures and sells boats. The company's management accountant gathered the following data to prepare budgets for 2012; Direct Materials Requirements Material A 12 metres per boat Material B 14 square meter per boat Inventory data of Direct Materials are; Beginning Inventory Material A 5.000 meters Material B 2400 square meters Inventory data of Finished Goods are; Beginning Inventory Target Ending Inventory Вoats 1.000 units 3.000 units Moreover, unit purchase price of material A was $60 and unit purchase price of material B was $10. For the coming year 2021 it is expected that unit purchase price of material A will be $64 and unit purchase price of material B will not change. The company uses FIFO inventory method. Labor hours required to produce 1 boat is 3 hours and the company plans to pay S12 per hour. Company budgeted manufacturing overhead rate of $6 per labor hour. Finally, the company expects to sell 4000 boats in 2021 at an average unit selling price of $6000.…
1. Foxie Owl’s Besty Bagel shop makes fresh bagels. She has to buy raw materials fresh every day for selling on that day. She wants to know exactly how much should she spend on raw materials. Foxie did some analysis over the past month and came back with the following numbers: Daily demand was equally likely to be 200, 225, 250, 275, or 300 bagels. What should be the number of bagels on hand to satisfy a Fill Rate requirement of 96%, rounded to next integer value? Group of answer choices 300 275 286 263 2. Suppose that instead of a discrete demand distribution, Foxie’s shop determines that the daily demand for bagels is normally distributed, with a mean of 250 and a standard deviation of 35. Foxie still wants a Fill Rate of 98%. What is the appropriate level of on-hand inventory for Foxie’s shop? Group of answer choices 263 274 257 270
LMNO Gaskets has formulated a production plan for a product to meet demand over the upcoming four quarters. Demand in each of the four quarters and production, overtime, and subcontracting capacities are reported in the table below, in addition to the feasible production plan. The relevant costs are: • Regular time production cost is $10/unit. Overtime production cost is $14/unit. Subcontracting cost is $18/unit Inventory is held at a cost of $1/unit/quarter. • Units may be backordered at a cost of $4/unit/quarter. Production Resource Regular Time Q1 Overtime Q1 Subcontract Q1 Regular Time Q2 Overtime Q2 Subcontract Q2 Regular Time Q3 Overtime Q3 Subcontract Q3 Demand in Quarter Demand in Quarter Q2 0 20 0 550 Q1 550 230 0 0 0 0 40 40 0 860 250 470 0 40 0 1330 What is the inventory cost for the year? What is the backorder cost for the year? What is the total cost for the year? Q3 0 0 0 0 0 30 510 160 0 700 What is the total overtime production cost for the year? Capacity 550 250 500…

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