PROBLEM-2 XYZ Company manufactures a number of products. One important product is Q, which consists of two internally manufactured items Rand S as in the figure below: R (1 Piece) ITEM Q R S Item Q is assembled in an assembly station, A 10; Item R is in work center WC 30, and item S is manufactured in work center WC 70. Operation data for product Q and items R and S are shown in the table: ITEM Q Week Gross Requirements Lot size Lot for lot 50 150 Q Work Center 1 2 40 80 A 10 WC 30 WC 70 3 40 S (3 Pieces) 4 30 Setup time (Hrs) 0 3.0 2.0 5 40 6 30 Runtime per piece Lead Time (weeks) (Hrs) 1.7 1.0 1.0 1 1 1 Determine "capacity requirements planning" stated for product Q in the work centers A 10, WC 30, and V 70 for the next weeks on the basis of material requirements planning carried out.

PROBLEM-2 XYZ Company manufactures a number of products. One important product is Q, which consists of two internally manufactured items Rand S as in the figure below: R (1 Piece) ITEM Q R S Item Q is assembled in an assembly station, A 10; Item R is in work center WC 30, and item S is manufactured in work center WC 70. Operation data for product Q and items R and S are shown in the table: ITEM Q Week Gross Requirements Lot size Lot for lot 50 150 Q Work Center 1 2 40 80 A 10 WC 30 WC 70 3 40 S (3 Pieces) 4 30 Setup time (Hrs) 0 3.0 2.0 5 40 6 30 Runtime per piece Lead Time (weeks) (Hrs) 1.7 1.0 1.0 1 1 1 Determine "capacity requirements planning" stated for product Q in the work centers A 10, WC 30, and V 70 for the next weeks on the basis of material requirements planning carried out.

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

ChapterC: Cases

Section: Chapter Questions

Problem 5.1SC: Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing...

See similar textbooks

Similar questions

Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
Problem 11-11 (Algo) Famous Albert prldes himself on being the Cookle King of the West. Small, freshly baked cookles are the specialty of his shop. Famous Albert has asked for help to determine the number of cookles he should make each day. From an analysis of past demand, he estimates demand for cookles as VROBARTLITY OF DENAND 0.04 DEEAND 1,800 dosen 2,000 2,200 0.10 0.20 2,400 2,600 2,000 3,000 0.26 0.15 0.03 0.14 ces Each dozen sells for $0.65 and costs $0.49, which includes handling and transportation. Cookles that are not sold at the end of the day are reduced to $0.30 and sold the following day as day-old merchandise. a. Compute the expected profit or loss for each cookie making decislon quantity. (Round your answer to the nearest whole number. Enter expected losses with a negative sign.) Cookles Baked (Dozen) Probability of Demand Expected Profit/Loss 1,800 0.04 2,000 0.10 2,200 0.28 2,400 0.26 2,600 0.15
Q4) A manufacturer provides specialized microchips. During the next 3 months its sales, costs, and available time are shown in the table. Month 1 Month 2 Month 3 There are no chips in stock at the beginning of the first month. It takes 1.5 hr of production time to produce a chip and costs $5 to store a chip from one month to the next. Determine a production schedule that meets the demand requirements, does not exceed the monthly production time limitations, and minimizes cost. Note that no chips should be in stock at the end of the 3 months. Use fmincon. Chips required Cost regular time ($/chip) Cost overtime ($/chip) Regular operation time (hr) Overtime (hr) 1000 100 110 2500 100 120 2200 120 130 2400 2400 720 2400 720 720
3. The MPS planner at Murphy Motors uses MPS time-phased records for planning end-item pro- duction. The planner is currently working on a schedule for the P24, one of Murphy's top-selling motors. The planner uses a production lot size of 70 and a safety stock of 5 for the P24 motor. Item: P24 Forecast Orders On hand Week 12345678 30 30 30 40 40 40 45 45 13 8 4 Projected available balance Available-to-promise MPS 20 a. Complete the MPS time-phased record for product P24. b. Can Murphy accept the following orders? Update the MPS time-phased record for accepted orders. Order 1234 4 Amount 40 30 30 25 Desired Week 4 6 2 3
K The demand for subassembly S is 130 units in week 7. Each unit of S requires 1 unit of T and 2 units of U. Each unit of T requires 2 units of V, 1 unit of W, and 1 unit of X. Finally, each unit of U requires 1 unit of Y and 3 units of Z. One firm manufactures all items. It takes 2 weeks to make S, 1 week to make T, 2 weeks to make U, 2 weeks to make V, 3 weeks to make W, 1 week to make X, 2 weeks to make Y, and 1 week to make Z. Click the icon to view the product structure and the time-phased product structure. Click the icon to view the on-hand inventory. Suppose that in addition to 130 units of S, there is also a demand for 20 units of U, which is a component of S. The 20 units of U are needed for maintenance purposes. These units are needed in week 6. Additionally, a new order has been received for 80 units of S due in week 8. Modify the net material requirements plan to reflect these changes. Construct a new net material requirements plan (enter your responses as whole numbers).…
Problem 21-9 (Algo) Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 131 units. The following is the BOM in indented form: ITEM X A B C DESCRIPTION Bracket assembly wall board Hanger subassembly D Hanger casting E Ceramic knob Rivet head screw F Metal tong G Plastic cap Item Inventory X 23 A 18 B5 Below is a table indicating current inventory levels: 55 USAGE 1 C 25 4 2 2 1 5 2 D 200 170 1,100 G 90
Table 1. Demand of Hairdryer from January to July [Jadual 1. Permintaan Pengering Rambut dari Januari 2021 hingga Julai 2021] Month Demand January February 2800 2870 March 2968 April Мay 3000 3100 Jun 3150 July 3400 a) Calculate forecast future demand for May, June, July and August by using 3 months simple moving average.[hitung ramalan permintaan masa depan untuk bulan Mei, Jun, Julai dan Ogos dengan menggunakan purata bergerak sederhana 3 bulan.] *
c. Compute and tabulate the daily demand for each month in the table below (round off to the nearest whole number). MONTH PRODUCTION DAYS DEMAND FORECAST DEMAND PER DAY JAN 2022 16 150 ? FEB 2022 16 150 ? MAR 2022 23 250 ? APR 2022 21 250 ? MAY 2022 22 400 ? JUN 2022 22 500 ? JUL 2022 21 600 ? AUG 2022 20 750 ? SEP 2022 20 450 ? OCT 2022 20 250 ? NOV 2022 16 150 ? DEC 2022 16 150 ? TOTAL ? ? d. Assuming that MPQ Limited had adopted a level strategy for the year ended 31 December 2022, compute the average daily demand for the year (round off to the nearest whole number). e. Prepare a graph showing the monthly forecasts and average daily forecast (in units per day) for MPQ Limited.
Shown below is a partially completed MPS record for hand drills. a. Develop the MPS record for the hand drills. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Item: Hand drills Quantity on Hand: 30 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity MPS start 1 15 20 N 40 25 3 15 15 Week Available-to- promise (ATP) inventory b. A distributor of the hand drills places an order for 15 units. What is the appropriate shipping date for the entire order? The order should ship on week (Enter your response as an integer.) 4 20 20 Order Policy: 60 units Lead Time: 1 week 5 55 0 6 35 0
4. In the past, Peter Kelle's tire dealership in Baton Rouge sold an average of 1,100 radials each year. In the past 2 years, 220 and 250, respectively were sold in fall, 360 and 300 in winter, 150 and 160 in spring, and 320 and 440 in summer. With a major expansion planned, Kelle projects sales next year to increase to 1,300 radials. Part 2 Based on next year's projected sales, the demand for each season is going to be (enter your responses as whole numbers): Season Demand Fall __________
Assume that you are the manager of a shop that assembles power tools. You have just received an order for 52 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws is Item Lead Time (weeks) On Hand Components Saw 2 15 A(2), B(1), C(4) A 1 10 E(3), D(1) B 2 5 D(2), F(3) C 2 65 E(2), D(2) D 1 20 E 1 10 F 2 30 Develop the material requirements plan for component E using lot-for-lot ordering. (Leave no cells blank - be certain to enter "0" wherever required.) Item: E(3) & E(2) LT = 1 wk. Beg. Inv. 1 2 3 4 5 6 7 8 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipt Planned order release