16. Complete the following schedule and then answer Problems 16 and 17.Forecast requirementsIn transitOn Hand13550Projected available balance30Planned ShipmentsShipping quantity = 50, Lead time = 1, Safety stock = 25230Period345What will the planned shipments be for periods 2, 3, and 4?a) 25 units for each periodb) 50 units for periods 2 and 4; zero units for period 3465c) 50 units for each periodd) 100 units in period 2, zero units in period 3, and 50 units in period 4e) 75 units in period 2, 35 units in period 3, 20 units in period 417. What is the projected available balance for period 4?a) 50 unitsb) 55 unitsc) 60 unitsd) 65 unitse) 75 units530

Given details: Calculation methods: Ending inventory = Planned order receipts + ending inventory…

Answered: 16. Complete the following schedule and…

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

What are the major assumptions made by economic order quantity (EOQ) model? Explain.
Demand for portable music players for joggers has caused Nancy Industries (Nancy) to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nancy expects demand for music player to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demands for the players for last year was as follows : Month Demand (units) Jan 4200 Feb 4300 Mar 4000 Apr 4400 May 5000 Jun 4700 Jul 5300 Aug 4900 Sep 5400 Oct 5700 Nov 6300 Dec 6000 Question : From the choice of simple moving average, weighted moving average, exponential smoothing, and linear regression analysis, which forecasting technique would you consider the most accurate to Nancy Industries? Why?
Year Cost of Good Sold Beginning Inventory (In Pesos) Ending Inventory (In Pesos) 1 503,425 10,300 12,400 2 643,056 12,400 11,200 3 690,432 11,200 10,670 4 734,509 10,670 11,200 5 758,734 ? 10,987 REQUIRED Determine the inventory turnover for year 5. Determine the number of days the finished goods stay in inventory in Year 1. There was no improvement in inventory turnover in Year 5 compared to Year 1. This statement is not correct. Write YES or NO for the answer
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
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.
Explain the practical application and significance of the Economic Order Quantity (EOQ) formula within the Wilson approach.
Table 1. Demand of Hairdryer from January to July [Jadual 1. Permintaan Pengering Rambut dari Januari 2021 hingga Julai 2021] Month Demand January February 2800 2870 March 2968 April Мay 3000 3100 Jun 3150 July 3400 a) Calculate forecast future demand for May, June, July and August by using 3 months simple moving average.[hitung ramalan permintaan masa depan untuk bulan Mei, Jun, Julai dan Ogos dengan menggunakan purata bergerak sederhana 3 bulan.] *
Explain the significance of the Economic Order Quantity (EOQ) formula in the Wilson approach.
ABC analysis on the following set of products Item Annual Demand Unit CostA 211 800 R9B 390 100 R90C 003 450 R6D 100 400 R100E 707 85 R2,000F 660 250 R320G 473 500 R75H 921 100 R75 Soft goods department sells 175 units per month of a certain large bath towel. The unit cost of a towel to the manufacturer is R2.50 and the cost of placing an order has been estimated to be R12.00. There is an inventory carrying charge of 27% of the unit cost per year. What is the optimal order quantity, the order frequency, and the annual holding and setup cost. If the ordering cost can be cut to R4.00, what will be the new economicorder quantity, the order frequency, and annual holding and setup costs.
Q2. After becoming the impressive champions of World Cup in France past month, U.S. Women National Soccer Team is set to start a Victory Tour that will take place in August. Within the Tour, the team will play 3 friendly games (one in TX, one in NY, one in CA). For the game in TX, Soccer Federation is anticipating a demand for the tickets by the following distribution. Number of Supporters P(Number of Supporters) 12000 0.10 15000 0.25 18000 0.40 21000 0.20 24000 0.05 The Federation must decide in which stadium the game will take place at, and they want to make this selection in a way that it maximizes their expected profit. Ticket price is $18 a seat and ticket printing cost is $4 a ticket. If the Federation has to pay additional $2 for each unsold ticket, which one of the following stadiums they should choose to play the game at? Please circle the answer and show all your calculations. a. Mike A. Myers Stadium, Austin (capacity = 20000) b.…
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…
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.

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