Calculate the total expenses (consider the setup cost+ holding cost only) of Wheel, Tire, and Spokesbased on the projected order released andinventory level (referred to as Projected on Hand)over an 8-week period if the Holding cost is$2/unit/week and the Setup cost is $400. Yourholding cost calculation should exclude the firstweek's inventory units.Because of bad economic environment underCOVID-19, the retailer has asked GIANT fordiscounts on the price of model "Flying". Afternegotiation, GIANT offered the following discountschedule for the retailer:Quantity ordered perorderDiscount on unitpriceLess than 120 units0%120 – 199 units10%200 units or above20%

Given holding cost(H)=$2unit/week Setup cost(S)=$400 Total time period =8weeks Annual quantity…

+ holding cost only) of Wheel, Tire, and Spokes based on the projected order released and inventory level (referred to as Projected on Hand) over an 8-week period if the Holding cost is $2/unit/week and the Setup cost is $400. Your

+ holding cost only) of Wheel, Tire, and Spokes based on the projected order released and inventory level (referred to as Projected on Hand) over an 8-week period if the Holding cost is $2/unit/week and the Setup cost is $400. Your

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Chapter16: Lean Supply Chain Management

Section: Chapter Questions

Problem 10DQ: The chapter presented various approaches for the control of inventory investment. Discuss three...

See similar textbooks

Similar questions

The chapter presented various approaches for the control of inventory investment. Discuss three additional approaches not included that might involve supply chain managers.
Weekly Average Demand 110 Standard deviation of (weekly) demand 30 Setup cost ($) 1400 Lead time (in weeks) 2 Procurement cost ($) 200 Holding cost /unit/week ($) 3 You are given the demand and inventory related information about a grocery store’s product in the table. The store is open for 46 weeks in a year. What is the reorder point if it wants to achieve a service level of 97%? (Do not round your intermediate calculations. Round your final answers to the nearest whole number.
Given Information Service Level - 95% (z value= 1.6649) Order Cost - $125Order Cycle (weeks) - 4, 5, 6, 7, 8Lead Time (weeks) - 2 weeksOperating Time - 52 weeks Standard deviation = 69.3237 Variable Holding Cost - 12.019% Fixed Holding Cost - 1,659,317.307 COMPUTE FOR ECONOMIC ORDER QUANTITY (EOQ) PER ORDER CYCLE. THANK YOUUUUU
As the Manager of Branson’s Department Store, you are responsible for ensuring that reorder quantities for the various items have been correctly established. You decide to test one item and choose product Z. A continuous review inventory policy has been used, so you examine this as well as other records and come up with the following data: Cost per unit $35 Holding cost 20 percent of unit cost Average daily demand 10 units Ordering cost $30 per order Standard deviation of daily demand 3 units Delivery lead time 4 days Because customers generally do not wait but go elsewhere, you decide on a service probability of 90 percent. Assume that Branson’s Department Store operates 320 days per year. [What is the annual demand (D)? Determine the optimal order quantity, Q*. Determine the reorder point (R) if demand is constant. Determine the reorder point (R) if demand is varies.
40) PLEASE HELP WITH THIS! Gentle Ben's Bar and Restaurant uses 5,000 quart bottles of an imported wine each year. The effervescent wine costs $3 per bottle and Is served only in whole bottles because it loses its bubbles quickly. Ben figures that it costs $10 each time an order is placed, and holding costs are 20 percent of the purchase price. It takes three weeks for an order to arrive. Weekly demand is 100 bottles (closed two weeks per year) with a standard devlation of 30 bottles. Ben would like to use an inventory system that minimizes inventory cost and will provide a 95 percent service probability. b. At what inventory level should he place an order? Note: Use Excel's NORM.S.IN( function to find the z value. Round z value to 2 decimal places and final answer to the nearest whole number.
Fisk Corporation is trying to improve its inventory control system and has installed an online computer at its retail stores. Fisk anticipates sales of 97,200 units per year, an ordering cost of $4 per order, and carrying costs of $1.50 per unit. What is the economic ordering quantity? How many orders will be placed during the year? What will the average inventory be? What is the total cost of ordering and carrying inventory?
Thomas Kratzer is the purchasing manager for theheadquarters of a large insurance company chain with a centralinventory operation. Thomas’s fastest-moving inventory item hasa demand of 6,000 units per year. The cost of each unit is $100, and the inventory carrying cost is $10 per unit per year. The aver-age ordering cost is $30 per order. It takes about 5 days for an order to arrive, and the demand for 1 week is 120 units. (This is acorporate operation, and there are 250 working days per year.)a) What is the EOQ?b) What is the average inventory if the EOQ is used?c) What is the optimal number of orders per year?d) What is the optimal number of days in between any two orders?e) What is the annual cost of ordering and holding inventory?f ) What is the total annual inventory cost, including the cost ofthe 6,000 units?
A firm requires 90,000 units (D) over a 120-day production period and is placing 2-orders of equal quantity (O). Inventory is used at a constant daily rate. Ordering and Holding Costs are accounted for at end of the production period. Ordering Costs (OC) are $5,000/order and Holding Costs (HC) are $4.00/unit based on average inventory. The price per unit of inventory is $50 (C"). The firm pays for the inventory 5-days after delivery. The firm's cost of capital is 10% (1). For the inventory system, the SECOND order is delivered at f= and payment for that order is made at f= Total Cost Ordering Costs + Holding Costs + Item Cost Total Cost OCx (D/Q)] + [HC (0/2)] + (C x D) Order Number 1 2 - Delivered At t= ORDERING COSTS HOLDING COSTS 5, 120 60, 65 120, 125 5, 10 0 Order Quantity 45,000 Cost $10,000 Payment Due At t= Ⓒ 5 150 PVF 0.998632 0.960526 PV $9,605
Dunstreet’s Department Store would like to develop an inventory ordering policy of a 95 percent probability of not stocking out. To illustrate your recommended procedure, use as an example the ordering policy for white percale sheets. Demand for white percale sheets is 5,000 per year. The store is open 365 days per year. Every two weeks (14 days) inventory is counted and a new order is placed. It takes 10 days for the sheets to be delivered. Standard deviation of demand for the sheets is five per day. There are currently 150 sheets on hand. How many sheets should you order?
Joe Henry's machine shop uses 2,450 brackets during the course of a year. These brackets are purchased from a supplier 90 miles away. The following information is known about the brackets: Annual demand 2,450 Holding cost per bracket per year $1.65 Order cost per order $18.50 Lead time 2 days Working days per year 250 a) What is the EOQ? __units (round your response to two decimal places). b) What is the average inventory if the EOQ is used?__ units (round your response to two decimal places). What would be the annual inventory holding cost? $__ (round your response to two decimal places). c) Given the EOQ, how many orders will be made annually?__orders (round your response to two decimal places). What would be the annual order cost? $__ (round your response to two decimal places). d) Given the EOQ, what is the total annual cost of managing (ordering and holding) the inventory? __ $ (round your response to two decimal places). d)…
An architect firm uses an average of 60 boxes of copier paper a day. The firm operates 280 days a year. Storage and handling costs for the paper are $30 a year per box, and its costs approximately $60 to order and receive a shipment of paper.(a) What quantity order size would minimize the total annual inventory cost?
Fisk Corporation is trying to improve its inventory control system and has installed an online system at its retail stores. Fisk anticipates sales of 58,800 units per year, an ordering cost of $4 per order, and carrying costs of $1.50 per unit. In the second year, Fisk Corporation finds that it can reduce ordering costs to $1 per order, but carrying costs will stay the same at $1.50 per unit. a-1. What is the economic ordering quantity for the second year? Economic ordering quantity (EOQ) a-2. How many orders will be placed during the second year? Number of orders a-3. What will the average inventory be for the second year? Average inventory Total costs units units a-4. What is the total cost of ordering and carrying inventory for second year? LA