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 sold a 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 What is the optimal order quantity of brushes (5 marks) What is the optimal number of orders per year (5 marks) Compute the period that most closely matches this EOQ (5 marks) What value of z should be used if A1 wishes to achieve a cycle service level of 98 percent (5 marks) 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 (10 marks)

The Answer is in the image, click to view ...

Question: 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

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 sold a 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.

What is the optimal order quantity of brushes? (5 marks)
What is the optimal number of orders per year? (5 marks)
Compute the period that most closely matches this EOQ. (5 marks)
What value of z should be used if A1 wishes to achieve a cycle-service level of 98 percent? (5 marks)
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? (10 marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

"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....

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...

Hello. I am looking for help with this problem set. Activity 4.5 - Module Problems Complete the following problems and submit the results in either a Microsoft Word document or a Microsoft Excel...

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....

Briefly discuss the cost-volume-profit analysis model and how it is used. Use the attached PDF. APA Citation. 300 words. REVISED PAGES 3 Chapter Three 1 Fundamentals of Cost-Volume-Prot Analysis...

You can submit an Excel file to support calculations, but please ?cut and paste? your solutions into the Word or PDF file. Be sure to show how you did your calculations. ACT 5140 - Accounting for...

How can leasing allow a firm to effectively depreciate land?

Calculate the missing statement of financial position amounts in each of the following independent situations: S 600,000 $180,000 S 990,000 Current assets Non-current assets Total assets Current...

Explain patient cost shares: deductibles, copayments and coinsurance What are their impacts on reimbursement to the provider? How will Knowing the differences between each patient cost share and...

Use an electronic calculator equipped with a natural logarithm function to evaluate each of the following. 1.01-120 In 850 0.01

Write an essay explaining what you would most like to see changed about our divorce laws.

Quail Corporation was created six years ago through contributions from Kasha ($900,000) and Frank ($100,000). In a transaction qualifying as a reorganization, Quail exchanges all of its assets...

1. The assessment center approach to employee selection relies heavily on ____________ to evaluate a candidates job skills. (a) intelligence tests (b) simulations and experiential exercises (c) 360...

State three real-world variables X, Y, and Z for which you expect a marginal association between X and Y but conditional independence controlling for Z.

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

=+d) Which type of error might customers consider more serious?

=+35. Cars, again. As in Exercise 33, state regulators are checking up on repair shops to see if they are certifying vehicles that do not meet pollution standards.

=+b) Explain in this context what happens if the quality control people commit a Type I error.