2.9 A company wants to develop a level production plan. The beginning inventory is zero.Demand for the next four periods is given in what follows.a. What production rate per period will give a zero inventory at the end of period 4?b. When and in what quantities will back orders occur?c. What level production rate per period will avoid back orders? What will be the end-ing inventory in period 4?PeriodForecast DemandPlanned ProductionPlanned Inventory01234Total9599

Answered: 2.9 A company wants to develop a level…

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

10. A company will sell remote control devices online. Expected yearly demand is 3000 units and it is sold per 250TL. The controllers can be purchased from supplier A. Ordering cost is 40 TL and annual holding cost is 25% of the price. a. Calculate the economic order quantity for the company. b. Calculate the number of orders per year. c. List the assumptions of EOQ model that you used to calculate the value in part A.
On August, a light business bought $3600 worth of lamps. At the beginning of September, the store had $1400 in lights on hand, and by the end of September, it projected to have $1600 in lamps on hand to meet some of the forecasted October sales. And what's the August planned cost of goods sold?
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?
1. Katherine is a forecast manager. She used exponential smoothing to forecast her sales with alpha equals 0.25. Her forecast for this week was 161 but the actual number is 232. What is her forecast for next week?2. Blue Pad Companyâ€™s lead time L is1week and demand rate is119units per week.Holding cost is $29 per unit and ordering cost is $281. Assume 52 weeks in a year.What is the EOQ? Keep two decimal points!3.Blue Pad Companyâ€™s lead time L is3week and demand rate is123units per week.Holding cost is $70 per unit and ordering cost is $726. Assume 52 weeks in a year.What is the ROP?4. Lugini Watchâ€™s annual demand is 107. It can produce at a rate of 19 watches per month with a $249 setup cost for the production run. Find the order quantity (EPQ) assuming carrying cost is $57 per unit a year. Keep two decimal points!5. Lugini Watchâ€™s annual demand is 108. It can produce at a rate of 24 watches per month. Using the…
7. Nowjuice, Inc., produces Shakewell fruit juice. A planner has developed an aggregate forecast for demand (in cases) for the next six months. Month May Jun Jul Forecast 4,000 4,800 5,600 Aug Sep 7,200 Oct 6,400 5,000 Use the following information to develop aggregate plans. Regular production cost Regular production capacity Overtime production cost Subcontracting cost Holding cost Beginning inventory $10 per case 5,000 cases $16 per case $20 per case $1 per case per month 0 Develop an aggregate plan using each of the following guidelines and compute the total cost for each plan. Which plan has the lowest total cost? a. Use level production. Supplement using overtime as needed. b. Use a combination of overtime (500 cases per period maximum), inventory, and subcontracting (500 cases per period maximum) to handle variations in demand. c. Use overtime up to 750 cases per period and inventory to handle variations in demand.
I want the answer
2. Perform an ABC analysis for the data provided. Clearly explain why you classified items as A, B, or C. Annual Unit Item Usage 2400 Cost $19.51 $32.60 $10.20 $6.80 2 6200 3 8500 4 3200 6000 $4.50 $55.70 $3.60 $44.90 $35.62 750 7 8200 8 9000 5800 10 820 $82.60 $40.50 11 500 12 2000 $15.40 $14.60 $35.80 13 2400 14 6300 15 4750 $17.30 2700 $51.75 $42.90 $25.30 16 17 1600 18 1350 19 5000 $67.00 20 1000 $125.00
.Substitue for Mandatory problem #2 on exam in attachment )-Calculate the Tracking Signal(RSFE/MAD t) given the following data and an alpha=0.4.MAD t-1=15: Period Actual Demand Forecast Demand Error ................... RSFE MAD t TS 0 Start up Start Up Start Up 15 1 30 45 2 43 3 38 4 37 5 40
1. Using the data provided here for problem 1. Calculate the following: 6 7 8 | 9 Week Demand 1| 2 3 4 5 2554 2333 4678 4525 2243 2988 2301 3777 3245 2122 2987 2487 2567 10 11 12 13 a. Average weekly demand. b. Target inventory for 98% Inventory Service Level for this period if you get replenished with new inventory every two weeks. Formulas used: a. b.
The units of Manganese Plus available for sale during the year were as follows: Mar. 1 June 16 Nov. 28 Inventory Purchase Purchase 23 units @ $29 32 units @ $30 42 units @ $36 97 units $667 960 1,512 $3,139 There are 14 units of the product in the physical inventory at November 30. The periodic inventory system is used. a. Determine the inventory cost by the FIFO method. $ b. Determine the inventory cost by the LIFO method. $ c. Determine the inventory cost by the weighted average cost methods. Round intermediate calculations and final answer to two decimal places.
WAI has developed the following MPS. Calculate theprojected available and the available-to-promise quantities for WAI.
Arizona Instruments produces bar code scannersfor consumers and other manufacturers on aproduce to stock basis. The production planneris developing an MPS for scanners for the next12 weeks.The product is built in a fixedorder quantityof 125 units, and there are 110 units in beginninginventory. The demand forecasts for the next 12weeks, including customer orders promised tocustomers for delivery in that time period, isshown on the shown on the next slide. Customer Orders Forecast Demand Period 1 2 3 4 5 6 7 8 9 10 11 12 Forecast 50 50 50 50 75 75 75 75 50 50 50 50 Customer order 35 25 25 20 0 15 0 0 10 0 0 10 Determine the MPS and Available to Promise (ATP)

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