Answered: Give the logical sequence of steps for…

Business

Operations Management

Give the logical sequence of steps for formulating and constructing a (structured) LP model.

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

Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
What is the purpose of the SCOR Model and what are the five basic functions of the SCOR Model?
SIMPLEX METHOD: Min C = 3X1 + 7X2 + 5X3 Subject to: X1 + X2 + X3 > 50 2X1 + 3X2 + X3 > 100 Based on the initial tableau, answer questions no. 1-5 What is the value of X3 on the Cj row? What is the value of S2 on the right-hand side/quantity column? What is the value of Zj on the right-hand side/quantity column? What is the value of X3 on the Cj – Zj row? What is the entering variable?
BicycleBro is a retailer that sells bicycles. The company had been operating for 30 days (1 month). By the end of 1 month it wants to measure its performance in terms of Inventory turnover and Days of inventory. Below is the information that the company has collected from its warehouse and accounting department Stock Count Sheet Item code Stock on hand Stock count week (week number when employees counted the stock on hand) 100 30 week1 200 10 week1 100 10 week3 200 20 week3 Inventory valuation Item code Value per unit (in $) 100 1000 200 2000 Bicycles sold by end of month Item code Units sold 100 5 200 10 Given the information above find What is the total inventory turnover rate for given period? What is the total Inventory Days of Sales for given period?
Suppose the government imposes a per-unit tax on the buyers of instant noodles. Does it necessarily mean that the buyers have to bear the entire tax burden? Explain with a diagram. With the above diagram, explain the impact of the per-unit tax on the consumer surplus, producer surplus and total surplus.
Given the following forecast and cost information, Regular time cost $ 40.00 per unitdetermine the total cost of a plan that uses regular time Overtime cost $ 60.00 per unitproduction output of 600 units per month, overtime is subcontracting cost $ 80.00 per unitused when needed up to a maximum of 60 units per holding cost $ 10.00 per unit per monthmonth, and subcontracting is used if additional units are needed to meet the forecast.Month Forecast1 5702 6003 6304 6505 6706 690Totals
This type of operational planning may cover the medium‐term needs of the business including budgeting, the purchasing and supply system and organisation thereof, purchasing and supply methods, negotiation and development of human resources. (1) Strategic level planning. (2) Tactical or middle‐management planning. (3) Operations level planning. (4) Operational planning. (5) Short‐term planning. This is in fact a production or operations scheduling system and not an inventory control system. It eliminates the holding of inventory and is based on requiring suppliers to deliver materials of the right quality to the business on the day they are needed and where they are needed. (1) Cyclical‐ordering system. (2) Materials‐requirements planning. (3) Just in time. (4) System of fixed‐order quantities. (5) Quick response system.
How do non-linear system models differ from linear models, and what are the challenges associated with analyzing and controlling them?
Production and Materials Purchases Budgets White Corporation’s budget calls for the following sales for next year:Quarter 1 90,000 units Quarter 3 68,000 unitsQuarter 2 76,000 units Quarter 4 96,000 unitsEach unit of the product requires 3 pounds of direct materials. The company’s policy is to begineach quarter with an inventory of product equal to 5% of that quarter’s estimated sales requirementsand an inventory of direct materials equal to 20% of that quarter’s estimated direct materials requirements for production.Required Determine the production and materials purchases budgets for the second quarter.
Is the organization in a good position to take on additional debt? Use the Hillside, Inc. Balance Sheet information in cells A2 through D18 and cells A21 through B38 to complete the Financial Performance Calculations in cells A40 through C60. Table 1: Hillside, Inc. Balance Sheet ($ in Millions) ASSETS LIABILITIES Cash & Marketable Securities 449.90 Accounts Payable 1,611.20 Accounts Receivable 954.80 Salaries Payable 225.20 Inventories 3,645.20 Other Current Liabilities 1,118.80 Other Current Assets 116.60 Total Current Liabilities 2,955.20 Total Current Assets 5,165.27 Other Liabilities 693.40 Machinery & Equipment 1,688.90 Land 1,129.70 Total Liabilities 3,648.60 Buildings 2,348.40 Depreciation (575.60)…
One of the products of Edwards Lifesciences (EL) is artificial heart valves made from the heart valves of pigs.8 Different sizes of valves are required. However, the size of a pig's heart valve cannot be ascertained before the heart is purchased and opened. Therefore, EL has a mismatch problem: shortages of some sizes and excess of others. A program was established to document the size distribution of valves supplied by each supplier, and purchases were made from those suppliers with the needed sizes. Linear programming was used to determine the set of the suppliers that collectively satisfied EL's demand. Suppose EL purchases pig valves from three suppliers. The cost and size mix of the valves purchased from each supplier are given in the table below. Each month EL places one order with each supplier. Suppose next month, 250 large, 300 medium, and 100 small valves are needed. Formulate an LP that can be used to minimize the cost of acquiring the needed valves and use Excel's Solver to…