answer both parts A mall-order house uses 15,975 boxes a year. Carrying costs are 42 cents per box a year, and ordering costs are $99. The followingprice schedule applies.Number of Boxes1,000 to 1,9992,000 to 4,9995,000 to 9,99910,000 or moreClick here for the Excel Data FilePrice per Box$1.451.351.251.20a. Determine the optimal order quantity. (Round your answer to the nearest whole number.)Optimal order quantityNumber of orderboxesb. Determine the number of orders per year. (Round your answer to 2 decimal places.)per year

EOQ stands for economic order quantity. It is a company's optimal order quantity that undervalues…

Answered: a. Determine the optimal order…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter3: Introduction To Optimization Modeling

Section3.8: A Multiperiod Production Model

Problem 22P

See similar textbooks

Similar questions

Pingu Company manufactures winter jackets. Setup costs are $2.00. Penguin manufactures 4,000 jackets evenly throughout the year. Using the economic order quantity approach, the optimal production run would be 200 when the cost of carrying one jacket in inventory for one year is 0.40. The given solution is this: 200 = 2*setup cost* Annual Demand / Carrying cost200 = 2*2*4000/ Carrying cost40000 = 16000 / Carrying costCarrying cost = 16000 / 40000Carrying Cost = 0.4 Hence, the cost of carrying one jacket in inventory for one year is 0.4 QUESTION: How did you get the 40,000 (that was divided to 16,000)?
Instructions There are four parts to this problem. Use Excel to perform the following. a. Use the economic order quantity formula (EOQ = SQRT((2SD/H)) to determine the optimal number of units that the company should order based on each assumed level of order based on each assumed level of order quantities provided in the data. b. Complete the table by calculating the number of orders per year, annual order cost, annual holding cost, and annual total cost. Highlight the minimum annual total cost using conditional formatting. Hint: The minimum cost should equal the cost at the EOQ you calculated in part a. c. Create a line chart that graphs annual order cost, annual holding cost, and annual total cost. The x-axis should be the quantity ordered. Include a chart legend, appropriate chart title, axes labels, and properly formatted amounts on the axes. d. Examine the chart and your responses to parts a and b. Indicate any relationships.
The Economic Order Quantity (EOQ) model is a classical model used for controlling inventory and satisfying demand. Costs included in the model are holding cost per unit, ordering cost and the cost of goods ordered. The assumptions for that model are that only a single item is considered, that the entire quantity ordered arrives at one time, that the demand for the item is constant over time, and that no shortages are allowed. Suppose we relax the first assumption and allow for multiple items that are independent except for a restriction on the amount of space available to store the products. The following model describes this situation: Let Dj = annual demand for item j Cj = unit cost of item j Sj = cost per order placed for item j i = inventory carrying charge as a percentage of the cost per unit W = the maximum amount of space available for all goods wj = space required for item j The decision variables are Qj, the amount of item j to order. The model is:…
The Economic Order Quantity (EOQ) model is a classical model used for controlling inventory and satisfying demand. Costs included in the model are holding cost per unit, ordering cost and the cost of goods ordered. The assumptions for that model are that only a single item is considered, that the entire quantity ordered arrives at one time, that the demand for the item is constant over time, and that no shortages are allowed. Suppose we relax the first assumption and allow for multiple items that are independent except for a restriction on the amount of space available to store the products. The following model describes this situation: Let Dj = annual demand for item j Cj = unit cost of item j Sj = cost per order placed for item j i = inventory carrying charge as a percentage of the cost per unit W = the maximum amount of space available for all goods wj = space required for item j The decision variables are Qj, the amount of item j to order. The model is: (view…
The Economic Order Quantity (EOQ) model is a classical model used for controlling inventory and satisfying demand. Costs included in the model are holding cost per unit, ordering cost, and the cost of goods ordered. The assumptions for that model are that only a single item is considered, that the entire quantity ordered arrives at one time, that the demand for the item is constant over time, and that no shortages are allowed. Suppose we relax the first assumption and allow for multiple items that are independent except for a restriction on the amount of space available to store the products. The following model describes this situation: Let Dj = annual demand for item j Cj = unit cost of item j Sj = cost per order placed for item j i = inventory carrying charge as a percentage of the cost per unit W = the maximum amount of space available for all goods wj = space required for item j The decision variables are Qj , the amount of item j to order. The model is: In…
Fixed-order-interval. This type of problem can be recognized when an order interval is given (e.g.,inventory is ordered every 10 days) along with the demand rate, lead time, and quantity on hand atorder time. Use Formula 13–16 to find the optimal order size.A lab orders a number of chemicals from the same supplier every 30 days. Lead time is five days.The assistant manager of the lab must determine how much of one of these chemicals to order. Acheck of stock revealed that eleven 25-milliliter (ml) jars are on hand. Daily usage of the chemical isapproximately normal with a mean of 15.2 ml per day and a standard deviation of 1.6 ml per day. Thedesired service level for this chemical is 95 percent.a. How many jars of the chemical should be ordered?b. What is the average amount of safety stock of the chemical?
c. Once you find the optimal order quantity i.e., EOQ, create a Data Table that generates inventory cost within ±100 units (with 10units increment) from the optimal order quantity. For example, if the EOQ=150, then you need to generate Data Table for inventory cost starting from 50 to 250 with 10 increments. Explain the exact steps completed in excel to create the data table d. Create a Scatter plot with “smooth lines” for the Data Table created in c) to show the inventory cost. Label your plot clearly (axis and title). The optimum order quantity should indicate the minimum cost in your plot.
Consider that you work at Kroger Grocery store, and that you've been tasked with creating an ABC inventory classification for 6 items. The 6 items, as well as their profit per case and number of cases sold per week, are as follows:Ribeye Steak - $135 in profit per case, 3 cases sold per weekLobster Tail - $245 in profit per case, 3 cases sold per weekPasta - $23 in profit per case, 12 cases sold per weekSalt - $3 in profit per case, 2 cases sold per weekNapkins - $12 in profit per case, 2 cases sold per weekTomato Sauce - $23 in profit per case, 11 cases sold per weekUsing total weekly profits, please classify each products into A, B, or C categories. Which items form the boundary of the class A and B items in your classification, and why? Which items form the boundary of the class B and C items in your classification, and why?
A distribution center (DC) in Wisconsin stocks Sony plasma TV sets. The center receives its inventory from a mega warehouse in Kansas with a lead time (L) of 5 days. The DC uses a reorder point (R) of 300 sets and afixed order quantity (Q) of 250 sets. The current on-hand inventory (OH) at the end of Day 1 is 400 sets, there are no scheduled receipts (SR), and there are no backorders (BO). Assume that all demands and receipts occur at the end of the day. The inventory position is compared to the reorder point after demands and receipts are accounted for. If necessary, an order is placed and the inventory position is updated. Given the demand schedule in the table below, determine when to order using a (Q) system
A mail-order house uses 16,870 boxes a year. Carrying costs are 60 cents per box a year, and ordering costs are $96. The following price schedule applies. Number of BoxesPrice per Box1,000 to 1,999$1.25 2,000 to 4,9991.20 5,000 to 9,9991.15 10,000 or more1.10 a.Determine the optimal order quantity. (Round your answer to the nearest whole number.) Optimal order quantity5000 boxes b.Determine the number of orders per year. (Round your answer to 2 decimal places.) Number of order per year
Skinner’s Fish Market buys fresh Boston bluefish daily for $4.10 per pound and sells it for $5.60 per pound. At the end of each business day, any remaining bluefish is sold to a producer of cat food for $1.60 per pound. Daily demand can be approximated by a uniform distribution between 180 and 350 pounds. The optimal order quantity is pounds (round your response to the nearest integer).
The maintenance department of a large hospital uses about 816 cases of liquid cleanserannually. Ordering costs are $12, carrying costs are $4 per case a year, and the new priceschedule indicates that orders of less than 50 cases will cost $20 per case, 50 to 79 caseswill cost $18 per case, 80 to 99 cases will cost $17 per case, and larger orders will cost $16per case. Determine the optimal order quantity and the total cost.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS

a. Determine the optimal order quantity. (Round your answer to the nearest whole number.) Optimal order quantity boxes b. Determine the number of orders per year. (Round your answer to 2 decimal places.) Number of order per year