Question

In: Operations Management

Weiss’s paint store uses a (Q, R) inventory control system to control its stock level. For...

Weiss’s paint store uses a (Q, R) inventory control system to control its stock level. For a particular popular white latex paint, historical data show that the distribution of monthly demand is approximately normal, with mean 28 and standard deviation 8. Replenishment lead time for this paint is about 14 weeks. Each can of paint costs the store $6. Although excess demands are backordered, the store owner estimates that unfilled demands cost about $10 each in bookkeeping and loss of goodwill costs. Fixed costs of replenishment are $15 per order, and holding costs are based on a 30% annual rate of interest.

a) Follow the Q, R policy identified in a), what is the inventory level when the order with size of Q (identified in a) arrives if there was $150 loss in bookkeeping and loss of goodwill due to unfilled demands in last cycle?

b) Follow the Q, R policy identified in a), what is the inventory level when the order with size of Q (identified in a) arrives if the inventory at the end of last cycle is 21?

Solutions

Expert Solution

Solution:-

Given:-

Month to month request: d=28, s=std. deviation=8

Lead time = L = 14 weeks= 14/4 =3.5 months

Cost of paint= C=$6 each

Cost of loss of altruism =$10 each

Obtainment cost= P= $15/request

Stock holding cost= h= 30% yearly per cost of every thing put away.

Yearly demand= D= 28*12=336

Optimal Lot Size =

=

=74.83

Optimal Lot Size=75 units

Accepting 95% assistance level, z= normiverse(95%) = 1.96

safety syock =

Be that as it may, sl = sexually transmitted disease deviation of lead time = 0

Safety stock =

safety stock =29.33= 30 units

Reorder point=ROP= lead time * month to month utilization + wellbeing stock = L*d +SS

ROP = 3.5*28+30 =128 units

A):-

In this way, so as to limit anticipated all out cost, the ideal part size is 75 units and the reorder point is 128 units.

Since there was lost generosity and accounting worth $150, it infers that there was loss of 150/10 i.e 15 units in the stock.

So when the request amount of EOQ = 75 units shows up to the parcel,

The stock level becomes = EOQ-delay purchased amount

=75-15 = 60 units.

In this way, the stock levels in the provided situation of delay purchase becomes 60 units to oblige for the misfortune.

B):-

Stock toward the finish of last cycle = 21 units.

Ideal arranged amount = 75 units.

Accordingly the new stock level after the given condition = EOQ + Inventory toward the finish of last cycle

=75+21= 96 units

In this way the new stock level after the given condition is 96 units.


Related Solutions

An electronics store uses a fixed order quantity inventory control system. Characteristics of one of its...
An electronics store uses a fixed order quantity inventory control system. Characteristics of one of its items is as follows: weekly demand is 2,000 units, ordering cost is $35 per order, holding cost per week is $0.04, replenishment lead-time is 3 weeks and the standard deviation of weekly demand is 400 units. Assuming the store operates 50 weeks per year, what is the EOQ for this item? Calculate the reorder point with safety stock if the store wishes to provide...
Nationwide Auto Parts uses a periodic review inventory control system for one of its stock items....
Nationwide Auto Parts uses a periodic review inventory control system for one of its stock items. The review interval is 12 ​weeks, and the lead time for receiving the materials ordered from its wholesaler is 4 weeks. Weekly demand is normally​ distributed, with a mean of 125 units and a standard deviation of 25 units. Refer to the standard normal table LOADING... for​ z-values. a. What is the average and the standard deviation of demand during the protection​ interval? The...
​The Discount Appliance Store uses a continuous review system (Q system).
The Discount Appliance Store uses a continuous review system (Q system).One of the company's items has the following characteristics:- Demand =10 units/week (assume 52 weeks per year)- Ordering or Setup Cost (S)=$ 45) order- Holding cost (H)=$12 unit/year- Lead Time (L)=3 weeks (constant)- Standard Deviation in Weekly Demand = 8 units- Cycle-Service Level =70%What is the EOQ for this item?What is the desired safety stock?What is the desired reorder point R?What is the total annual cost?Suppose that the current policy...
Question 1: Using a computerized Inventory Management System, a Paint Supply Store franchise continuously monitors the...
Question 1: Using a computerized Inventory Management System, a Paint Supply Store franchise continuously monitors the inventory of all the paint located at each of their 15 stores and their distribution warehouse. The Paint Supply Store franchise sells an average of 32 gallons of Red Paint every week (for 52 weeks per year, Standard Deviation of the Demand = 4 gallons). They purchase Red Paint from their supplier at a price of $2.00 per gallon. It takes 1.25 weeks to...
San Lorenzo General Store uses a periodic inventory system and the retail inventory method to estimate...
San Lorenzo General Store uses a periodic inventory system and the retail inventory method to estimate ending inventory and cost of goods sold. The following data are available for the month of October 2018: Cost Retail Beginning inventory $ 47,000 $ 62,000 Net purchases 10,480 32,800 Net markups 2,400 Net markdowns 1,400 Net sales 44,000 Required: Complete the table below to estimate the average cost of ending inventory and cost of goods sold for October.
Problem 2 Cindy’s Appliance Store uses a perpetual inventory system, and ending inventory at April 30...
Problem 2 Cindy’s Appliance Store uses a perpetual inventory system, and ending inventory at April 30 was $25,000. Following is a listing of transactions for Cindy’s for the month of May. Cindy’s purchased refrigerators from GE on account at a total cost of $500,000 with terms 2/10, n/30. Cindy’s also paid freight of $800 on the refrigerators purchased from GE. Several of the refrigerators had to be returned to GE, and GE issued a credit to Cindy’s for 10 refrigerators...
Fortune Stores uses the periodic inventory system for its merchandise inventory. The April 1 inventory for...
Fortune Stores uses the periodic inventory system for its merchandise inventory. The April 1 inventory for one of the items in the merchandise inventory consisted of 120 units with a unit cost of $375. Transactions for this item during April were as follows: April 9 Purchased 40 units @ $395 per unit 14 Sold 80 units @ $600 per unit 23 Purchased 20 units @ $400 per unit 29 Sold 40 units Required a. Calculate the cost of goods sold...
LeMay Department Store uses the retail inventory method to estimate ending inventory for its monthly financial...
LeMay Department Store uses the retail inventory method to estimate ending inventory for its monthly financial statements. The following data pertain to one of its largest departments for the month of March 2021: Cost Retail Beginning inventory $ 52,000 $ 72,000 Purchases 219,000 412,000 Freight-in 19,470 Purchase returns 5,500 8,000 Net markups 7,000 Net markdowns 4,700 Normal breakage 8,000 Net sales 292,000 Employee discounts 3,000 Sales are recorded net of employee discounts. Required: 1. Compute estimated ending inventory and cost...
GGG uses a perpetual inventory system. The company’s beginning inventory of a particular product and its...
GGG uses a perpetual inventory system. The company’s beginning inventory of a particular product and its purchases during the months of January and February were as follows:                                                                                         Quantity                             Unit Cost    Beginning inventory (Jan. 1)................................................. 50                                         $6.00        Purchase (Jan. 10)................................................................. 25                                           7.00        Purchase (Jan. 22)................................................................. 25                                           8.52           Purchase (Feb. 9)…………………………………………              65                                    11.00             Total     ...............................................................................                                                   On February 25, GGG sells 65 units of this product. The other units remain in inventory at February...
Cansela Corporation uses a periodic inventory system and the LIFO method to value its inventory. The...
Cansela Corporation uses a periodic inventory system and the LIFO method to value its inventory. The company began 2018 with inventory of 5,600 units of its only product. The beginning inventory balance of $75,600 consisted of the following layers:    2,100 units at $11 per unit = $ 23,100 3,500 units at $15 per unit = 52,500 Beginning inventory $ 75,600    During the three years 2018–2020, the cost of inventory remained constant at $17 per unit. Unit purchases and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT