The beginning stock of a product is 200 units (On hand stock =200 unites). Safety Stock level is 50 unites. It is desirable to prepare a12-week Master Production Schedule. MPS is 400 units. The Demand forecast and Customer order quantities for the 12 periods aregiven in the table below. Determine the Master Production Schedule and Available to promise amount (ATP) in a way that maintainsthe amount of safety stock.DemandForecastCustomerOrder12345670 60 90 90 110 1208012012011011010090713080815050914040101450111800121900

Beginning inventory = 200 units Safety stock = 50 units MPS = 400 units Demand Forecast and Customer…

Answered: The beginning stock of a product is 200…

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

In each of the following, name the term defined or answer the question. Answers are listed at the bottom.1. The model was most appropriate for making a one-time purchase of an item.2. The model most appropriate when inventory is replenished only in fixed intervals of time—for example, on the first Monday of each month.3. The model most appropriate when a fixed amount must be purchased each time an order is placed.4. Based on an EOQ-type ordering criterion, what cost must be taken to zero if the desire is to have an order quantity of a single unit?5. The term used to describe demand that can be accurately calculated to meet the need of a production schedule, for example
Historical demands observed for the last 5 months are 1000, 2300, 3200, 1750, and 1200. To match the demand, the company placed respective orders of 1100, 2500, 4000, 1000, and 900 units. (a) Compute the variance of demand. (b) Compute the variance of orders. (c) Compute the bullwhip measure. Is there an amplifying or smoothing effect?
Help need. management accounting Lebar Daun Sdn Bhd is planning to use the economic order quantity model to determine the optimal order levels of raw materials. Material Z is consumed evenly over the year and the current usage is 120,000 units. The material is purchased in boxes and each box contains 12 units of material Z, at a price of RM252 per box. A safety stock of 200 boxes is kept. The cost of placing and handling orders is estimated to be RM6,300, which is based cost incurred for similar orders that have already made. The cost of RM6,300 was for 30 orders. The inflation of 2 per cent should be added to the above ordering costs. Besides, the company estimates to be charged the transporation cost of RM15 per order. It should be assumed that ordering costs change in proportion to the number of orders place. Other costs which relate to material Z such as insurance, interest and space costs for a year, were calculated at 15 % of the purchase price. Required: a. Calculate the order…
As with other products, Fisher-Price faces the decision of how many Weather Teddy units to order for the comingholiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, or28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning themarket potential. The product management team asks you for an analysis of the stock-out probabilities forvarious order quantities, an estimate of the profit potential, and to help make an order quantity recommendation.Fisher-Price expects to sell Weather Teddy for $24 based on a cost of $16 per unit. If inventory remains afterthe holiday season, Fisher-Price will sell all surplus inventory for $5 per unit. After reviewing the sales historyof similar products, Fisher-Price’s senior sales forecaster predicted an expected demand of 20,000 units with a.95 probability that demand would be between 10,000 units and 30,000 units. Question: One of Fisher-Price’s managers felt…
A jewelry manufacturer is creating a routine order schedule for some new products: J66 and J67. J66 can be ordered any time. J67 is set up to be ordered every 4 weeks. The company is closed 2 weeks out of a 52 week year otherwise it is open. Given the following, show me the calculation (I have provided the final answer) the questions at the end: J66 acceptable stockout risk = 2.5%, lead time = 2 weeks, ordering cost =$70, annual holding cost = 30%, unit cost =$15, standard deviation = 4 units per week, and average weekly demand is 60 units. J67 acceptable stockout risk = 2.5%, lead time = 2 weeks, ordering cost =$30, annual holding cost = 30%, unit cost =$20, standard deviation = 5 units per week, and average weekly demand is 70 units. I know the reorder point for j67 is 153 units on hand. 1) Show me the math to come up with the 153 units answer. 2) What is the reorder point for the J66? (I know the answer is 306 units so show me the calculation), 3) If the J67 has 110 units on…
Chris usually sells 120 copies of newspaper each day and believe that sale are normally distributed, with a standard deviation of 15 papers. He pays 70 cents for each paper, which sells $1.25. For each unsold paper, he receives 30-cent credit. a) determine how many papers he should order each day b) calculate the stockout risk for that quantity.
Birka Styles & Co is introducing a new line of beachwear for their retail stores. The manager needs to decide how many lots of the new beachwear to order for their stores. The marketing came up with a payoff table (see below) considering information about the price, projected sales level, and cost of inventory and ordering. DEMAND Order size Low Medium High 1 lot 12,000 15,000 15,000 2 lots 9,000 25,000 35,000 3 lots 6,000 35,000 60,000 The owner found out that: P(Low demand) = 1/3; P(Med demand) = 1/2; P(High demand) = 1/6. Which of the following decision is NOT true? A)The best decision is to order 3 lots for a payoff of $29,500. The probabilities gave me enough information to perform a Laplace approach. B)The best decision is to order 3 lots for a payoff of $29,500. The probabilities gave me enough information to perform the EMV approach. C)The EVPI is $2,000. D)The EVwPI is $31,500.
David’s Delightful Kites Company (DDKC) manufactureskites. Th e most popular is David’s Daredevil model. Demandmanagement has prepared forecast estimates for the next sixweeks. Beginning inventory is 15 David’s Daredevils. As themaster scheduler for DDKC, you must prepare an MPS. Your MPSorder quantity is 72 kites. (a) Prepare the MPS using an order quantity of 72 kites.(b) Calculate the ending inventory for each period.(c) What is the maximum number of units held in inventory?(d) How many MPS orders are needed?
Becky Shelton, a teacher at kemp middle school is in charge of ordering the T-shirts to be sold for the school's annual fund-raising project the t-shirts are printed with a special kemp school logo. In some years the supply of T-shirts has been insufficient to satisfy the number of sales orders. In other years, T-shirts have been left over. excess T-shirts are normally donated to some charitable organization. T-shirts cost the school $7 each and are normally sold for $14 each. Ms Shelton has decided to order 790 shirts. Required 1) if the school receives actual sales orders for 715 shirts, what amount of profit will the school earn?what is the cost of waste due to excess inventory? 2) If the school receives actual sales orders for 830 shits, what amount of profit will the school earn? What amount of opportunity cost will the school incur? a) Profit $1,050 waste due to excess inventory b) Profit opportunity cost
pls show detailed computation need help

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