The Las Vegas Corporation purchases a critical component from one of its key suppliers. The operations manager wants to determine the economic order quantity, along with when to reorder, to ensure the annual inventory cost is minimized. The information obtained from historical data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. Round your answers according to the input instructions for each question but use unrounded values in all calculations.
Questions
1. What is the economic order quantity? Round your answer to the nearest whole number.
units
2. What is the annual purchase cost? Round your answer to the nearest dollar.
$
3. What is the annual holding cost? Round your answer to the nearest dollar.
$
4. What is the annual order cost? Round your answer to the nearest dollar.
$
5. What is the total annual inventory cost? Round your answer to the nearest dollar.
$
6. What is the reorder point? Round your answer to the nearest whole number.
units
7. What is the number of orders placed per year? Round your answer to the nearest whole number.
orders
8. What is the time between orders? Round your answer to the nearest whole number.
days
Homework Answers
| Days per year= | 360 | ||
| Annual demand, D= | (demand per day)*(days per year) | 6,200 | |
| Order cost or setup cost, S | 90.00 | ||
| item cost,P | $22.00 | ||
| holding cost percent | 16.00% | ||
| holding cost per year, H= | (holding cost percent)*(item cost) | $3.52 | |
| Lead time, LT | 4 | ||
| Economic Order quantity, Q= | squareroot(2*S*D/H) | 563.07 | |
| Economic Order quantity (Rounded up) | 563 units | Answer 1 | |
| annual holding cost= | Q*H/2 | $ 991.00 | Answer 3 |
| Annual ordering cost= | D*S/Q | $ 991.00 | Answer 4 |
| Annual Purchasing cost= | (annual demand)*(item cost) | $136,400.00 | Answer 2 |
Dear Student,
Please note : Chegg's guidelines mandate to solve one question (or
1st four sub-parts of the very same question) at a time. I would
request you to post your question again. At that time, kindly
mention the specific remaining questions (or sub-parts) to be
answered.
Add Answer to:
The Las Vegas Corporation purchases a critical component from
one of its key suppliers. The operations...
Excel Online Structured Activity: EOQ Calculation The Las Vegas Corporation purchases a critical component from one...
Excel Online Structured Activity: EOQ Calculation The Las Vegas Corporation purchases a critical component from one of its key suppliers. The operations manager wants to determine the economic order quantity, along with when to reorder, to ensure the annual inventory cost is minimized. The information obtained from historical data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. Round your answers...
High Tech Inc. is a virtual store that stocks a variety of calculators in its warehouse. Customer orders are placed; the orders are picked and packaged; and then orders are shipped to the customers. A...
High Tech Inc. is a virtual store that stocks a variety of calculators in its warehouse. Customer orders are placed; the orders are picked and packaged; and then orders are shipped to the customers. A fixed-order-quantity inventory control system (FQS) helps monitor and control these SKUs. The following information is for one of the calculators that High Tech stocks, sells, and ships. Average demand 9.5 calculators per week Lead time 5 weeks Order cost $15/order Unit cost $10.00 Carrying charge...
Southeastern Bell stocks a certain switch connector at its central warehouse for supplying field service offices....
Southeastern Bell stocks a certain switch connector at its central warehouse for supplying field service offices. The yearly demand for these connectors is 15,800 units. Southeastern estimates its annual holding cost for this item to be $24 per unit. The cost to place and process an order from the supplier is $76. The company operates 300 days per year, and the lead time to receive an order from the supplier is 2 working days. a) What is the economic order...
The Kuantan Corporation purchases a component from a supplier who offers quantity discounts to encourage larger...
The Kuantan Corporation purchases a component from a supplier who offers quantity discounts to encourage larger order quantities. The supply chain manager of the company wants to determine the optimal order quantity to ensure the total annual inventory cost is minimized. The company’s annual demand forecast for the item is 4,550 units, the order cost is $25 per order, and the annual holding rate is 12 percent. The price schedule for the item is: Order Quantity Price per Unit ($)...
Stephanie Robbins is attempting to perform an inventory analysis on one of her most popular products...
Stephanie Robbins is attempting to perform an inventory analysis on one of her most popular products Annual demand for this product is 5.000 units carrying costs $50 per unit per year, order costs for her company typically run nearly $30 per order and load time averages 10 days. Assume 250 working days per year.) a) The economic order quality is units fround your response to the nearest whole number). b) The average Inventory is units (round your response to the...
2. Joe Henry’s machine shop uses 10,000 brackets during the course of a year. These brackets...
2. Joe Henry’s machine shop uses 10,000 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 10,000 Holding cost per bracket per year $1.75 Order cost per order $22.00 Lead time 4 days Working days per year 250 a. Given the above information, what would be the economic order quantity (EOQ)? b. Given the EOQ, what would be the average inventory? What...
Joe Henry's machine shop uses 2,490 brackets during the course of a year. These brackets are...
Joe Henry's machine shop uses 2,490 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 Holding cost per bracket per year Order cost per order Lead time Working days per year 2,490 $1.30 $20.00 2 days 250 a)What is the EO0? 276.79 units (round your response to two decimal places). b)What is the average inventory if the EOQ is used? 138.4 units...
b) As a contractor to Petronas, East Technology uses 4000 valves for repairing one of Petronas plant every year. These valves are purchased from a supplier 200 km away. The following information...
b) As a contractor to Petronas, East Technology uses 4000 valves for repairing one of Petronas plant every year. These valves are purchased from a supplier 200 km away. The following information is known about the valves Table Q3b: Forecast demand for plastic product Annual demand 4000 Holding cost /valve/vear Order cost/ year RM 9 RM 25 s days Lead time Working days per year 250 Given the above information, calculate i) The economic order quantity (EOQ)? ii) The annual...
Discount-Mart, a major East Coast retailer, wants to determine the economic order quantity for its halogen...
Discount-Mart, a major East Coast retailer, wants to determine the economic order quantity for its halogen lamps. It currently buys all halogen lamps from Specialty Lighting Manufacturers, in Atlanta. Annual demand is 2,000 lamps, ordering cost per order is $60, carrying cost per lamp is $12 a) What is the EOQ? 142 lamps per order (round your response to the nearest whole number). b) What are the total annual costs of holding and ordering (managing) this inventory? $ 1,697 (round...
a) What is the economic order quantity? _______ units (round your response to the nearest whole...
a) What is the economic order quantity? _______ units (round
your response to the nearest whole number).
b) What are the annual holding costs? $_________(round your
response to the nearest whole number).
c) What are the annual ordering costs? $__________ (round
your response to the nearest whole number).
d) What is the reorder point? _______ units (round your
response to the nearest whole number).
Score: 1.5 of 2 pts 10 of 24 (23 complete) w score: 77.62% , 33.38 .....
Excel Online Structured Activity: EOQ Calculation The Las Vegas Corporation purchases a critical component from one of its key suppliers. The operations manager wants to determine the economic order quantity, along with when to reorder, to ensure the annual inventory cost is minimized. The information obtained from historical data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. Round your answers...
Southeastern Bell stocks a certain switch connector at its central warehouse for supplying field service offices. The yearly demand for these connectors is 15,800 units. Southeastern estimates its annual holding cost for this item to be $24 per unit. The cost to place and process an order from the supplier is $76. The company operates 300 days per year, and the lead time to receive an order from the supplier is 2 working days. a) What is the economic order...
Stephanie Robbins is attempting to perform an inventory analysis on one of her most popular products Annual demand for this product is 5.000 units carrying costs $50 per unit per year, order costs for her company typically run nearly $30 per order and load time averages 10 days. Assume 250 working days per year.) a) The economic order quality is units fround your response to the nearest whole number). b) The average Inventory is units (round your response to the...
Joe Henry's machine shop uses 2,490 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 Holding cost per bracket per year Order cost per order Lead time Working days per year 2,490 $1.30 $20.00 2 days 250 a)What is the EO0? 276.79 units (round your response to two decimal places). b)What is the average inventory if the EOQ is used? 138.4 units...
b) As a contractor to Petronas, East Technology uses 4000 valves for repairing one of Petronas plant every year. These valves are purchased from a supplier 200 km away. The following information is known about the valves Table Q3b: Forecast demand for plastic product Annual demand 4000 Holding cost /valve/vear Order cost/ year RM 9 RM 25 s days Lead time Working days per year 250 Given the above information, calculate i) The economic order quantity (EOQ)? ii) The annual...
Discount-Mart, a major East Coast retailer, wants to determine the economic order quantity for its halogen lamps. It currently buys all halogen lamps from Specialty Lighting Manufacturers, in Atlanta. Annual demand is 2,000 lamps, ordering cost per order is $60, carrying cost per lamp is $12 a) What is the EOQ? 142 lamps per order (round your response to the nearest whole number). b) What are the total annual costs of holding and ordering (managing) this inventory? $ 1,697 (round...
a) What is the economic order quantity? _______ units (round
your response to the nearest whole number).
b) What are the annual holding costs? $_________(round your
response to the nearest whole number).
c) What are the annual ordering costs? $__________ (round
your response to the nearest whole number).
d) What is the reorder point? _______ units (round your
response to the nearest whole number).
Score: 1.5 of 2 pts 10 of 24 (23 complete) w score: 77.62% , 33.38 .....
Most questions answered within 3 hours.
-
Eleanor and Kyoko are roommates. They spend most of their time
studying (of course), but they...
asked 3 minutes ago -
Answer the questions
1.What is the value of a stock based on the dividend-growth
model if...
asked 4 minutes ago -
Per the Barron's report the average weeks unemployed is 21.5
(population mean) with a population standard...
asked 23 minutes ago -
1.. All following elements have been identified as
important to supporting school’s level of involvement with...
asked 6 minutes ago -
A hypothesis test is used to test the hypotheses H0:
μ = 10.5 versus HA: μ...
asked 33 minutes ago -
8.41- From a list of the 729 people who went on a cruise, 25
were randomly...
asked 51 minutes ago -
A derrick boat approaches a two-mile marker 100 m ahead at a
velocity of 29.0 m/s....
asked 19 minutes ago -
Given the following enthalpy change values for the reactions
below:
A + 2B → C ;...
asked 20 minutes ago -
Chapter 12 looks at nutrients
involved in blood health and immunity. Which nutrients are
important here, and why?...
asked 22 minutes ago -
If your initial bet was $5, your second bet
must be $10, then $15, etc. If...
asked 55 minutes ago -
Draw both the monomer and polymer structures of the following
polymers
Nylon 6,6
Poly(ethylene terephthalate)
asked 54 minutes ago -
A ball of mass .5 kg initially at rest is kicked directly toward
a fence from...
asked 36 minutes ago