Ram Roy's firm has developed the following supply, demand, cost, and inventory data. Period 1 2 3 Regular Time 40 30 30 Supply Available Overtime Subcontract 15 15 15 15 20 15 Demand Forecast 20 units $100 $150 $250 $4 40 55 50 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 $ 0 (enter your response as a whole number).

Ram Roy's firm has developed the following supply, demand, cost, and inventory data. Period 1 2 3 Regular Time 40 30 30 Supply Available Overtime Subcontract 15 15 15 15 20 15 Demand Forecast 20 units $100 $150 $250 $4 40 55 50 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 $ 0 (enter your response as a whole number).

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

Assume the weight is 0.6 for the most recent period; 0.2 for the second most recent; 0.1 for the third most recent; and 0.1 for the fourth most recent period. Using the four-period weighted moving average technique to predict the demand in February 2019. Find the X and Y values. Dt Ft Period Demand Four-period weighted Moving Average 2014 September 9400 October 10300 November 11200 December 4998 2015 January 9800 7209 February 9555 X March 9800 Y Group of answer choices X = 9899.8; Y = 9778.2 X = 9312.8; Y = 9555.2 X = 9029.6; Y = 9312.8 X = 9555.0; Y = 9313.7 X = 9872.4; Y = 9029.4
The annual demand for an automobile part is 3200 units. The unit cost is 60 OMR and inventory carrying charge is 25% of unit cost. Ordering cost is 20 OMR per order. (i) Determine the economic order point (ii) If you place an order for 110 units every time, is it profit or loss? How much and Why? (iii) Why demand forecasting is important for an organization? Compare qualitative and quantitative forecasting technique with an example.
Find the EAR in each of the following cases: Stated Rate (APR) Number of Times Compounded 7% Quarterly16 Monthly11 Daily12 Infinite
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
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
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
A firm is faced with the attractive situation in which it canobtain immediate delivery of an item it stocks for retailsale. The firm has therefore not bothered to order the item in any systematic way. However, recently profits have beensqueezed due to increasing competitive pressures, and thefirm has retained a management consultant to study itsinventory management. The consultant has determined thatthe various costs associated with making an order for theitem stocked are approximately $70 per order. She has alsodetermined that the costs of carrying the item in inventoryamount to approximately $27 per unit per year (primarilydirect storage costs and forgone profit on investment ininventory). Demand for the item is reasonably constantover time, and the forecast is for 16,500 units per year.When an order is placed for the item, the entire order isimmediately delivered to the firm by the supplier. The firm operates 6 days a week plus a few Sundays, or approxi-mately 320 days per year.…
Thinking tools service assembles customized personal computers from generic parts. Formed and operated by part-time Svci students paulette cruz and maureen luis, the company has had steady growth since it started. The company assembles computers mostly at night, using part time students. Paulette and Maureen purchase generic computer parts in volume at a discount from a variety of sources whenever they see a good deal. Thus, they need a good forecast of demand for their computers so that they will know how many parts to purchase and stock. They have compiled demand data for the last 12 months as reported below A. Use exponential smoothing with smoothing parameter a=0.2 to compute the demand forecast for january (period 13) B. Use exponential smoothing with smoothing parameter a=0.5 to compute the demand forecast for january (period 13). C. Paulette believes that there is an upward trend in the demand, the initial forecast is 37 and the trend over this period is 0 units. Use…
Knowing how to use the ABC analysis, make up a list of 10 items in a stores inventory, then decide which 10 items sold at the store would constitute 80% of the revenue and create a Word document using the ABC analysis.
Engage: Inventory Planning: Forecasting during Uncertainty Inventory Planning: Forecasting During Uncertainty COVID-19 has unleashed unprecedented consumer demand and exposed fractures in the just-in-time supply chain model. In the span of just a few months, your supply chain may have changed drastically. Supplier shutdowns in China. Increased shipping demands. Decreased working capital. These evolving conditions impact your go-forward inventory strategy. Forecasting inventory requirements have always included a mix of past trends, sound predictions, and supplier relationships. But the uncertainties we are facing right now make this process more challenging. This includes Evolving consumer demands Product availability, and Predictable transportation Let's look at these inputs and how they may impact inventory planning.   Uncertainties in Consumer Demand Consumer demand is on a roller coaster and the ride doesn’t seem to be slowing down soon. Shelter at home requirements have led…
Engage: Inventory Planning: Forecasting during Uncertainty Inventory Planning: Forecasting During Uncertainty COVID-19 has unleashed unprecedented consumer demand and exposed fractures in the just-in-time supply chain model. In the span of just a few months, your supply chain may have changed drastically. Supplier shutdowns in China. Increased shipping demands. Decreased working capital. These evolving conditions impact your go-forward inventory strategy. Forecasting inventory requirements have always included a mix of past trends, sound predictions, and supplier relationships. But the uncertainties we are facing right now make this process more challenging. This includes Evolving consumer demands Product availability, and Predictable transportation Let's look at these inputs and how they may impact inventory planning.   Uncertainties in Consumer Demand Consumer demand is on a roller coaster and the ride doesn’t seem to be slowing down soon. Shelter at home requirements have led…
Engage: Inventory Planning: Forecasting during Uncertainty Inventory Planning: Forecasting During Uncertainty COVID-19 has unleashed unprecedented consumer demand and exposed fractures in the just-in-time supply chain model. In the span of just a few months, your supply chain may have changed drastically. Supplier shutdowns in China. Increased shipping demands. Decreased working capital. These evolving conditions impact your go-forward inventory strategy. Forecasting inventory requirements have always included a mix of past trends, sound predictions, and supplier relationships. But the uncertainties we are facing right now make this process more challenging. This includes Evolving consumer demands Product availability, and Predictable transportation Let's look at these inputs and how they may impact inventory planning.   Uncertainties in Consumer Demand Consumer demand is on a roller coaster and the ride doesn’t seem to be slowing down soon. Shelter at home requirements have led…