A company must meet the following demands(but backlogs and inventory allowed with charges)January 30; February 30; March 20all demand must be met by end of March.Inventory costs $20/ unit at month end, and backlogged demand incursa $5 / unit per month cost.This table lists the monthly production capacity and unit production costs.MonthJanuaryFebruaryMarchProduction Cap353035Unit costs400420410Set up the transportation simplex (and then solve) where the rows areMonthly Supply and the Columns are the monthly deliveries.You'll need a dummy demander.A unit shipped from February Supply to a January demand is LATE. A unitshipped from a February Supply to a March demand has been put inInventory for a month.1. How many February units are shipped to February demand2. What is the total optimal cost.

Find the Given details below: Given details: Month Production Capacity Unit cost Demand…

Answered: A company must meet the following…

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 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
Historical demands observed for the last 5 months are 1000, 2300, 3200, 1750, and 1200. To match the demand, the company placed respective orders of 1100, 2500, 4000, 1000, and 900 units. (a) Compute the variance of demand. (b) Compute the variance of orders. (c) Compute the bullwhip measure. Is there an amplifying or smoothing effect?
Martina is in charge of ordering brake pads for an auto shop. The daily demand for brake pads is normally distributed with an average of 40 brake pads and a standard deviation of 8 break pads. Currently, it takes 4 days between when Martina places an order for new brake pads and when the order is received. Currently, Martina orders new break pads when there are 184 break pads left in stock. 1) What is the average demand during lead time? 2) What is the standard deviation of demand during lead time? 3)What is the service level provided by Martina's auto shop?
Evaluate the ethical dilemmas in inventory optimization, particularly concerning product shelf life, waste reduction, and environmental impact.
Green Gardens' owner has asked your advice about a possible problem at his business. Over the last 6 months the large-sized lawn and garden inventory (ie, tables, chairs, planters, etc.) has appeared to be short. The inventory records that employees use to determine what is on hand show that more inventory is available than can actually be located. This has cause frustration and mis-trust in the inventory records for the sales employees. The owner realizes that the problem is bigger than just frustrated employees. He is afraid that inventory is being stolen, a problem he didn't think possible given that these are large items that are not easily moved. Requirements: Provide the owner with two internal controls that he could implement to reduce the likelihood of theft of the lawn and garden inventory.
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)
Help need. management accounting Lebar Daun Sdn Bhd is planning to use the economic order quantity model to determine the optimal order levels of raw materials. Material Z is consumed evenly over the year and the current usage is 120,000 units. The material is purchased in boxes and each box contains 12 units of material Z, at a price of RM252 per box. A safety stock of 200 boxes is kept. The cost of placing and handling orders is estimated to be RM6,300, which is based cost incurred for similar orders that have already made. The cost of RM6,300 was for 30 orders. The inflation of 2 per cent should be added to the above ordering costs. Besides, the company estimates to be charged the transporation cost of RM15 per order. It should be assumed that ordering costs change in proportion to the number of orders place. Other costs which relate to material Z such as insurance, interest and space costs for a year, were calculated at 15 % of the purchase price. Required: a. Calculate the order…
Solve for the most economical number of units that a company should order given the following: The yearly demand for the company's product is 300.000 units with an ordering cost of $40 per order and carrying cost of $5 per unit of inventory per year.
gainesvile cigar stocks cuban cigars that have variable lead times because of the difficulty in importing the product: lead time is normally distributed with an average of 6 weeks and a standard deviation of 2 weeks. demand is also a variable and normally distributed with a mean of 200 cigars per week and a standard deviation of 25 cigars. a) for a 90% of service level, what is the rop?
ATK-Auto obtains one of the critical parts from its sub-constructor located in China. Daily demand at the production plant in Roma is normally distributed, with a mean of 2100 and a standard deviation of 450 units. The target CSL is 95 percent. The company is considering two different modes of transportation from China: Sea or Air. Sea transportation results in a lead time of 30 days and costs $1.5 per part. Air transportation results in a lead time of 4 days and costs $8.50 per part. Each part costs $350 and ATK-Auto uses a holding cost of 25 percent. Given the minimum lot sizes, ATK would order 11,000 parts at a time if using sea transport and 400 parts at a time if using air transport. Assume that ATK pays for the parts when the order is placed.a. Assuming that ATK follows a continuous review policy, what reorder point and safety inventory should the warehouse aim for when using sea or air transportation?b. How many days of cycle inventory does ATK carry under each policy?c. Which…
David’s Delightful Kites Company (DDKC) manufactureskites. Th e most popular is David’s Daredevil model. Demandmanagement has prepared forecast estimates for the next sixweeks. Beginning inventory is 15 David’s Daredevils. As themaster scheduler for DDKC, you must prepare an MPS. Your MPSorder quantity is 72 kites. (a) Prepare the MPS using an order quantity of 72 kites.(b) Calculate the ending inventory for each period.(c) What is the maximum number of units held in inventory?(d) How many MPS orders are needed?
Windmire Company manufactures and sells to local wholesalers approximately 300,000 units per month at a sales price of $4 per unit. Monthly costs for the production and sale of this quantity follow.

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