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

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?
Figure shows a partially completed MPS record for 2 inch pneumatic control valves. Suppose that you receive the following orders at right for the valves (shown in the order of their arrival). As they arrive, you must decide whether to accept or reject them. Which orders would you accept for shipment?Order Amount (Units) Week Requested1 15 22 30 53 25 34 75 7
. Worldwide Can-Openers, Inc., makes a family of two hand-operated can openers. The production plan is based on months. There are 4 weeks in this month. Opening inventory is 2000 dozen, and it is planned to increase that to 4000 dozen by the end of the month. The MPS is made using weekly periods. The forecast and projected available balance for the two models follow. The lot size for both models is 1000 dozen. Calculate the production plan and the MPS for each item.
Determine whether the following statements are true or false. Statement T or F 1. Raw material is the material purchased but not processed 2. MRP stands for MATERIAL REQUIREMENT PLANNING. 3. EOQ stands for Environmental Outsourcing Quality 4. For calculating EOQ Model Quantity discounts are not possible 5. A safety stock means that the stock is fully free of danger for people. 6. MRP is usually a computer software.
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.
6) Nicole has decided to go to school which costs her a total of P19,500 and give upi on a job that paid her P24,900 for the year. But instead, she can hope to earn P29,900 after she graduates. Nicole's opportunity cost amount to?a. P19,500 b. P24,900c. P29,900d. P5,000 7. Villanueva Enterprises reported the ff. information. What is the cost of goods manufactured in February?I. Jan. 2017 -job accumulated cost of P3,000ii. Feb. 2017 -the following costs were added to production: Job 1-P10,000 Job 2-P8,000Job 3-P7,000 III. Feb. 2017 Job 1 was completed and sold for P18,000 Job 2 was completed but not sold Job 3 remains in production b. P8,000c. P10,000 d. P13,000e. P21,000 8. Julie borrowed a certain amount from Diane on June 2016. Two years later, Julle i again borrowed P5,000. Julie decided to pay P1,000 on June 2019 and dischargei her balance by paying P7,500 on June 2021. What was the amount borrowed oni June 2016 if the interest rate is 8% compounded annually?a. P1,389.50 b.…
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?
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%.
Article: Planning for Holiday Shipping at FedEx FedEx started as Federal Express in 1971 and made its first delivery in 1973 with 14 aircrafts and 389 employees, successfully delivering 186 packages.50 The company was founded by Frederick W. Smith who first presented his idea for the shipping company in a term paper for a business class at Yale University in 1964. Smith did not do well on the paper as his professor did not see the need for overnight package deliveries. But more than 45 years later, Smith has clearly proved his professor wrong. FedEx now employs more than 325,000 employees and uses its 652 aircraft and more than 100,000 trucks to ship on average 10.5 million packages a day in over 220 countries. Managing such a large enterprise with so much complexity clearly requires effective planning. Similar to other shipping companies, FedEx engages in significant planning to prepare for Christmastime deliveries, the company’s peak season. FedEx typically meets with major…
BJ is the manager of a Grocery Store. She now needs to replenish her supply of strawberries. Her regular supplier can provide as many cases as she wants. However, because these strawberries already are very ripe, she will need to sell them tomorrow. BJ estimates that she will be able to sell 10, 11, 12, or 13 cases tomorrow. She can purchase the strawberries for $3 per case and sell them for $8 per case. However, any unsold case tomorrow will be sold to nearby Cafeterias at a flat price of $2 per case. BJ now needs to decide how many cases to purchase today to be offered for sale tomorrow. BJ has checked the store's records on daily sales of strawberries. On this basis, she estimates that the prior probabilities are 0.2, 0.4, 0.3, and 0.1 for being able to sell 10, 11, 12, and 13 cases of strawberries tomorrow. (a) Develop a decision analysis structured model of this problem using Excel formulas by identifying the decision alternatives, the states of nature, and the payoff table. (b)…
One of the products of Edwards Lifesciences (EL) is artificial heart valves made from the heart valves of pigs.8 Different sizes of valves are required. However, the size of a pig's heart valve cannot be ascertained before the heart is purchased and opened. Therefore, EL has a mismatch problem: shortages of some sizes and excess of others. A program was established to document the size distribution of valves supplied by each supplier, and purchases were made from those suppliers with the needed sizes. Linear programming was used to determine the set of the suppliers that collectively satisfied EL's demand. Suppose EL purchases pig valves from three suppliers. The cost and size mix of the valves purchased from each supplier are given in the table below. Each month EL places one order with each supplier. Suppose next month, 250 large, 300 medium, and 100 small valves are needed. Formulate an LP that can be used to minimize the cost of acquiring the needed valves and use Excel's Solver to…
As the production planner for Xiangling Hu Products, Inc., you have been given a bill of material for a bracket that is made up of a base, 2 springs, and 4 clamps. The base is assembled from 2 clamps and 1 housing. Each clamp has 1handle and 1 casting. Each housing has 2 bearings and 2 shafts. There is no inventory on hand. c) Compute the net quantities needed if there are 25 of the base and 100 of the clamp in stock. Base: units (enter your response as a whole number). Spring: units Clamp: units Housing: units Handle units Casting: units Bearing: units Shaft: units

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