Given the following data:PeriodGross1 2 3 45 6 7 8Requirements 20 20 50 50 80 8050 50The beginning inventory is 0 and there are no scheduled receipts. The order cost is $50 and theholding cost is $1 per part per period.What are the order costs, carrying costs, and totals cost over the 8 periods using the period orderquantity rule with POQ = 2?Oorder costs $200, carrying costs $200, and total costs $400Oorder costs $400, carrying costs $340, and total costs = $740Oorder costs $200, carrying costs $340, and total costs $540Oorder costs $400, carrying costs $0, and total costs = $400

Answered: Given the following data: Period Gross…

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

i need D) The demand for a certain article is 400 art/month. The ordering cost is $35 and the storage cost is $10/month. The purchase cost is $15 but if 70 items or more are purchased there is a discount andThey drop at $10. a) Obtain the optimal amount of inventory Yb) Obtain the total cost of inventoryc) Is it convenient to accept the discount?d) What is the cost of inventory with quantity m?
Brock Co. adopted the dollar-value LIFO inventory method as of January 1, year 1. A single inventory pool and an internally computed price index are used to compute Brock’s LIFO inventory layers. Information about Brock’s dollar-value inventory follows: What was Brock’s dollar-value LIFO inventory at December 31, year 2? a. $80,000 b. $74,000 c. $66,000 d. $60,000
Miguel has a product with an annual holding cost percentage of 20%, an ordering cost of $110 per order, and annual demand of 15,000 units. The following price schedule applies to the product from a supplier. What is the optimal order quantity? Show all work including a graph. Units Price 1-250 $30.00 251-500 $28.00 501-750 $26.00 ≥ 751 $25.00
Given an ordering cost of $200, a holding cost of $2 perunit, and a negligible lead time, examine the following de-mand patterns and predict which lot sizing technique wouldresult in the lowest total cost. Verify your predictions Period 1 2 3 4 Gross Requirements 50 50 10 10
The annual demand, ordering cost, and the annual inventory carrying cost rate for a certain item are 600 units, Quantity 1 to 49 50 to 249 250 and up Price $5.00/unit $4.50/unit $ 4.10/unit $20/order and 30% of item price, respectively. (a) Assume the discounts applied to all the units in the order, what should the order quantity be in order to minimize the average annual cost? Also, show the minimal average annual cost. (b) Assume the discounts applied to the units are incremental, what should the order quantity be in order to minimize the average annual cost? Also, show the minimal average annual cost.
Tacky Souvenirs sells lovely handmade tablecloths at its islandstore. These tablecloths cost Tacky $15 each. Customers wantto buy the tablecloths at a rate of 240 per week. The companyoperates 52 weeks per year. Tacky, the owner, estimates hisordering cost at $50. Annual holding costs are 20 percent of theunit cost. Lead time is 2 weeks. Using the information given,(a) Calculate the economic order quantity.(b) Calculate the total annual costs using the EOQ.(c) Determine the reorder point.
In the calculation of an optimal policy for an all-units discount schedule, you firstcompute the EOQ values for each of the three order costs, and you obtain: Q(0) =800, Q(1) =875, and Q(2) =925. The all-units discount schedule has breakpointsat 750 and 900. Based on this information only, can you determine what the optimal order quantity is? Explain your answer.
Rafiki Bar uses 10,000 cases of millet beer monthly. One case costs Shs.5,000. Holding cost is 30% of the cost of a case p.a while ordering cost is Shs.100,000 per order. The firm works 360 days in a year while lead time is 6 days. Required: ii. Determine the days between orders and the reorder point iii. Determine the total cost of the inventory policy iv. Suppose actual holding cost turns out to be 15% instead of 30% and the inventory policy above is implemented for a year, determine the cost of prediction error if every other parameter estimate turns out as predicted.
A bey Kuru villa, of Parkside Plumbing, uses I ,200 ofa certain spare part that costs $25 for each order, with an annualholding cost of $24.a) Calculate the total cost for order sizes of25, 40, 50, 60, and 100.b) Identify the economic order quantity and consider the implicationsfor making an error in calculating economic orderquantity.
The two most important inventory-based questionsanswered by the typical inventory model are:a) when to place an order and the cost of the order.b) when to place an order and how much of an itemto order.c) how much of an item to order and the cost of the order.d) how much of an item to order and with whom theorder should be placed.
Emery Pharmaceutical uses an unstable chemicalcompound that must be kept in an environment where both temperatureand humidity can be controlled. Emery uses 800 poundsper month of the chemical, estimates the holding cost to be 50%of the purchase price (because of spoilage), and estimates ordercosts to be $50 per order. The cost schedules of two suppliers areas follows: a) What is the economic order quantity for each supplier?b) What quantity should be ordered, and which supplier should be used?c) What is the total cost for the most economic order size?d) What factor(s) should be considered besides total cost?
Penalty costs can be assessed only against the number of units of demand that cannot be satisfied, or against the number of units weighted by the amount of time thatan order stays on the books. Consider the following history of supply and demandtransactions for a particular part:Number of Items Demand duringMonth Received MonthJanuary 200 520February 175 1,640March 750 670April 950 425May 500 280June 2,050 550Assume that starting inventory at the beginning of January is 480 units.a. Determine the ending inventory each month. Assume that excess demands areback-ordered.b. Assume that each time a unit is demanded that cannot be supplied immediately,a one-time charge of $10 is made. Determine the stock-out cost incurred duringthe six months (1) if excess demand at the end of each month is lost, and (2) ifexcess demand at the end of each month is back-ordered.c. Suppose that each stock-out costs $10 per unit per month that the demandremains unfilled. If demands are filled on a first-come,…

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