Pennington Cabinets is a manufacturer of several different lines of kitchen andbathroom cabinets that are sold through major home improvement retailers.Pennington built material requirement planning as follows:CurrentJanFebMarGross requirements11001150Scheduled receipts810Projected available balance750Net requirementsPlanned order receiptsPlanned order releaseCompute planned order receipts in Mar, assuming that minimum lot size is 1.

Find the Given details below: Month Jan Feb Mar Gross Requirements 1100 1150 Scheduled…

Answered: Pennington Cabinets is a manufacturer…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter7: Nonlinear Optimization Models

Section7.7: Portfolio Optimization Models

Problem 41P

See similar textbooks

Similar questions

The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. As indicated by the algebraic formulation of the Pigskin model, there is no real need to calculate inventory on hand after production and constrain it to be greater than or equal to demand. An alternative is to calculate ending inventory directly and constrain it to be nonnegative. Modify the current spreadsheet model to do this. (Delete rows 16 and 17, and calculate ending inventory appropriately. Then add an explicit non-negativity constraint on ending inventory.)
The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Modify the Pigskin model so that there are eight months in the planning horizon. You can make up reasonable values for any extra required data. Dont forget to modify range names. Then modify the model again so that there are only four months in the planning horizon. Do either of these modifications change the optima] production quantity in month 1?
Lemingtons is trying to determine how many Jean Hudson dresses to order for the spring season. Demand for the dresses is assumed to follow a normal distribution with mean 400 and standard deviation 100. The contract between Jean Hudson and Lemingtons works as follows. At the beginning of the season, Lemingtons reserves x units of capacity. Lemingtons must take delivery for at least 0.8x dresses and can, if desired, take delivery on up to x dresses. Each dress sells for 160 and Hudson charges 50 per dress. If Lemingtons does not take delivery on all x dresses, it owes Hudson a 5 penalty for each unit of reserved capacity that is unused. For example, if Lemingtons orders 450 dresses and demand is for 400 dresses, Lemingtons will receive 400 dresses and owe Jean 400(50) + 50(5). How many units of capacity should Lemingtons reserve to maximize its expected profit?
3-2) The optimal quantity of the three products and resulting revenue for Taco Loco is: A) 28 beef, 80 cheese, and 39.27 beans for $147.27. B) 10.22 beef, 5.33 cheese, and 28.73 beans for $147.27. C) 1.45 Z, 8.36 Y, and 0 Z for $129.09. D) 14 Z, 13 Y, and 17 X for $9.81. 3-3) Taco Loco is unsure whether the amount of beef that their computer thinks is in inventory is correct. What is the range in values for beef inventory that would not affect the optimal product mix? A) 26 to 38.22 pounds B) 27.55 to 28.45 pounds C) 17.78 to 30 pounds D) 12.22 to 28 pounds
Maxwell Manufacturing makes two models of felt tip marking pens. Requirements for each lot of pen...Maxwell Manufacturing makes two models of felt tip marking pens. Requirements for each lot of pens are given below.Fliptop Model Tiptop Model AvailablePlastic 3 4 36Ink Assembly 5 4 40Molding Time 5 2 30The profit for either model is $1000 per lot.What is the linear programming model for this problem?What are the boundary points of the feasible region?What is the profitability at each boundary point of the feasible region?Find the optimal solution.
Jean Clark is the manager of the Midtown Saveway-Grocery Store. She now needs to replenish hersupply of strawberries. Her regular supplier can provide as many cases as she wants. However,because these strawberries already are very ripe, she will need to sell them tomorrow and thendiscard any that remain unsold. Jean estimates that she will be able to sell 12, 13, 14, or 15 casestomorrow. She can purchase the strawberries for $7 per case and sell them for $18 per case. Jeannow needs to decide how many cases to purchase. Jean has checked the store’s records on dailysales of strawberries. On this basis, she estimates that the prior probabilities are 0.1, 0.3, 0.4, and 0.2for being able to sell 12, 13, 14, and 15 cases of strawberries tomorrow. a. Develop a decision analysis formulation of this problem by identifying the decisionalternatives, the states of nature, and the payoff table. b. How many cases of strawberries should Jean purchase if she uses the maximin payoffcriterion? c. How…
The aggregate demand for a product line for the next 6 months is given below. The firm has regular capacity of 120 units per month, overtime capacity for 40 more units per month, and subcontracting can supply up to 100 units per month. Month 1 2 3 4 5 6Demand 220 160 200 210 200 190Additional DataPrevious output level 150 unitsBeginning inventory 100 unitsShortage cost K250 per unit per monthInventory holding cost K100 per unit per monthRegular time cost K1200 per unitSubcontracting cost K2000 per unitOvertime cost K1500 per unitHiring workers to increase production level K200 per unitFiring workers to decrease production level K500 per unitUse the Chase Strategy and answer the following questions Using the data given If the regular capacity is increased to 210 from the current level of 120 units per month and you meet your demand by only regular time production, then answer the…
The aggregate demand for a product line for the next 6 months is given below. The firm has regular capacity of 120 units per month, overtime capacity for 40 more units per month, and subcontracting can supply up to 100 units per month. Month 1 2 3 4 5 6Demand 220 160 200 210 200 190Additional DataPrevious output level 150 unitsBeginning inventory 100 unitsShortage cost K250 per unit per monthInventory holding cost K100 per unit per monthRegular time cost K1200 per unitSubcontracting cost K2000 per unitOvertime cost K1500 per unitHiring workers to increase production level K200 per unitFiring workers to decrease production level K500 per unitUse the Chase Strategy and answer the following questions. a. What is the total cost of shortagesand the cost of overtime production? b. What is the cost of subcontracting? c. What is the cost of increasing production level?
Based on the following sensitivity analysis, which of the following products would be considered most sensitive to changes or errors in the objective function coefficient? Variable Cells Cell Name Final Value Reduced Cost Objective Coefficient AllowableIncrease AllowableDecrease $B$2 Product_1 0 −2 25 11 4 $B$3 Product_2 175 0 25 12 14 $B$4 Product_3 0 −1.5 25 8 5 Constraints Cell Name Final Value Shadow Price Constraint R.H.Side AllowableIncrease AllowableDecrease $H$9 Resource_A 0 0 100 1E+30 100 $H$10 Resource_B 525 0 800 1E+30 275 $H$11 Resource_C 700 1.75 700 366.6666667 700 multiple choice Product_1 Product_2 Product_3
Based on the following sensitivity analysis, which of the following products would be considered most sensitive to changes or errors in the objective function coefficient? Variable Cells Cell Name Final Value Reduced Cost Objective Coefficient AllowableIncrease AllowableDecrease $B$2 Product_1 0 −2 25 10 5 $B$3 Product_2 175 0 25 10 14 $B$4 Product_3 0 −1.5 25 8 6 Constraints Cell Name Final Value Shadow Price Constraint R.H.Side AllowableIncrease AllowableDecrease $H$9 Resource_A 0 0 100 1E+30 100 $H$10 Resource_B 525 0 800 1E+30 275 $H$11 Resource_C 700 1.75 700 366.6666667 700 Choose the product Product 1 Product 2 Product 3
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…
Wormwood, Ltd., produces a variety of furniture products. The planning committee wants to prepare an aggregate plan for the next six months using the following information.Month1 2 3 4 5 6Demand 160 150 160 180 170 140CapacityRegular 150 150 150 150 160 160Overtime 10 10 0 10 10 10Cost Per UnitRegular time $50Overtime 75Subcontract 80Inventory holding, per month 4Subcontracting can handle a maximum of 10 units per month. Beginning inventory is zero.Develop a plan that minimizes total cost. No back orders are allowed. Regular capacity = Regularproduction.

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