Question 4.EXERCISE OF MRP:BILL OF MATERIALS: X= 5 A +7B+ 3 CY = 6 A+ 12 B + 8CX, Y: Finished Goods.A, B, C: Raw Materials.DEMAND:DAYS: 1236 7845X2525252423242322Y3030303232343535STOCK INFORMATION:SIZE INITIAL STOCK1 UN1 UNTransportation StockDay 1: 12, Day 4:6PRODUCTL.T.1 Day1 Day20Y15Day 1: 8, Day 5: 6Fill the MRP Tables for Products X and Y and compute the Needs for A, Band C.PRODUCT: XINITIALDAYSSTOCK1234578GROSS DEMANDIN STOCKRECEIVEDFINAL STOCKNET DEMANDPRODUCTIONPRODUCTION ORDERSPRODUCT: YINITIALDAYSSTOCK1234578GROSS DEMANDIN STOCKRECEIVEDFINAL STOCKNET DEMANDPRODUCTIONPRODUCTION ORDERS

Working note: lot size is assumed to be L4L since nothing has been specified. Final stock =…

Answered: BILL OF MATERIALS: X= 5 A+7B+30 Y = 6…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Question 8 The following Level 0 MRP information is given for a personal computing system. Monitors for these computing systems are a Level 1 item and each computer receives only one monitor. Using a lead time of one week, what are the Level 1 Gross Requirements for Monitors? Assume any inventory on hand will be used as soon a possible. Group of answer choices a. 1100 in week 3, 600 in week 4, 300 in week 5 b. 1100 in week 2, 600 in week 3, 300 in week 4 c. 500 in week 1, 600 in week 2, 200 in week 3 d. 500 in week 2, 600 in week 3, 200 in week 4 e. Impossible to determine from this information
Q3 The numbers for March are correct. Cost table: LayoffHiringInventory Totals: 36 36 55,209 Costs: $54,000 $162,000 $165,627 Cost of plan:$381,627 Planning values Starting inventory: 3,000 Starting and ending workforce: 214 Hours worked per month per hour: 240 Hours per unit: 30 Hiring cost per worker: $4,500 Layoff cost per worker: $1,500 Monthly per-unit holding cost: $3 Forecasted sales: Month Forecasted salesMarch 1,649April 1,427May 1,137June 976July 1,531August 1,976September 2,470October 2,529November 3,016December 2,910January 2,434February 1,945
QUESTION TWO Musa's Cashmere Sweaters has authorized the following MPS for her exclusive line of cashmere sweaters. She wants to use the MPS record for promising future orders. Current order promises are included. The MPS order quantity is 60 units. Beginning Inventory is 0. Complete the following MPS record. Period 1 2 3 4 5 6 7 8 9 10 11 12 Forecast 15 15 15 15 20 20 20 20 25 25 25 25 Customer orders 12 10 8 25 40 0 15 30 30 0 0 40 Projected available Available-to-promise MPS 60
Q4 Costs: LayoffHiringInventory Totals: 246 246 30,000 Costs: $246,000 $492,000 $30,000 Cost of plan:$768,000 Planning values Starting inventory: 2,500 Starting and ending workforce: 200 Hours worked per month per hour: 360 Hours per unit: 40 Hiring cost per worker: $2,000 Layoff cost per worker: $1,000 Monthly per-unit holding cost: $1 Forecasted sales:Month Forecasted salesMarch 1,827April 1,620May 1,440June 1,179July 1,611August 2,115September 2,637October 2,502November 3,150December 3,231January 2,826February 2,331
QUESTION 1 AJ Fabrication has the following aggregate demand requirements and other data for the upcoming four quarters. Quarter Demand 1 1300 2 1400 3 1500 4 1300 Previous quarter's output = 1,500units Beginning inventory = 200units Stockout costs = $50 per unit Inventory holding cost = $10 per unit at end of quarter Hiring workers = $4 per unit Firing workers = $8 per unit Unit cost = $30 per unit Overtime = $10 extra per unit a) Which of the following production plans is better: Plan A - chase demand by hiring and firing: or plan B - product at a constant rate of 1200 and obtain remainder from overtime? b) Explain the differences between repair and preventive maintenance? c) Explain the implications of each approach when developing an asset maintenance strategy? d) Explain the benfits and challenges associated with the implementation of an MRP system?
Question: For the Cutting Labor per item constraint, how much additional profit can be made by adding 10 hours of Cutting Labor per item resource available?
Question:Compare and contrast MRP, MRP-II and ERP systems?
2 ERP articles review.
Practice Question 1 BackgroundKC Mechanic Shop was established by Mr. John, a seasoned mechanic who has over 20 years ofexperience in the automotive repair industry. Sales figures for the last ten months are as follows:-Months Actual Sales1 30,0002 39,0003 42,0004 50,0005 55,0006 61,0007 70,0008 77,0009 81,50010 90,000Spare Parts Use a three-period and a four-period weighted moving average to forecast salesfor the 12th month. (Use weights of 1,2,3 and 1,2,3 4). From the data provided in the case, use MAD to determine which forecastingtechnique is more accurate. If forecast for month 7 is $72,000, with an alpha of 0.4, use exponentialsmoothing to forecast sales for months 8 and 9.
Required information Skip to question George Caloz & Frères, located in Grenchen, Switzerland, makes luxury custom watches in small lots. One of the company’s products, a platinum diving watch, goes through an etching process. The company has recorded etching costs as follows over the last six weeks: Week Units Total Etching Cost 1 9 $ 21 2 12 25 3 13 30 4 9 20 5 11 25 6 18 34 72 $ 155 For planning purposes, management would like to know the variable etching cost per unit and the total fixed etching cost per week. 2-a. Using the least-squares regression method, estimate the variable etching cost per unit and the total fixed etching cost per week. 2-b. Express these estimates in the form Y = a + bX.
Question 4 ) Case mix funding (e.g., using "diagnostic related groups" or "resource intensity weights") is designed to counter supplier induced demand True False
QUESTION THREEa) Zambia Breweries has a backlog of 250 crates of Fanta drinks at the end of December. The demand of Fanta drinks is expected to be 400 crates in January, 500 crates in February and 550 crates in March. Each worker can produce 50 crates of drinks per month with regular wage costing the company K10 000 per worker per month. Hiring cost has been calculated to be K25 000 per. Hiring cost has also been calculated to be K50 000 per worker. Backlog cost have been determined to cost the company K250 per worker. There are no cost associated with carrying the inventory. Develop a level of production plan (aggregate plan) and determine the cost. b) Explain why aggregate planning is necessary in production and operation management.c) Define the meaning and what happens at each of these aggregate capacity planning;i) Matching Demand approachii) Level Capacity approach.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

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

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS