WAI has developed the following MPS. Calculate theprojected available and the available-to-promise quantities for WAI. 1467Forecast30 30 30 4040404545Customer Order3515 20181215Proj. Available 50Available-to-promiseMPS1001001003.2.

MPS is a predicted form schedule for fabricating end products or goods options. It is an essential…

Answered: 1 4 6 7 Forecast 30 30 30 40 40 40 45…

1 4 6 7 Forecast 30 30 30 40 40 40 45 45 Customer Order 35 15 20 18 12 15 Proj. Available 50 Available-to-promise MPS 100 100 100 3. 2.

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

Production Quantity Model A manufacturing company operates 300 days a year with an annual demand for component C of 43,200 units. The fabrication department at the company is able to produce 800 units per day and send them over to assembly while production is in progress. If assembly sends a work order for 11,200 units of component C to fabrication, how long is the order receipt period? Given the order quantity in the previous question, what is the average inventory level for component C?
How would these factors affect an EOQ analysis?(1) The use of just-in-time procedures.
B15. The restaurant uses 24 bottles of wine to operate and it has 3 bottles in hand. Calculate the Desired Ending Inventory (DEl) if the number of days in the delivery period is 2 and the safety factor is 10%. Using the Periodic Order Method, calculate the number of bottles that the restaurant should order.
The Meeras Cafeteria at the College of Economics and Political Science serves cooked food including shawarma and hamburgers, as well different types of drinks and packaged food products 1/ What type of inventory system would you suggest for the Meeras Cafeteria - Continuouis Review or Periodic Review? What is the reason for your answer. 2) To implement the system you suggest, what data will you need, and how do you obtain this data. 3) Once you have identified the needed data, explain how you can implement the inventory management system. Indicate a recommended service level, how you will decide the order quantities and how inventory will be monitored.
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.
The fixed quantity version of EOQ compares and contrasts with the fixed interval version. Where will each of the scenarios be used?
Investigate the effects of demand variability on the overall effectiveness of the Wilson approach in inventory management.
Madonna’s Burgers is considering making hamburger buns in-house instead of buying them from its supplier. It has estimated the fixed costs for a used over to be $7,000 and the variable costs for the buns to be $0.25. It purchases buns for $0.50 each, and there are no fixed purchase costs. Its annual demand for buns is forecasted to be 15,000. Madonna’s wants to know how many buns it has to make to break even.
Discuss the meaning of inventory analyses by ABC. Name a number of actions that can identify the status of ABC?
Explore the role and implications of safety stock within the framework of the Wilson approach for effective inventory control.
Describe that reorder point & lead time interrelated in inventory analysis in what way ?
No Spacing Heading 1 Paragraph Styles Ed Item SKU A3378 has a demand that is normally distributed during the lead time, with a mean of 360 units and standard deviation 9999 of 12. If Hinsdale cannot have stockout in more than 10% of the time in any order, how much safety stock should be maintainec and at what reorder point? Calculate Hinsdale's safety stock and reorder point for three other SKUS under the following conditions of demand and lead time: A) SKU F5402: daily demand is normally distributed with a mean of 16, standard deviation of 4, lead time is 4 days, and must operate at a 95% service level Calculate Hinsdale's safety stock and reorder point for three other SKUS under the following conditions of demand and lead time: 1. SKU F5402: daily demand is normally distributed with a mean of 16, standard deviation of 4, lead time is 4 days, and must operate at a 95% service level. hs: On