please solve all parts within 30 minutes. You may need to use the appropriate technology to answer this question.Kelly's Service Station does a large business in tune-ups. Demand has been averaging 240 spark plugs per week. Holding costs are $0.05per plug per week, and reorder costs are estimated at $10 per order.Kelly's does not want to be out of stock on more than 1% of his orders. There is a one-day delivery time. The standard deviation of demandis five plugs per day. Assume a normal distribution of demand during lead time and a seven-day work week. (The station operates 52 weeksper year.)(a) What inventory policy do you suggest for Kelly's station? (Round the order size and the reorder point to the nearest whole number andthe cycle time to two decimal places.)Kelly's service station should orderspark plugs everyweeks when the supply reaches(b) What is the average amount of safety stock for the reorder point for part (a)? (Round your answer to the nearest whole number.)(c) What is the total variable weekly cost including safety stock cost (in dollars)? (Round your answer to two decimal places.)$

Given in the question: Average Demand Per Week 240 Holding Cost per plug per week $…

What inventory policy do you suggest for Kelly's station? (Round the order size and the reorder point to the nearest whole number and the cycle time to two decimal places.) Kelly's service station should order weeks when the supply reaches spark plugs every What is the average amount of safety stock for the reorder point for part (a)? (Round your answer to the nearest whole number.) What is the total variable weekly cost including safety stock cost (in dollars)? (Round your answer to two decimal places.)

What inventory policy do you suggest for Kelly's station? (Round the order size and the reorder point to the nearest whole number and the cycle time to two decimal places.) Kelly's service station should order weeks when the supply reaches spark plugs every What is the average amount of safety stock for the reorder point for part (a)? (Round your answer to the nearest whole number.) What is the total variable weekly cost including safety stock cost (in dollars)? (Round your answer to two decimal places.)

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter5: Probability: An Introduction To Modeling Uncertainty

Section: Chapter Questions

Problem 32P: Assume that the traffic to the web site of Smileys People, Inc., which sells customized T-shirts,...

See similar textbooks

Similar questions

You have been hired as a financial manager by Alpha Company which sells 2,700 of car batteries per year, and places orders for 600 of metals. The Company has no safety stocks. Moreover, the financial analyst estimates a 50% probability of no shortages in each cycle, and the likelihood of inventory shortages of 10, 20, and 30 units as 0.25, 0.15, and 0.10 respectively. The carrying cost per unit per year is $2. The stockout cost is $5, What is the optimal level of safety stock should you recommend? You plan to consider safety stock of 0, 10, 20, and 30 units
Thomas' Bike Shop stocks a high-volume item that has a normally distributed demand during lead time. The average daily demand is 100 units, the lead time is 4 days, and the standard deviation of demand of 20 units. 1.) What should the reorder point be to satisfy a 90% service level to Thomas? 2.) Suppose Thomas decides to cut back on safety stock by 40%, what would be his new service probability?
A local TV repairs shop uses 36,000 units of a part each year (A maximum consumption of 100 units per working day). It costs P20 to place and receive an order. The shop orders in lots of 400 units. It cost P4 to carry one unit per year of inventory. Calculate the Economic Order Quantity If you are expecting 2 days delay, how much is the safety stock? If you are expecting 2 days delay, how much is the reorder point?
Phillips Corporation is a major manufacturer of food processors. It purchases motors from Viking Corporation. Annual demand is 52,000 motors per year or 1,000 motors per week. The ordering cost is $360 per order. The annual carrying cost is $6.50 per motor. It currently takes 2 weeks to supply an order to the assembly plant. Q. Now assume that demand can vary during the 2-week purchase-order lead time. The following table shows the probability distribution of various demand levels: Total Demand for Motors for 2 Weeks Probability of Demand (sums to 1) 1,600 0.05 1,800 0.20 2,000 0.50 2,200…
SamaCell has a demand of 2,000 cells per year. The cost of each unit is $80, and the inventory carrying cost is $10 per unit per year. The average ordering cost is $30 per order. It takes about two days for an order to arrive and there are 250 working days per year. Round to two decimal places. a) What is the EOQ? units. b) What is the average inventory if the EOQ is used? units. c) What is the optimal number of orders per year? orders. d) What is the optimal number of days in between any two orders? days. e) What is the annual cost of ordering and holding inventory? USD. What is the reorder point (ROP)?
Zozan Corp. manufactures Hydrogen engines automobiles. Recently 450 new orders placed by customers requesting credit. The variable cost is $35,000 per unit, and the credit price is $43,000 each. Credit is extended for one period, and based on historical experience, payments for 20% of the orders are never collected. The required return is 4% per period. Assuming a repeat customer, should it be filled by the firm? The customer will not buy if credit is not extended
Transcribed Image Text: You have been hired as a financial manager by Alpha Company which sells 2,700 of car batteries per year, and places orders for 600 of metals. The Company has no safety stocks. Moreover, the financial analyst estimates a 50% probability of no shortages in each cycle, and the likelihood of inventory shortages of 10, 20, and 30 units as 0.25, 0.15, and 0.10 respectively. The carrying cost per unit per year is $2. The stockout cost is $5, What is the optimal level of safety stock should you recommend? You plan to consider safety stock of 0, 10, 20, and 30 units.
Brody Inc. is currently selling a product at P20 per piece. The income statement for the current month showed that Brody Inc. have sold 100,000 units, variable costs of P800,000 and fixed costs of P400,000. Management is thinking of reducing the current sales price by P2 and based on studies, this will increase unit sales by 20%. If you are the company’s management accountant, what will be the financial impact of this scenario that you will report to management? a. no change in profit b. an P80,000 drop in profitability. c. a P240,000 drop in profitability. d. a P400,000 drop in profitability.
According to the Financial Department, the cost for a short waiting of a customer is $20. When there are: backorder, lost sales, lost customer, the costs are: $40, $100, S600 respectively. Y Figures calculated by the Marketing Department for the last year show the following: 1. 20% of all stock-outs result in short waiting of a customer. 2. 50% of all stock-outs result in a back order. 3. 20% of all stock-outs result in a lost order. 4. 10% of all stock-outs result in a lose of a customer. Questions: a. What is the average cost of a stock-out? b. How much should we invest in inventory to reduce the number of stock-outs from 1000 a year to only 200 per year?
Scholes Systems supplies a particular type of office chair to large retailer such as Target, Costco, and Office Max. Scholes is concerned about the possible effects of inflation on its operations. Presently, the company sells 85,000 units for $80 per unit. The variable production costs are $50, and fixed costs amount to $1,450,000. Production engineers have advised management that they expect unit labor costs to rise by 20 prevent and unit materials costs to rise by 10 percent in the coming year. Of the $50 variable costs, 45 percent are from labor and 25 percent are from materials. Variable overhead costs are expected to increase 25 percent. Sales prices cannot increase more than 10 percent. It is also expected that fixed costs will rise by 6 percent as a result of increased taxes and other miscellaneous fixed charges. The company wishes to maintain the same level of profit in real dollar terms. It is expected that to accomplish this objective, profits must increase by 7 percent…
Raveen Products sells camping equipment. One of the company’s products, a camp lantern, sells for $80 per unit. They managed to sell 10,000 lanterns per month. Variable expenses are $55 per lantern, and fixed expenses associated with the lantern total $150,000 per month. Compute the company’s Margin of Safety in percentage. If the variable expenses per lantern increase as a percentage of the selling price, Will it result in a higher or a lower break-even point? (Assume that the fixed expenses remain unchanged.) At present, the company is selling 10,000 lanterns per month. The sales manager is convinced that a 10% reduction in the selling price will result in a 50% increase in the number of lanterns sold each month. Prepare two contribution format income statements, one under present operating conditions, and one as operations would appear after the proposed changes. Calculate Contribution Margin Amount of Present Operating Conditions Calculate Net Profit of Present Operating…
Zozan Corp. manufactures Hydrogen engines automobiles. The variable cost is $41,000 per unit, and the credit price is $44,000 each. Credit is extended for one period, and based on historical experience, payments for 11% of the orders are never collected. The required return is 3% per period. Assuming a repeat customer, should it be filled by the firm? The customer will not buy if credit is not extended (Do not use the $ sign. if your answer is -$123,456.78, then enter -123456.78).