/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} Q 24OQ Retailers Warehouse (RW) is an i... [FREE SOLUTION] | 91影视

91影视

Retailers Warehouse (RW) is an independent supplier of household items to department stores. RW attempts to stock enough items for a 98 percent service probability. A stainless steel knife set is one item it stocks. Demand (2,400 sets per year) is relatively stable over the entire year. Whenever a new stock is ordered, a buyer must assure that numbers are correct for stock on hand and then phone in a new order. The total cost involved to place an order is about \(5. RW figures that holding inventory in stock and paying for interest on borrowed capital, insurance, and so on, add up to about \)4 holding cost per unit per year. Analysis of the past data shows that the standard deviation of demand from retailers is about four units per day for a 365-day year. Lead time to get the order in seven days.

a. What is the economic order quantity?

b. What is the reorder point?

Short Answer

Expert verified

Answer

The reorder point (ROP) is the inventory level that triggers an action to replenish that specific inventory stock.

Step by step solution

01

Step-by-Step Solution

Step 1: Economic Order Quantity (EOQ)

It is the bare minimum of an item that a corporation has on hand, such that when a stock falls below this level, the item must be reordered. During the replenishment lead period, it is normally approximated as the predicted usage plus safety stock. The EOQ (Economic Order Quantity) paradigm believed that there is no time lag between ordering and procuring suppliers.

Economic Order Quantity (EOQ) is a manufacturing formula that finds the most cost-effective number of items to acquire based on ordering and carrying expenses. In other words, it reflects the best amount of inventory that a firm should purchase each time to reduce the expenses associated with ordering and storing inventory.

02

(a) Calculation of Economic Order Quantity (EOQ)

Given,

Annual demand (A) = 2,400 books

Ordering cost per unit (S) = $5

Holding cost (H) = $4

Number of working days in a year = 365

Lead time (L) = 7 days

Standard deviation D= 4 sets

EOQ=2ASHWhere,A=AnnualDemandS=OrderingcostperunitH=Carryingcostperunit

EOQ=2ASH=22,40054=77.45or78units

So, the Economic Order Quantity (EOQ) is 78 units.

03

(b) Calculation of the daily demand and value of z, standard deviation during the lead time, and Reorder point  as given below

Given,

Annual demand (A) = 2,400 books

Number of working days in a year = 365

Dailydemandd=AnnualDemandNo.ofworkingdays=2,400365=6.57or7

So, the daily demand is 7 units.

Calculation of standard deviation during the lead time

Given,

Lead time (L) = 7 days

Standard deviation D= 4 sets

role="math" localid="1650530972150" L=i=1L2d=742=10.58sets

So, the standard deviation during the lead time is 10.58 sets.

Calculation of numbers of standard deviation which is denoted by z

By using an excel spreadsheet and function NORMSIV with the probability of 98% as given below:

=NORMSIV(0.98) and this will yield the z value to 2.05

Calculation of the Reorder point by using the following formula as given below:

Reorderlevel=dL+锄蟽L=77+2.0510.58=70.689or71sets

So, the reorder point is 71 sets.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with 91影视!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

What are the four main functions within SAP鈥檚 supply chain software?

Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 130 units. The following is the BOM in indented form:

ITEMS

DESCRIPTION

USAGE

X

Bracket assembly

1

A

Wall board

4

B

Hanger sub-assembly

2

D

Hanger casting

3

E

Ceramic knob

1

C

Rivet Head screw

3

F

Metal tong

4

G

Plastic cap

2

Below is a table indicating current inventory levels:

ITEMS

X

A

B

C

D

E

F

G

Inventory

25

16

60

20

180

160

1000

100

a.Using Excel, create the MRP using the information provided.

Prepare an aggregate plan for the coming year, assuming that the sales forecast is perfect. Use the spreadsheet 鈥淏radford Manufacturing.鈥 In the spreadsheet, an area has been designated for your aggregate plan solution. Supply the number of packaging lines to run and the number of overtime hours for each quarter. You will need to set up the cost calculations in the spreadsheet. You may want to try using the Excel Solver to find a solution. Remember that your final solution needs an integer number of lines and an integer number of overtime hours for each quarter. (Solutions that require 8.9134 lines and 1.256 hours of overtime are not feasible.)

Following are the process flow sequences for three products: A, B, and C. There are two bottleneck operations鈥攐n the first leg, and the fourth leg鈥攎arked with an X. Boxes represent processes, which may be either machine or manual. Suggest the location of the drum, buffer, and ropes.

Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the 1st quarter is Jan, Feb, and Mar; 2nd quarter Apr, May, Jun; 3rd quarter Jul, Aug, Sep; and 4th quarter Oct, Nov, Dec.

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Last year

100

125

135

175

185

200

150

140

130

200

225

250

This year

125

135

135

190

200

190

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.