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 a-4. What is the total cost of ordering and carrying inventory for second year? $ Total costs units units

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 a-4. What is the total cost of ordering and carrying inventory for second year? $ Total costs units units

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

Related questions

Q: ABC Corporation resells one type of candle. It has 250 working days. Each day, it sells an average…

A: Following are the calculations: EOQ =2*Annual Demand*Ordering CostHolding Cost =2*125000*4009.50…

Q: Dave's Auto Supply custom mixes paint for its customers. The shop performs a weekly inventory count…

A: As specified above solved this problem using Excel and Here are the Excel formulas:

Q: What is the economic ordering quantity? How many orders will be placed during the year? What will…

A: Annual usage or Annual demand (A) = 97200Ordering Cost (B) = $4 per orderCarrying Cost (C) = $1.50…

Q: Weekly Average Demand 210 Standard deviation of (weekly) demand 30 Setup cost ($) 1000 Lead time (in…

A: Weekly Average Demand (d) = 210The standard deviation of (weekly) demand (σd) = 30Setup cost =…

Q: Assume that the sales representative just walked in the door and there are currently 450 pounds of…

A: Sure, let's break down the process step by step:1. Calculating Reorder Point: - We start by…

Q: a) b) Use this information to answer the following questions RobCo is a distributor of Protectron…

A: Economic order quantity is used in managing the level of inventory in a warehouse that represents…

Q: is used by traders to record the yearly profits & losses of the business. * General book…

A: A general book is used by traders to record yearly profits and losses.

Q: 9.4 A florist carries an average inventory of $12,000 in cut flowers. The flowers require special…

A: A firm's numerous expenses for keeping goods on hand are known as carrying costs. Taxes, insurance,…

Q: H & K Electronic Warehouse sells a 12-pack of AAA batteries, and this is a very popular item. Demand…

A: Mean demand (d) = 50 unitsStandard deviation of daily demand = 16Lead time (L) = 5 daysStandard…

Q: Stationery Supplies orders plastic erasers from a company in Nürnberg, Germany.It takes six weeks to…

A: From the question, we know that Stationary suppliers orders two time 200 erasers in a year. And it…

Q: Investigate how demand variability affects the overall effectiveness of the Wilson approach in…

A: The Wilson EOQ (Economic Order Quantity) model is a valuable tool in inventory management, but its…

Q: An increase in Economic Order Quantity will lead to Increase in Ordering cost Reduction in…

Q: Energyzer , a regional electronics retailer , estimates that sells 13 , 000 4-packs of batteries per…

A: The Economic Order Quantity is determined for the purpose of inventory management so that it will…

Q: If the company in #8 uses exponential smoothing (smoothing factor = .6) and the forecast for the…

A: Find the given details below: Given Details: Year Sales 2017 1000000 2018 1200000…

Q: The distribution manager for Putnam Corporation is trying to establish the most economic ordering…

A: Continuous review system is where inventory is reviewed on continuous basis. Economic order quantity…

Q: Refer to the standard normal table for z-values. a. If the company uses a periodic review system, P…

A: Here, given that this company uses a period review system, I would determine the EOQ quantity, from…

Q: At what inventory level should he place an order

A: Annual Demand (D) = 5,000 bottles Cost = $ 3 Ordering Cost (O) = $ 10 Holding Cost (H) = 0.20 * 3 =…

Q: Please use the following information for questions #1-5. Knights Corporation, a leader in…

A: Economic Order Quantity or EOQ (Q*) is the optimal quantity of inventory required that helps in…

Question

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

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Calculation of Economic order quantity

VIEW

Step 2: Calculation of number of orders and average inventory in second year

VIEW

Solution

VIEW

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions

Sam's Pet Hotel operates 52 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases kitty litter for $13.00 per bag. The following information is available about these bags: ≻Demand=75 bags/week ≻Order cost=$55.00/order ≻Annual holding cost=25 percent of cost ≻Desired cycle-service level=80 percent ≻Lead time=4 weeks (24 working days) ≻Standard deviation of weekly demand=15 bags ≻Current on-hand inventory is 320 bags, with no open orders or backorders. Part 2 a. Suppose that the weekly demand forecast of 75 bags is incorrect and actual demand averages only 50 bags per week. How much higher will total costs be, owing to the distorted EOQ caused by this forecast error? The costs will be $enter your response here higher owing to the error in EOQ. (Enter your response rounded to two decimal places.) a. What is the EOQ? What would the average time between orders (in weeks)? b. What should R be? c. An inventory withdraw…
Describe the inventory models of stochastics? What is the use of when?
PART A Speedy Bicycle Company (SBC) is a wholesale distributor of a wide variety of bicycles and bicycle parts. The most popular model is the Dragonfly, which sells for $170. All manufacturing is done at a plant in China, and shipment takes a month (30 days) from the time an order is placed. The estimated order cost is $75, including customs clearance. SBC's cost per bicycle is 65% of retail price, and inventory carrying cost is 11% per year of SBC's cost. If the company cannot fulfill a retail order, the retailer will get the shipment from another distributor and SBC loses that business. SBC is planning inventory for 2023 based on forecasted demand and wants to maintain a 93% service level to minimize lost orders. The company has 300 working days per year. 2021 Forecasted Demand for the Dragonfly Bicycle Model: F A J 15 58 J 8 M 31 M 96 J 59 38 A 23 S 16 0 14 N 26 D 41
The distribution manager for Putnam Corporation is trying to establish the most economic ordering policy for the standard model of its best-selling microwave oven. He has control of the finished goods warehouse for the factory and must satisfy wholesaler demand. The following information is available: Wholesale value $100 Annual demand 50,000 units Std. Deviation of Demand 30 units per day Working year 250 days Production lead time 9 days Ordering cost for production $1,800 Holding cost per unit per year 20% of value Desired service level 96 percent: If Putnam wishes to use the periodic review system, what should be the safety stock, reorder point? If the current on hand inventory is 1,000 units, how many units should be ordered?
Johnson's Juice sells bottles of "keep me awake during class" fruit juice to college students. Annual demand is 88,000 bottles. The company uses an annual holding cost percentage of 16% in its setup cost is $45 per order. The current price per bottle from the supplier is $.75, and Johnson's Juice resells it to customers for $2.00 each. However, the supplier has notified Johnson's Juice that starting nect week the purchase price will rise to $1.15 due to tariffs imposed by the government. Johnson's inventory of bottles is about to be depleted. How many bottles should Johnson's jiuce purchase in the next order. (assume the bottles are full of chemicals so the juice will never expire.)
Please do not give solution in image format thanku Prince Electronics, a manufacturer of consumer electronic goods, has five distribution centers in different regions of the country. For one of its products, a highspeed modem priced at $360 per unit, the average weekly demand at each distribution center is 85 units. Average shipment size to each distribution center is 450 units, and average lead time for delivery is 2 weeks. Each distribution center carries 2 weeks' supply as safety stock but holds no anticipation inventory. Part 2 a. On average, how many dollars of pipeline inventory will be in transit to each distribution center? $enter your response here. (Enter your response as an integer.)
A manufacturer of hospital supplies has a uniform annual demand for 80,000 boxes of bandages. It costs $20 to store one box of bandages for one year and $320 to set up the plant for production. How many times a year should the company produce boxes of bandages in order to minimize the total storage and setup costs? Question content area bottom Part 1 The company should produce boxes of bandages enter your response here time(s) a year.
At a recent manufacturing workshop, XYZ, Incorporated explained that demand for disposable masks increase rapidly in March 2020 when quarantine mandates first took effect. At the time, retailers could only place a single order to cover demands through the end of the summer. A certain retailer purchased disposal masks from a supplier at a cost of $20 per unit and sold them for $30 per unit. By the end of summer, demand for masks subsided considerably and all masks that weren't sold during the summer could be sold at a discounted price of $18 per unit. The retailer estimated that demand between March and August would be Normally distributed with mu = 10,000 and sigma = 1525 units With, supply chains becoming more stable since March 2020, the retailer is currently in the process of establishing a contract with a disposable mask supplier. The supplier has agreed to sell masks to the retailer for $18 per unit and will make deliveries any time the supplier places an order for a cost of $100…
The distribution manager for Divine Corporation is trying to establish the most economic ordering policy for the standard model of its best-selling microwave oven. He has control of the finished goods warehouse for the factory and must satisfy wholesaler demand. The following information is available: Wholesale Value $100 Annual Demand 50,000 units Standard Deviation of Demand 30 units per day Working Year 250 days Production Lead Time 9 days Ordering Cost for Production $1,800 Holding Cost per unit per year 20% of value Desired Service Level 96 percent If Divine decides to use a continuous review system, what should be economic order quantity, safety stock, and the reorder point? If on the other hand, Divine wishes to use the periodic review system, what should be the safety stock, reorder point? If the current on hand inventory is 1,000 units, how many units should be ordered?
KVS Pharmacy stocks a popular brand of over the counter flu and cold medicine. The average demand for the medicine is six packages per day, with a standard deviation of 1.2 packages. A vendor for the pharmaceutical company checks KVS’s stock every 60 days. During one visit, the store had eight packages in stock. The lead time to receive an order is five days. Determine the order size for this order period that will enable KVS to maintain a 95% service level.
Peter Sagan is in charge of maintaining hospital supplies at Champs Hospital. During the past year the mean weekly demand for a special type of tubing was 186 packages of this tubing with a standard deviation of 13 packages of tubing. The lead time for receiving this tubing from the supplier is 1.5 weeks. Peter would like to maintain a 95% service level and places an order for 750 packages every time an order is placed. d) If the weekly demand is 186 and there is a 1.5 week lead time - what is the reorder point (99% service level)? e) If the carrying cost per year is $0.50/unit/year - what is the additional cost associate with the 99% service level compared to 95% service level (i.e. cost of safety stock at 99% level - cost of safety stock at 95% service level)?
Only question no. 4 As fast as possible please