Ram Roy's firm has developed the following supply, demand, cost, and inventory data. Supply Available Demand Regular Time Period Overtime Subcontract Forecast 1 30 15 40 2 35 15 5 55 3 40 20 5 60 Initial inventory Regular-time cost per unit Overtime cost per unit Subcontract cost per unit Carrying cost per unit per month 20 units $100 $150 S200 $2 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 S (enter your response as a whole number).
Q: Weekly demand for Lego at a Wal-Mart store is normally distributed with a mean of 2,500 boxes and a…
A:
Q: Single-period. This type of problem can be recognized when a probability distribution or empirical…
A: Ce = $500 Cs =? Optimal spare parts = 2
Q: g. The total cost for this inventory plan h. The number of orders i. Ordering point j. The profit…
A: g. Total cost of inventory plan: Total Cost = Purchase Cost + Ordering Cost + Holding Cost…
Q: Ram Roy's firm has developed the following supply, demand, cost and Invelnuly dld. Supply Available…
A: given, initial inventory = 30units regular time per cost = $100 overtime per cost = $160 sub…
Q: I need a detailed assistance to solve the following problem in: Operations Analysis. 1) A trucking…
A: Step1: Calculating the value of monthly carrying cost per truck. We have,Monthly carrying cost per…
Q: The purchasing manager for the Pacific Steel Companymust determine a policy for ordering coal to…
A: Given: Demand (per unit) (D) = 5 x 120 x 360 = 21,600 units Ordering cost (S) = $80 per order…
Q: Economic order quantity. Maximum level of stock. Minimum level of stock.
A: There are multiple sub-parts in one question, as per the guideline, I should answer only the first…
Q: A hospital must order the drug Porapill from DaisyDrug Company. It costs $500 to place an order and…
A: As per the values provided, we have, K = $ 500 (cost of placing an order) J = $ 30 (cost of…
Q: Ram Roy's firm has developed the following supply, demand, cost, and inventory data. Supply…
A: First arrange the excel sheet with the given data and formula as shown: Now enter the following…
Q: A manager receives a forecast for next year. Demand is projected to be 600 units for the first half…
A: Given that first half demand = 600 units second half demand =920 units monthly holding cost = $2…
Q: Ram Roy's firm has developed the following supply, demand, cost, and inventory data. Assume that the…
A: We will solve this by using the transportation method and using excel solver.
Q: The economic order quantity of Geo Co. is determined to be 450 units and it sells its only product…
A: A Small Introduction about Purchasing Buying is the purchasing of labor and products. A thing that…
Q: Happy Henry’s car dealer sells an imported car called the EX123. Once everythree months, a shipment…
A: Ans 1: Given data Holding cost = $500 per year Emergency shipments cost = $250 Ans 1:…
Q: A jewelry shop procures a ring at $20 each and sells it at $80 each. Weekly demands for the ring…
A: “Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…
Q: The purchasing manager for the Pacific Steel Companymust determine a policy for ordering coal to…
A: a. D = 5*12*360 = 21600 tons/yearS = $80H = 20%average inventory level=20%*$12(negotiated cost)=…
Q: The purchasing manager for the Atlantic Steel Company must determine a policy for orderingcoal to…
A: Economic order quatity i.e. optimal quantiyqo=2× S×CpCu×i S=Annual Requirement =5×360…
Q: Tracy McCoy is the office administrator for the department of management science at Tech. The…
A: R=dL+Zσd2L+σL2d2=2×2+2.780.82×2+0.52×22=4+2.78×1.28+1=4+4.19=8.19
Q: If the company in #8 uses exponential smoothing (smoothing factor = .6) and the forecast for the…
A: Find the given details below: Given Details: Year Sales 2017 1000000 2018 1200000…
Q: A local semiconductor firm, Superchip, is planning its workforce and production levels over the next…
A: Given Information Cost of laying off off a worker = $400Cost of hiring a new worker = $200…
Q: 3. Cynthia Knott’s oyster bar buys fresh Louisiana oysters for $5 per pound and sells them for…
A: Note: - For a multiple subparts question we can answer only up to three subparts. So we will answer…
Q: Consider the supply : Last year, the retailer’s weekly variance of demand was 200 units.The…
A: What is the bullwhip effect? Envision an individual having a long whip in his grasp, and on the off…
Q: Weekly demand for printers at a store is normally distributed with a mean of 250 and a standard…
A: Given that: Average demand per period(D) = 250 Standard deviation of demand (σd) = 96 Leadtime(L) =…
Q: Ray wishes to determine the optimal order quantity for its best-selling bike in his bike store. Ray…
A: Daily demand, AVG = 23 units Unit price, u= $107 Number of working days, w= 269 Carrying cost, h =…
Q: Inventory A certain bookstore chain has two stores, one in San Francisco and one in Los Angeles.…
A: Given : Hard Soft Plastic San Francisco 3,000 5,000 6,000 Los Angeles 2,000 4,000 3,000
Q: The manager of Alaina’s Garden Center must make the annual purchasing plans for rakes, gloves, and…
A: Given information Year 1 Year 2 1 45 67 2 339 444 3 299 329 4 222 283…
Q: How can this goal be achieved? Are there alternative solutions which might also be effective?
A: Hawkins Supply Company's inventory rotation challenge can be fixed with Just In Time management…
Q: The EastCoasters Bicycle Shop stocks bikes; helmets;clothing; a variety of bike parts including…
A:
Q: Berry Computer is considering moving some of its operations overseas in order to reduce labor costs.…
A: Given data, Main circuit board costs = $75 per unit Overseas costs = $ 65 to produce Holding = 20%…
Q: A pizzeria in downtown Changloon is trying to determine the best order quantity for its pizza…
A: The step by step solution of the same is as follows:
Q: Ram Roy's firm has developed the following supply, demand, cost, and inventory data. Supply…
A: Given data; Regular time cost 100 $/unit Overtime cost 150 $/unit…
Q: Company B is a retailer of mobile phones in Australia that works 250 days in a year. The manager is…
A: Hello thank you for the question. As per guidelines, we would provide only first three-subparts at a…
Q: ompany B is a retailer of mobile phones in Australia that works 250 days in a year. The manager is…
A: EOQ≈ 29 phones. Total cost of purchase= $35,206 Total ordering cost =$2,586 Total cost of holding…
Q: I'm trying to determine optimal order quantity but only have a Mean forecast and a standard…
A: The most cost-effective amount of a product to acquire at a given moment is the optimal order…
Q: A jewelry shop procures a ring at $20 each and sells it at $80 each. Weekly demands for the ring…
A:
Q: Kroton Motor Parts Sdn. Bhd. purchased a raw material named Kroton, from an outside supplier at a…
A: Annual Demand Annual Demand is the quantity required by a company to fulfil its operations. It…
Q: The barkeeper at South Chillz has asked you to assist him in finding the combination of mixed drinks…
A: Decision variables: x1 = No. of servings to make of Bobby Burns x2 = No. of servings to make of…
Q: Cassorla’s Clothes sells a large number of white dress shirts. The shirts, which bear the store…
A: Given Monthly demand = 120 units Standard deviation = 32 Lead time = 3 weeks (0.75 month) Lead time…
Q: Company B is a retailer of mobile phones in Australia that works 250 days in a year. The manager is…
A: Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…
Q: A retailer has two merchandizers, Sue and Bob, who are responsible for setting orderquantities for…
A: Correct answer is d. Bob because he is probably ordering more than the mean of the demand forecast.…
Q: Company B is a retailer of mobile phones in Australia that works 250 days in a year. The manager is…
A: The formulas used for solving the question are: EOQ = 2 × Annual demand × Ordering costHolding cost…
Q: Muscat Tubes Manufacturing LLC are the manufacturer of picture tubes for T.V. The following are the…
A: The question is related to Inventory Management. We will Start with calculation of Reorder level.
Q: The following lots of a particular commodity were available for sale during the year Beginning…
A: Calculation of cost of goods available for sale Date Units Unit cost Total cost Beginning…
Q: r pays $28 for each battery and estimates that the annual holding cost is 30 percent of the…
A: The current ordering and holding costs are: C(100) = (R/Q)K+(Q/2)h
Q: The Union Street Microbrewery makes 1220 Union beer, which it bottles and sells in its…
A: Optimal order quantity=QCp, ordering/producing cost=1700Ch=carrying cost=1.25D=Annual…
Q: Ram Roy's firm has developed the following supply, demand, cost, and inventory data. Supply…
A: we use solver method of transportation to get the cost by using a excel file
Q: Ram Roy's firm has developed the following supply, demand, cost, and inventory data. Supply…
A: The greatest output that can be reached in the manufacturing of manufactured items is referred to as…
Q: 1. Using the data provided here for problem 1. Calculate the following: 1 2| 3 | 4 | 5 6 7 8 9 Week…
A: As we can see, that weekly demand is not the same in all weeks. Hence, variable demand case.
Q: Suppose that we would like to determine Reorder Point for the product. From the historical data the…
A: Mean demand during lead time d= 200 units Standard deviation during lead time σ= 10 units Maximum…
Q: An EOQ model that incorporates quantity discounts is used to determine: a. whether to use…
A: Answer - how many units should be ordered
2
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
how did you get the answers to the optimal production
- 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 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 levelAutoTime, a manufacturer of electronic digital timers, has a monthly fixed cost of $50,000 and a production cost of $7 for each timer manufactured. The timers sell for $15 each. (a) What is the cost function C(x)?C(x) = (b) What is the revenue function R(x)?R(x) = (c) What is the profit function P(x)?P(x) = (d) Compute the profit (loss) corresponding to production levels of 3000, 6000, and 11,000 timers, respectively. (Input a negative value to indicate a loss.) 3000 timers $ 6000 timers $ 11,000 timers $
- 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?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 daysA distributor of large appliances needs to determine the order quantities and reorderpoints for the various products it carries. The following data refer to a specii c refrigeratorin its product line:Cost to place an orderHolding costCost of refrigeratorAnnual demandStandard deviation of demand during lead timeLead time$10020 percent of product cost per year$500 each500 refrigerators10 refrigerators7 daysConsider an even daily demand and a 365-day year.a. What is the economic order quantity?b. If the distributor wants a 97 percent service probability, what reorder point, R, shouldbe used?
- ABC Company has correctly computed its economic order quantity at 1,000 units; however, management feels it would rather order in quantities of 1,500 units. How should ABC’s total annual purchase order cost and total annual carrying cost for an order quantity of 1,500 units compare to the respective amounts for an order quantity of 1,000 units? A. Lower purchase order cost and lower carrying cost B. Lower purchase order cost and higher carrying cost C. Higher purchase order cost and higher carrying cost D. Higher purchase order cost and lower carrying costsBicycleBro 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?Your company makes hand sanitizer in two lines: Moisturizing+, and StandardSoap. On the market, Moisturizing+ retails for $175/L and StandardSoap retails for $95/L. You make the hand sanitizer by combining lotion, soap, and secret ingredient SpecialX. These ingredients are purchased from a mysterious supplier, and you can purchase at most 4000L of lotion, 5000L of soap, and 750L of SpecialX in a month. Lotion costs $25/L, soap costs $10/L, and SpecialX costs $35/L. To make 1L of Moisturizing+, you need to combine 0.5L of lotion, 0.3L of soap, and 0.2L of SpecialX. To make 1L of StandardSoap, you need to combine 0.4L of lotion, 0.55L of soap, and 0.05L of SpecialX. Your company has committed to donating 500L of StandardSoap to a local charity. Since this is a donation, you will not receive any revenue. However, the costs and purchasing limits apply to both the hand sanitizer that is sold on the market and donated to charity. You want to maximize your monthly profit. Assume that…
- Cryolab Inc makes and sells a lawn fertilizer called Hypergro. The company has developed standard costs for one bag of Hypergro as follows: Standard Quantity/Hours Standard Price/Rate Standard Cost per Bag Direct Material 25 pounds ₱ 0.75 ₱18.75 Direct Labor 0.25 hours ₱69.00 ₱17.30 Variable overhead 0.25 hours ₱24.00 ₱ 6.00 Total ₱42.05 The company had no beginning inventories of any kind on January 1. Variable overhead is applied to production on the basis of standard direct labor hours. During January, the following activity was recorded by the company: Production of Fastgro: 23,000 bags Direct materials purchased: 585,000 pounds at a cost of ₱436,250 Direct labor worked: 5,800 hours at a cost of ₱397,300 Variable overhead incurred: ₱140,650 Inventory of direct materials on January 31: 8,000 pounds Compute the variances and indicate whether it is FAVORABLE (F) or UNFAVORABLE (U) in your solution sheet. The raw…Prior to opening his branch in Fourways, Conrad made a decision to conduct further research intopotential suppliers for his new business venture. He downloaded the integrated annual report forAstral Foods to conduct his research. The link for the integrated annual report can be found using thefollowing link:https://www.astralfoods.com/assets/Documents/Investor%20Centre/2022/Integrated%20Report%20for%20the%20year%20ended%2030%20September%202022.pdf. Q3.2 Discuss the viewpoint you believe Chicky Fillet should adopt towards stakeholders.Discuss the various stakeholders, their possible interests, and the proposed businessapproach towards honouring their interests.Explain what is the definition of a deterministic inventory model ? When is it appropriate to use ?