/*! 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} Q9OQ_a Semans is a manufacturer that pr... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

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.

Short Answer

Expert verified

Items

Net requirement

X

105

A

114

B

70

D

110

E

50

C

30

F

870

G

30

Step by step solution

01

MRP

Material requirements planning(MRP)is a method that assists producers in scheduling, budgeting, and managing their inventories during production. It is a software-based platform.

02

 Calculation of demand, inventory and net requirement

Demand for X = 130

Inventory = 25

Net requirement,

X = demand - inventory

= 105

Every bracket assembly requires (4 of A), (2 of B), and (3 of C).

Demand for A = 4 x 105

= 420

Inventory = 16

Net requirement = 420 – 16

= 404

Demand for B = 2 x 105

= 210

Inventory for B = 60

B Net requirement = 210 – 60

=150

Same for (3 of D) and (1 of E)

Demand for D = 3 x Net requirement of B

= 3 x 250

= 750

Inventory for D = 180

D, net requirement = 750 – 180

= 570

Demand for E = 1 x Net requirement of B

= 1 x 250

= 250

Inventory for E = 160

E, net requirement = 250 – 160

=90

Demand for C = 3 x 250

= 750

Inventory = 20

C, net requirement = 750 – 20

= 730

Rivet head screw, C requires (4 of F) and (2 of G)

Demand of F = 4 x 730

=2920

Inventory of F = 1000

F, net requirement = 2920 – 1000

= 1920

Demand of G = 2 x 730

=1460

Inventory = 100

G, net requirement = 1460 – 100

=1360

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

Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows:

Month

Demand (units)

January

4200

February

4300

March

4000

April

4400

May

5000

June

4700

July

5300

August

4900

September

5400

October

5700

November

6300

December

6000

b. To be reasonably confident of meeting demand, Nina decides to use three standard errors of estimate for safety. How many additional units should be held to meet this level of confidence?

SY Manufacturers (SYM) is producing T-shirts in three colors: red, blue, and white. The monthly demand for each color is 3,000 units. Each shirt requires 0.5 pounds of raw cotton that is imported from Luft-Geshfet-Textile (LGT) Company in Brazil. The purchasing price per pound is \(2.50 (paid only when the cotton arrives at SYM’s facilities) and the transportation cost by sea is \)0.20 per pound. The traveling time from LGT’s facility in Brazil to the SYM facility in the United States is two weeks. The cost of placing a cotton order, by SYM, is $100 and the annual interest rate that SYM is facing is 20 percent.

a. What is the optimal order quantity of cotton?

b. How frequently should the company order cotton?

c. Assuming that the first order is needed on April 1, when should SYM place the order?

d. How many orders will SYM place during the next year?

e. What is the resulting annual holding cost?

f. What does the resulting annual ordering cost?

g. If the annual interest cost is only 5 percent, how will it affect the annual number of orders, the optimal batch size, and the average inventory? (You are not expected to provide a numerical answer to this question. Just describe the direction of the change and explain your answer.)

Question: Under which conditions would a plant manager elect to use a fixed order quantity model as opposed to a fixed–time period model? What are the disadvantages of using a fixed–time period ordering system?

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

The number of cases of merlot wine sold by the Connor Owen winery in eight years is as follows:

Using an exponential smoothing model with an alpha value of 0.20, estimate the smoothed value calculated as of the end of 2012. Use the average demand for 2005 through 2007 as your initial forecast, and then smooth the forecast forward to 2012.

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.