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

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.

keosha answered 3 weeks ago

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...

Question