JN Company manufactures two products that use material 1, material 2, andmaterial 3. Consider the following table:Resources neededMaterial 1Material 2Material 3Price per Unit in PesosRequirement per UnitProduct 1220150Product 2314200a. Write the linear programming model for this problem.b. Present the optimal solution and interpret the result.Maximum Availability(units)12001000800c. Determine the status of each resource.d. Determine the dual prices for the materials 1, 2 and 3. Explain each value.e. Determine the feasibility ranges for the dual prices obtained in (d).f. If the available number of material 1 is increased to 1300 units, find the new optimumsolution.g. Find the range of optimality for (i.) product 1 and (ii.) product 2 for which the optimal.solution remains valid.

Linear programming is a mathematical technique that is also used in operations management…

Answered: a. Write the linear programming 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?
The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.
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.
Data collected on the yearly demand for 50- pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Estimate demand for vear 12 with a weighted moving average in which sales in the most recent year are given a weight of 2 and sales in the other two years are each given a weight of 1. Year Demand (Bags) 4 6. 3 4. 4. 10 6 8. 8. 8. 12 10 14 11 15 O A. 13.67 O B. 14.00 OC. 14.87 O D. 11.79 Click to select your answer. Us MacBook Air 888 * ES F2 F4 F6 F7 4) F9 F10 %23 2$ & * 4 6. 7 8 9. Q W R T Y F C V В alt command command option %#3
Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows: MONTH DEMAND (UNITS) January 4,150 February 4,250 March 3,950 April 4,350 May 4,950 June 4,650 July 5,250 August 4,850 September 5,350 October 5,650 November 6,250 December 5,950 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.8. (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this…
Kpogas produces chairs and tables. Using economic forecast for the next month, Kpogas’ marketing manager has judged that during that period, it will be possible to sell as many chairs or tables as the company can produce. Management must now recommend a production target for next month. That is, how many chairs and tables should be produced if Kpogas’ management wishes to maximize next month’s profit contribution? Making this decision requires a consideration of the following key factors: ● Kpogas’s unit contribution margin is GH¢ 5,000 on each chair that is sold and GH¢ 4,000 on each table that is sold. ● Each product is put through Kpogas’s machining operations in both department A and department B. For next month’s production, the two departments have 150 and 160 hours available time, respectively. Each chair produced uses 10 hours of machining in department A and 20 hours of machining in department B, whereas each table produced uses 15 hours of machining in department A and 10…
The distribution of daily demand for party cakes at a bakery is shown in the following table: Relative Frequency Demand 0.08 18 0.02 21 0.02 34 0.04 43 0.07 56 0.38 67 0.12 87 0.27 114 Determine the optimal number of cakes to make each day if labour and material are estimated to cost $35.455 per unit. Cakes are sold for $50.65 per unit, and leftover cakes at the end of the day are sold next day at half price. a. 114 b. 67 c. 87 d. 43 e. 56
PROBLEM The Seminole Company wishes to apply the Miller-Orr model to manage its cash investment. Seminole’s management has determined that the cost of either investing in or selling marketable securities is $200. By looking at Seminole Company’s past cash needs, they have determined that the variance of daily cash flows is $10,000. Seminole Company’s opportunity cost of cash, per day, is estimated to be 0.05%. Seminole management has figured, based on their experience dealing with the cash flows of the company, that there should be a cushion— a safety stock—of cash of $20,000. 1. How much is the variance of daily cash flows? (Use a number, no decimal value, no commas, no currency, no space) * 2. How much is the opportunity cost of cash, per day? (Use a number, must be in decimal form. eg. 6.3%/100, encode 0.063 , no commas, no currency, no space) * 3. How much is the cost per transaction? (Use a number, no decimal value, no commas, no currency, no space) * PLEASE ANSWER ALL QUESTIONS.…
3. As manager of the St. Cloud Theater Company, you have decided that concession sales would support themselves. The following table provides the information you have been able to put together thus far: Item Softdrink Selling Price $1.00 Variable Cost $0.65 Percent of Revenue Wine Coffee 1.75 1.00 0.95 0.30 25 25 30 Candy 1.00 0.30 20 Last year's manager. Jim Freeland, has advised you to add 10% of variable cost as a waste allowance for all categories. You estimated labor cost to be $250.00 (5 booths with 2 people each). Even if nothing is sold, your labor cost will be $250.00, so you decide to consider this as fixed cost. Booth rental, which is a contractual cost of $50.00 for each booth per night, is also a fixed cost. a. What is the break-even volume per evening of performance? b. How mush would you expect to sell each evening at the break-even point?
Roger Co. implemented activity-based costing in the current year. To select the appropriate driver for Cost Pool A, Roger performed regression analyses for two independent variables, Driver 1 and Driver 2, using monthly operating data. The monthly levels of Cost Pool A were the dependent variables in both regressions. Output results from the regression analyses were as follows: Driver 1 R squared Intercept X variable (slope) At the budgeted production level for next month, the levels of Driver 1 and Driver 2 are expected to be 5,880 and 7,000, respectively. Based on this information, what is the budgeted amount for Cost Pool A for next month? O A. $3,280 OB. $2,624 O C. $3,464 O D. $3,785 0.46 $551.00 Driver 2 $0.55 0.80 $970.00 $0.33
The distribution of daily demand for party cakes at a bakery is shown in the following table: Relative Frequency Demand 0.05 10 0.03 22 0.05 37 0.06 45 0.03 53 0.39 61 0.19 88 0.2 111 Determine the optimal number of cakes to make each day if labour and material are estimated to cost $26.985 per unit. Cakes are sold for $38.55 per unit, and leftover cakes at the end of the day are sold next day at half price. O a. 45 O b. 88 Oc. 61 O d. 111 O e. 53

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

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

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

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

SEE MORE TEXTBOOKS

a. Write the linear programming model for this problem. b. Present the optimal solution and interpret the result. c. Determine the status of each resource.