LP Model FormulationPlease make sure that your answers in LP Model Formulation are composed of Decision Variables, Objective Functionand Constraints.1. RDB caterer must prepare from five fruit drinks in stock 500 gal of a punch containing at least 20 percent orange juice, 10percent grapefruit juice, and 5 percent cranberry juice. If inventory data are as shown below, formulate the LP model thatwill enable RDB caterer to determine how much of each fruit drink to use to obtain the required composition at minimumtotal cost.Orange Juice,%CranberrySupply, galCost ($) / galGrapefruitJuice,%Juice,%Drink A40402001.5Drink B510204000.75Drink C1001002.00Drink D100501.75Drink E8000.25

Given data is Demand = 500 gal Minimum requirement of orange juice = 20% = 100 gal Minimum…

Answered: LP Model Formulation Please make sure…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter3: Introduction To Optimization Modeling

Section3.8: A Multiperiod Production Model

Problem 22P

See similar textbooks

Similar questions

Francesca’s Boutique has a merchandise budget that includes $53,420 in planned sales for Dresses, $5342 in planned reductions, and $63,762 in planned purchases. The assortment includes 4 sub classifications (Casual (30%), dressy (20%), day-to-night (35%), date night (15%)) with 5styles, 4 colors, 4 sizes (for each sub class). The average first price on the dress is $45. Francesca’s expects to devote about 50 square feet to displaying the dresses in each store (10 stores), and the shirts to generate approx. $107 per square foot during the fall selling period. Markdowns are expected to be 10% of sales. Average Markup is 63%. Based on the information provided: What is the planned volume of the assortment? (Note: Use Planned Merchandise to Receive figures) How many SKUs are in this assortment? What is the model stock for the entire dress assortment?
Leather-All produces a line of handmade leather products. At the present time, the company is producing only belts, handbags, and attache cases. The predicted demand for these three types of items over a six-month planning horizon is as follows: Month No. of Belts Handbags Attache CasesWorking days1 22 2500 1250 2402 20 2800 680 3803 19 2000 1625 1104 24 3400 745 755 21 3000 835 1266 17 1600 375 45 The belts require an average of two hours to produce, the handbags three hours, and the attache cases six hours; all the workers have the skill to work on any item. Leather-All has 46 employees who each have a share in the firm and cannot be fired. There are an additional 30 locals that are available and can be hired for short periods at a higher cost. Regular employees earn $8.50 per hour on regular time, and $14.00 per hour on overtime. Regular time comprises a seven-hour workday and the regular employees will work as much overtime as is available. The additional workers are hired for…
Omega DB Corp. has a policy of maintaining an inventory of finished goods equal to 40 percent of the next month’s budgeted sales. If Omega DB Corp. plans to produce 6,000 units in June, what are budgeted sales for July in units? Budgeted sales for the first six months of 2019 for Omega DB Corp. are listed below: Units:JANUARY 6,000FEBRUARY 7,000MARCH 8,000APRIL 7,000MAY 5,000JUNE 4,000
A mail-order house uses 16,870 boxes a year. Carrying costs are 60 cents per box a year, and ordering costs are $96. The following price schedule applies. Number of BoxesPrice per Box1,000 to 1,999$1.25 2,000 to 4,9991.20 5,000 to 9,9991.15 10,000 or more1.10 a.Determine the optimal order quantity. (Round your answer to the nearest whole number.) Optimal order quantity5000 boxes b.Determine the number of orders per year. (Round your answer to 2 decimal places.) Number of order per year
Max the Tailor is going to sell custom suits. He was able to rent a garage from his Uncle Ed for $2,000 a month, which includes utilities, and he already owns the equipment he needs. He anticipates being able to sell his suits for $500 each. The raw materials (fabric, buttons, zippers, thread, etc.) will cost an average of $75 for each suit, and he plans to spend $25 per suit to advertise them. Assuming these are all the costs and revenues, what will be Max’s monthly break-even point in units? Does this seem like a reasonable amount for him to produce and sell every month? Please show your calculations.
I need assistance to solve the following problem in Operations Analysis. 2) A coffee store is experiencing sales of 280 pounds of coffee beans per year. The supplier charges the store $2.40 per pound, and the paperwork and labor costs incurred by the store in placing an order total $45 per order. Holding costs are based on 20% interest rate per annum. a) What is the optimal order size (write down the model name, its parameters and formula)? b) What is the time between order placements (include the formula)? c) What is the average annual holding cost (include the formula)? d) If the lead time is 3 weeks, what is the reorder level based on inventory on hand (include the formula)?
Williams Inc. produces fluorescent lightbulbs for commercial use. The accounting manager isattempting to estimate the total cost for the next quarter using the high-low method. He has compileddata and found the high and low costs are $10,000 and $6,000, respectively, and the associated costdrivers are 7,000 and 3,000 packs, respectively. What is the value for b (the variable cost per unit)?What is the value for a (the fixed quantity)?
Suppose this information is available for PepsiCo, Inc. for 2015, 2016, and 2017. (in millions) 2015 2016 2017 Beginning inventory $ 2,100 $ 2,400 $ 2,300 Ending inventory 2,400 2,300 2,700 Cost of goods sold 18,227 20,071 20,478 Sales revenue 39,145 42,957 44,066 Calculate the days in inventory for PepsiCo, Inc. for 2015, 2016, and 2017. (Round days in inventory to 1 decimal place, e.g. 5.1.) 2015 2016 2017 Days in inventory days
Auria will produce 3 vehicle components and knows that each start generates a cost of 5,000 pesos. The cost of the units is $ 200, $ 100 and $ 70 respectively. Annual demand is 100,000 units for Product A, 150,000 units for Product B, and 200,000 units for Product C. The inventory rate is 15% per month. Product A and B are basic and substitutable products, so there must be a minimum average inventory of 8,000 units of both. The company seeks a maximum of $ 100,000 invested money in inventory. The available warehouse space is 400m3 and product A occupies 0.5m3, product B 0.7m3 and C 1m3. Consider that product A and C allow shortages and the goodwill loss cost is $ 3 for each unit of those items. a) Formulate the problem as a mathematical programming model (objective function and constraints) that minimizes the total annual cost
Ardie Corporation uses 30,000 units. Each order placed is for 1,500 units. The stockout units is 300. Management is willing to accept a stockout probability of 40 percent. The stockout cost per unit is P3.20. What does the total stockout cost? choose the letter of the correct answera. P2,680.00b. P3,680.00c. P4,680.00d. P5,680.00e. P7,680.00
I need a detailed explanation and assistance to solve this problem: Wineco produces wine cooler as a blend of wine, grape juice and apple juice ingredients, which it sells for $4 per gallon. The costs of ingredients are given in the following table: Cooler Ingredient Price per Gallon ($) wines 1.20 grape juice 1.40 Apple juice 0.60 Wineco owns a blending plant with a production capacity of 200 gallons per day. Because the plant is fully automated, all other production costs are negligible by comparison to the cost of ingredients, and can be ignored. Government regulations mandate that wine cooler products must satisfy the following guidelines: At least 10% of the blend produced must be grape juice. The ratio of apple juice to grape juice in the blend produced must be 2.5:1 The blend produced must contain between 20% and 25% wine. Wineco wishes to use LP in order to determine the quantities of ingredients to buy for a day’s production of wine cooler, so…
A single inventory item is ordered from an outside supplier. The anticipateddemand for this item over the next 12 months is 6, 12, 4, 8, 15, 25, 20, 5, 10, 20, 5,12. Current inventory of this item is 4, and ending inventory should be 8. Assume aholding cost of $1 per period and a setup cost of $40. Determine the order policyfor this item based ona. Silver–Meal.

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