Consider a two-stage plant-retailer supply chain. Lead time for orders is two weeks. Safety stock is equal to one week's demand, and future demand is estimated by the average of the past two weeks. 1. Develop production planning model (equations) for the retailer that states the order-up- to rule, and order quantities as a function of time. 2. Using a table format (Columns are Week, Starting retail inventory, On order, Order-up-to target, Order quantity, and Demand) track performance of the retailer for eight weeks if demand suddenly shifts from 100 units per week to 110 units per week starting in period 3 and stays at 110 to the end.

Consider a two-stage plant-retailer supply chain. Lead time for orders is two weeks. Safety stock is equal to one week's demand, and future demand is estimated by the average of the past two weeks. 1. Develop production planning model (equations) for the retailer that states the order-up- to rule, and order quantities as a function of time. 2. Using a table format (Columns are Week, Starting retail inventory, On order, Order-up-to target, Order quantity, and Demand) track performance of the retailer for eight weeks if demand suddenly shifts from 100 units per week to 110 units per week starting in period 3 and stays at 110 to the end.

Name: Consider a two-stage plant-retailer supply chain. Lead time for order
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: Consider a two-stage plant-retailer supply chain. Lead time for orders is two weeks. Safetystock is equal to one week's demand, and future demand is estimated by the average of thepast two weeks.1. Develop production planning model (equations) for t

Understanding Business

12th Edition

ISBN:9781259929434

Author:William Nickels

Publisher:William Nickels

Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment

Section: Chapter Questions

Problem 1CE

See similar textbooks

Similar questions

Instructions There are four parts to this problem. Use Excel to perform the following. a. Use the economic order quantity formula (EOQ = SQRT((2SD/H)) to determine the optimal number of units that the company should order based on each assumed level of order based on each assumed level of order quantities provided in the data. b. Complete the table by calculating the number of orders per year, annual order cost, annual holding cost, and annual total cost. Highlight the minimum annual total cost using conditional formatting. Hint: The minimum cost should equal the cost at the EOQ you calculated in part a. c. Create a line chart that graphs annual order cost, annual holding cost, and annual total cost. The x-axis should be the quantity ordered. Include a chart legend, appropriate chart title, axes labels, and properly formatted amounts on the axes. d. Examine the chart and your responses to parts a and b. Indicate any relationships.
Suppose that an organization is engaged in manufacturing and sales of a seasonal product. Based on a sales forecast of 1000, 500, 500, and 2000 per quarter, calculate a level production plan, quarterly ending inventory, and average quarterly inventory. If inventory carrying costs are $7 per unit per quarter, what is the annual cost of carrying inventory? Assume that the opening and ending inventories are zero. (without using Excel)
A company manufactures two products A and B. Each A requires two C’s and one D. Each D requires two F’s and one E, while each E requires one F. Each product B requires one D and two E’s. The table below shows data from the inventory records. ITEM ITEM ITEM ITEM DATA CATEGORY C D E F Lot - sizing rule Fixed Order Quantity = 220 Lot for Lot Fixed Order Quantity = 300 Period Order Quantity P = 2 Lead time 3 weeks 2 weeks 3 weeks 2 weeks Scheduled receipts 280 (week 1) None 300 (week 3) None Beginning inventory 25 0 150 600 The MPS for product A calls for 85 units to be started in week 3 and 100 units to be started in week 6. The MPS for product B calls for 180 units to be started in week 5.Develop the material requirements plan (showing Gross requirements, Scheduled receipts, On hand inventory, Net requirements, and Planned-order release) for the next six weeks for items C, D, E and F.
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.
Suppose that an organization is engaged in the manufacturing and sales of a seasonal product. Based on a sales forecast of 1000, 500, 500, and 2000 per quarter, calculate a level production plan, quarterly ending inventory, and average quarterly inventory. If inventory carrying costs are $7 per unit per quarter, what is the annual cost of carrying inventory? Assume that the opening and ending inventories are zero. (With steps)
Halloween is the big holiday for a candy manufacturer—more than half of its salesoccur in the month leading up to Halloween. As a result, the manufacturer produces a largestockpile of inventory before the holiday. Which of the following best explains the reason forthis inventory?a. Seasonalityb. Batchingc. Buffersd. Uncertain demande. Pricing
Hayes electronics assumed with certainty that the ordering cost is $450 per order and the inventory carrying cost is $170 per unit per year. However, the inventory model parameters are frequently only estimates that are subject to some degree of uncertainty. Consider four cases of variation in the model parameters as follows: (a) both ordering cost and carrying cost are 10% less that originally estimated, (b) both ordering cost and carrying cost are 10% higher than originally estimated, (c) ordering cost is 10% higher and carrying cost is 10% lower than originally estimated, and (d) ordering cost is 10% lower and carrying cost is 10% higher than originally estimated. Determine the optimal order quantity and total inventory cost for each of the four cases. Prepare a table with values from all four cases and compare the sensitivity of the model solution to changes in parameter values.
Please do not give solution in image format thanku A company produces sandals in four different patterns for summer. The demand for all four patterns is seasonal and normally distributed. Each of the four patterns has an expected demand of 10,000 pairs with a standard deviation of 4,000 pairs. Currently, all patterns are produced before the start of the season. Production cost is $20 per pair, and they are sold for a wholesale price of $36 per pair. Any unsold sandal at the end of the season is sold at discounted price of $15 per pair. It costs $1 per pair to hold the sandals in inventory for the entire season if it does not sell. The company is considering the postponement of printing the pattern of the sandals. This will require the base sandals to be made in advance (identical for each of the four models) and the final patterns to be printed later. This will increase production cost of sandals to $22. 5 per pair. What is the optimal cycle service level before postponement? (choose…
Usha Handling Company is currently faced with an inventory rotation problem. Thisdifficulty stems from the fact that some supplies must be used prior to a stated expiration date.Upon receipt, a new shipment of these perishable items must be stacked beneath the boxes that are currently in inventory. A substantial amount of time is consumed in restacking the items according to their expiration dates. The company would like to reduce the double and sometimes triple handling of items. How can this goal be achieved? Are there alternative solutions which might also be effective?
(1-b) XYZ company produces staplers and other items. The production cost per unit is $8 and the cost of setting up the production line for this is $60. The annual holding cost rate is 30%. The company works 250 days per year. The production rate for this product is 120 per day. If the annual demand is 20,000 units, i. Which batch size should the company use? ii. What is the minimum monthly cost? iii. What is the total production time allocated to this product annually?
1. In a manufacturing company:Beginning Inventory + Purchases = Cost of Goods Available for Sale a) True b) False 2. Manufacturers have three unique inventory categories: Raw Materials, Work in Process, and Finished Goods. But retailers have only an Inventory account. a) True b) False 3. Period costs are any costs that are not product costs like Commission Expense, Office rent Expense, Advertisement Expense, Office Salary Expense. a) True b) False
What is the average demand and standard deviation of demand during the protextion interval? the target inventory ? the order quantity ?