The table above provides the aggregate plan of production by a firm. It is known that the firm uses a level plan with lost sales, i.e., without backorders. Given this information, what is the number in the cell that says xx? Month# Forecast# Starting inv.# Net requirement# Prod. rate# Ending inv.# StockoutJan10008416690Feb 25001831O321.0Mar20002000O490.0Apr 7107108000May1500700810159669O80015101510151015101510XxX

Stockout is a situation when the inventory stock of a company is less than the demand for the…

The table above provides the aggregate plan of production by a firm. It is known that the firm uses a level plan with lost sales, i.e., without backorders. Given this information, what is the number in the cell that says xx?

The table above provides the aggregate plan of production by a firm. It is known that the firm uses a level plan with lost sales, i.e., without backorders. Given this information, what is the number in the cell that says xx?

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

You are conducting a retrospective analysis for an Order-Up-To system (thus, the unsold inventory at the end of a week is carried over to the next week). The beginning inventory in week 1 is 150 units, the demand in week 1 is 180 units and the demand during week 2 is 250 units. If you receive a shipment of 115 units every week, at the end of week 2, the inventory level is 180 the inventory level is 200 the inventory level is 310 the backorder level is 30 the backorder level is 50 none of the above is correct
The seasonal demand for a particular product is given below: Period 1 2 3 4 5 6 Demand 300 450 100 450 450 100 The fixed parameters are: Fixed Cost $8 Unit Production Cost $1 Holding Cost $1.3 Calculate total ordering cost using following three methods: i) Lot-for-Lot ii) Wagner-Whitin algorithm iii) Fixed order quantity Please do fast .. ASAP.. fast
The seasonal demand for a particular product is given below: Period 1, 2, 3 ,4 ,5, 6 Demand 300 ,450 ,100 ,450 ,450 ,100 The fixed parameters are: Fixed Cost $8 Unit Production Cost $1 Holding Cost $1.3 Calculate total ordering cost using the following three methods: i) Lot-for-Lot ii) Wagner-Whitin algorithm iii) Fixed order quantity
How Tyler should plan on ordering the flour for his bakery. Based on the attached: How much should Tyler plan on ordering the flour for his bakery? When should Tyler order the flour for his bakery
A shop is planning an order for a popular Christmas festive season product. Demand for the product usually starts from first week of December till first week of January and reduces sharply thereafter. For this reason, and to stimulate sales for leftovers, the product is sold at a significantly reduced price from the second week of January to the fourth week of January. Any leftover after the fourth week of January goes waste. The table below gives past data on total demand for the period from first week of December to first week of January, and from second week of January to fourth week of January, together with their respective chances of occurrence. The product can be purchased at a wholesale price of GHS60 per unit for a pack containing 600 products, GHS57 per unit for a pack containing 800 products, and GHS52 per unit for a pack containing 1000 products. The shop plans to sell the product for GHS80 per unit from first week of December to first week of January, and at a reduced…
Bakery A sells bread for $2 per loaf that costs $0.50 per loaf to make. Bakery A gives an 80% discount for its bread at the end of the day. Demand for the bread is normally distributed with a mean of 300 and a standard deviation of 30. What order quantity maximizes expected profit for Bakery A? (use the normal distribution table posted on Canvas and round up to the nearest integer)
Production Quantity Model A stew production facility sells the stew in an adjoining store. Demand for the stew is 32 gallons per day. Both the store and production facility operate 310 days per year. The company can produce 128 gallons per day. It costs $1200 to set up a production run. The stew is stored at an annual cost of $20 per gallon. The company wants to use the optimal order quantity. (Round the order quantity to an integer value) What is the maximum inventory level? How many production runs will be required each year? What is the total annual carrying cost? If the store places an order to the production facility for 1000 gallons of stew (not necessarily the economic order quantity), how many gallons of stew will be sold during the order receipt period?
An online retailer sells 1,500 t-shirts per year. The cost of the t-shirts to the store is $3.00 and the cost of placing an order is $15 per order. It cost $0.60 per t-shirt per year for the retailer to hold the t-shirts. The retailer sells the t-shirts for $9.99. Determine (a) the optimal order quantity, (b) the order frequency (c) the annual holding and setup cost.
A retailer has two merchandizers, Sue and Bob, who are responsible for setting orderquantities for the products they manage. For all of their products, the critical ratio is .7and the coefficient of variation of their demand forecasts is 0.35. At the end of the season, Sue is proud to report that she has sold the entire inventory she purchased. Bob, onthe other hand, sold only about a third of his products. Who is more likely to be choosing quantities that maximize expected profit? a. Sue because she doesn’t incur the cost of salvaging inventory.b. Sue because she must have sold more units than Bob.c. Bob because even leftover inventory generates some additional revenue.d. Bob because he is probably ordering more than the mean of the demand forecast.
12 Bakery A uses the newsvendor model to manage its inventory of bread loaf Bakery A sells bread for $4.6 per loat that costs $1.7 per loat to make. At the end of the day, the leftover bread is sold at $1.2 per loaf. The critical ratio of the bread loaf= % (Report your answer without the percentage sign. Keep ONE decimal in your answer. For example, f you answer is 0.9563, report 95.6 in the answer) (Difficuity Level Hard)
Quantity to OrderDaily demand for a product is 10 units, with a standard deviation of 3 units. The review period is 30 days, and the lead time is 14 days. Management has set a policy of satisfying 98 percent of demand from items in stock. At the beginning of this review period, there are 150 units in inventory.How many units should be ordered?
Ram Roy's firm has developed the following supply, demand, cost, and inventory data Period 1 2 3 Regular Time 30 30 40 Supply Available Overtime Subcontract 5 15 15 15 5 5 Demand Forecast 40 20 units $100 $150 $200 $6 45 55 Initial inventory Regular-time cost per unit Overtime cost per unit Subcontract cost per unit Carrying cost per unit per month Assume that the initial inventory has no holding cost in the first period and backorders are not permitted Allocating production capacity to meet demand at a minimum cost using the transportation method, the total cost is $ (enter your response as a whole number)