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.# StockoutJan10008410Feb 25001907473Mar 20002000566Apr 3303300May15003960159593OO110414341434143414341434XX0011041038

level production means similar production in every period. Lost sales means once a shortage…

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

Boston Company use a special part in manufacturing of its finished products. The unit cost thisspecial part is $ 35, and details of its manufacturing cost is as follows. The $35 unit productcost of this part is based on average 25,000 number of parts produced each year.An outside supplier has offered to supply the 25,000 parts at a cost of $30 per part. The specialequipment used to manufacture the above part. This equipment can only be used formanufacturing of this part and if not used it has no resale value.The total amount of general factory overhead, which is allocated based on direct labor-hours,would be unaffected by this decision because it is fixed cost..Suggest the management whether to stop producing internally and buy them from theoutside supplier?Description CAD Direct Materials 10Direct Labor 6Variable overheads…
In the spreadsheet model shown below, an analyst makes the following data entries. Cell ВЗ В4 В5 B6 Value 113,000 90,000 119,000 99,000 A 1 Revenue 2 Month Revenue Change (%) n/a =(B4-B3)/B3 =(B5-B4)/B4 =(B6-B5)/B5 3 January 4 February 5 March 6 April What values will be shown in the following cells? (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) Cell Value С4 % C5 C6 %
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…
A manager receives a forecast for next year. Demand is projected to be 600 units for the first halfof the year and 900 units for the second half. The monthly holding cost is $2 per unit, and it costsan estimated $55 to process an order.a. Assuming that monthly demand will be level during each of the six-month periods covered bythe forecast (e.g., 100 per month for each of the first six months), determine an order size thatwill minimize the sum of ordering and carrying costs for each of the six-month periods.b. Why is it important to be able to assume that demand will be level during each six-month period?c. If the vendor is willing to offer a discount of $10 per order for ordering in multiples of 50units (e.g., 50, 100, 150), would you advise the manager to take advantage of the offer in eitherperiod? If so, what order size would you recommend?
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.
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)