Q 6. A production line is to run at 1200 units per month. Salesare forecast as shown in the following table. Calculate theexpected period-end inventory. The opening inventory is700 units. All periods have the same number of workingdays.WeekForecast Demand3|5 6124800 850 600 550 600 700Planned Production 1200 1200|1200 1200 1200|1200PlannedInventory700

Inventory primarily describes the assets like raw materials, work-in-process of products,…

Answered: Q 6. A production line is to run at…

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

14. Financial aspects apparently manages the proficient assignment of scant products. Where does shortage fit in the round stream model?
ssume you are the manager of a shop that assembles power tools. You have just received an order for 50 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws follows: 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 for all items. (Leave no cells blank - be certain to enter "0" wherever required.)
1
QUESTION THREE (a) The actual demand of a product for 6 months are summarized in Table below: Actual Demand Values Month ( ) t Demand ( ) tD 1 300 2 450 3 700 4 900 5 1200 6 1400 i. Find three months weighted moving averages by assuming the weights 1 0.15 W = , 2 0.36W = and 3 0.49 W = . ii. Compute the mean forecast errors. iii. Compute the mean square error
Name the 4P’s?
Jody of Jody’s Custom Tailoring is considering expandingher growing business. Th e question is whether to expand with abigger facility than she needs or with a small facility, knowing thatshe will have to reconsider expanding in three years.Jody has estimated the following chances for demand:• Th e likelihood of demand being high is 0.50.• Th e likelihood of demand being low is 0.50. She has also estimated profi ts for each alternative:• Large expansion has an estimated profi tability of either$200,000 or $100,000, depending on whether demand turnsout to be high or low.• Small expansion has a profi tability of $80,000, assuming thatdemand is low.• Small expansion with an occurrence of high demand wouldrequire considering whether to expand further. If thebusiness expands at that point, the profi tability is expectedto be $120,000. If it does not expand further, the profi tabilityis expected to be $70,000.Draw a decision tree and solve it. What should Jody’s CustomTailoring do?
Graphical Method
Q7.An example of a leading performance measure is: a. Number of new customers b. Production cycle time
Problem 2: Week Forecast Customer Orders Projected On-Hand Inventory MPS Available-to-Promise On-hand Inventory schedule production whenever projected on-hand inventory drops below MPS lot size Complete the master production schedule based on the following information 160 160 30 300 1 120 110 2 100 100 3 130 75 4 110 50 5 140 32 6 140 11 7 170 5 8 180 0
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. Week On hand 30 30 30 1 2 3 4 5 6 7 8 40 40 40 45 45 13 8 4 Item: P24 Forecast Orders Projected available balance 20 Available-to-promise MPS 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. Amount 40 Order Desired Week 1 4 2 6 3 30 2 4 25 3 30 4882 7623
Q7. The president of Rose Bowl Enterprises, Desmond Howard, projects the firms aggregate DEMAND requirements over the next 8 months as follows: These are the monthly DEMAND, not production. MONTH JAN FEB MAR APR MAY JUN JULY AUG DEMAND 1,400 1,600 1,800 1,800 2,200 2,200 1,800 1,800 PRODUCTION 1,600 from December INVENTORY 200 from Dec plus 200 His operations manager is considering a new plan, which begins in January with 200 units on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle time costs. The plan is called plan A. Plan A: Vary the workforce level to execute a strategy that produces the quantity demanded in the prior month. The December demand was given as 1,600 units per month. Therefore, the production for JAN will be 1,600. However, only 1,400 are needed. Therefore, the extra 200 produced go into inventory and there is a holding cost for inventory. Also, per the above, you already have 200 units in inventory…
4 (Using the same problem) A vendor for the local ballpark food stand is questioning whether to stock his concession with a large or small inventory. He believes that it will depend upon the size of the crowd. He has developed a payoff matrix for the various alternatives (stocking decision) and states of nature (size of crowd). What is the Expected Monetary Value (EMV)? Alternatives Large Inventory Small Inventory Probability A) $68,400 O B)-$20,000 O C) $10,000 O D) $51,500 O E) $78,400 Large Crowd $220,000 $90,000 .20 PROFIT ($) Average Crowd $50,000 $70,000 .50 Small Crowd -$2,000 -$5,000 30

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