B). A company wants to develop a level production plan for a familyof products. The opening inventory is 100 units, and an increase to150 units is expected by the end of the plan. The demand for eachperiod is given in what follows. How much should the companyproduce each period? What will be the ending inventories in eachperiod? All periods have the same number of working days.Period146.TotalForecast Demand | 100120| 130140 120 | 110PlannedProductionPlanned100InventoryC). For the following data, calculate the number of workers requiredfor level production and the resulting month-end inventories. Eachworker can produce 15inventory is 9000 units.units per day, and the desired endingMonth1234TotalWorking Days20241219Forecast Demand28,00027,50028,50028,500Planned ProductionPlanned Inventory 11,250

Since you have asked multiple questions, we will solve the first question for you. If you want any…

Answered: B). 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

1. Forrest and Dan make boxes of chocolates for which the demand is uncertain. Forrest says, "That's life." On the other hand, Dan believes that some demand patterns exist that could be useful for planning the purchase of sugar, chocolate, and shrimp. Forrest insists on placing a surprise chocolate-covered shrimp in some boxes so that "You never know what you'll get." Quarterly demand (in boxes of chocolates) for the last three years is shown in the table below: b. If the expected sales for chocolates are 14,400 cases for year 4, use the multiplicative seasonal method to prepare a forecast for each quarter of the year. (Round all intermediate calculations to two decimal places.) The first quarter forecast is what? boxes of chocolates. (Enter your response rounded to the nearest whole number.)
(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?
What is the average demand and standard deviation of demand during the protextion interval? the target inventory ? the order quantity ?
Q: A hardware company stocks nuts and bolts and orders them from a local supplier once every 2 weeks (10 working days). Lead time is 2 days. The company has determined that the average demand for 1⁄2 inch bolts is 150 per week (5 working days), and it wants to keep a safety stock of 3 days’ supply on hand. An order is to be placed this week, and the stock on hand is 130 bolts.a. What is the target level?b. How many 1⁄2 inch bolts should be ordered this time?
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?
1. The demand for a product of Carolina Industries varies greatly from month to month. Based on the past three years of data, the following shows the monthly demand at Carolina Industries. Unit Demand # Months 300 6 400 8 500 12 600 10 A.If the company places monthly orders equal to the expected value of the monthly demand, what should Carolina’s monthly order quantity be for this product? B. What are the variance and the standard deviation for the number of units demanded?
Your company has previously used a fixed order size where ordering takes place once a quarter, but since the product's sustainability only allows warehousing for a limited time, demand varies somewhat and the product's character also means that the stock cost is rather expensive, SEK 54 per product and year. So, the company wants to investigate whether a more dynamic order size is preferable. Each order costs the company approximately SEK 1,200. The forecast for the next 4 months is given below: Month 1 2 3 4 Forecast 180 320 490 180 Decide in which periods ordering should take place (you can choose the calculation method).
c) Dtee operates a small novelty shop. Each morning she purchases a small quantity of daily computerized horoscopes at a cost of R15.00 per item. She resells them later in the day for R25.00 per horoscope. For the past 200 days, Dtee's demand has been 6 items on 60 days, 7 items on 60 days, 8 items on 40 days, 9 items on 20 days and 10 items on 20 days. The horoscopes come in packages of 2, which forces Dtee to purchase an even number, and the horoscopes are saleable for one day only. At the end of each working day, however, Dtee can sell any remaining horoscopes to a night-town peddler for R10.00 per item. Set up the pay-off matrix for this problem.
[item no. 9] In marginal analysis with discrete distributions for single-period inventory models, the value of ML/(ML+MP) is 0.8. The probability distribution of sales is given by the following by the table below. Find the optimal number of units to order. Daily demand 80 90 100 110 120 Probability that demand will be at this level 0.10 0.20 0.30 0.30 0.10 a. 90 units b. 110 units c. 100 units d. 80 units
2. A manager then obtained 10 lists of items with their following unit cost and gets the peso value in annual basis. By doing the A-B approach you will need to multiply the annual demand for t particular items to its unit costs as follows: Item Number Annual Demand Unit Cost Annual Peso Value 1 3,500 360 2 2,000 70 3 5,400 500 4 2,500 100 5 1,200 70 6 2,000 1,000 7 1,200 210 8 2,000 4,000 9 10,000 10 10 1,500 200 Item Number Annual Peso Classification % of item Value 2/3 % of annual Peso Value
a. Mr. Mashabela operates a small novelty shop. Each morning he purchases a small quantity of daily computerized horoscopes at a cost of R15.00 per item. He resells them later in the day for R25.00 per horoscope. For the past 200 days, Mr. Mashianoke's demand has been 6 items on 60 days, 7 items on 60 days, 8 items on 40 days, 9 items on 20 days and 10 items on 20 days. The horoscopes come in packages of 2, which forces Mr. Mashabela to purchase an even number, and the horoscopes are salable for one day only. At the end of each working day, however, Mr. Mashabela can sell any remaining horoscopes to a night-own peddler for R10.00 per item. i) Set up the payoff matrix for the above problem. ii) Assuming the probabilities of the occurrence of the state of nature is unknown, how many computerized horoscopes should the decision maker purchase based on opportunistic loss? i) Using the expected monetary value approach, determine how many computerized horoscopes should Mr. Mashabela purchase.…
A product's demand in cach period follows a Normal distribution with mean of 50 and standard deviation of 6. The order up to level S is 225. Lead time is 3 periods. What is the Expected On hand Inventory? Show all formulas used. calculations and results. What is the stock out probability ? Show all formulas used, calculations and results.

SEE MORE QUESTIONS

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