The master schedules for product P and Q along with the Bills of Material and part information are shownbelow: Given this information, answer the next 3 questions:MPSPeriodProduct PProduct QPartABCD100a.b.25010Lead Lot Ontime Sizing Hand1 L4L502L4L1L4L2L4L 650Part Information37510050400C. 800d. 2004100200ScheduledReceipts50 in pd 210 in Pd 20051255011. The second planned order release for Part A is:100 in Pd. 1150 in Pd. 3c.10 in Pd. 2d. 200 in Pd. 312. The gross requirements for Part C in Pd. 3 are:a. 500b. 300c. 900d. 450C (2)13. The planned order release for Part D in Pd. 1 is:a. 0b. 60067525A (2)PD (1)B (1)D (1)C (1)B (1)QD (2)D (2) Acme Inc. sells a widget with demand of 50 a day. Acme reviews its orders every 15 days and maintains asafety stock level of 200. The lead-time A is 3 days and today there are 227 units in stock. Please answer thenext 2 questions:14. The target inventory level for item A is:a. 1500b. 1150c. 1250d. 170015. If an order for A is placed today, the order quantity should be:a. 923b. 789c. 1240d. 80016. At a Super America convenience store, customers enter the facility at the average rate of 15 customersper hour. There is a single attendant who takes an average of 4 minutes to process a customer. If weassume that every customer must be processed, the average number of customers in the store is:1.01.5c.5d. .833a.b.

Answered: Image /qna-images/answer/b7da9627-a82e-4e7f-89cf-cb3171cf3516.jpg

Answered: The master schedules for product P and…

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

1. Gursoy Manufacturing Company originally estimated its annual demand for item XYZ as 8000 units per year at a unit cost of $10. The order cost is $30 and the holding cost per unit is $3 annually. Gursoy has discovered at the end of the year that annual demand is only 6000 units and holding cost per unit per year are closer to $4. The only good news is that Gursoy figured orders cost $25 to place instead of $30 each. Gursoy now wants to know the significance of these mistakes on last year's decisions. a) What was the combined effect of these errors on the economic order quantity for item XYZ? b) What was the individual effect of each error on item XYZ economic order quantity? c) What was the combined effect of these errors on the minimum total variable cost (fixed order cost and holding cost) of item XYZ for last year? d) What was the individual effects of each error in demand on the minimum total variable cost for last year?
Assume that the company has been able to reduce the cost of placing an order to only P1.00 and that when the waste and inefficiency caused by inventories is considered, the cost to carry an inventory jumps to P 1.60 per unit. What would be the Economic Order Quantity (EOQ) under these conditions?
Given this information:Lead-time demand 600 poundsStandard deviation of lead time demand 52 pounds (Assume normality.)Acceptable stockout risk during lead time 4 percenta. What amount of safety stock is appropriate?b. When should this item be reordered?c. What risk of stockout would result from a decision not to have any safety stock?
A manufacturing company produces two products X and Y. Each product X requires one A and two Bs. Each B requires one C and one D. Each product Y requires 1 C and 4Ds. Table Q5A shows data from the inventory records of components. Table Q5A Data category A B C D Lot - sizing rule Fixed order quantity = 250 Lot for lot Lot for lot Fixed order quantity = 1000 Lead time 3 weeks 2 weeks 1 week 2 weeks Beginning inventory 70 0 200 800 The MPS for products X and Y is given in Table Q5B. The on-hand inventories are as follows: X = 100, Y = 30. The only scheduled receipts are 250 units of X in period 2.The lead times are as follows: X = 2 weeks, Y = 3 weeks. The chase strategy is used for both products. Table Q5B Demand in period Product SS 1 2 3 4 5 6 7 8 X 50 300 200 250 Y 30 400 Required: a) Draw a product structure tree for each product. b) Develop…
39 Item X Is a standard item stocked in a company's inventory of component parts. Each year the firm, on a random basis, uses about 2,700 of item X, which costs $25 each. Storage costs, which include insurance and cost of capital, amount to $5 per unit of average inventory. Every time an order is placed for more of item X, it costs $20. a. Whenever item X is ordered, what should the order size be? Note: Round your answer to the nearest whole number. b. What is the annual cost for ordering item X? Note: Round your order quantity to the nearest whole number and your final answer to 2 decimal places.
5. A product has an average daily demand of 400 units with standard deviation of 10.0 units. Lead-time is 1 day. If management would like to satisfy all demand in 80% of the cycles, what is the reorder point? 6. A product sells for $24 per unit and costs the retailer $12 per unit, unsold units by the end of the season are salvaged for $7.0. Demand is normally distributed with a mean of 1000 units and standard deviation of 100 units. How many units should the retailer order? 7. A product sells for $24 per unit and costs the retailer $12 per unit, unsold units by the end of the season are salvaged for $9.0. Demand is normally distributed with a mean of 1000 units and standard deviation of 100 units. How many units should the retailer order?
1. Forrest and Dan make boxes of chocolates for which the demand is uncertain. Forrest says, "That's life." On the other hand, Dan believes that some demand patterns exist that could be useful for planning the purchase of sugar, chocolate, and shrimp. Forrest insists on placing a surprise chocolate-covered shrimp in some boxes so that "You never know what you'll get." Quarterly demand (in boxes of chocolates) for the last three years is shown in the table below: b. If the expected sales for chocolates are 14,400 cases for year 4, use the multiplicative seasonal method to prepare a forecast for each quarter of the year. (Round all intermediate calculations to two decimal places.) The first quarter forecast is what? boxes of chocolates. (Enter your response rounded to the nearest whole number.)
Bulldogs Inc. expects to use 48,000 boxes of chocolate per year costing P12 per box. Inventory carrying cost is equal to 20% of the purchase price. The company uses its inventory at a constant rate. The lead time for placing the order is 3 days, and Bulldogs Co. holds 2,400 boxes of paint as safety stock. If the company orders 2,000 boxes of chocolate per order, what is the cost of carrying inventory? A. P8,160 B. P5,280 C. P5,760 D. P2,400
Rick Jerz is attempting to perform an inventory analysison one of his most popular products. Annual demand for thisproduct is 5,000 units; ca rrying cost is $50 per unit per year; ordercosts for his company typically run nearly $30 per order; and leadtime averages I 0 days. (Assume 250 working days per year.)a) What is the economic order quantity?b) What is the average inventory?c) What is the optimal number of orders per year?d) What is the optimal number of working days between orders?e) What is the total annual inventory cost (carrying cost+ ordering cost)?t) What is the reorder poi nt?
39) please help me with this Item X Is a standard item stocked in a company's inventory of component parts. Each year the firm, on a random basis, uses about 2.700 of item X, which costs $25 each. Storage costs, which include insurance and cost of capital, amount to $5 per unit of average inventory. Every time an order is placed for more of item X, it costs $20 c. What is the annual cost for storing item X? Note: Round your order quantity to the nearest whole number and your final answer to 2 decimal places.
Catlea Merchandising is engaged in selling school shoesfor both boys and girls in their teenage years. Catlea needs 32,000 pairs of shoes in a year in order to satisfy the market demand. It costs ₱ 48 to place an order while ₱ 8 is needed to hold each quantity of shoe in Catlea's inventory. Upon checking on Catlea's supplier, it takes 8 days in between placing an order and eventually receiving it. a. Determine the Economic Order Quantityb. Determine the number of order per monthc. Determine the reorder point
Furnco sells secretarial chairs. Annual demand isnormally distributed, with mean of 1,040 chairs and standarddeviation of 50.99 chairs. Furnco orders its chairs from itsflagship store. It costs $100 to place an order, and the leadtime is two weeks. Furnco estimates that each stockoutcauses a loss of $50 in future goodwill. Furnco pays $60 foreach chair and sells it for $100. The annual cost of holdinga chair in inventory is 30% of its purchase cost.a Assuming that all demand is backlogged, what arethe reorder point and the safety stock level? b Assuming that all stockouts result in lost sales, de-termine the optimal reorder point and the safety stock level.

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

The master schedules for product P and Q along with the Bills of Material and part information are shown below: Given this information, answer the next 3 questions: MPS Period 1 2 3 4 5 6