Question

In: Statistics and Probability

The VP for Fite's Footballs has asked you to perform an audit of inventory levels for...

The VP for Fite's Footballs has asked you to perform an audit of inventory levels for a different region. The inventory manager was recently terminated and you need to determine the appropriate safety stock for each item. Management has set the service level at 85%. Given the data below, what would the FILL RATE be for the following item?

Price $100
Annual Demand 156,000 units
Cost per Order $200
Cost to hold the item per year 25%
Economic order quantity 1580
Lead Time 3 weeks
Standard Deviation of Forecasted Demand During Lead Time 200

choose the correct answer:

Fill Rate = 98.2%

Fill Rate = 98.4%

Fill Rate = 98.6%

Fill Rate = 99.0%

Fill Rate = 99.3%

Solutions

Expert Solution

Answer:

Here some data is missing in the above queston i can Assume the data to solve this problem to find fill rate.

Price= P= $100

Annual Demand = D=156,000 units

Cost per Order = Co= $200

Holding cost = Ch = 25% *100 = $ 25

Economic order quantity = Q= 1580

Lead Time = 3 weeks

Standard Deviation of Forecasted Demand During Lead Time = σL = 200

CSL = 85% which gives value of Z as -

Z = NORMSINV (85%) = 1.036

Safety stock = SS = Z*σL = 1.036 * 200 = 207.2

Expected shortage = ESC = - SS [1 - NORMDIST(SS /σL,0,1,1)] + σL * NORMDIST(SS /σL,0,1,0)

=-207.2[1-NORMDIST(1.036,0,1,1)] + 200 *NORMDIST(1.036,0,1,0)

=-207.2 *0.150 + 200*0.233

= -31.08 + 46.6

=15.52

Fill rate = fr = (Q - ESC) / Q

= (1580-15.52)/1580

=0.990

Fill rate = fr = 99.0 %

NOTE:: I HOPE THIS ANSWER IS HELPFULL TO YOU......**PLEASE SUPPORT ME WITH YOUR RATING......

**PLEASE GIVE ME "LIKE".....ITS VERY IMPORTANT  FOR,ME......PLEASE SUPPORT ME .......THANK YOU


Related Solutions

2) The Audit firm Dewy, Cheatham, & Howe has been asked to perform an attest audit...
2) The Audit firm Dewy, Cheatham, & Howe has been asked to perform an attest audit of Seriously Crook Puppy Investments (SCPI) Ltd (an investment firm that has been registered with ASIC for 10 years). Your early assessment of SCPI Ltd indicates that it has a high-risk business environment (0.85), poor to none existent internal controls (0.95), and the detection of problems during any reasonable level of audit is very poor (0.75). Required: a) List and discuss what you need...
The VP of the company you work for has asked you to evaluate the proposed acquisition...
The VP of the company you work for has asked you to evaluate the proposed acquisition of a new chromatograph for the firm’s R&D department. The equipment's basic price is $90,000, and it would cost another $13,500 to modify it for special use by your firm. The chromatograph, which falls into the MACRS 3-year class, would be sold after 3 years for $22,500. The MACRS rates for the first 3 years are 0.3333, 0.4445 and 0.1481. Use of the equipment...
QUESTION 4 An Engagement supervisor has asked the audit senior to perform the following procedures related...
QUESTION 4 An Engagement supervisor has asked the audit senior to perform the following procedures related to an engagement. For each procedure listed, identify the financial statement assertion being tested by selecting the appropriate option from the list provided. Each item is used only once.       -       A.       B.       C.       D.       E.       F.       G.       H.    Trace beginning balances for inventory to prior...
Heraklion Co is a manufacturer of footballs and is a new audit client for your firm....
Heraklion Co is a manufacturer of footballs and is a new audit client for your firm. You are an audit supervisor of Spinalonga & Co. and are currently preparing for the forthcoming interim and final audit for the year ending 31 October 2016. You are required to document and assess the sales system, recommend control improvements to deal with a specific fraud issue as well as undertake substantive testing of revenue. Sales ordering, goods dispatched and invoicing Heraklion Co sells...
Ken Smith, the partner in charge of the audit of Houghton Enterprises, has asked you to...
Ken Smith, the partner in charge of the audit of Houghton Enterprises, has asked you to join the audit team that is planning an audit of tjis client that the firm has audited for the last four years. As part of the planning process, it was learned that the client recently adopted an IT-Based Accountingsystem to replace its manual system. You have been asked to consider the audit implications of this change. Required Briefly explain in two to three sentences...
manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the...
manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex Company Comparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 1,040,000 $ 1,280,000 Marketable securities 0 300,000 Accounts receivable, net 3,020,000 2,120,000 Inventory 3,680,000 2,300,000 Prepaid expenses 270,000 210,000 Total current assets 8,010,000 6,210,000 Plant and equipment,...
You have been hired as a CPA to perform an audit of an entity. You do...
You have been hired as a CPA to perform an audit of an entity. You do not have any evidence that suggests the organization is a government organization. No evidence suggests that the government has the power to dissolve of the entity. All net assets are allocated to among different entities, which do not revert to a government. Additionally, it does not seem that the organization has the power to enact a tax levy. Analyze the organization to determine if...
As the internal audit team lead for IT Audit, you have been asked to utilize COBIT...
As the internal audit team lead for IT Audit, you have been asked to utilize COBIT as a framework to a Case where a dental wholesale distributor lost in revenue when the IT department use Pear P-Phone as a platform to build a new order entry system. Use COBIT framework to justify your responses.
a construction company that you work for asked you to perform an economic study to determine...
a construction company that you work for asked you to perform an economic study to determine if it would be desirable to purchase a new road master scraper . you have assembled the following information . a new road master will cost $40000 and will have a service life of 20 years if a good maintenance plan is followed. maintenace operating cost wil amount to $12000 for year one and will increase $6000 each year that is in use .the...
a. Hilmi and Partner has been engaged to perform an audit for Asian Bin Bhd for...
a. Hilmi and Partner has been engaged to perform an audit for Asian Bin Bhd for the year ended 31 December 2018. While finalizing the audit, you noted that the net profit is MYR 450,000 in the directors’ report compared with MYR 500, 000 in the Statement of Comprehensive Income. Based on your discussion with the management, you find out that the difference is due to an adjustment to inventory adjustment, you have made the necessary adjustment. However, the directors...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT