6 12. A company wants to plan production and inventory levels for its new product forthe next 4 months so as to minimize the inventory holding and production costs.Demand is anticipated to be 130, 160, 270, and 150, respectively. The product ismanufactured at the cost of $32 per unit. The cost of carrying one unit of inven-tory at the end of the month is $4. The inventory level at the beginning of the firstmonth is 10 units and inventory required at the end is at least 20 units. Otherinformation is given below:EinoMMONTHPRODUCTION CAPACITY11602003210daga 4160a. Formulate a linear program, clearly defining all variables used, to determinethe production and inventory in each period that minimizes the total cost.bob. Use Solver to find the optimal solution to the linear program from part a.

A linear program (LP) is a mathematical optimization problem that involves finding the values of…

Answered: a. Formulate a linear program, clearly…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

(a) Give examples of independent and related dependent demand (b) APL company assembles and sales an electronics device (ED) on a contract basis. End item ED has composed of 3 units of subassembly BG and 5 units of component DD. BG is assembled using 3 DDs and 4 FCs. There are orders of 500 and 875 units of the device (ED) at the beginning of week 6 and week 8. In assembling BG, an extra 20 percent scrap allowance must be added. DD can only be ordered in whole cases of 400 units per case. One case of DD is received in each of week 1 and week 2. Also, there are 200 units of BG and 425 units of DD now on hand. The lead time for the item BG, DD, and FC is 2 weeks and that is for the item ED is 1 week.i. Calculate the required number of DD and FC for producing 100 units of ED. There is no stock of any item. ii. Prepare a material requirements plan for the component DD.
You are the executive chef at a large wedding facility, and a wedding with a confirmed count of 168 is scheduled for tomorrow at noon. Everything has been ordered except the shrimp, which was missing from the last purchase order. It will have to be a last-minute rush order, and only one supplier can get it to you in time. The purchase order will be for frozen raw, U 16-20, shrimp peeled, de-veined, tail-on, in 5-pound boxes (according to your spec for the product). You’ve dealt with this supplier before, and made a note to yourself on the jumbo shrimp spec that this vendor’s product averages 19 to 20 shrimp per pound and has a 96% yield. Catering policy dictates that a 10% buffer be provided for unexpected guests, and the catering menu states that 5 shrimp are to be served per person. If you have 4 pounds of good jumbo shrimp on hand, how much will you order for the wedding? Will there be any leftover product? How much?
1. Forrest and Dan make boxes of chocolates for which the demand is uncertain. Forrest says, "That's life." On the other hand, Dan believes that some demand patterns exist that could be useful for planning the purchase of sugar, chocolate, and shrimp. Forrest insists on placing a surprise chocolate-covered shrimp in some boxes so that "You never know what you'll get." Quarterly demand (in boxes of chocolates) for the last three years is shown in the table below: b. If the expected sales for chocolates are 14,400 cases for year 4, use the multiplicative seasonal method to prepare a forecast for each quarter of the year. (Round all intermediate calculations to two decimal places.) The first quarter forecast is what? boxes of chocolates. (Enter your response rounded to the nearest whole number.)
2. A manager then obtained 10 lists of items with their following unit cost and gets the peso value in annual basis. By doing the A-B approach you will need to multiply the annual demand for t particular items to its unit costs as follows: Item Number Annual Demand Unit Cost Annual Peso Value 1 3,500 360 2 2,000 70 3 5,400 500 4 2,500 100 5 1,200 70 6 2,000 1,000 7 1,200 210 8 2,000 4,000 9 10,000 10 10 1,500 200 Item Number Annual Peso Classification % of item Value 2/3 % of annual Peso Value
Given this information:Lead-time demand 600 poundsStandard deviation of lead time demand 52 pounds (Assume normality.)Acceptable stockout risk during lead time 4 percenta. What amount of safety stock is appropriate?b. When should this item be reordered?c. What risk of stockout would result from a decision not to have any safety stock?
2.)Birka Styles & Co is introducing a new line of beachwear for their retail stores. The manager needs to decide how many lots of the new beachwear to order for their stores. The marketing came up with a payoff table (see below) considering information about the price, projected sales level, and cost of inventory and ordering. DEMAND Order size Low Medium High 1 lot 12,000 15,000 15,000 2 lots 9,000 25,000 35,000 3 lots 6,000 35,000 60,000 If the owner of Birka Styles & Co is an optimist, how many lots should the manager order?
2.)Birka Styles & Co is introducing a new line of beachwear for their retail stores. The manager needs to decide how many lots of the new beachwear to order for their stores. The marketing came up with a payoff table (see below) considering information about the price, projected sales level, and cost of inventory and ordering. DEMAND Order size Low Medium High 1 lot 12,000 15,000 15,000 2 lots 9,000 25,000 35,000 3 lots 6,000 35,000 60,000 A)If the owner of Birka Styles & Co is an optimist, how many lots should the manager order? B)If the owner of Birka Styles & Co is a pessimist, how many lots should the manager order? C)The owner wants to use minimax regret. How many lots should the manager order?
The materials manager for a billiard ball maker must periodically place orders for resin, one of the raw materials used in producing billiard balls. She knows that manufacturing uses resin at a rate of 50 kilograms each day, and that it costs $.04 per day to carry a kilogram of resin in inventory. She also knows that the order costs for resin are $100 per order, and that the lead time for delivery is four days. If the order size was 1,000 kilograms of resin, what would be the average inventory level?
Franklin Tooling, Inc., manufactures specialty tooling for firms in the paper-making industry. All of their products are engineer-to-order and so the company never knows exactly what components to purchase for a tool until a customer places an order. However, the company believes that weekly demand for a few components is fairly stable. Component 135.AG is one such item. The last 26 weeks of historical use of component 135.AG is recorded below. Week Demand Week Demand 1 2 3 4 5 6 7 8 9 10 11 12 13 137 136 143 136 141 128 149 136 134 142 125 134 118 14 15 16 17 18 19 20 21 22 23 24 25 26 131 132 124 121 127 118 120 115 106 120 113 121 119 Use OM Explorer’s Time Series Forecasting Solver to evaluate the following forecasting methods. Start error measurement in the fifth week, so all methods are evaluated over the same time interval. Use the default settings for initial forecasts.i. Naïve (1-Period Moving Average)ii. 3-Period Moving Averageiii. Exponential Smoothing,…
6. A company stocks an item that is consumed at the rate of 20 units each day. Every time an order is placed for new supply, $ 100 must be paid. A unit inventory held in stock for one week will cost $ 0.15. Lead time is 3 days. a. What is the economic order quantity (EOQ)? b. What is the cycle time for the EOQ? c. What is the total cost for the EOQ? d. What is the total cost if the order quantity is 300 more than EOQ? e What is the optimum number of orders (rounded to the closest integer) that the company has to place each year? f What is the level of inventory at the reorder point? Assume that the company has a standing policy of not allowing shortages in demand.
A busness is aunchng a new product. The aunch wil require a number of related actvties as follows hre (7 weeks) select an advertising agency (2 weeks), plan an advertising campaign wth the agency (4 weeks),products from the manufacturer (13 weeks) select distributors for the product (9 weeks), take initial orders fromoperation (12 weeks), pack enough products for the launch stock (8 weeks), order the launch quantty ofthe distrbutors (3 weeks), dispatch the initial orders to the distrbutors (2 weeks). (a) What is the earest timeconduct the advertsing campaign (10 weeks), design the packaging of the product (4 weeks), set up packinga sales manager (5 weeks), requre the sales manager to recruit saes peope (4 weeks), tran the sales people that the new product can be ntroduced to the market? (b) If the company hre traned salesmen who do notneed further training, coud the product be introduced 7 weeks earler? (c) How long could one delay selectngthe advertising agency? In the example above,…
As with other products, Fisher-Price faces the decision of how many Weather Teddy units to order for the comingholiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, or28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning themarket potential. The product management team asks you for an analysis of the stock-out probabilities forvarious order quantities, an estimate of the profit potential, and to help make an order quantity recommendation.Fisher-Price expects to sell Weather Teddy for $24 based on a cost of $16 per unit. If inventory remains afterthe holiday season, Fisher-Price will sell all surplus inventory for $5 per unit. After reviewing the sales historyof similar products, Fisher-Price’s senior sales forecaster predicted an expected demand of 20,000 units with a.95 probability that demand would be between 10,000 units and 30,000 units. Compute the probability of a stock-out for the…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

a. Formulate a linear program, clearly defining all variables used, to determine the production and inventory in each period that minimizes the total cost. bon moun bas b. Use Solver to find the optimal solution to the linear program from part a. pitagarit!