......2...2. The property manager of a city government issues chairs, desks, and other office furniture to citybuildings from a centralized distribution center. Like most government agencies, it operatesminimize its costs of operations. In this distribution center, there are two types of standard Dechairs, Model A and Model B. Model A is considerably heavier than Model B, and costs $20 perchair to transport to any city building; each model B costs $14 to transport. The distributioncenter has on hand 400 chairs-200 each of A and B.41. 5. 16.The requirements for shipments to each of the city's buildings are as follows:Building 1 needs at least 80 of ABuilding 2 needs at least 150 of B.Building 3 needs at least 120 chairs, but they can be of either type,Building 4 needs 40 chairs, but at least as many B as A.a.Write the algebraic formulation of the problem.Decision Variables:b. Solve using Excel solver to minimize cost.mixed.Hint: there are eight decision variables because we need to know how many of each chair (A andB) to deliver to each of the four buildings and seven constraints. The objective is to minimizecost.

Linear programming is a mathematical technique that is also used in operations management…

Answered: Write the algebraic formulation of the…

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

The Frist Corporation has the followinginternal controls related to inventory:1. Only authorized inventory warehousing personnel are allowed in inventory storageareas.2. All inventory products are stored in warehousing areas that are segregated fromother storage areas used to house equipment and supplies.3. All inventory held on consignment at Frist Corporation is stored in a separatearea of the warehouse.4. The inventory purchasing system only allows purchases from pre-approved vendors.5. The perpetual inventory system tracks the average number of days each inventoryproduct number has been in the warehouse.6. Microchips are embedded in each product and when inventory items are removedfrom the warehouse to shipping, radio-frequencies signal a deduction of inventoryto the perpetual inventory system.7. On a weekly basis, inventory accounting personnel take samples of inventoryproducts selected from the perpetual inventory system and verify that the inventoryis on-hand in the warehouse…
The GIIC -Company must determine a policy for ordering coal to operate 15 smelters. Each smelter requires exactly 5 tons of coal per day to operate, and the firm operates 360 days per year. The purchasing manager has negotiated a contract to obtain the coal for 5 BD per ton for the coming year. The purchasing manager has determined that the ordering cost is 40 BD per order, and the cost of holding coal is 20% per ton of its value. i. Determine the optimal quantity of coal to receive in each order. ii. Determine the total inventory-related costs associated with the optimal ordering policy (do not include the cost ii. If five days' lead time is required to receive an order of coal, how much coal should be on hand when an iv. Optimal quantity 1837.11 Tons, Total cost 1837.11 BD, Inventory during LT 275 Tons of the coal). order is placed? i. Optimal quantity 1469.694 Tons, Total cost 1469.694 BD, Inventory during LT 375 Tons ii. Optimal quantity 734.85 Tons, Total cost 1649.694 BD,…
In a large microelectronics plant, the assembly cell for circuit boards has a demand for 300 units an hour. Two feeder cells supply partsA and B to the assembly cell (one A and one B for each board). Standard containers that look like divided trays are used. A container will hold 22 As or 13 Bs. It takes 13 minutes to fill up a container with As and 22 minutes to fill up a container with Bs. Transit time to the assembly cell is 5 minutes for both A and B. No safety factor is used. Kanbans to be circulated Between Process A and Assembly cell? Kanbans to be circulated Between Process B and Assembly cell?
The Delta company uses three raw materials to make cakes. Delta is trying to reduce warehousing costs and establishes three policies to that end: i) The annual number of orders for all products must be at least 20 per contractual terms with transportation providers. ii) The average inventory in units must be a maximum of 1800. iii) Because the raw material is perishable, there can never be more than 2000 units in inventory of raw material 1. Raw material 2 has a maximum allowed of 1200 units and the raw material 3 can store maximum 400 units. The following table shows the product information: Materia Demanda Costos por unidad Costo por prima (u/año) ordenar ($) 2200 2 300 2 500 4 650 3 3000 10 100 Consider an interest rate of 10% per year. A) Formulate the problem as a mathematical programming model that minimizes the total annual cost. b) Represent the problem in a single equation including the constraints in terms of lambda c) Find the optimized batch sizes for the company's raw…
7. Maribel is considering installing ice cream stalls on Turtle Beach. The length of the beach is 5 miles long. On average, in a week, there are 1,000 subathers that come to the beach and each value an icecream at $5. Transportation costs are $2.5. Each icecream costs $0.5 to make and there are $40 as a fixed maintenance cost per stall. A )Find the optimal number of stalls for Maribel? B) What is the profit at optimal number of stalls?
14. Akali is the only nurse in lonia. lonia has 21 ninja households distributed one-tenth of a mile along the main street. Each ninja household goes to see Akali for her services at most one time per week. There are additional dangers on the street going there-and back again which are equal to $0.5 for every tenth of the mile. The reservation price of each ninja to pay for Akali services is $10. To serve each ninja, Akali incurs $2 costs. What the maximum price should Akali charge if she wants to serve the whole lonia? How much would she earn?
A mgr. must set up an invty system for two (2) new production items, P34 & P35. P34 can be ordered at any time, butP35 can only be ordered once every 4 weeks. The co. operates 50 weeks a year and the weekly usage rates for both itemsare normally distributed. The mgr. has gathered the following information about the items:Item P34 Item P35Average wkly demand 60 units 70 unitsStandard deviation 4 units per wk 5 units per wkUnit cost $15 $20Annual Holding cost 40% 40%Ordering cost $70 $30Lead time 2 weeks 2 weeksAcceptable stockout risk 5% 5%a) When should the manager reorder each item?b) Compute the order quantity for P34c) Compute the reorder point for P35 if 110 units are on hand at the time the order is placed
ANT Infra orders two kinds of precast items: A and B for use in its projects from two different suppliers. The precasts are needed throughout the entire 52-week year. Precast A are used at a relatively constant rate and are ordered whenever the remaining quantity drops to the reorder level. While, precast B is ordered from a supplier who delivers by every three weeks. Data for both precast items are as follows:Item Precast A Precast BAnnual demand 10,000 5,000Holding cost (% of item cost)20% 20%Order cost $150 $25Lead time 4 weeks 1 weekSafety stock 55 units 5 unitsItem cost $10.00 $2.00 a. Employ Q system for precast A and calculate the EOQ, the reorder point, total inventory cost? b. Employ P system for precast B and estimate the target level inventory and total inventory cost?
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 20 4.5X2 -1.25 Basis Св 5X1 4.36X3 S1 S2 a3 RHS -0.75 10.7 X3 1. 4.36 -0.13 11.25 1.25 -2.5 11.5 S2 0.1 X1 5.15 C-Z How much is it worth an extra hour added to b1 on the optimal solution?
In the 3M concept, money keeper refers to_________. A.Perbendaharaan / Treasury B.Parlimen / Parliament C.Dewan Undangan Negeri (DUN) / State Legislative Assembly D.Jawatankuasa Kira-Kira Wang Awam (PAC) / Public Accounts Committee (PAC)
E - Max uses the basic EOQ model to determine the order quantity . They used to buy electronics from a Korean supplier in Dubai with a lead - time of 5 days . Recently , the supplier has decided to close the warehouse in Dubai and deliver all items from Korea directly to customers in Oman with a lead time of 10 days . Under this situation , the economic order quantity will (Q^ * ) 1)double 2)None of these 3)increase , but not double 4)decrease by a factor of two 5)do remain the same
Cooler Corporation is a manufacturer of cooling products. It purchases 14,400 units of a particular component (CK55) each year at a cost of $60 per unit. Cooler Corporation requires a 12% annual rate of return on investment. In addition, relevant carrying costs for insurance, material-handling, and breakage are $0.40 per unit per quarter, whereas warehousing rental cost is $12,000 per month. Relevant costs per purchase order are $144.00. Purchasing manager’s salary is $80,000 per year. Required: Calculate Cooler’s EOQ for CK55. Calculate Cooler’s total ordering and carrying costs. Assume that demand is uniform throughout the year and is known with certainty. The purchasing time is half a month. Calculate the reorder point for CK55.

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

Write the algebraic formulation of the problem. Decision Variables: b. Solve using Excel solver to minimize cost. a.