Question

In: Operations Management

The Hunicut and Hallock Corporation makes two versions of the same basic file cabinet, the TOL...

The Hunicut and Hallock Corporation makes two versions of the same basic file cabinet, the TOL (Top-of-the-line) five drawer file cabinet and the HQ (High-quality) five drawer filing cabinet. You are reviewing the MRP for the HQ file cabinet. The HQ file cabinet is made up of five drawers with each drawer requiring two bearings, one on each side. Complete the Materials Requirements Plan (MRP) below in order to answer the questions in the quiz.

HQ 1 2 3 4
Gross Requirements 50 0 100 20
Scheduled Receipts 50
Projected Available Balance 22
On-hand
Net Requirements
Planned Order Receipt
Planned Order Release

Lead Time = 1 period; Safety-stock = 10; Lot-size = multiples of 50

Drawers 1 2 3 4
Gross Requirements
Scheduled Receipts 300 200
Projected Available Balance 35
On-hand
Net Requirements
Planned Order Receipt
Planned Order Release

Lead Time = 1 period; Safety-stock = 15; Lot-size = multiples of 100

Bearings 1 2 3 4
Gross Requirements 100
Scheduled Receipts 595
Projected Available Balance 20
On-hand
Net Requirements
Planned Order Receipt
Planned Order Release

Lead Time = 2 periods; Safety-stock = 10; Lot-size ≥ 450

Solutions

Expert Solution

MRP:

Particulars

Period

0

1

2

3

4

HQ

OH =22

LT=1

SS=10

Q = Multiples of 50

Gross Requirements

0

50

0

100

20

Scheduled Receipts

0

50

0

0

0

Projected On-hand

22

22

22

22

22

Net Requirements

0

0

0

78

8

Planned Order Receipts

0

0

0

100

50

Planned Order Releases

0

0

100

50

0

Drawers

OH =35

LT=1

SS=15

Q = Multiples of 100

Gross Requirements

0

0

500

250

0

Scheduled Receipts

0

300

200

0

0

Projected On-hand

35

35

335

35

85

Net Requirements

0

0

0

215

0

Planned Order Receipts

0

0

0

300

0

Planned Order Releases

0

0

300

0

0

Bearings

OH =20

LT=2

SS=10

Q≥450

Gross Requirements

0

0

600

100

0

Scheduled Receipts

0

595

0

0

0

Projected On-hand

20

20

615

15

365

Net Requirements

0

0

0

85

0

Planned Order Receipts

0

0

0

450

0

Planned Order Releases

0

450

0

0

0

   Formula:

          Net requirements = Gross requirements – On hand inventory – Scheduled receipts.


Related Solutions

8. A business wants to know whether two versions of an email offer have the same...
8. A business wants to know whether two versions of an email offer have the same click-through proportion. It sent a random sample of customers an email. It randomly decided which of the two offers went in each email. In the end, it had the following data. 505 out of the 1218 customers that received the first email, clicked on the offer. 468 out of the 1221 customers that received the second email, clicked on the offer. (a) What is...
Children in elementary schools in a US city were given two versions of the same test,...
Children in elementary schools in a US city were given two versions of the same test, but with the order of questions arranged from easier to more difficult in version A and in reverse order in version B. A randomly selected group of 44 students were given version A; their mean grade was 83 with standard deviation 5.6. Another randomly selected group of 38 students were given version B; their mean grade was 81 with standard deviation 5.3. A hypothesis...
Layton Machining Company (LMC) manufactures two versions of a basic machine tool. One version is a...
Layton Machining Company (LMC) manufactures two versions of a basic machine tool. One version is a standard model and one is a custom model, which requires some additional work and slightly higher-grade materials. The manufacturing process at LMC requires that each product go through two departments, Grinding and Finishing. The process in each department uses a single type of machine. Total machine capacity in Grinding is 51,000 hours, and in Finishing, total machine capacity is 31,000 hours. (Each department has...
Ferris Corporation makes a single product—a fire-resistant commercial filing cabinet—that it sells to office furniture distributors....
Ferris Corporation makes a single product—a fire-resistant commercial filing cabinet—that it sells to office furniture distributors. The company has a simple ABC system that it uses for internal decision making. The company has two overhead departments whose costs are listed on the following page: Manufacturing overhead .................................. $500,000 Selling and administrative overhead ................ 300,000 Total overhead costs ........................................ $800,000 The company’s ABC system has the following activity cost pools and activity measures: Activity Cost Pool Activity Measure Assembling units ........................
Willow Company produces lawn mowers. One of its plants produces two versions of mowers: a basic...
Willow Company produces lawn mowers. One of its plants produces two versions of mowers: a basic model and a deluxe model. The deluxe model has a sturdier frame, a higher horsepower engine, a wider blade, and mulching capability. At the beginning of the year, the following data were prepared for this plant: Basic Model Deluxe Model Expected quantity 40,000 20,000 Selling price $180 $360 Prime costs $80 $160 Machine hours 5,000 5,000 Direct labor hours 10,000 10,000 Engineering support (hours)...
DiDonato Supplies manufactures two versions of presentation remotes: Basic and Laser. Both models go through the...
DiDonato Supplies manufactures two versions of presentation remotes: Basic and Laser. Both models go through the same assembly process and are produced in the same plant. The difference between the models is in the additional parts for the laser model as well as the cost of the parts themselves. The following data are available for the year just ended: Basic Laser Total Number of units 290,000 80,000 370,000 Parts cost per unit $12 $25 Other costs: Direct labor $ 832,000...
USE BASIC PYTHON Focus on Basic file operations, exception handling. Save a copy of the file...
USE BASIC PYTHON Focus on Basic file operations, exception handling. Save a copy of the file module6data.txt (Below) Write a program that will a. Open the file module6data.txt b. Create a second file named processed. txt c. Read the numbers from the first file one at a time. For each number write into second file, if possible, its I. Square ii. Square root iii. Reciprocal (1/number)use a math module function for the square root. use exception handling to trap possible...
A manufacturing company makes runners for cabinet drawers. To assess the quality of the manufacturing process,...
A manufacturing company makes runners for cabinet drawers. To assess the quality of the manufacturing process, the company collected one sample of 300 consecutively manufactured runners each day for 20 days and counted the number of defective items. The resulting sample data are: Sample:             1      2      3      4      5      6      7      8      9    10 Sample Size:   300 300 300 300 300 300 300 300 300 300 Defectives:        8       6     11    15    12    11     9      6      5      4 Based on your previous answers, sketch the p control chart for your own reference. Now plot all the...
A publisher sells subscriptions to its print publications and to its online versions of the same...
A publisher sells subscriptions to its print publications and to its online versions of the same publications. A customer can buy a print-only subscription for (see separate sheet) months for (see separate sheet), or a print subscription plus an online subscription for (see separate sheet). Experience shows that almost all customers buy the print plus the online subscription, so the publisher does not allocate between print only and print plus online; it simply treats everything—even the print-only subscriptions—for accounting purposes...
ABC Corporation makes skis in two departments: Department A makes      the frame and Department B...
ABC Corporation makes skis in two departments: Department A makes      the frame and Department B adds the bindings and paints the skis. Monthly      capacities are as follows:                                                                         Department A         Department B                  Monthly capacity                         4,000 pairs of skis    5,000 pairs of skis                      The company can sell 5,000 pairs per month. A pair of skis sells for $500 and has a      variable cost of $250.     Required: Assuming that ABC sells every pair it...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT