AFigure 16.19B (1)C(2)LT = 1LT = 2TABLE 16.1D (1)INVENTORY RECORD DATAITEMLT = 3DATA CATEGORYLat sizing ruleLead timeScheduled rece ptsFOQ = S00 units3 weeksPOQ (P=3)L4L1 week2 weeksNane200 (week 1)NoneBeginning (on hand)inventory20425POQtum: 8Lat sie: POQP - 3)Description.Lead time: 1wekWeek10Gross10020012018060requirementsScheduledProjectedon handinventoryHannedreceiptiHanned orderreteasesL4Ltam: CLat sue: LALDescriptionLead time 2 weksWeek10Gross200400240120requirementsScheduledceptsProjectedon handimventoryHannedrecetsManned ordurreleases L4LLat sie LALLead time: 2 weeksItem:CDescription:Week10Grossrequirements200400240360120ScheduledreceiptsProjectedon-handinventoryPlannedreceiptsHanned orderreleasesFOQLat sie: FOQ- s00 unitsLead time: 3 weekstemDDescriptionWeek10Gross400240300120requirementsScheduledreceiptsProjectedon-handinventoryPlannedreceiptsPlanned orderreleases

Answered: Figure 16.19 B (1) C 2) LT=1 LT-2 TABLE…

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

Which are some of the things that drive variability in demand management and forecasting? 1. MOQs 2. Promotional sales on products 3. Supplier contracting 4. Order fulfillment 5. Network planning 6. None of the above Please give me answer ASAP with clear explanation.
21- Which one of the following represent FIFO method of inventory evaluation? a. Old items remain in inventory b. Old merchandise is sold first c. New merchandise is sold first d. Average number of goods are sold
A busness is aunchng a new product. The aunch wil require a number of related actvties as follows hre (7 weeks) select an advertising agency (2 weeks), plan an advertising campaign wth the agency (4 weeks),products from the manufacturer (13 weeks) select distributors for the product (9 weeks), take initial orders fromoperation (12 weeks), pack enough products for the launch stock (8 weeks), order the launch quantty ofthe distrbutors (3 weeks), dispatch the initial orders to the distrbutors (2 weeks). (a) What is the earest timeconduct the advertsing campaign (10 weeks), design the packaging of the product (4 weeks), set up packinga sales manager (5 weeks), requre the sales manager to recruit saes peope (4 weeks), tran the sales people that the new product can be ntroduced to the market? (b) If the company hre traned salesmen who do notneed further training, coud the product be introduced 7 weeks earler? (c) How long could one delay selectngthe advertising agency? In the example above,…
The following data give monthly Demband >1300 units Ordenng cost Holding lo st to Q - $ 15 pe oder $2/ units peo year 464 Lead time 4 days %3D wha t is the tolal annua / vanable inventory Cost Cie total annus! total aroual ordening) © $968 $ 8 ® $484 D $ I436 14520
3(AL Jn 2020, Square-Nine Entrerprise has purchased 250,000 micro-chips for the first four months and 35% more on the remainder as a component in the production of its products. As much as 25% of the purchase is not used but instead stored in the warehouse. Each unit of the final product is sold in the market at a price of $18.99 per unit, and the storage cost is a total of $1.13 per unit. The cost price of the order is $5,500 for each delivery that takes three weeks. Calculate: 1) An annual optimal order quantity. 2) A total of number of orders placed in a year. 3) Time range between orders if the company operates for 49 weeks in a year 4) What are total units for reorder point? 5) Cost of Goods Sold.
Demand forecasting and planning is not a part of inventory management function. Select one : 1.True 2.Fales
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
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.
Michael’s Offi ce Supply (MOS) sells offi ce furniture,equipment, and supplies. Th is week the company has received 50customer orders. Each order has an average of fi ve line items. Th eaverage dollar amount of each order is $1200. MOS was able toship 47 of the 50 orders on schedule.(a) Using the percentage of orders shipped on time, calculatethe customer service level.(b) If Michael’s calculates customer service level by using thepercentage of line items shipped on schedule, how manyline items must be shipped to achieve the same customerservice level calculated in part (a)?(c) If Michael’s calculates customer service level by thepercentage of dollar volume shipped, how many dollarsof product must be shipped to achieve the same customerservice level calculated in part (a)?(d) What factors determine the customer service levelmeasure that MOS should use?
b. Forward Thinking Limited (FTL) has used a fixed-time period inventory system that involvedtaking a complete inventory count of all items each month. However, increasing labor costs, areforcing FTL, to examine alternative ways to reduce the amount of labour involved in inventorystockrooms, yet without increasing other costs, such a shortage costs. Table 4 (below) is arandom sample of 20 FTL’s items.6Table 4. Annual Usage by Value of a sample of FTL’s InventoryItem Number Annual Usage ($) Item Number Annual Usage ($)1 10,700 11 2,8502 14,100 12 1,5003 4,100 13 3,3004 16,100 14 2,6005 8,200 15 110,1006 1,900 16 14,9007 84,100 17 9,6008 990 18 1,8009 1040 19 3,80010 94,100 20 12,600 (i) What would you recommend FTL to do to cut back its labor cost? (Illustrate using an ABCplan).
full hand written plz otherwise skip..i'll give you multipke uovote
The following particulars were collected for the year 2015 from Need LLCMonthly demand -2,000 unitsCost of placing an order RO 225.Annual carrying cost per unit 8%Purchase price of input unit RO 350Minimum usage 30 units per weekMaximum usage 50 units per weekRe-order period 6 to 8 weeks.For emergency purchase 4 weeks Required:(a) Re-order quantity(b) Re-order level(c) Minimum level(d) Maximum level(e) Average Stock Level(f) Danger level

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