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.WeekOnhand30 30 301 2 3 4 5 6 7 840 40 40 45 451384Item: P24ForecastOrdersProjected availablebalance20Available-to-promiseMPSa. 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.Amount40OrderDesired Week1426330242533048827623

To complete the MPS time-phased record for product P24 and determine if Murphy Motors can accept the…

Answered: 3. The MPS planner at Murphy Motors…

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

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.
12. Determine the planned purchases for January (a) at retail and (b) at cost for the lingerie department when the seasonal merchandise plan indicates the following planned figures: Round to the nearest dollar. Sales $88,000 Markdowns 8% BOM Stock $81,000 EOM Stock $66,000 Markup 49%
Product A Order Qty = 400 Order Lead Time = 2 Forecast Demand Scheduled Receipts Projected Available Inventory 400 Planned Order Receipts Planned Order Releases 1 300 OD 4, 6, 2 300 400 Sketch and fill in the grid on scrap paper to use on upcoming questions In what periods would you incur a planned order release? OA 1.3, and 4 2.4, and 5 OC 3,5, and 6 and 7 3 300 PERIODS 4 300 5 300 6 300 7 100 8 100
The table above provides the aggregate plan of production by a firm. It is known that the firm uses a level plan with backorders. Given this information, what is the number in the cell with the question mark?
Exercise 1: You are the operations manager at the company Servicios de Salud, Inc., which provides care services to the elderly. An important aspect of your job is ensuring that nursing homes have a healthy inventory of nutritional drinks for residents. Below is the historical demand for the product for one year: Month Historical demand (boxes) Forecasted demand (boxes) January 300 February 340 March 370 April 410 ¿? May 470 ¿? June 570 ¿? July 630 ¿? August 720 ¿? September 640 ¿? October 460 ¿? November 420 ¿? December 390 ¿? a. Calculate the average demand for each period from April to December using the 3-month simple moving average. Presents calculations and findings in a clear and organized manner. b. Discuss any trends or patterns observed in the calculated moving average demand values. c. Make an interpretation of the results and their implications for forecasting…
2. Discover ambiguities or omissions in the following statement of requirements for part ofa ticket-issuing system:An automated ticket-issuing system sells rail tickets. Users select their destination andinput a credit card and a personal identification number. The rail ticket is issued and themcredit card account charged. When the user presses the start button, a menu display ofpotential destinations are activated, along with a message to the user to select a destination.Once a destination has been selected, users are requested to input their credit card. Itsvalidity is checked and the user is then requested to input a personal identifier. When thecredit transaction has been validated; the ticket is issued.
Discuss the concept of demand variability and how it impacts the effectiveness of the Wilson approach. What strategies can be employed to mitigate the effects of demand variability in this approach?
Sheet 9: Q8 Planning model Q8. Use below table to to find the profit of the company, (production plan is 3000) Y slope 2500 2000 5500 65000 7500 95000 Unit price 15.5 Units 3000 Fixed cost 19000 Y(pkp) X(pkp) alope Var cot sotal cost Sale
Costs Previous quarter's output Beginning inventory Stockout cost for backorders Inventory holding cost 1,500 units O units $50 per unit $10 per unit for every unit held at the end of the quarter $40 per unit $80 per unit $30 per unit $15 extra per unit Not available Hiring workers Layoff workers Unit cost Overtime Subcontracting a) Use Chase Demand Strategy b) Use Level Production Strategy with Backordering
7. Nowjuice, Inc., produces Shakewell fruit juice. A planner has developed an aggregate forecast for demand (in cases) for the next six months. Month May Jun Jul Forecast 4,000 4,800 5,600 Aug Sep 7,200 Oct 6,400 5,000 Use the following information to develop aggregate plans. Regular production cost Regular production capacity Overtime production cost Subcontracting cost Holding cost Beginning inventory $10 per case 5,000 cases $16 per case $20 per case $1 per case per month 0 Develop an aggregate plan using each of the following guidelines and compute the total cost for each plan. Which plan has the lowest total cost? a. Use level production. Supplement using overtime as needed. b. Use a combination of overtime (500 cases per period maximum), inventory, and subcontracting (500 cases per period maximum) to handle variations in demand. c. Use overtime up to 750 cases per period and inventory to handle variations in demand.
CVP Analysis with Income Taxes Cohen Company produces and sells socks. Variable cost is$6 per pair, and fixed costs for the year total $75,000. The selling price is $10 per pair.Required Calculate the following:1. The breakeven point in units.2. The breakeven point in sales dollars.3. The units required to make a before-tax profit of $40,000.4. The sales dollars required to make a before-tax profit of $35,000.5. The sales, in units and in dollars, required to make an after-tax profit of $25,000 given a tax rate of 30%.
6

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