Question: Please put in EXCEL format 1. Apply ABC analysis for the following items: Item Number Item Cost (5) 4.0 1.5 0.25 2.0 A111 B111 C111

Please put in EXCEL format 1. Apply ABC analysis Please put in EXCEL format

1. Apply ABC analysis for the following items: Item Number Item Cost (5) 4.0 1.5 0.25 2.0 A111 B111 C111 D111 E111 F111 G111 H111 I111 J111 K111 L111 Annual Usage (Unit) 2.500 7,500 4,000 1,300 850 2,000 800 6,000 1,100 3,500 1,900 1.200 0.75 3.7 16 | | 2. Weekly demand for a product is 250 units with a standard deviation of 60 units (assume 52 weeks per year). Lead-time is 3 weeks. Calculate the safety stock and the reorder point for 98 percent service level. 3. Using the data below, find the EOQ, the total annual cost associated with the economic order quantity, the reorder point, number of orders per year and the time between orders. Annual Demand Weeks Operating Set up Cost Holding rate Unit cost Lead-Time 1 15,600 units 152 weeks/year $60/order 20% $80/unit 5 weeks

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!

Please include excel formulas 1. Apply ABC analysis for the following items: Item Number Item Cost ($) Annual Usage (Unit) A111 4.0 2,500 B111 1.5 7,500 C111 0.25 4,000 D111 2.0 1,300 E111 55 850...

1. Apply ABC analysis for the following items: Item Number Item Cost ($) 4.0 A111 B111 C111 D111 E111 F111 G111 H111 1111 J111 K111 L111 1.5 0.25 2.0 55 5.5 0.75 1.7 Annual Usage (Unit) 2,500 7,500...

Apply ABC analysis for the following items: Item Number Item Cost ($) Annual Usage (Unit) A111 4.0 2,500 B111 1.5 7,500 C111 0.25 4,000 D111 2.0 1,300 E111 55 850 F111 5.5 2,000 G111 0.75 800 H111...

1. Apply ABC analysis for the following items: Item Number A111 B111 C111 D111 E111 F111 G111 H111 1111 J111 K111 L111 Item Cost | Annual Usage ($) (Unit) 4.0 2,500 1.5 7,500 0.25 4,000 2.0 1,300 55...

financial SUBDOMAINS: 325.4 COMMUNICATING EFFECTIVELY IN ORGANIZATIONS 326.1 MANAGING INTERNAL COST & CONTROLLING FINANCES 326.2 MANAGING CAPITAL & FINANCIAL ASSETS 326.4 MANAGING ENTERPRISE RISK &...

ALL DATA RELATES TO THE PERIOD UNDER CONSIDERATION IN THIS REVIEW, AND ACTUAL AND STANDARD COSTS PER UNIT ARE UNCHANGED FROM THE PREVIOUS PERIOD AYB225 ASSIGNMENT SEMESTER 1 2015 ALL DATA RELATES TO...

Need help with Management Accounting assignment (need excel part completed)!!! AYB225 ASSIGNMENT SEMESTER 1 2015 ALL DATA RELATES TO THE PERIOD UNDER CONSIDERATION IN THIS REVIEW, AND ACTUAL AND...

Looking for accounting tutor to complete this assignment. Need and A grade for reasonable price given easy deadline. AYB225 ASSIGNMENT SEMESTER 1 2015 ALL DATA RELATES TO THE PERIOD UNDER...

I need an Excel worksheet for the 5.0 section that is on my business proposal. It is for the pro forma based on the values in the income statement provided. Papa Geo's Restaurant Budget Proposal for...

With x01, x02, . . . , x0k and X0 as defined in Exercise 14.39 and Y0 being a random variable that has a normal distribution with the mean Î²0 + Î²1x01 + · ·...

1. A monopoly is inefficient solely because the monopolist gets a profit at the expense of consumers. ____________ (True/False) 2. To show the deadweight loss from monopoly, we compare the monopoly...

If the WACC decreases from year to year, does it mean the company is decreased in value?

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...