Determine the optimal Q and TC given the following information:D = 30,000 boxesCh = $2Co$300Discount schedule:Quantity (boxes)Price ($ per box)431 to 9,99910,000 to 14,9994115,000 to 19,9993820,000 or more36Show complete solution.

Given data: Annual demand(D) = 30,000 units Ordering cost(S) = $300 Holding cost(H) = $2

Answered: Determine the optimal Q and TC given…

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

QUESTION 2 When used effectively, S&OP Planning does not require cross-functional collaboration. O True False
Explain briefly the difference between product cost and period cost & application of “Theory of Constraints” in real world.
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
question #3 Same problem statement: Weekly demand for DVD-Rs at a retailer is normally distributed with a mean of 1,000 boxes and a standard deviation of 150. Currently, the store places orders to the supplier, with a reorder point of 4,200 boxes. The order quantity to the supplier is fixed at 5,000 boxes. Replenishment lead time is 4 weeks, fixed order cost per order is $100, each box costs the retailer $10, and the inventory holding cost is 25% per year. With a safety stock of 300 boxes, what is the approximate service level (round to two decimals)? Numeric Response 84.13 * f5 10 f6 0 4- ♫+ fg C fil W f12. insert prt sc + 11 Ə ← delete backspace home num lock 4x D end 1:23 PM 11/15/2022 pg up
Each Triam Deluxe gamer computer system consists of two speakers, a monitor, a system unit, a keyboard, and an installation kit. These pieces are packed together and shipped as a complete kit. In MRP terms, all of these items are level 1 items that make the level 0 kits. Complete the MRP records, using the following information: • Production plans for complete kits are as follows: Start assembling 4,500 kits in week 2 Start assembling 1,000 kits in weeks 3, 4, and 5 Start assembling 8,000 kits in week 6 • The gross requirements for the system unit have already been given to you. For the remaining items, you will need to figure out the gross requirements. • All scheduled receipts, lead times, and beginning inventory levels are shown. Click the icon to view the MRP records. Construct the material requirements plan for item System unit (enter your responses as whole numbers). System unit: Lead Time = 1 week; Minimum order quantity = 3,500 Week 1 2 3 Gross requirements 4,500 1,000…
QUESTION 2 Identify and explain four assumptions of the economic order quantity.
bus ules des cussions zzes Please refer to the Network Diagram below. Let Xij represent the number of units shipped from i to j, where i= 1, 2, 3 and j-4, 5, 6. The objective function is to minimize overall transportation cost while making sure all demand is met. Answer each question independently of the other questions. Unit shipping costs are intentionally hidden from the diagram. Supply 100 50 50 Plants 2 Retailers Demand 50 25 110 Under which of the following situations (consider them separately) would we have demand shortages? I. Route 1-6 is removed.
QUESTIONS (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 OA) $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
QUESTION 12 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 answer using the criterion of maximin? Alternatives Large Inventory Small Inventory Probability OA) -$2,000 O B) $0 OC) $51,667 OD) $220,000 O E) -$5,000 Large Crowd $220,000 $90,000 .20 PROFIT (S) Average Crowd $50,000 $70,000 1.50 Small Crowd -$2,000 -$5,000 30
Question 2 Rohe (Hong Kong) Ltd is a pharmaceutical company which manufactures and supplies various drugs for drug stores in Asia. Currently, Rohe (Hong Kong) Ltd has four factories A, B, C and D. Management has decided to build a new factory at a location central to these factories. Information regarding the yearly demands and the map coordinates for the four factories are shown in below table. Factories Demand - x-coord 9,000- 3,000- 5,000 y-coord 130 40 A Be 20 60 Ce 70 100 De 16,000- 90 30 (a) Determine the map coordinates of the new factory. (b) Suggest and elaborate TWO other factors that need to consider in the selection of location. «
Please do not give solution in image format thanku 1) Determine which shipping alternative would be most economical to ship 80 boxes of parts when each box has a price of $200 and holding costs are 30 percent of price, given this shipping information: overnight, $300, two-day, $260, six-day, $180.
A Maintains a particular gym. 55% on a gross murgain of all it's training products. In April the gym had a beginning inventory of 142, 000 net Purchases of 202,000 and net sales of 433,000, to estimate Use grass profit method Cost (in #1) of ending inventory?

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

Determine the optimal Q and TC given the following information: D = 30,000 boxes ● Ch = $2 Co = $300 ● Discount schedule: Price ($ per box) Quantity (boxes) 1 to 9,999 43 10,000 to 14,999 41 15,000 to 19,999 38 20,000 or more 36 Show complete solution.