a. How much should Joan produce each month if she wishes to have a level operations plan with no back orders or stockouts? Plot your cumulative production on the preceding graph. b. What is ending inventory for month 4 under this plan? c. Joan decides to have a level-production, level-employment sales and operations plan with no ending inventory at the end of the planning horizon. How much should she make each month? What are the monthly back orders?

a. How much should Joan produce each month if she wishes to have a level operations plan with no back orders or stockouts? Plot your cumulative production on the preceding graph. b. What is ending inventory for month 4 under this plan? c. Joan decides to have a level-production, level-employment sales and operations plan with no ending inventory at the end of the planning horizon. How much should she make each month? What are the monthly back orders?

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

A jewelry shop procures a ring at $20 each and sells it at $80 each. Weekly demands for the ring over the past 20 weeks are as follows. Demand 51 52 53 54 55 56 57 58 59 60 Frequency o 1 3 2 2 3 4 2 2 1 What are the under-stocking and over-stocking costs for the shop? What is the newsvendor critical ratio? How many rings per week should the shop order? Suppose that the weekly demand is uniformly distributed between 40 and 80. How many rings per week should the shop order?
Problem 20-10 (Algo) You are a newsvendor selling San Pedro Times every morning. Before you get to work, you go to the printer and buy the day's paper for $0.30 a copy. You sell a copy of San Pedro Times for $1.10. Daily demand is distributed normally with mean = 265 and standard deviation = 53. At the end of each morning, any leftover copies are worthless and they go to a recycle bin. a. How many copies of San Pedro Times should you buy each morning? (Use Excel's NORMSINV() function to find the correct critical value for the given a-level. Round your z-value to 2 decimal places and final answer to to 2 decimal places.) Optimal order quantity b. Based on a, what is the probability that you will run out of stock? (Round your answer to the nearest whole number.) Probability
Demand forecasting and planning is not a part of inventory management function. Select one : 1.True 2.Fales
Problem 20-10 (Algo) You are a newsvendor selling San Pedro Times every morning. Before you get to work, you go to the printer and buy the day’s paper for $0.50 a copy. You sell a copy of San Pedro Times for $1.25. Daily demand is distributed normally with mean = 335 and standard deviation = 67. At the end of each morning, any leftover copies are worthless and they go to a recycle bin. a. How many copies of San Pedro Times should you buy each morning? (Use Excel's NORMSINV() function to find the correct critical value for the given α-level. Round your z-value to 2 decimal places and final answer to to 2 decimal places.) b. Based on a, what is the probability that you will run out of stock? (Round your answer to the nearest whole number.)
Camille forecasts to sell 575 units of the perfume she is selling by the first week of December. At the end of the 1st week of December, she was able to disposed 500 perfumes at Php150 each. Of these 500 units, she gave a total of 20 giveaways. The total cost for each perfume is Php120. Determine Camille’s net sales volume. *4802075500 Let’s say that last November you have sold 10,000 pieces of chrysanthemum at 25 pesos each. For every piece sold, you will be given a commission of 10%. How much was your total commission? *225,00025,00010,0002.50250,000
In determining open-to-buy, what is subtracted from planned purchases? O On hand On order EOM stock BOM stock Question 37 Your department is planning a 10 percent increase in sales for the entire three- month period (February-April). Sales for the period last year were $19,000. Fifty percent of the total planned sales are projected to occur in March, and 25 percent of sales are planned to occur in each of the other two months. Planned stock-sales ratio for each month is 2.0. Total planned reductions for the period are 5 percent of planned sales. Reductions are projected to occur for each month as follows: February (10 percent), March (40 percent), and April (50 percent). An ending inventory of $5,000 is planned for the period. PLANNED PURCHASES FOR FEBRUARY ARE: O $24,200 O $15.779 O None (overbought). $10.895.50
1. Determine the inventory order quantity for Diamant’s distributor.2. Compare the optimal order quantity with a seasonally adjusted forecast for demand. Doesthe order quantity seem adequate to meet the seasonal demand pattern for Diamonds(i.e., is it likely that shortages or excessive inventories will occur)?
Construct the cost living index number by (i) Aggregative expenditure method. (ii) Family budget method for the year 2004 taking 200 as base. Commodity Quantity Unit price($) 2000 2004 |2 Qnts Qnt 25 kg Qnt 10 kg kg kg 25kg Clothing 25 met Meter 4 Qnts Qntl |House woeat 50 75 Rice 100 120 Sugar Pure Ghee5 kg Veg. Ghee 5kg Qnt 80 120 10 10 Oil Qnt 200 200 4 Fuel 8 10 Rent |One 20 25
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?
.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
Suppose this information is available for PepsiCo, Inc. for 2015, 2016, and 2017. (in millions) 2015 2016 2017 Beginning inventory $ 2,100 $ 2,400 $ 2,300 Ending inventory 2,400 2,300 2,700 Cost of goods sold 18,227 20,071 20,478 Sales revenue 39,145 42,957 44,066 Calculate the days in inventory for PepsiCo, Inc. for 2015, 2016, and 2017. (Round days in inventory to 1 decimal place, e.g. 5.1.) 2015 2016 2017 Days in inventory days
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).