Inventory and cost of goods sold

Assignment Help Business Management
Reference no: EM13861555

Inventory

1. Topeka tool Works reports the monthly values for its inventory and cost of goods sold for the most recent twelve months as follow:

Month

Inventory ($ 000)

Cost of Goods Sold ($ 000)

Month

Inventory ($ 000)

Cost of Goods Sold ($ 000)

January

1550

1225

July

1250

1100

February

1850

2150

August

1400

1150

March

1300

1550

September

1700

1700

April

1400

975

October

1800

1350

May

2000

1350

November

1200

1400

June

1650

1550

December

900

1000

Calculate the company's inventory turnover.

2.  A company uses ABC analysis to help manage its inventory. Its current stock of inventory reflects the following items, item value, and quantity. Which items would you classify as A items? As B items? As C items?

Item Part #

Item Price

Quantity In Stock

142-AZ

$546.00

318

4392-GF

$45.00

1250

86935-ES

$15.35

3546

173-DC

$653.00

1876

999-BA

$199.00

526

7846-NM

$23.00

973

2765-OP

$385.00

790

103-VX

$12.50

4875

2648-YT

$16.75

5185

3. Compute the total annualized inventory holding and ordering costs when the cost per order (S) is $75, the annual demand (D) is 120,000, the annual carrying charge (i) is 25%, the order quantity (Q) is 1200, and the item's cost is $50.

4. A coffee shop uses approximately 250 pounds of a particular type of coffee every week. The shop is open 52 weeks a year. The annual carrying charge for the coffee is 20%. If 1 pound of coffee costs the shop $12.00 and the cost associated with each order is $39, how many pounds of this coffee should be ordered each time an order is placed in the shop wants to minimize its total annualized inventory-related costs?

5. The following quantity discount is offered to a company that purchases 120,000 units of the product annually.

Order  Quantity Price per Unit

0-1999

$50

2000-3999

$49

4000 or more

$46

Each time an order is placed, the company incurs a cost of $75. If the company's carrying charge is 25% of the price of the item, what order quantity should it use to minimize its total inventory-related costs?

6. Dayton Electronics demands a part at a daily rate of 40 units. The lead time for replenishment is four days for this item. The standard deviation of demand during the lead time is 8. Dayton Electronics prides itself on having a high level of customer service and strives to achieve a service level of 99%. How much safety stock should Dayton Electronics hold for this item?

Reference no: EM13861555

Questions Cloud

Analyzing the article - materialism and consumer ethics : You are required to present your summary and analysis in a PPT presentation that should include the following: Introduction and context of the article / Research question and objectives / important concepts / methodology / Main findings / your opi..
Calculate and plot lift given a set of data : Calculate and plot lift, given a set of data, and analyze optimal policy. Analyze the data to determine the optimal policy for enhancing profitability.
Capital is on the vertical axis of isoquant map : Walmart is laying off cashiers, and increasingly adopting the policy where customers must use self checkout or pay a fee. Jason Clarke is the manager of a Walmart. There are 20 cashiers and 8 self-checkout stations in this store to serve 1000 custome..
How do you explain the use of time value of money : How do you explain the use of time value of money
Inventory and cost of goods sold : 1. Topeka tool Works reports the monthly values for its inventory and cost of goods sold for the most recent twelve months as follow:
Interested in buying two types of goods : Sam is interested in buying two types of goods, x and y. He can either use all his income to buy 3 units of x and 9 units of y, or 9 units of x and 3 units of y. If he spends all his income on x, how many units can he buy?
How do these test results affect lesson planning : How do state ELL proficiency tests, such as the AZELLA (AZ) or the WIDA (other states), guide data-informed decision making? How do these test results affect lesson planning
Substitution effects associated with an increase in price : Suppose a consumer spends her income on lobster and frozen pizza. Assume that the consumer has an income of $600, the price of lobster is $50, and the price of frozen pizza is $6. Using indifference curves and budget constraints show the income and s..
Product cycle hypothesis-industrialized economy : According to the product cycle hypothesis, a product will be produced only in an industrialized economy. When

Reviews

Write a Review

Business Management Questions & Answers

  Caselet on michael porter’s value chain management

The assignment in management is a two part assignment dealing 1.Theory of function of management. 2. Operations and Controlling.

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. Due to increase in the preference for light beer drinkers, Chris Prangel wants to introduce light beer version in Mountain Man. An analysis into the la..

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. An analysis into the launch of Mountain Man Light over the present Mountain Man Lager.

  Analysis of the case using the doing ethics technique

Analysis of the case using the Doing Ethics Technique (DET). Analysis of the ethical issue(s) from the perspective of an ICT professional, using the ACS Code of  Conduct and properly relating clauses from the ACS Code of Conduct to the ethical issue.

  Affiliations and partnerships

Affiliations and partnerships are frequently used to reach a larger local audience? Which options stand to avail for the Hotel manager and what problems do these pose.

  Innovation-friendly regulations

What influence (if any) can organizations exercise to encourage ‘innovation-friendly' regulations?

  Effect of regional and corporate cultural issues

Present your findings as a group powerpoint with an audio file. In addition individually write up your own conclusions as to the effects of regional cultural issues on the corporate organisational culture of this multinational company as it conducts ..

  Structure of business plan

This assignment shows a structure of business plan. The task is to write a business plane about a Diet Shop.

  Identify the purposes of different types of organisations

Identify the purposes of different types of organisations.

  Entrepreneur case study for analysis

Entrepreneur Case Study for Analysis. Analyze Robin Wolaner's suitability to be an entrepreneur

  Forecasting and business analysis

This problem requires you to apply your cross-sectional analysis skills to a real cross-sectional data set with the goal of answering a specific research question.

  Educational instructional leadership

Prepare a major handout on the key principles of instructional leadership

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd