Need help solving for the rest of this question C. and D. 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 he makes).The profit on one serving of Wimpy is $0.44, on one serving of Dial 911, $0.57. Each serving of Wimpy requires 0.25 pound of beef, 0.25 cup of onions, and 5ounces 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 5 ounces of hotsauce. Today, Kilgore has 21 pounds of beef, 16 cups of onions, 89 ounces of Kilgore's special sauce, and 61 ounces of hot sauce on hand.(a) Develop a linear programming 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 of servings of Wimpy to make and let D = the number of servings of Dial 911 to make.)Max 0.44W+0.57Ds.t.Beef 0.25W +0.25D < 21Onions 0.25W+0.4D < 10Special Sauce 5W+ 2D ≤89Hot Sauce 5D < 61W, DZ0(b) Find an optimal solution. (Round your answers to two decimal places.)(W, D) =12.92,12.2Profit = $12.64(c) What is the dual value for special sauce? (Round your answer to two decimal places.)088xInterpret the dual value.For every 1 ounce increase in special sauceProfit = $Does the solution confirm the answer to part (c)?Yes(d) Increase the amount of special sauce available by 1 ounce and re-solve. (Round your answers to two decimal places.)(W, D) =No, the profit will increaseNeed Help? Read Itby $

Answered: Image /qna-images/answer/10faf8c1-99d2-41c8-ad0d-6ae94f84463a.jpg

Answered: Kilgore's Deli is a small delicatessen…

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

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…
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
Just need help finding the sausage constraint quantity value
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.
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…
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…
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…
Tom is a habitual shopper at garage sales. Last Saturday he stopped at one where there were several types of used building materials for sale. At the low prices being asked, Tom knew that he could resell the items in another town for a substantial gain. Four things stood in his way: he could only make one round trip to resell the goods; his pickup truck bed would hold only 1200 pounds; the pickup truck bed could hold at most 80 cubic feet of merchandise; and he had only $190 cash with him. He wants to load his truck with the mix of materials that will yield the greatest profit when he resells them. Formulate (define objective function and constraints) and solve this problem (using excel solver) as a linear program.
Please do not give solution in image formate thanku. Consider a firm that operates a cannery. All fish brought in by a fleet of fishing boats are processed at the cannery. The firm also has a freezer of unlimited size that stores unprocessed fish. Assume that the freezer is empty in the beginning of the year. There are three seasons. The fleet yields 8400 tons/month during the first third of the year, 11200 tons/month during the middle third, and only 1400 tons/month during the final third. The cannery's processing capacity equals 7000 tons/month. a- What is the inventory level at the end of January? Please give your answer in tons. b - What is the inventory level at the end of February? Please give your answer in tons. c - What is the inventory level at the end of May? Please give your answer in tons. d - What is the average monthly inventory (in tons)? Please keep 4 decimals. e - Calculate the average system throughput rate. Please give your answer in tons/month. f - Determine the…
A company possesses two manufacturing plants, each of which can produce three products, X, Y, and Z, from a common raw material. However, the proportion in which the products are produced differs in each plant, and so are plant's operating costs per hour. Data on production per hour and costs are given below, together with current orders in hand of each product. Products Operating cost per hour Y Plant A 4 9. Plant B 4 2 10 Orders on hand 50 24 60 Formulate the above as a linear programming problem. Find the number of production hours needed to fulfill the orders on hand at minimum cost using the using Big M method.
As a potential owner of a club known as Club Salida, you are interested in determining the necessary volume of sales in dollars to reach the breakeven next year. You decided to break down the club's sales into. four categories, where beer is the first. Your estimate of the sale of beer is that it will serve 30,000 servings. The selling price per unit will average $ 1.50; its cost is $ .75. The second category is food, of which you expect sell 10,000 units with an average unit price of $ 10.00 and a cost of $ 5.00. The third category is desserts and wine, of which you also hope to sell 10,000 units, but with an average unit price of $ 2.50 and a cost of $ 1.00. The last category is inexpensive lunches and sandwiches, of which you expect sell a total of 20,000 units with an average price of $ 6.75 and a cost per unit of $ 3.25. Your fixed costs (i.e. rent, utilities, etc.) are $ 1,800 a month plus $ 2,000 a month for entertainment. a) What is your breakeven point in dollars per month? b)…
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?

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