Problem 2:WeekForecastCustomer OrdersProjected On-Hand InventoryMPSAvailable-to-PromiseOn-hand Inventoryschedule productionwhenever projected on-handinventory drops belowMPS lot sizeComplete the master production schedule based on thefollowing information16016030300112011021001003130754110505140326140117170581800

The master production schedule is a detailed plan that describes the number of goods that should be…

Answered: Problem 2: Week Forecast Customer…

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.
3.. Calculate the Economic Order Quantities (EOQs) for the A items.
The following is the summary of the receipts and issues of material in a Special Ice factory during December 2020. Prepare Store Ledger according to First in First Out Method. December 2020 Dec 1. Opening balance 500 units @ GH¢25 per unit Dec 3. Issue 70 units Dec 4. Issue 100 units Dec 8. Issue 80 units Dec 13. Received from supplier 200 units @ GH¢24.50 per unit Dec 14. Returned to store 15 units @ GH¢24 per unit Dec 16. Issue 180 units. Dec 20. Received from supplier 240 units @ GH¢24.75 per unit Dec 24. Issue 304 units. Dec 25. Received from supplier 320 units @ GH¢24.50 per unit Dec 26. Issue 112 units Dec 27. Returned to store 12 units @ GH¢24.50 per unit Dec 28. Received from supplier 100 units @ GH¢25 per unit b. Two components P, Q are used as follows. Normal usage 1000 units per week each. Re-ordering quantity P - 20,000 units Q - 8,000 units Re-ordering period P - 4 to 6 weeks Q…
Warehouse: 4. What is stock receipt? What consideration should be taken in the stock receipt?
Given an order cost of $100, a, per period holding cost of $.50, and the following requirements schedule: Period Demand 150 90 60 70 100 60 What is the part-period method lot size for the order for the first period? Select one а. 300 Ob. 470 c. 240 d. 370 e. 150 3
7. The following were taken from the records of Sauyo Company: Year Cost of Beginning Ending Good Sold Inventory Inventory (In Pesos) (In Pesos) 340,500 25,300 30,200 2. 435,040 30,200 35,400 520,400 35,400 36,400 4 547,500 36,400 38,300 600,700 38,300 39,000 Required: Compute the inventory turn-over for year 5. Round off answer to whole number.
A Figure 16.19 B (1) C(2) LT = 1 LT = 2 TABLE 16.1 D (1) INVENTORY RECORD DATA ITEM LT = 3 DATA CATEGORY Lat sizing rule Lead time Scheduled rece pts FOQ = S00 units 3 weeks POQ (P=3) L4L 1 week 2 weeks Nane 200 (week 1) None Beginning (on hand) inventory 20 425 POQ tum: 8 Lat sie: POQP - 3) Description. Lead time: 1wek Week 10 Gross 100 200 120 180 60 requirements Scheduled Projected on hand inventory Hanned receipti Hanned order reteases L4L tam: C Lat sue: LAL Description Lead time 2 weks Week 10 Gross 200 400 240 120 requirements Scheduled cepts Projected on hand imventory Hanned recets Manned ordur releases
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: 12 units at $47 Jan. 11 Aug. 13 20 units at $48 Nov. 30 $564 960 735 Avaliable for sale $2,259 There are 20 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using the (a) first-in, first-out (FIFO) method; (b) last-sout (LIFO) method; and (c) weighted average cost method (round per-unit cost to two decimal places and your final answer to the nearest whole dollar). a First-in, first-out (FIFO) b. Last-in, first-out (LIFO) c. Weighted average cost Inventory Purchase Purchase 15 units at $49 47 units 1,284 X
2.7 Which of the following help explain how the Reorder Point (ROP) works in conjunction with the Economic Order Quantity (Q), the number of orders (N) and the time between orders (T)? a) The Economic Order Quantity (Q) and the Annual Demand (D) are used to determine the number of Order (N) b) The number of orders (N) and the number of days that a firm works (W) are used to determine the time span between orders (T) c) Orders are placed every T days unless the inventory on hand fall to or below the Reorder Point d) Only a and b e) f) Only b and c All of a, b and c 2.8 The objective of Inventory Management is to balance inventory investment (cost) and customer service. a) TRUE b) False 2.9 The Economic Order Quantity (EOQ), the number of orders, the Reorder Point (ROP), the time between orders are important analytics in Inventory Management. a) TRUE b) FALSE 2.10 The number of working days for a firm is an important input in calculating the components of the Economic Order Quantity…
Complete the master productin schedule based on thefollowing information:Week 1 2 3 4 5 6 7 8 9Forecast 320 100 30 110 40 240 290 60 410Customer Orders 60 50 80 20 60 60 0 0 0Projected On-Hand Inventory 600MPS ReleasedMPS DueAvailable-to-promise (ATP) Scheduled production whenever projected on-had inventory drops below 30MPS lot size: 300Production lead time or lead time for MPS releases 1
Complete the master production schedule (enter your responses as whole numbers). On-hand inventory at end of week 1: 190 Week Forecasted demand Booked orders Projected ending inventory Master production schedule Available to promise 2 280 125 680 770 3 400 170 280 4 290 265 640 650 5 250 150 390 6 260 265 965 840 7 250 240 715 8 290 125 1295 870 555 9 310 190 985
Part (A) To control the inventory, organizations have three alternate approaches: Economic Order Quantity (EOQ). Materials Requirements Planning (MRP) and Just-in-Time (JIT). Discuss those three approaches identify the goal of each one? And how the organization can achieve such a goal? Part (B) Some threats could be happened in the production cycle, one of them is over or under production threat. Discuss two problems and two controls related to this threat. for the toolbar, press ALT F10 (PC) or ALT+FN+F10 (Mac).

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