Ram Roy's firm has developed the following supply, demand, cost, and inventory data. Supply Available Regular Time Demand Period Overtime Subcontract Forecast 40 15 10 40 30 15 10 55 40 15 10 55 Initial inventory Regular-time cost per unit Overtime cost per unit Subcontract cost per unit Carrying cost per unit per month 20 units $100 $160 $200 $4 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 $ 13500 (enter your response as a whole number).

Ram Roy's firm has developed the following supply, demand, cost, and inventory data. Supply Available Regular Time Demand Period Overtime Subcontract Forecast 40 15 10 40 30 15 10 55 40 15 10 55 Initial inventory Regular-time cost per unit Overtime cost per unit Subcontract cost per unit Carrying cost per unit per month 20 units $100 $160 $200 $4 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 $ 13500 (enter your response as a whole number).

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter10: Introduction To Simulation Modeling

Section10.5: Introduction To @risk

Problem 19P: In Problem 12 of the previous section, suppose that the demand for cars is normally distributed with...

See similar textbooks

Similar questions

In Problem 12 of the previous section, suppose that the demand for cars is normally distributed with mean 100 and standard deviation 15. Use @RISK to determine the best order quantityin this case, the one with the largest mean profit. Using the statistics and/or graphs from @RISK, discuss whether this order quantity would be considered best by the car dealer. (The point is that a decision maker can use more than just mean profit in making a decision.)
The Frist Corporation has the followinginternal controls related to inventory:1. Only authorized inventory warehousing personnel are allowed in inventory storageareas.2. All inventory products are stored in warehousing areas that are segregated fromother storage areas used to house equipment and supplies.3. All inventory held on consignment at Frist Corporation is stored in a separatearea of the warehouse.4. The inventory purchasing system only allows purchases from pre-approved vendors.5. The perpetual inventory system tracks the average number of days each inventoryproduct number has been in the warehouse.6. Microchips are embedded in each product and when inventory items are removedfrom the warehouse to shipping, radio-frequencies signal a deduction of inventoryto the perpetual inventory system.7. On a weekly basis, inventory accounting personnel take samples of inventoryproducts selected from the perpetual inventory system and verify that the inventoryis on-hand in the warehouse…
A golf specialty wholesaler operates 50 weeks per year. Management is trying to determine an inventory policy for its 1-irons, which have the following characteristics:Demand 1D2 = 2,000 units/yearDemand is normally distributedStandard deviation of weekly demand = 3 unitsOrdering cost = $40/orderAnnual holding cost 1H2 = $5/unitsDesired cycle@service level = 90 percentLead time 1L2 = 4 weeksa. If the company uses a periodic review system, what should P and T be? Round P to the nearest week.b. If the company uses a continuous review system, what should R be?
The following particulars were collected for the year 2015 from Need LLCMonthly demand -2,000 unitsCost of placing an order RO 225.Annual carrying cost per unit 8%Purchase price of input unit RO 350Minimum usage 30 units per weekMaximum usage 50 units per weekRe-order period 6 to 8 weeks.For emergency purchase 4 weeks Required:(a) Re-order quantity(b) Re-order level(c) Minimum level(d) Maximum level(e) Average Stock Level(f) Danger level
Explain what is the definition of a deterministic inventory model ? When is it appropriate to use ?
BicycleBro is a retailer that sells bicycles. The company had been operating for 30 days (1 month). By the end of 1 month it wants to measure its performance in terms of Inventory turnover and Days of inventory. Below is the information that the company has collected from its warehouse and accounting department Stock Count Sheet Item code Stock on hand Stock count week (week number when employees counted the stock on hand) 100 30 week1 200 10 week1 100 10 week3 200 20 week3 Inventory valuation Item code Value per unit (in $) 100 1000 200 2000 Bicycles sold by end of month Item code Units sold 100 5 200 10 Given the information above find What is the total inventory turnover rate for given period? What is the total Inventory Days of Sales for given period?
You may need to use the appropriate appendix table or technology to answer this question. Three firms carry inventories that differ in size. Firm A's inventory contains 2,000 items, firm B's inventory contains 5,000 items, and firm C's inventory contains 10,000 items. The population standard deviation for the cost of the items in each firm's inventory is a = 121. A statistical consultant recommends that each firm take a sample of 50 items from its inventory to provide statistically valid estimates of the average cost per item. Managers of the small rm state that because it has the smallest population, it should be able to make the estimate from a much smaller sample than that required by the larger firms. However, the consultant states that to obtain the same standard error and thus the same precision in the sample results, all firms should use the same sample size regardless of population size. (a) Using the finite population correction factor, compute the standard error for each of…
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 15 units at $40 $600 Aug. 13 Purchase 5 units at $41 205 Nov. 30 Purchase 11 units at $42 462 Available for sale 31 units $1,267 There are 9 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using the (a) first-in, first-out (FIFO) method; (b) last-in, first-out (LIFO) method; and (c) weighted average cost method (round per-unit cost to two decimal places and your final answer to the nearest whole dollar). a. First-in, first-out (FIFO) $fill in the blank 1 b. Last-in, first-out (LIFO) $fill in the blank 2 c. Weighted average cost $fill in the blank 3
Which of the following statements are true or false? 1.1 One of the objectives of purchasing and supply chain management is to maintain an optimum balance of inventory that would ensure the desired level of customer service while increasing costs. 1.2 Supply management has a major impact on the net income of the firm because it increases input costs and reduces sales revenue 1.3 The purchasing and supply function of a firm operates independently from the other enterprise functions. 1.4 Supply Management is the process of planning, organising, coordinating and controlling all the resources of the firm effectively and efficiently in order to attain the objectives of the firm as determined by management. 1.5 Strategic plans formulated at top management of purchasing and supply management are implemented or executed at top level management 1.6 In decentralized purchasing structures negotiating power is increased and volume discounts are made possible. 1.7 Steps of the strategic…
Use Excel to make calculations Given the following sales data: Quarter Year 1 Year 2 1 120 150 2 160 200 3 210 250 4 130 170 Compute the seasonal index for each quarter and forecast quarterly demand for year 3 with a projected annual demand of 1000. The efficiency of a production unit is 70 percent. The unit produces an average of 100 products per day. Determine the effective capacity of the unit. The utilization of a machine is 60 percent. The machine has a design capacity of 150 units per hour and an effective capacity of 100 units per hour. Find the efficiency of the machine. FloorsRUs is considering new locations for its manufacturing plants. Costs for constructing a new facility in Huntsville are $1,100,000 and the company estimates that for every product from its new line, there would be an additional cost of $3. If the company were to locate in Hays, the new facility would cost $1,800,000 and each product would incur a $2…
Nutmeg Inc. uses the LIFO method to account for inventory. During years in whichinventory unit costs are generally rising and in which the company purchases more inventory than it sells to customers, its reported gross profit margin will most likely be:A. lower than it would be if the company used the FIFO method.B. higher than it would be if the company used the FIFO method.C. about the same as it would be if the company used the FIFO method.
Abby just finished her short-term course in Culinary Arts. With this pandemic we are facing now, her father is retrenched from his work. To help her family financially, she decided to make brownies and sell it online. The cost of producing 36 pieces of brownies are the following: ₱600 worth of ingredients ₱45 for 6 pieces of medium box ₱100 for 1 hour of labor cost ₱150 delivery cost The cost of promoting the product is none since she promotes it using any social media platform. Let’s say your desired return on sale is 40% and since it is a home-based small business, she will not have any fixed expenses related to baking. Using the Unit Product Cost, compute for the unit product cost and the marked-up price of her brownies.