Phillip Flamm's Computer Store in Texas sells a printer for $150. Demand is constant during the year, and annual demand is forecasted to be 960 units. Holding cost is $10 per unit per year, whereas the cost of ordering is $50 per order. Currently, the company is ordering 12 times per year (80 units each time). There are 250 working days per year, and the lead time is 13 days.

Phillip Flamm's Computer Store in Texas sells a printer for $150. Demand is constant during the year, and annual demand is forecasted to be 960 units. Holding cost is $10 per unit per year, whereas the cost of ordering is $50 per order. Currently, the company is ordering 12 times per year (80 units each time). There are 250 working days per year, and the lead time is 13 days.

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: William Beville's computer training school, in Richmond, stocks workbooks with the following…

A: The optimal quantity a business should acquire to reduce its inventory expenses, such as shortfall…

Q: Race One Motors is an Indonesian car manufacturer. At its largest manufacturing facility, in…

A: Given data: Annual Demand (D) = 12,500 Working days in a year =250 Ordering cost (S) = $30.00 per…

Q: Rick Jerz is attempting to perform an inventory analysis on one of his most popular products. Annual…

A: Annual demand, d =5000 units Carrying cost, h =$50 per unit per year Ordering cost, o =$30 per order…

Q: William Beville's computer training school, in Richmond, stocks workbooks with the following…

A: The economic order quantity (EOQ) is a optimal order quantity where logistics costs, stock outs,…

Q: Rick Jerz is attempting to perform an inventory analysis on one of his most popular products. Annual…

A: From the above given information, Annual demand, d =5000 units Ordering cost, o =$30 Holding cost, h…

Q: Are the following statements true Or false; 1) Pipe line inventory never depends on ordered…

A: "In the pipeline" denotes something that will happen soon. In the context of inventory management,…

Q: Matthew Liotine's Dream Store sells water beds and assorted supplies. His best-selling bed has an…

A: EOQ FormulaWhere:D is the annual demand for the product.S is the ordering cost per order.H is the…

Q: a) The EOQ for the workbooks is (round your response to the nearest whole number).

A: Economic order quantity refers to the volume of production that the business should add in order to…

Q: An office supply store open five days a week must determine the best inventory policy for boxes of…

A: Find the given details below:

Q: M. Cotteleer Electronics supplies microcomputer circuitry to a company that incorporates…

A: To minimize the costs, I will determine the optimal order quantity, Next, I will determine the…

Q: For fixed order quantity inventory system, which of the following costs is increased when order size…

A: Both (b) and (c)(b)ordering cost(c)start-up quality cost

Q: William Beville's computer training school, in Richmond, stocks workbooks with the following…

A: Let's delve deeper into the concepts and calculations involved in solving this inventory management…

Q: Thomas Smith is the purchasing manager for the headquarters of a large insurance company chain with…

A: Below is the solution:-

Q: Matthew Liotine's Dream Store sells water beds and assorted supplies. His best-selling bed has an…

A: Given-

Q: A disadvantage of the fixed-period inventory system is that: A It involves higher ordering costs…

A: The fixed-period inventory system involves making orders based on a set review period, such as…

Q: 12.8 Madeline Thimmes's Dream Store sells water beds and assorted supplies. Her best-selling bed has…

A: Given,Annual Demand = 400 units Ordering Cost = $40, holding Cost = $5 per unit per yearSo, to…

Q: Mattress Firm sells water beds and assorted supplies. Their best-selling bed has an annual demand…

A: Given- Annual demand (D) = 395 units Ordering cost (S) = $43 Holding cost (H) = $5 per unit per…

Q: To minimize the cost, how many units should be ordered each time an order is placed? What is the…

A: Inventory management stands as a critical facet within the supply chain and operations, focusing on…

Q: Weekly Mean of 25. Weeklly standard Deviation is 7. Ordering cost per order is $20. cost per…

A: Given- Weekly Mean demand = 25 units Ordering cost (S) = $20 per order Cost per balloon = $5 Holding…

Q: The electrolyte drink for our beloved NMSU soccer team average normally distributed demand of 5…

A: The reorder point (ROP) can be defined as a degree of stock which triggers an activity to recharge…

Question

Operation mangement

a) Given the current policy of ordering 80 units at a time, the total of the annual ordering cost and the annual holding cost is $_____(round your response to the nearest whole number).

b and c in image

Phillip Flamm's Computer Store in Texas sells a printer for $150. Demand is constant during the year, and annual demand is forecasted to be 960 units. Holding cost is $10 per unit per year, whereas the cost of ordering is $50 per order. Currently,
the company is ordering 12 times per year (80 units each time). There are 250 working days per year, and the lead time is 13 days.

b) If the company used the absolute best inventory policy, the total of ordering and holding cost is $ (round your response to the
nearest whole number).
c) The reorder point is units (round your response to the nearest whole number).

Expert Solution

This question has been solved!

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

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: Given details:

VIEW

Step 2: Calculations:

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

K William Beville's computer training school, in Richmond, stocks workbooks with the following characteristics: Demand D 19,400 units/year Ordering cost S $27/order Holding cost H $5/unit/year a) The EOQ for the workbooks is 458 (round your response to the nearest whole number) b) What are the annual holding costs for the workbooks? $ (round your response to the nearest whole number).
← William Beville's computer training school, in Richmond, stocks workbooks with the following characteristics: Demand D 19,400 units/year Ordering cost S $27/order Holding cost H $5/unit/year a) The EOQ for the workbooks is 458 (round your response to the nearest whole number). b) What are the annual holding costs for the workbooks? $ 1145 (round your response to the nearest whole number). c) What are the annual ordering costs? $ (round your response to the nearest whole number).
Thomas Kratzer is the purchasing manager for the headquarters of a large insurance company chain with a central inventory operation. Thomas’s fastest-moving inventory item has a demand of 6,000 units a year. The purchasing cost of each unit is $16 (additional 5% discount applies if at lease 150 units ordered a time), and the inventory carrying cost is $3 per unit per year. The average ordering cost is $10 per order. It takes about 3 working days for an order to arrive. (This is a corporate operation, and there are 300 working days per year.) Answer the following questions, Q1~Q5. Note that you must include Excel formulas/calculations showing how you arrive at the answer. Q1: Assume that the demand is consistent throughout the year. What is the ROP? Note that stockouts and unnecessary inventory holding should be avoided at any times. Q2: Assume that the demand is consistent throughout the year. Based on the EOQ model, to minimize the costs of purchasing, ordering and inventory holding…
Manipulation Manufacturing Company uses 1,000 units of Chip annually in its production. Order costs consist of P10 for placing a long-distance call to make the order and P40 for delivering the order by truck to the company warehouse. Each Chip costs P100 and the carrying costs are estimated at 15.625% of the inventory cost. If the EOQ for Chip is 80 and the total ordering cost is P625. Compute for the Total Carrying Costs.
The optimal solution of this linear programming problem is at the intersection of constraints 1 and 2. Max 6x1 + 3x2 s.t. 4x1 + x2 ≤ 400 4x1 + 3x2 ≤ 600 x1 + 2x2 ≤ 300 x1, x2 ≥ 0 (a) Over what range can the coefficient of x1 vary before the current solution is no longer optimal? (Round your answers to two decimal places.) ------ to -------- (b) Over what range can the coefficient of x2 vary before the current solution is no longer optimal? (Round your answers to two decimal places.) ----- to -------- (c) Compute the dual value for the first constraint, second constraint & third constraint
Matthew Liotine's Dream Store sells water beds and assorted supplies. His best-selling bed has an annual demand of 405 units. Ordering cost is $38; holding cost is $5 per unit per year. a) To minimize the total cost, how many units should be ordered each time an order is placed? EOQ = units (round your response to the nearest whole number). b) If the holding cost per unit was $6.00 instead of $5, what would the optimal order quantity be? New EOQ = units (round your response to the nearest whole number). A
Abey Kuruvilla, of Parkside Plumbing, uses 1,250 of a certain spare part that costs $26 for each order, with an annual holding cost of $27. a) Calculate the total cost for order sizes of 25, 40, 50, 60, and 100 (round your responses to two decimal places). b) What is the economic order quantity? units (round your response to two decimal places).
Annual demand (D) is 49,000 units. Ordering Cost (S) is $1,000 per order. Holding cost (H) is $2 per unit per year. Find economic order quantity (Q*). 7,000 units 49,000,000 units 4,950 units 3,500 units 4,083 units
William Beville's computer training school, in Richmond, stocks workbooks with the following characteristics: a) The EOQ for the workbooks is (round your response to the nearest whole number). b) What are the annual holding costs for the workbooks? $ (round your response to the nearest whole number). c) What are the annual ordering costs? $ (round your response to the nearest whole number). Demand D Ordering cost S Holding cost H 19,300 units/year $24/order $4/unit/year
If Sarah wants to minimize inventory holding and ordering costs, how much Palm oil should she purchase with each order (in kgs)?
If annual demand is 12,000 units, annual holding cost is $15 per unit, and setup cost per order is $25, what is the EOQ lot size?
Regional Supermarket is open 360 days per year. Daily use of cash register tape averages 10 rolls. Usage appears normally distributed with a standard deviation of 2 rolls per day. The cost of order-ing tape is $1, and carrying costs are 40 cents per roll a year. Lead time is three days. a. What is the EOQ?b. What ROP will provide a lead time service level of 96 percent?