Question

In: Operations Management

A company that manufactures snow shovels has one plant and two distribution centers (DCs). Given the...

A company that manufactures snow shovels has one plant and two distribution centers (DCs). Given the following information for the two DCs, calculate the gross requirements, projected available, and planned order releases for the two DCs and the gross requirements, projected available, and planned order releases for the central warehouse.

Distribution Center A Transit Time:   2 weeks Order Quantity:   500 units

Week

1

2

3

4

5

Gross Requirements

300

200

150

275

300

In Transit

500

Projected Available 200

Planned Order Release

Distribution Center B

Transit time: 2 weeks

Order Quantity: 200 weeks

Week

1

2

3

4

5

Gross Requirements

50

75

100

125

150

In Transit

Projected Available  150

Planned order release

Central Supply

Lead time : 1 week

Order Quantity= 600 units

Week

1

2

3

4

5

Gross Requirements

Scheduled receipts

Projected available 400

Planned order release

Please show all work.

Solutions

Expert Solution

Below is the screenshot of the MRP schedule -

Below is the screenshot of the formula applied -


Related Solutions

Frandec Company manufactures, assembles, and rebuilds material handling equipment used in warehouses and distribution centers. One...
Frandec Company manufactures, assembles, and rebuilds material handling equipment used in warehouses and distribution centers. One product, called a Liftmaster, is assembled from four components: a frame, a motor, two supports, and a metal strap. Frandec’s production schedule calls for 4000 Liftmasters to be made next month. Frandec purchases the motors from an outside supplier, but the frames, supports, and straps may be either manufactured by the company or purchased from an outside supplier. Manufacturing and purchase costs per unit...
4. (20 pts) GA Industries manufactures handling equipment used in distribution centers. One product, called a...
4. (20 pts) GA Industries manufactures handling equipment used in distribution centers. One product, called a Liftmaster, has three components: a frame with strap, a motor and two supports. The most recent order has been for 4000 Liftmasters for next month. The sales and production departments must work together to determine delivery schedules. Although the processes used in the manufacture of the three components vary, there are three areas where the production manager is concerned about the availability of resources....
An entity manufactures parts at its factory which it uses at a number of distribution centers....
An entity manufactures parts at its factory which it uses at a number of distribution centers. The following costs relate to the manufacture of the parts: 1. Fixed production overheads, apportioned on a reasonable basis 2. Costs of transporting the parts from the factory to the distribution centers 3. The costs of returning the transportation vehicles from the distribution centers to the factory 4.The ongoing costs of storing the parts at the distribution centers prior to their use. Which of...
The Jordan Company has two divisions and manufactures one type of watch. The two divisions are...
The Jordan Company has two divisions and manufactures one type of watch. The two divisions are the production Division and the Package & Delivery Division. The production Division manufactures watches and then sells them to the Package & Delivery Division, which packs the watches and sells them to retailers. The market price for the Package & Delivery Division to purchase this watch is £40. Production’s cost per watch are: £ Direct materials 6 Direct labour 7 Variable overhead 5 Division...
The Jordan Company has two divisions and manufactures one type of watch. The two divisions are...
The Jordan Company has two divisions and manufactures one type of watch. The two divisions are the production Division and the Package & Delivery Division. The production Division manufactures watches and then sells them to the Package & Delivery Division, which packs the watches and sells them to retailers. The market price for the Package & Delivery Division to purchase this watch is £40. Production’s cost per watch are: £ Direct materials 5 Direct labour 7 Variable overhead 5 Division...
Liverpool Company has two divisions and manufactures one type of watch.. The two divisions are the...
Liverpool Company has two divisions and manufactures one type of watch.. The two divisions are the production Division and the Package & Delivery Division. The production Division manufactures watches and then sells them to the Package & Delivery Division, which packs the watches and sells them to retailers. The market price for the Package & Delivery Division to purchase this watch is £40. Production’s cost per watch are: £ Direct materials 6 Direct labour 7 Variable overhead 5 Division fixed...
McKinsey Machines Ltd manufactures a single product A.   It has two cost centers namely molding department...
McKinsey Machines Ltd manufactures a single product A.   It has two cost centers namely molding department and painting department. Information Molding Department Painting Department Total Manufacturing overheads $ 1,806,000 $ 2,205,000 Total Machine hours (estimated) 210,000 Total Direct Labour Cost $ 1,260,000 McKinsey Ltd executes job no. 410.   The cost and output details of Job No.410 are given below: Information Molding Department Painting Department Direct Materials $ 1,410 $ 996 Direct Labour $ 870 $ 2,040 Number of machine hours...
A manufacturer of automotive gaskets has two plants, A and B. Plant A manufactures 65 %...
A manufacturer of automotive gaskets has two plants, A and B. Plant A manufactures 65 % of the gaskets and plant B manufactures 35 %. Because of a batch of faulty material from a company supplying both plants, 3% of the gaskets are of sub-standard quality from plant A and 5% are sub-standard from plant B. Despite your internal quality control procedures, you still had a sub-standard gasket returned from one of your customers. What is the probability it came...
Miller Toy Company manufactures a plastic swimming pool at its Westwood Plant. The plant has been...
Miller Toy Company manufactures a plastic swimming pool at its Westwood Plant. The plant has been experiencing problems as shown by its June contribution format income statement below: Flexible Budget Actual Sales (3,000 pools) $ 179,000 $ 179,000 Variable expenses: Variable cost of goods sold* 33,390 44,540 Variable selling expenses 11,000 11,000 Total variable expenses 44,390 55,540 Contribution margin 134,610 123,460 Fixed expenses: Manufacturing overhead 50,000 50,000 Selling and administrative 75,000 75,000 Total fixed expenses 125,000 125,000 Net operating income...
Miller Toy Company manufactures a plastic swimming pool at its Westwood Plant. The plant has been...
Miller Toy Company manufactures a plastic swimming pool at its Westwood Plant. The plant has been experiencing problems as shown by its June contribution format income statement below: Flexible Budget Actual Sales (6,000 pools) $ 265,000 $ 265,000 Variable expenses: Variable cost of goods sold* 95,580 112,700 Variable selling expenses 14,000 14,000 Total variable expenses 109,580 126,700 Contribution margin 155,420 138,300 Fixed expenses: Manufacturing overhead 63,000 63,000 Selling and administrative 78,000 78,000 Total fixed expenses 141,000 141,000 Net operating income...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT