A linear programming computer package is needed.Kilgore's Deli is a small delicatessen located near a major university. Kilgore does a large walk-in carry-out lunch business. The deli offers two luncheon chilispecials, Wimpy and Dial 911. At the beginning of the day, Kilgore needs to decide how much of each special to make (he always sells out of whatever hemakes). The profit on one serving of Wimpy is $0.46, on one serving of Dial 911, $0.59. Each serving of Wimpy requires 0.25 pound of beef, 0.25 cup of onions,and 5 ounces of Kilgore's special sauce. Each serving of Dial 911 requires 0.25 pound of beef, 0.4 cup of onions, 2 ounces of Kilgore's special sauce, and 5ounces of hot sauce. Today, Kilgore has 18 pounds of beef, 13 cups of onions, 86 ounces of Kilgore's special sauce, and 58 ounces of hot sauce on hand.(a) Develop an LP model that will tell Kilgore how many servings of Wimpy and Dial 911 to make in order to maximize his profit today. (Let W = the number ofservings of Wimpy to make and let D = the number of servings of Dial 911 to make.)Maxs.t.BeefOnionsSpecial SauceHot SauceW, D ≥ 0(b) Find an optimal solution. (Round your answers to two decimal places.)(W, D) =Profit = $(c) What is the dual value for special sauce? (Round your answer to two decimal places.)$Interpret the dual value.For every 1 ounce increase in ---Select---IO Nothe profit will ---Select--- by $(d) Increase the amount of special sauce available by 1 ounce and re-solve. (Round your answers to two decimal places.)(W, D) =Profit = $Does the solution confirm the answer to part (c)?Yes

Answered: Image /qna-images/answer/d6e288c6-b187-453a-918e-0f0abf9a2fc2.jpg

Answered: A linear programming computer package…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section2.5: Ordering With Quantity Discounts And Demand Uncertainty

Problem 7P

See similar textbooks

Similar questions

General Motors is trying to determine how frequently they should have tires delivered to their Flint, Michign truck assembly plant. The tires are large and expensive to hold in inventory, and there is also a sgiicant fee each te a tire delivery is made. Which of the following tools would be most useful in making this decision O A/F Ratio Method Newsvendor Model Base Stock Model Economic Order Quantity Model Minimum Cycle Length Model
An automotive warehouse stocks a variety of parts that are sold at neighborhoodstores. One particular part, a popular brand of oil filter, is purchased by thewarehouse for $1.50 each. It is estimated that the cost of order processing andreceipt is $100 per order. The company uses an inventory carrying charge based on warehouse for $1.50 each. It is estimated that the cost of order processing andreceipt is $100 per order. The company uses an inventory carrying charge based ona 28 percent annual interest rate.The monthly demand for the filter follows a normal distribution with mean280 and standard deviation 77. Order lead time is assumed to be five months.Assume that if a filter is demanded when the warehouse is out of stock, then thedemand is back-ordered, and the cost assessed for each back-ordered demand is$12.80. Determine the following quantities:a. The optimal values of the order quantity and the reorder level.b. The average annual cost of holding, setup, and stock-out associated…
Just need help finding the sausage constraint quantity value
Boston Company use a special part in manufacturing of its finished products. The unit cost thisspecial part is $ 35, and details of its manufacturing cost is as follows. The $35 unit productcost of this part is based on average 25,000 number of parts produced each year.An outside supplier has offered to supply the 25,000 parts at a cost of $30 per part. The specialequipment used to manufacture the above part. This equipment can only be used formanufacturing of this part and if not used it has no resale value.The total amount of general factory overhead, which is allocated based on direct labor-hours,would be unaffected by this decision because it is fixed cost..Suggest the management whether to stop producing internally and buy them from theoutside supplier?Description CAD Direct Materials 10Direct Labor 6Variable overheads…
Princetown paints ltd manufactures three basic types of paint. emulsion, gloss, and undercoat. using the same mixing machines and direct labour for each of the three products. the Management accountant of Princetown paints was faced with the task of arranging the weekly production for his company. information about the sale price and costs per 100 liters is given in the following table ( all figures in $). sales price per 100 liters ( emulsion 120), ( gloss 126), ( undercoat 110). variable cost per 100 liters ( emulsion 120), ( gloss 126), ( undercoat 110). direct material costs ( emulsion 11), ( gloss 25), ( undercoat 20). direct labour costs ( emulsion 30), ( gloss 36), ( undercoat 24). mixing costs ( emulsion 32), ( gloss 20), ( undercoat 36). other variable costs ( emulsion 12), ( gloss 15), ( undercoat 10). the cost of direct labour is $3 per hour and the variable cost of mixing is $4 per hour. in any one week, direct labour hours are restricted to 8000 hours and mixing machine…
The Delta company uses three raw materials to make cakes. Delta is trying to reduce warehousing costs and establishes three policies to that end: i) The annual number of orders for all products must be at least 20 per contractual terms with transportation providers. ii) The average inventory in units must be a maximum of 1800. iii) Because the raw material is perishable, there can never be more than 2000 units in inventory of raw material 1. Raw material 2 has a maximum allowed of 1200 units and the raw material 3 can store maximum 400 units. The following table shows the product information: Materia Demanda Costos por unidad Costo por prima (u/año) ordenar ($) 2200 2 300 2 500 4 650 3 3000 10 100 Consider an interest rate of 10% per year. A) Formulate the problem as a mathematical programming model that minimizes the total annual cost. b) Represent the problem in a single equation including the constraints in terms of lambda c) Find the optimized batch sizes for the company's raw…
Jays Office Supplies sells Printers, which it orders from Brands mart Inc in . Because of shipping and handling costs, each order must be for 5 printers. Because of the time it takes to receive an order, the company places an order every time the present stock drops to 5 Printers. It costs $50 to place an order. It costs the company $500 in lost sales when a customer asks for a Printer and the warehouse is out of stock. It costs $100 to keep each Printer stored in the warehouse. If a customer cannot purchase a Printer when it is requested, the customer will not wait until one comes in but will go to a competitor. The following probability distribution for demand for Printer has been determined: Questions 1.Simulate CWD 's ordering and sales policy for 20 weeks 2. Compute the average cost of the policy PLEASE NOTE I SENT THIS IN ALREADY BUT I REALIZED I LEFT OUT SOME VITAL INFORMATION AND AGAIN THIS IS NOT FROM ANOTHER SITE.
Aboloway Company stocks a part that has a daily demand represented by the empirical distribution (shown in the table below). When restocking this part, the average lead time from the supplier is 3 days with a standard deviation of 0.5 days. The plant manager wants to determine how much safety stock to maintain for this part to ensure that stock-outs will not be incurred in more than 5.5% of the order cycles. Daily demand (d) in units Frequency 5 10 10 35 15 65 20 32 25 8 Total Observations = 150 3a. Find the mean and standard deviation for demand. 3b. Based on the information in problems 3 and 3a, what is the mean and standard deviation of demand during the lead time? 3c. Based on the information in problems 3, 3a, and 3b, how much safety stock should the plant manager maintain to ensure that stock-out will not be incurred in more than 5.5% of the order cycles?
In the spreadsheet model shown below, an analyst makes the following data entries. Cell ВЗ В4 В5 B6 Value 113,000 90,000 119,000 99,000 A 1 Revenue 2 Month Revenue Change (%) n/a =(B4-B3)/B3 =(B5-B4)/B4 =(B6-B5)/B5 3 January 4 February 5 March 6 April What values will be shown in the following cells? (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) Cell Value С4 % C5 C6 %
The GIIC -Company must determine a policy for ordering coal to operate 15 smelters. Each smelter requires exactly 5 tons of coal per day to operate, and the firm operates 360 days per year. The purchasing manager has negotiated a contract to obtain the coal for 5 BD per ton for the coming year. The purchasing manager has determined that the ordering cost is 40 BD per order, and the cost of holding coal is 20% per ton of its value. i. Determine the optimal quantity of coal to receive in each order. ii. Determine the total inventory-related costs associated with the optimal ordering policy (do not include the cost ii. If five days' lead time is required to receive an order of coal, how much coal should be on hand when an iv. Optimal quantity 1837.11 Tons, Total cost 1837.11 BD, Inventory during LT 275 Tons of the coal). order is placed? i. Optimal quantity 1469.694 Tons, Total cost 1469.694 BD, Inventory during LT 375 Tons ii. Optimal quantity 734.85 Tons, Total cost 1649.694 BD,…
Bigby Riggs sells high-end art frames that are ordered every Thursday to prepare for next week's demand. The most popular frame style is sold at $50 per unit and it costs Bigby $35 per piece. If too many art frames are ordered, Bigby incurs an inventory carrying cost of $2 per frame. If Bigby runs out of stock for the week, he forgoes the profits from missed sales. Bigby has the option to order 100, 150, or 200 art frames to meet next week's demand which can be either 100, 150, or 200 frames. Based on historical demand, Bigby has determined the following probability information: P(100) = 0.4, P(150) = 0.3, P(200) = 0.3 What is the Expected Monetary Value of your best alternative?
Bigby Riggs sells high-end art frames that are ordered every Thursday to prepare for next week's demand. The most popular frame style is sold at $50 per unit and it costs Bigby $35 per piece. If too many art frames are ordered, Bigby incurs an inventory carrying cost of $2 per frame. If Bigby runs out of stock for the week, he forgoes the profits from missed sales. Bigby has the option to order 100, 150, or 200 art frames to meet next week's demand which can be either 100, 150, or 200 frames. Based on historical demand, Bigby has determined the following probability information: P(100) = 0.4, P(150) = 0.3, P(200) = 0.3 The expected value of perfect information (EVPI) is $_________.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS