Please do not give solution in image format thanku Question 20 (4 puniFred's Fabrication has the following aggregate demand requirements and other datafor the upcoming four quarters. Please answer the following questions based onaggregate planning.Quarter Demand8001000123Stockout/backorder cost$80 per unitInventory holding costProduction increaseProduction decrease$10 per unit at end of quarter$20 per unit$40 per unitWhat is the holding cost for quarter 1 if level strategy is adopted?41200160010001800Previous quarter's outputBeginning inventory900600900 units180 units

Holding cost which is also known as carrying cost is the expenses that a company has to incur while…

Fred's Fabrication has the following aggregate demand requirements and other data for the upcoming four quarters. Please answer the following questions based on aggregate planning. Quarter 2 3 Demand 800 1000 900 600 Previous quarter's output Beginning inventory Stockout/backorder cost Inventory holding cost Production increase Production decrease 900 units 180 units $80 per unit $10 per unit at end of quarter $20 per unit $40 per unit What is the holding cost for quarter 1 if level strategy is adopted? 1200 1600 1000 1800

Fred's Fabrication has the following aggregate demand requirements and other data for the upcoming four quarters. Please answer the following questions based on aggregate planning. Quarter 2 3 Demand 800 1000 900 600 Previous quarter's output Beginning inventory Stockout/backorder cost Inventory holding cost Production increase Production decrease 900 units 180 units $80 per unit $10 per unit at end of quarter $20 per unit $40 per unit What is the holding cost for quarter 1 if level strategy is adopted? 1200 1600 1000 1800

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 10 You plan to get in a position of short-the-basis by selling cash corn in June basis JUL and buying it in August when the basis is trading against the SEP. Which of the following pre-spread orders would you want to enter to provide you with the most favorable structure for your anticipated short-the-basis position? O Buy JUL / Sell SEP at a 25¢ premium to the JUL Buy JUL/Sell SEP at a 25¢ premium to the SEP Buy SEP / Sell JUL at a 25¢ premium to the SEP O Buy SEP / Sell JUL at a 25¢ premium to the JUL
QUESTION 1 Mr Mathebula sells high end music systems. He orders his produets once a year. His re-order point without any safety stock is 500 units. Inventory cost is R25 per month and the cost of a stock-out is R200 per set per year. Given the following demand probabilities determine a recommended safety stock level. Demand during lead Probability time .1 250 .25 500 .5 750 .1 1000 .05 1
Q.9.1 Calculate safety stock given the following information: Averaged Demand: 350 items; Standard deviation during the lead time = 10 items; 5 % stock out policy Q.9.2. Calculate ROP and SS. Average daily demand (normally distributed) =15 units Standard deviation= 5 units; Lead time is constant at 2 days; 90% Service Level Desired
QUESTION 3 Given the following inventory information, construct an (a) ABC analysis by annual dollar usage, (b) ABC analysis by current inventory value, and (c) an ABC inventory matrix. Is the firm stocking the correct inventories? Item Number Unit Cost Annual Usage Phy Inv B8867 6 100 8,000 J1252 5.25 6,500 120 K9667 0.88 4,000 1,000 L2425 1 1,500 375 M4554 5.5 2,000 500 T6334 70 500 800 W9856 0.75 800 20,000 X2215 1.5 8,000 2,000 Y3214 32 1,000 500 Y6339 4 3,500 125 Calculate the annual usage for K9667.
Question 4An electronics shop sells 6000 headphones in a year and the sales is relatively constantthroughout the year. These headphones are purchased for SR 20.00 each, and the leadtime is three days. The holding cost per headphone per year is 10% of the unit cost andthe ordering cost per order is SR 75. There are 300 working days per year. Calculate thefollowing:(i) What is the annual holding cost?(ii) In minimizing the cost, how many orders would be made each year?(iii) Given the EOQ, what is the total annual inventory cost (including purchase cost)?(iv) What is the time between orders?(v) What is the ROP?
Question 4An electronics shop sells 6000 headphones in a year and the sales is relatively constantthroughout the year. These headphones are purchased for SR 20.00 each, and the leadtime is three days. The holding cost per headphone per year is 10% of the unit cost andthe ordering cost per order is SR 75. There are 300 working days per year. Calculate thefollowing:(i) What is the annual holding cost?(ii) In minimizing the cost, how many orders would be made each year?(iii) Given the EOQ, what is the total annual inventory cost (including purchase cost)? Write the answer on the computer
Question 7 Firm develop new products to a.gain market share and build brand equity b.keep their research and development teams gainfully employed c.take up slack in capacity d.gain first mover advantage and eliminate waste Question 8 Economic order quantity (EOQ) assumes all of the following conditions apply .demand is known and is constant over time .there are no shortages allowed.lead time for the receipt of orders is constant.Order quantity is received all at once true or false? question 10 Trade-offs in the new product development relate to A.Product / service design, time to market and profitability B.Proft. Expenditure and market share C.Time. cost and quality D.Market reach, product / service design and timing
Q4. What are the various types of inventory? Explain each type in brief.
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).
How would you adjust MPS schedule when safety stock requirements are given?
Question1: A business wants to classify its inventory items in order to determine its inventory policy. The table contains information about the inventory items in the business. Accordingly, using the "ABC" analysis, determine the stock groups of the enterprise.1-) What percentage of the total inventory items and total inventory costs will the A group inventory items constitute?2-) What percentage of the total inventory items and total inventory costs will the B group inventory items constitute?3-) What percentage of the total inventory items and total inventory costs will the C group inventory items constitute?
Q2) Clancy's Motors has the following demand to meet for custom manufactured fuel injector parts. The holding cost for that item is $2 per month and each setup costs $80. Lead time is 0 months. Calculate the planned order releases using: (a) the EOQ technique, and (b) the POQ technique. And What are the costs of each plan, including the holding cost of any inventory left over after month 7? What technique performance is better. Month 1 2 3 4 5 6 7 Requirement 400 150 200 150 100 150 250 Answer: (a) The monthly holding cost = $2/month Average monthly demand = ??? units The EOQ = ??? units Total inventory held = ??? units Setup costs = $??? Holding cost = $???? Total cost = $???? (b) POQ Interval = ?.??, round to # month. Total inventory held = ? units Setup costs = $??? Holding cost = $? Total cost = $???