Order policy = 80 unitsLead time = 2 weeks Quantity on Hand 60 1Forecast5060Customer orders (booked)Projected on HandMPS quantityMPS startAvailable-to-promiseWhat is the projected on-hand inventory in week 5?Select one:O a. 50O b. 35O c. 0O d. 40O e. 7524020Week4453401551064012 5735835

Find the Given details below: Weeks 1 2 3 4 5 6 7 8 Forecast 50 40 40 40 40 40 35 35 Customer…

Answered: Quantity on Hand 60 1 Forecast 50…

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

The units of Manganese Plus available for sale during the year were as follows: Mar. 1 June 16 Nov. 28 Inventory Purchase Purchase 23 units @ $29 32 units @ $30 42 units @ $36 97 units $667 960 1,512 $3,139 There are 14 units of the product in the physical inventory at November 30. The periodic inventory system is used. a. Determine the inventory cost by the FIFO method. $ b. Determine the inventory cost by the LIFO method. $ c. Determine the inventory cost by the weighted average cost methods. Round intermediate calculations and final answer to two decimal places.
Q3: FIND INITIAL FEASIRLE SOLUTION COST FOR GIVEN PROBLEM by using A north-west oomer rule Bleast cost method e-Vogels approvimation method D1 D2 D3 D4 SUPPLE P1 2. 11 P2 1. 1. Pa 8. 15 6. 10 Demand 2. A* JIS O 11600 O 11300 O 11200 O 11000
JAN FEB MAR APR MAY BEGINNING INV PERIOD JUN TOTAL BEGINNING WORKERS AVGE. MONTHLY OUTPUT PER WORKER INV. HOLDING COSTS COST/CATEGORY TOTAL COST PER CATEGORY 5,000 8 4,000 0.3 DEMAND 24,000.00 32,000.00 32,000.00 48,000.00 60,000.00 44,000.00 240,000.00 UNITS WORKERS UNITS/WORKER PER CASE/MONTH REG. PROD 0.00 $0.80 CHASE- HIRE/FIRE HIRING COST SUBCONTRACTING FIRING/LAYOFF $1.15 COST COST OVERTIME/ SUBCONTRACT ENDING INV. $1,000 $1.15 $1,500 0.00 $0.30 PER WORKER PER CASE PER WORKER WORKERS HIRE FIRE 0.00 $1,000.00 COST OF PLAN= 0.00 $1,500.00 $
QUESTION 20 What are purchased items or extracted materials that will be transformed into components or products called? A. finished goods inventory B. MRO inventory C. raw materials inventory D. distribution inventory E. work-in-process inventory QUESTION 21 Which inventory function exists between the manufacturing plant and the distribution plant? OA. transportation inventory OB. lot-size inventory C. anticipation inventory D. fluctuation inventory E. speculative inventory QUESTION 22 In inventory management, when discussing customer service we mean: OA. whether repair of the product is available. B. whether the product is available regardless if the customer desires it or not. OC. whether the product is available when the customer wants it. OD. whether the customer wants the available product. OE. whether the customer is available when the product is.
Q1. Discuss different type of inventory control techniques used in operations Management with example.
Beginning inventory and purchases Units Unit Cost Total Cost Jan 1 60 $7 $420 April 1 45 $10 $450 July 1 70 $8 $560 September 1 40 $6.50 $260 If ending inventory is 105 units, what is the weighted average of each unit in inventory?
14 Uncommitted inventory that is physically on-hand is called ______. a ready-to-buy b ready-to-sell c made-to-stock d available-to-promise 15 Which system calculates materials, subassemblies, and components required for end item production? a production planner b master production schedule c capacity requirements planning d materials requirements planning 16 What is the process that identifies which parent item has generated requirements for a component called? a where-used analysis b splitting c pegging d netting
PP.52 A manufacturer of solid state drives (SSDs) has projected the next six months of demand to be as shown the table below: Supply/Demand Info Feb 60,800 Mar Apr May Jun 57,200 45,600 46,000 56,200 Forecast (demand) Regular production Overtime production Subcontract production Ending inventory Hired employees Fired employees Total employees Cost variables are as follows: Cost Variables Labor cost hour Overtime cost/unit Subcontracting costunit Holding cost/unit/month Hiring cost employee Firing cost employee Beginning Jan 48,600 7.200 180 $15 $38 $32 $8 $2,900 $5.300 Here is some additional relevant (capacity) information: Capacity Information Total labor hours/SSD Regular production units/employee/month Max regular production/month Max overtime production/month Max subcontractor production/month 3 200 55,200 3.000 5.200 Assuming the company uses regular production first, then ONLY overtime and/or subcontract production, answer the following questions: What is the regular production…
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
1. Describe the various functions of purchase orders. Describes the steps to register a purchase order in the Sage 50 (Peachtree) program.
Costs Holding cost $8/ refrigerator/ month Subcontracting $80/ refrigerator Regular-time labor $12/ hour Overtime labor $18/ hour for hours above 8 hours/ worker/ day Hiring cost $40/ refrigerator Layoff cost $80/ refrigerator Stockout cost none Other Data Current workforce (December) 8 people Labor hours/ refrigerator 4 hours Workdays/ month 20 days Beginning inventory 250 refrigerators Units demanded in December 320 refrigerators Month Demand Forecast January 400 February 500 March 550 April 700 May 800 June 700
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

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

Quantity on Hand 60 1 Forecast 50 Customer orders (booked) 60 Projected on Hand MPS quantity MPS start Available-to-promise What is the projected on-hand inventory in week 5? Select one: O a 50 O b. 35 О с. 0 O d. 40 Oe. 75 s 2 40 20 Week 4 40 45 3 40 5 7 35 6 12 5 8 35