V2 2. MC also considers selling a high-end and a low-end model, 100 and 500 units per month, respectively.Their unit cost is $2000 and $500, respectively. The joint order cost is increased by $1000 for eachadditional product type (i.e., $7000 for three product types). Find the optimal number of joint orders peryear and subsequently the optimal order quantity for each product type (round it to the nearest integer).Also, calculate the total annual cost for the three product types with joint orders.

Economic order quantity is the formula that is used in the management of inventory to determine the…

Answered: 2. MC also considers selling a high-end…

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

A manufacturer procures a subassembly from a supplier. The annual demand is 165,000 units, the cost per unit is $5, the inventory-carrying charge is 13 percent, and the order cost is $220. For orders between 10,000 but less than 25,000, a six percent discount is applied, and for orders exceeding 25,000, an eight percent discount is applied. What is the optimal order quantity? Use the Quantity Discount Excel template to find your answer.
An organization manufactures supplies for landscaping companies which has an annual demand of 16,000. The cost of storing each unit is $2.5/year and $50 to make an order. Say the company has 300 days of annually, answer the following questions: a. What is the optimal order quantity? b. How many orders in a year? c. How many days between orders? d. How much is the total inventory cost?
The materials manager for a billiard ball maker must periodically place orders for resin, one of the raw materials used in producing billiard balls. She knows that manufacturing uses resin at a rate of 50 kilograms each day, and that it costs $.04 per day to carry a kilogram of resin in inventory. She also knows that the order costs for resin are $100 per order, and that the lead time for delivery is four days. If the order size was 1,000 kilograms of resin, what would be the average inventory level?
A printing company anticipates using 40,000 reams of paper at a uniform rate over the next year. Each time they place an order for X units of reams of paper, it is charged a flat fee of $200. Carrying costs are $4 per unit per year. A. use the formula for Economic Order Quantity to find out how many reams of paper they should purchase in each order. B. how many orders should they place over the year?
The store wants to determine the Economic Order Size (EOQ) and Total Inventory Cost for this brand of carpet given an estimated annual demand of 10,000 yards of carpet, an annual carrying cost of P 37.50 per yard, and an ordering cost of P 7,500.00. The store would also like to know the number of orders that will be made annually and the time between orders (i.e., the order cycle), given that the store is open every day except 52 Sundays, Philippine Independence Day, New Year, and Christmas Day (which are assumed to fall not on Sundays) A. Using the computed optimal order size or EOQ, determine the optimum Total Cost. C. Determine the Order Cycle Time
1) What is the total demand of an enterprise with an economic order quantity of 1,500 units, a cost of 11.250 TL for each order, and 75 TL for one unit of inventory?a) 20,000b) 17,500c) 7,500d) 12,500f) 2,500 2) What is the total inventory cost of this business?a) 200,000b) 239,000c) 185,250d) 168,750e) 218,500
A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a servicelevel of .98. The order interval is 14 days, and lead time is 2 days. Average demand for one itemis 40 units per day, and the standard deviation of demand is 3 units per day. Given the on-handinventory at the reorder time for each order cycle shown in the following table, determine theorder quantities for cycles 1, 2, and 3.Cycle On Hand1 422 83 103
If EOQ = 289 units, S = $100, and H = $1 per unit per month, what approx. annual demand (D) level would the EOQ model best fit? Pick the closest answer option. EOQ = Sq root of [(2D*S)/H] D = annual demand in units S = cost of placing 1 order; H = cost of holding 1 unit of that item in inventory for 1 year 3596 units 3540.00 units 5011 units 4510 units
Genesis Company is a wholesaler. It purchases 60,000 units of Product X per month for sale to retailers. The cost of placing an order is P100. The cost of holding one unit of inventory for one year is P4. Note: Kindly input your answer with comma.Example: 10,000 Required: a. Compute the economic order quantity. b. How many orders would be placed under the EOQ policy? c. Compute the annual ordering cost for the EOQ. d. Compute the annual carrying cost for the EOQ. e. Compute the total inventory-related cost at the EOQ.
The following information relates to the forthcoming period:-Order costs = $25per orderHolding costs = 17% of purchase priceAnnual demand = 16,000 unitsPurchase price = $17 per unitOrder quantity = 650 unitsRequired:-What are the total annual costs of inventory?
A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a service level of .99. The order interval is 12 days, and lead time is 4 days. Average demand for one item is 63 units per day, and the standard deviation of demand is 6 units per day. Given the on-hand inventory at the reorder time for each order cycle shown in the following table. Use Table. Cycle On Hand 1 38 2 10 3 93 Determine the order quantities for cycles 1, 2, and 3: (Round your answers to the nearest whole number) Cycle Units 1 1019 Numeric ResponseEdit Unavailable. 1019 incorrect. 2 1047 Numeric ResponseEdit Unavailable. 1047 incorrect. 3 964 Numeric ResponseEdit Unavailable. 964 incorrect.
We are given the following information for a product:Order cost $50Annual demand N(960, 3,072.49)Annual holding cost $6/item/yearShortage cost $80 per unitLead time one monthSales price $40 per unitProduct cost $30 per unita Determine the order quantity and the reorder pointunder the assumption that all demands are backordered. b Determine the order quantity and reorder point un-der the lost sales assumption.

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