Tupperware Brands Corporation has 1200 units of microwaveable bowls in stock at northernfactory and southern factory, respectively. The corporation received order of this productfrom three different retailers I, II and III in quantities of 1000, 700 and 500 units, respectively.The unit shipping costs (in rupees per unit) from the factories to the retailers are as follows:Factorynorthern (1)Southern (2)and the output is given as follows:I1413Model VariableValue x11Value x12Value x13Value x21Value x22Value x23RetailerII1113Units070030010000200III1312(a) Draw a network model to illustrate the above problem.(b) Formulate a linear programming model for the problem.[NOTE: Please use x, where i=1,2,..., n -Factory and j=1,2,...,m -Retailer torepresent your decision variables.]

Answered: Tupperware Brands Corporation has 1200…

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

Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows: MONTH DEMAND (UNITS) January 4,150 February 4,250 March 3,950 April 4,350 May 4,950 June 4,650 July 5,250 August 4,850 September 5,350 October 5,650 November 6,250 December 5,950 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.8. (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this…
Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (UNITS) January February 4,100 4,200 March 3,900 April 4,300 May 4,900 June 4,600 July 5,200 August 4,800 September 5,300 October 5,600 November 6,200 December 5,900
The seasonal demand for a particular product is given below: Period 123 4 5 6 Demand 300 450 100 450 450 100 The fixed parameters are: Fixed Cost $8 Unit Production Cost $1 Holding Cost $1.3 Calculate total ordering cost using following three methods: i) Lot-for-Lot ii) Wagner-Whitin algorithm iii) Fixed order quantity
Ram Roy's firm has developed the following supply, demand, cost, and inventory data Period 1 2 3 Regular Time 30 30 40 Supply Available Overtime Subcontract 5 15 15 15 5 5 Demand Forecast 40 20 units $100 $150 $200 $6 45 55 Initial inventory Regular-time cost per unit Overtime cost per unit Subcontract cost per unit Carrying cost per unit per month Assume that the initial inventory has no holding cost in the first period and backorders are not permitted Allocating production capacity to meet demand at a minimum cost using the transportation method, the total cost is $ (enter your response as a whole number)
1. HP produces printers for sale in Europe in its Vancouver, Canada factory. Printers sold in different countries differ in terms of the power outlet as well as the language manuals. Currently HP assembles and packs printers for sale in individual countries. The distribution of weekly demand in different countries is normally distributed with mean an standard deviation as shown in the Table below. Assume demand in different countries to be independent. Given that the lead time from the Vancouver factory is six weeks, how much total safety inventory does HP require in Europe if it targets a cycle service level of 95 percent? Country France/Benelux UK/Ireland Germany Italy/Spain/Portugal Demand Forecast 3000 4000 4000 2500 Standard Deviation 2000 2200 1250 800 EAMO2 ad of el how A utarase sit themsi What if HP decides to build a central distribution center (DC) in Europe. It will ship base printers (without power supply) to the new DC. When an order is received, the DC will assemble…
Fuego Limited is a table-glass retailer located in Vancouver. The company purchases glasses from Anderson PLC. The details of the table glasses are as follows: The purchase price per glass – $3,000 Cost of an order - $500 The annual cost of carrying a glass - 2% of the purchase price Monthly Demand - 1,250 Units The company has been offered a discount of 1% on the price of a table glass if the lot size is 3,000 table glasses at a time. Required: i. Calculate the Economic Order Quantity. ii. Calculate the total inventory cost. iii. Draw a graph and discuss the behavior of the total inventory holding cost, total ordering cost, and total cost for the given scenario. iv. Advise whether the quantity discount offer can be accepted (Assume that the inventory carrying cost does not vary according to the discount policy)
Problem 20-39 (Algo) CU, Incorporated (CUI), produces copper contacts that it uses in switches and relays. CUI needs to determine the order quantity, Q, to meet the annual demand at the lowest cost. The price of copper depends on the quantity ordered. Here are price-break and other data for the problem: Price of copper $ 0.84 per pound up to 2,499 pounds $ 0.83 per pound for orders between 2,500 and 4,999 pounds $ 0.81 per pound for orders 5,000 pounds or greater Annual demand 54,000 pounds per year Holding cost 25 percent per unit per year of the price of the copper Ordering cost $ 30 Which quantity should be ordered? Quantity_____________pounds
James Calender is the buyer for "Joe's Radio Hut", a local electronics chain that has developed a loyal customer base with its quality service and competitive pricing. Due to the short selling lives of electronics products, James has only a single opportunity to order the new GO multifunction photo printer and hair dryer. The item sells for $139.24 and the per unit cost is $128.93. Any units remaining at the end of the season must be disposed of at a cost of $18.04. Demand for the item is believed to be normally distributed with a mean 605 and standard deviation 145.2. What is the cost of shortage? (specify answer to 2 decimal places)What is the critical fractile? (specify answer to 3 decimal places)What is the cost minimizing order quantity? (specify answer as a whole number)
13.2 A company manufactures component parts for machine tools in North America and ships them to Southeast Asia for assembly and sale in the local market. The components are shipped by sea, transit time averages 6 weeks, and the shipping costs $2700 per shipment. The company is considering moving the parts by air at an estimated cost of $7500; the shipment taking 2 days to get there. If inventory in transit for the shipment costs $125 per day, should they ship by air?
No Spacing Heading 1 Paragraph Styles Ed Item SKU A3378 has a demand that is normally distributed during the lead time, with a mean of 360 units and standard deviation 9999 of 12. If Hinsdale cannot have stockout in more than 10% of the time in any order, how much safety stock should be maintainec and at what reorder point? Calculate Hinsdale's safety stock and reorder point for three other SKUS under the following conditions of demand and lead time: A) SKU F5402: daily demand is normally distributed with a mean of 16, standard deviation of 4, lead time is 4 days, and must operate at a 95% service level Calculate Hinsdale's safety stock and reorder point for three other SKUS under the following conditions of demand and lead time: 1. SKU F5402: daily demand is normally distributed with a mean of 16, standard deviation of 4, lead time is 4 days, and must operate at a 95% service level. hs: On
1. Padilla Electronics stocks and sells a particular brand of microcomputer. It costs the firm $450 each time it places an order with the manufacturer for the microcomputers. The cost of carrying one microcomputer in inventory for a year is $170. The store manager estimates that total annual demand for the computers will be 1,200 units, with a constant demand rate throughout the year. Orders are received within the minutes after placement from a local warehouse maintained by the manufacturer. The store policy is never to have stock outs of the microcomputers. The store is open for business everyday of the rear except Christmas day. In reference to problem no. 1, determine the minimum total annual inventory cost
A clothing manufacturing company requires raw materials for 8 consecutive weeks as follows: 30, 40, 50, 35, 60, 30, 40, and 30 units with a one-time order cost of $50,000 and a storage fee of $500 per unit/week. From these data calculate the total cost of procurement using:a. Lot For Lot (LFL) Methodb. Economic Order Quantity (EOQ) Methodc. Period Order Quantity (POQ) Method Using this table format: Week 1 2 3 4 5 6 7 8 Gross requirements Schedule receipts Projected on hand Net requirements Planned order receipts Planned order releases

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