Minimize z= 5.15x1+ 4.5x2 + 4.36x3(hundreds of dollars)s.t:?x1 + ?x2 + ?x3 > 140?x1 + ?x2 + ?x3 s 200(production capacity: hours)(warehouse capacity; hundreds of sq. ft.)?x1+?x2 = 5(demand for 6 oz. giasses; hundreds of cases)x1, x2, x3 204.5X2-1.25BasisСв5X14.36X3S1S2a3RHS-0.7510.7X31.4.36-0.1311.251.25-2.511.5S20.1X15.15C-ZHow much is it worth an extra hour added to b1 on the optimal solution?

Objective function: Minimize Z =5.15X1 + 4.5X2 + 4.36X3

Answered: Minimize z=5.15x1+4.5x2+4.36x3…

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

P8.11B (L0 4) (Dollar-Value LIFO) Landon Company bottles a variety of soft drinks. Recently, the company decided to valueits inventories using dollar-value LIFO pools. The clerk who accounts for inventories does not understand how to value theinventory pools using this new method, so, as a private consultant, you have been asked to teach him how this new methodworks.He has provided you with the following information about purchases made over a 6-year period.Ending InventoryDate (End-of-Year Prices) Price IndexDec. 31, 2016 $212,000 100Dec. 31, 2017 226,600 103Dec. 31, 2018 264,000 110Dec. 31, 2019 261,000 116Dec. 31, 2020 324,000 120Dec. 31, 2021 312,500 125You have already explained to him how this inventory method is maintained, but he would feel better about it if you were toleave him detailed instructions explaining how these calculations are done and why he needs to put all inventories at a base-yearvalue.Instructions(a) Compute the ending inventory for Landon Company for 2016…
Please do not give solution in image format thanku Prince Electronics, a manufacturer of consumer electronic goods, has five distribution centers in different regions of the country. For one of its products, a highspeed modem priced at $360 per unit, the average weekly demand at each distribution center is 85 units. Average shipment size to each distribution center is 450 units, and average lead time for delivery is 2 weeks. Each distribution center carries 2 weeks' supply as safety stock but holds no anticipation inventory. Part 2 a. On average, how many dollars of pipeline inventory will be in transit to each distribution center? $enter your response here. (Enter your response as an integer.)
Q1/ Alpha Company estimates its product cost at 8000 $, the estimated annual requirement is 25000 units at holding cost 15% of product cost. a. What is the most economical number of units to order?(EOQ). b. How many orders should be placed in a year?(optimal number of orders).
c) Even if there is substantial uncertainty in the parameters in the EOQ-model, it is still quite a useful model. Discuss why.
2. Atlanta D = 80,000 annual demand 5% holding cost Purchase cost $13.00/unit Ship quantity = 1,000/container Cost to place PO = $50/PO Shipping cost = $1,200/container Annual order cost Annual holding cost Annual logistics cost Total purchase cost Total annual costs |||||||||| =
Mr. Robertson owns a store. His mark-up percentage is 80%. He is also VAT registered, VAT is 15% of the selling price. Mr. Robertson buys handbags at R108 each, what is the selling price of these bags excluding VÁT? 2.1 2.2 How much profit would he earn selling 25 bags? | 2.3 Calculate the selling price of one handbag including VAT. 2.4 Mr. Robertson hires a new assistant. She calculates that a pair of shoes that is bought for R850 should be sold for R1572,50 excluding VAT. State, with calculations, whether her mark-up percentage was correct. 2.5 Mr. Robertson sells a pair of jeans for R459,99 excluding VAT. Calculate the cost price before the mark-up.
14 To calculate Economic Order Quantity (EOQ =sqrt(D*k/h)
Q#3 · Let p + 3q/2 = 27 be an equation involving two variables p (price) and q (quantity). Indicate the meaningful domain and range of this function when (a) the price (b) the quality are considered independent variables.
(3marks) c. The Ambrosia Bakery makes cakes for freezing and subsequent sale. The bakery, which operates five days a week, 52 weeks a year, can produce cakes at the rate of I16 cakes per day. The bakery sets up the cake-production operation and produces until a predetermined number have been produced. When not producing cakes, the bakery uses its personnel and facilities lor produciny other bakery tems Ihe selup cost lor a oduction run of cakes is 700 The cost of holdling frozen cakes in storage is 9 per Cake per year. the annual demand lor Ihuzen cakes, which Is contant over time, is G000 cakes. Determine the lollowing 1Optimal production run quantity ii. The maximum inventory ii. Total annual inventory costs iv. Optimal number of production runs per year V. Optimal cyele tinie (time between run starts)
3. (Ch9) A store has collected the following information on one of its products: Demand = 4,500 units/year Standard deviation of weekly demand = 12 units Ordering costs = $40/order Holding costs = $3/unit/year Cycle-service level = 90% (z for 90% = 1.28) Lead-time = 2 weeks Number of weeks per year = 52 weeks a. If a firm uses the continuous review system to control the inventory, what would be the order quantity and reorder point? b. The firm decided to change to the periodic review system to control the item's inventory. For the most recent review, an inventory clerk checked the inventory of this item and found 300 units. There were no scheduled receipts or backorders at the time. How many units should be ordered? (HINT: Use the EOQ model to derive P, the time between reviews.)
QUESTION 20 What are purchased items or extracted materials that will be transformed into components or products called? A. finished goods inventory B. MRO inventory C. raw materials inventory D. distribution inventory E. work-in-process inventory QUESTION 21 Which inventory function exists between the manufacturing plant and the distribution plant? OA. transportation inventory OB. lot-size inventory C. anticipation inventory D. fluctuation inventory E. speculative inventory QUESTION 22 In inventory management, when discussing customer service we mean: OA. whether repair of the product is available. B. whether the product is available regardless if the customer desires it or not. OC. whether the product is available when the customer wants it. OD. whether the customer wants the available product. OE. whether the customer is available when the product is.
dt = demand Kt = ordering cost Ct = cost per item ht = holding cost per item per unit time

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