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-sellingmotors. The planner uses a production lot size of 70 and a safety stock of 5 for the P24 motor.Item: P24ForecastOrdersOnhandWeek1234567830 30 30 40 40 40 45 4513 84Projected availablebalanceAvailable-to-promiseMPS20a. 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.Order12344Amount40303025Desired Week4623

WeekItem P24On-hand12345678Forecast3030304040404545Orders1384Projected available balance20ATPMPS

Answered: The MPS planner at Murphy Motors uses…

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

Item4 Time Remaining 2 hours 53 minutes 2 seconds 02:53:02 eBookReferences Item 4 Time Remaining 2 hours 53 minutes 2 seconds 02:53:02 The production planner for a private label soft drink maker is planning the production of two soft drinks: root beer (R) and sassafras soda (S). There are at most 12 hours per day of production time and 1,500 gallons per day of carbonated water available. A case of root beer requires 2 minutes of time and 5 gallons of water to produce, while a case of sassafras soda requires 3 minutes of time and 5 gallons of water. Profits for the root beer are $6.00 per case, and profits for the sassafras soda are $4.00 per case. The firm’s goal is to maximize profits. What is the time constraint? rev: 09_21_2020_QC_CS-229783 Multiple Choice 5R + 5S ≤ 720. 3R + 5S ≤ 720. 2R + 5S ≤ 720. 3R + 2S ≤ 720. 2R + 3S ≤ 720.
Electro Fans has just received an order for one thousand 20˝ fans due in week 7. Each fan consists of a housing assembly, two grills and a fan assembly. The housing assembly consists of a frame, two supports and a handle. The following table gives lead times, on-hand inventory, and scheduled receipts. Table 1.1: Lead time and quantity on hand Item Lead Time Qty on hand Lot size# Scheduled receipt 20˝ Fan Housing Frame Supports (2) Handle Grills (2) Fan Assembly 1 1 2 1 1 2 3 80 90 - 50 400 200* 150 - - - 100 400 450 - 50 fan assembly in week 2 * In week 3 it was found that 50% of the on hand inventory of the grills was damaged. # Items without any lot size given should be considered as lot-for-lot. (i) Construct a product structure. (ii) Construct a time-phased product structure. (iii) Prepare a net requirement plan.
1. RBF, an emerging singer, is getting ready to cut his first album. The cost of recordingthe CD is Php 500,000 but copies are Php 500 apiece. If the album can be sold forPhp1,500 each, (a) how many CDs must be sold to break even? (b)What is thebreakeven point in dollars?RBF is confident that demand for his album will substantially exceed the break-evenpoint computed above. So, Mikey is contemplating having his album at a classier (andpricier) studio. The cost to record the CD would rise to Php 90,000. However, since thisnew studio works with very high volume, production costs would fall to Php 200 per CD.(c) What is the breakeven point for this new process?(d) Compare this process to the process proposed in the pre SHOW COMPLETE SOLUTION.
Problem 21-9 (Algo) Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 137 units. The following is the BoM in indented form: ITEM DESCRIPTION USAGE X Bracket assembly 1 A Wall board 5 B Hanger subassembly 2 D Hanger casting 2 E Ceramic knob 1 C Rivet head screw 4 F Metal tong 3 G Plastic cap 1 Below is a table indicating current inventory levels: Item X A B C D E F G Inventory 30 20 73 22 200 149 1,000 90 b. What are the net requirements of each item in the MPS? (Leave no cells blank - be certain to enter "0" wherever required.)
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
A single inventory item is ordered from an outside supplier. The anticipateddemand for this item over the next 12 months is 6, 12, 4, 8, 15, 25, 20, 5, 10, 20, 5,12. Current inventory of this item is 4, and ending inventory should be 8. Assume aholding cost of $1 per period and a setup cost of $40. Determine the order policyfor this item based onc. Part period balancing
Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 125 units. The following is the BOM in indented form: ITEM DESCRIPTION USAGE X Bracket assembly 1 A Wall board 4 B Hanger subassembly 2 D Hanger casting 4 E Ceramic knob 1 C Rivet head screw 3 F Metal tong 4 G Plastic cap 2 Below is a table indicating current inventory levels: Item X A B C D E F G Inventory 22 15 75 24 202 139 1,000 95 What are the Net Requirements for X, A, B, and C respectively?
Market Company’s policy is to have 30% of the next month's sales on hand at the end of the current month. Projected sales for August, September, and October are 26,000 units, 21,000 units, and 31,000 units, respectively. How many units must be purchased in September?
Rebalance Rebalance (RB) is a New England sneaker manufacturer that plans to release a high per-formance running shoe { the Rebalance Air (RBA) sneaker { in the US. RB divides the US into four major zones, each of which has come back with an estimate of demand. The planning team at RB needs to use this and other information to decide on a manufacturing quantity for the RBA sneaker in Fall 22 (the first season that will see the introduction of the RBA). 1. The RBA is manufactured in Mainland China and costs RB $60 per pair to manufacture. The sneaker retails for $220. So as to protect this nascent new design,RB will not put the sneaker on clearance (if at all needed) until Summer 23 at which point it expects to only recover $52 per sneaker. What service level should RB choose to manufacture to? 2. The East, West, Central and South teams each expect demand of 80,000 units. The demand planning teams in each of these regions are only somewhat accurate so you can expect the coefficient of…
A initially assume that Phi wants to minimize his inventory requirements. Assume that each order will be only for what is required for a single period. Calculate the net requirements and planned order releases for the gear boxes and input shafts. Assume that lot sizing is done using a lot-for-lot (L4L). Gear box requirements Week 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipt Planned order release Input shaft requirements Week 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipt Planned order release
The table below provides demand data for 6 weeks (weeks 31-36 for the current year) for one product. Inventory is managed with a periodic review system where T = 5 weeks and M = 280. The previous order was for 120 units at the end of week 28. The lead time is a constant 4 weeks. At the beginning of week 31 the inventory level is 130 units. Orders are made at the end of a week. 1. When is the next order? end of week __________ 2. How large is the next order? ___________ Week Demand Inventory 31 30 32 40 33 45 34 30 35 30 36 30
21. Given the forecast and booked orders shown in the table below, and a beginning inventory of 45, what is the master production schedule quantity for period 4 if you want to end period 4 with 0 inventory? Period 1 2 3 4 Forecasted Demand 70 65 60 55 Booked Orders 80 60 30 50 Projected ending inventory Master production schedule 70 60 65 Available to Promise 0 Group of answer choices 35 30 20 25

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