Consider the following information. PART X Gross Requirements Scheduled Receipts Projected On-Hand Inventory 110 Q-40, LT-3 weeks, Safety Stock = 15 Compute the planned order releases and projected on-hand inventory for component part X. Round your answers to the nearest whole number. If your answer is zero, enter "0". PART X Gross Requirements Scheduled Receipts Projected On-Hand Inventory 110 Planned Order Releases 1 50 60 1 50 60 WEEK 3 100 2 0 2 0 0 4 70 WEEK 3 100 -0 5 0 4 70 0. 5 0 0

Consider the following information. PART X Gross Requirements Scheduled Receipts Projected On-Hand Inventory 110 Q-40, LT-3 weeks, Safety Stock = 15 Compute the planned order releases and projected on-hand inventory for component part X. Round your answers to the nearest whole number. If your answer is zero, enter "0". PART X Gross Requirements Scheduled Receipts Projected On-Hand Inventory 110 Planned Order Releases 1 50 60 1 50 60 WEEK 3 100 2 0 2 0 0 4 70 WEEK 3 100 -0 5 0 4 70 0. 5 0 0

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

Your company currently keeps a safety stock of 554 units of a particular product that has a lead time of 10 days. Records indicate that the weekly demand was as follows: 1176 955 780 1052 736 842 748 993 852 738 794 1444 1333 1372 1106 706 923 734 786 729 1357 1165 1277 683 1106 What is the current service level? Input your result as the decimal form and round to 4 decimal places. You are requested to recommend a safety stock that will ensure an average service level of 97.5%. The lead time is not expected to change. What safety stock would you recommend? (0 decimal places)
"If the demand for a good decreases when a consumer's income rises, the demand for that good must decrease when its price rises". This statement is valid for Nora's demand for cheese. This statement is not valid for Chris' demand for pasta. Q1 a) Using an appropriate model with a diagram, explain in detail Nora's demand for cheese.
Which of the following is ‘data’? i. Number of items in inventory in the store were 3,000 ii. Value of items in the store was OMR 5,000 iii. Total items with value OMR 1,500 to OMR 3,000 were 500
Consider the following information. PART X Gross Requirements Scheduled Receipts Projected On-Hand Inventory 130 Q-60, LT-3 weeks, Safety Stock - 20 Compute the planned order releases and projected on-hand inventory for component part X. Round your answers to the nearest whole number. If your answer is zero, enter "0". PART X Gross Requirements Scheduled Receipts Projected On-Hand Inventory 130 Planned Order Releases 1 50 50 1 50 130 0 2 0 WEEK 3 70 99 2 0 130 120 ®® 4 0 WEEK 3 70 30 0 5 130 x 4 0 30 5 130 20 0
27) Ali has a restaurant where the customers use a different number of disposable cups each day he is open. Every 30 days, Ali places an order to replenish his cup inventory. It takes 3 days for the order to arrive, at which point it brings the inventory level up to 4000 cups. It costs Ali $30 to have the order processed. Select all statements that apply to Ali's situation: Group of answer choices a) Ali uses a Continuous Inventory System b) d is constant c) Ali uses a Periodic Inventory System d) Ali uses a Fixed-Order-Quantity Inventory System e) Maximum Inventory Level is constant
You are the executive chef at a large wedding facility, and a wedding with a confirmed count of 168 is scheduled for tomorrow at noon. Everything has been ordered except the shrimp, which was missing from the last purchase order. It will have to be a last-minute rush order, and only one supplier can get it to you in time. The purchase order will be for frozen raw, U 16-20, shrimp peeled, de-veined, tail-on, in 5-pound boxes (according to your spec for the product). You’ve dealt with this supplier before, and made a note to yourself on the jumbo shrimp spec that this vendor’s product averages 19 to 20 shrimp per pound and has a 96% yield. Catering policy dictates that a 10% buffer be provided for unexpected guests, and the catering menu states that 5 shrimp are to be served per person. If you have 4 pounds of good jumbo shrimp on hand, how much will you order for the wedding? Will there be any leftover product? How much?
Which of the following is a valid approach to introduce safety stock for dependent demand items? None of the other answer choices are correct. Safety stock is never introduced for dependent demand items A, B, and C are all valid approaches A. Increase the replenishment order by a quantity specified by some estimate of expected plan error B. Add Safety Time into the requirements plan C. Utilize statistical techniques to set safety stocks directly for a dependent demand item
An organization has a goal to prevent the ordering of inventory quantities in excess of its needs. One individual in the organization wants to design a control that requires a review of all purchase requisitions by a supervisor in the user department prior to submitting them to the purchasing department. Another individual wants to institute a policy requiring agreement of the receiving report and packing slip before storage of new inventory receipts. Which of these controls is (are) relevant in achieving the stated goal? Explain your answer.
c) Even if there is substantial uncertainty in the parameters in the EOQ-model, it is still quite a useful model. Discuss why.
Consider the following information. PART X Gross Requirements Scheduled Receipts Projected On-Hand Inventory 100 Q = 60, LT= 3 weeks, Safety Stock = 5 1 70 70 PART X Gross Requirements Scheduled Receipts Projected On-Hand Inventory 100 Planned Order Releases 1 70 70 100 2 0 > X WEEK 3 40 Compute the planned order releases and projected on-hand inventory for component part X. Round your answers to the nearest whole number. If your answer is zero, enter "0". 2 0 4 0 100 WEEK 3 40 5 160 60 4 0 40 0 X 5 160 Check My Work -60 0
University of Florida football programs are printed 1 week prior to each home game. Attendance averages 90,000 screaming and loyal Gators fans, of whom two-thirds usually buy the program, following a normal distribution, for $5 each. Unsold programs are sent to a recycling center that pays only 10 cents per program. The standard deviation is 5,000 programs, and the cost to print each program is $1. Refer to the standard normal table for z-values. a) What is the cost of underestimating demand for each program? Cs = $ (round your response to two decimal places). b) What is the overage cost per program? = $ (round your response to two decimal places). c) How many programs should be ordered per game? programs should be ordered per game (round your response to the nearest whole number). d) What is the stockout risk for this order size? Stockout risk = (round your response to four decimal places).
University of Florida football programs are printed 1 week prior to each home game. Attendance averages 90,000 screaming and loyal Gators fans, of whom two-thirds usually buy the program, following a normal distribution, for $5 each. Unsold programs are sent to a recycling center that pays only 10 cents per program. The standard deviation is 5,000 programs, and the cost to print each program is $1. Refer to the standard normal table for z-values. a) What is the cost of underestimating demand for each program? C = $4 (round your response to two decimal places). b) What is the overage cost per program? Co = $.9 (round your response to two decimal places). c) How many programs should be ordered per game? programs should be ordered per game (round your response to the nearest whole number).