Question: Artists' Advantage sells painting supplies. The most basic brush for watercolors, the T100, sells 2,080 per year. The order cost is $30 per order, and

Artists' Advantage sells painting supplies. The most basic brush for watercolors, the T100, sells 2,080 per year. The order cost is $30 per order, and the holding cost is $3.00 per box. The lead time for an order is 3 weeks, and the standard deviation of demand is 6 boxes per week.
a. What is the optimal order quantity of brushes?
b. What is the optimal number of orders per year?
c. Compute the period that most closely matches this EOQ.
d. What value of z should be used if Al wishes to achieve a cycle-service level of 98 percent?
e. Using the period from part c, compute the target inventory level T. How much safety stock of brushes does this provide? How does this compare to the safety stock if a continuous review system is used?

Step by Step Solution

★★★★★

3.32 Rating (170 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Artists Advantage a b Orders per year c The period that most closely matches this i... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

792-B-M-L-S-C-M (4558).docx

120 KBs Word File

Students Have Also Explored These Related Management Leadership Questions!

Al Kitchens, Inc., installs kitchen cabinets, countertops, and floors. Al uses 30,000 tubes of caulk per year (assume 50 weeks per year) in the installation process. The order cost is $24 per order,...

Smallville Bus System provides public transportation to the residents of Smallville. The maintenance department manages 1,000 buses and faces annual demand for 2,166 tires. The order cost is $50 per...

An electronics retailer carries a particular cellular telephone with the following characteristics: Average monthly sales = 120 units Ordering cost = $25 per order Carrying cost = 35 percent per year...

"Artists' Advantage" sells painting supplies. 2080 units of the most basic brush for watercolors, the T100, are sold a year. The order cost is $30 per order, and the holding cost is $3.00 per box....

In EXCEL FORMULA PLEASE Artists Advantage sells painting supplies. 2080 units of the most basic brush for watercolors, the T100, are sold a year. The order cost is $30 per order, and the holding cost...

"Artists' Advantage" sells painting supplies. 2080 units of the most basic brush for watercolors, the T100, are sold a year. The order cost is $30 per order, and the holding cost is $3.00 per box....

Directions: Solve the following problems and submit the solutions in Microsoft Excel. "Artists' Advantage" sells painting supplies. 2080 units of the most basic brush for watercolors, the T100, are...

"Artists' Advantage" sells painting supplies. 2080 units of the most basic brush for watercolors, the T100, are sold a year. The order cost is $30 per order, and the holding cost is $3.00 per box....

Marketing Math Student Workbook Carla's Cookie Company Use the information in the table below to calculate the financial metrics for each scenario. Scenario 1: all cookies sold individually for...

What two career paths do most experienced professionals take when moving into the information security discipline? Are there other pathways available? If so, describe them.

Use an incidence matrix to represent the graphs in Exercises 13-15. In Exercise 13-15 b

Why do FIs face a return or interest earnings penalty by holding large amounts of assets such as cash, T - bills, and T - bonds to reduce liquidity risk? Question 8 options: 1 ) These assets carry a...

How do you tell SAS and Stata where a line ends, by default?

What is the purpose of the EOQ and the ROP? How can they be used together?

What are the assumptions of the EOQ model?

What are the two major costs considered in the EOQ model? Why is the total purchase price not a factor affecting the order quantity?

Answers are given in blue. Please solve only using Excel Functions. Any other explanation other than excel will be rejected. \f\f\f\f

BKE manufactures carbon capture modules. The firm does not currently pay a dividend and uses all company profits to expand a company-owned lithium mine. Analysts expect BKE to pay a dividend of $1.25...

Becker Industries is considering an all equity capital structure against one with both debt and equity. The all equity capital structure would consist of 26,000 shares of stock. The debt and equity...