Calculate the number of days of cost of goods sold held

Assignment Help Corporate Finance
Reference no: EM13839166

Question 1:

Lott Manufacturing, Inc. has been ordering parts for its production process in lots of 10,000 units. Each order costs the firm $50 to place and holding costs per unit aver $3. Lott uses 200,000 units every 250 days.

a. Calculate EOQ

b. What is the difference in inventory costs between the EOQ and the current order quantity of 10,000 units?

c. Given the EOQ calculated in part a., how many orders should be placed and what is the average inventory balance?

d. If it takes two days to receive an order from suppliers, at what inventory level should Lott place another order?

Must show all formulas and steps in solving equations.

Question 2:

Assuming order costs are $55 per order, total periodic demand is $100,000 units and the EOQ is 24,000 units, calculate the implied per unit holding cost?

Question 3:

Below is presented table of data for cost of goods sold and ending inventory for the first six months of 2012 for Wynn Manufacturing, Inc.

                                                DEC    JAN    FEB    MAR   APR   MAY  JUNE___________

Cost of goods sold                              1000    1500   2100   2700   3500   4800

Ending Inventory_________________300    _ 450      630      810 _ 1050__1440____________

You may assume that each month has 30 days

a. Calculate the number of days of cost of goods sold held in inventory for March, April, May, and June assuming quarterly cost of goods sold is used to calculate average daily costs of goods sold.

b. Discuss your findings in part a.  What is happening with the firm's investment in inventory?

c. Below is a purchasing schedule and a schedule showing the dollar amount of those purchases remaining as an inventory balance for successive months. Calculate a balance fraction matrix and discuss what it shows about the firm's management of its inventory balance.

                                                ENDING INVENTORY BALANCES

______________________PURCHASES_____FEB____MAR___APR____MAY____JUNE_

Feb                                          1650                330174

Mar                                          2280 456             234

Apr                                          2880                                                    576302

May                                         3740                                                                748402

June                                         5190                                                                                        1038

End of Month Inventory                                        NA           63081010501440_

Reference no: EM13839166

Questions Cloud

Discuss different types of investment appraisal methods : Discuss and compare the different types of investment appraisal methods My Velo can use, including a discussion of the advantages and disadvantages of each.
Richard dilemma : Bongo Plus was formed in February 2014 with the goal of selling advertising trinkets to local businesses. Bongo Plus is a small, privately­held company that does not yet have a Board of Directors. Bongo's main competitive advantage is that the com..
Understand the disease concept of dependence on alcohol : Participate in a motivational enhancement group; Understand the disease concept of dependence on alcohol, Learn the medical consequences of excessive alcohol use and Understand the process of recovery
Research on graph or table format : Using the Internet, the text, or another reliable source such as a newspaper or periodical site, (not a scholastic or school site like Khan Academy and not Wikipedia), research some important data that has been presented in graph or table format.
Calculate the number of days of cost of goods sold held : What is the difference in inventory costs between the EOQ and the current order quantity of 10,000 units - given the EOQ calculated in part a., how many orders should be placed and what is the average inventory balance?
Ater-tax income per year in retiremen : You are currently 27 years old and plan on retiring at age 67. Based on current life tables and family history,you anticipate living another 23 years after retirement (morbid but important to consider). You estimate that you will need $157,212 in aft..
Evaluation of cassie assessment plan : Consider what you have learned about effective, developmentally appropriate assessment so far in this course. Your evaluation of Cassie's assessment plan. Suggestions that you would make to Cassie regarding her plan
Describe a production environment : 1. Describe a production environment in which MRP would be useful. Describe a production environment in which not be useful.
What is a consequence of replacing manual harvesting : What is a consequence of replacing manual harvesting by mechanical harvesting?explain

Reviews

Write a Review

Corporate Finance Questions & Answers

  Impact of the global economic crisis on business environment

This paper reviews the article of ‘the impact of the global economic crisis on the business environment' that is written by Roman & Sargu (2011).

  Explain the short and the long-run effects on real output

Explain the short and the long-run effects on real output, price, and unemployment

  Examine the requirements for measuring assets

Examine the needs for measuring assets at fair value in accounting standards

  Financial analysis report driven by rigorous ratio analysis

Financial analysis report driven by rigorous ratio analysis

  Calculate the value of the merged company

Calculate the value of the merged company, the gains (losses) to each group of shareholders, NPV of the deal under different payment methods. Synergy remains the same regardless of payment method.

  Stock market project

Select five companies for the purpose of tracking the stock market, preparing research on the companies, and preparing company reports.

  Write paper on financial analysis and business analysis

Write paper on financial analysis and business analysis

  Intermediate finance

Presence of the taxes increase or decrease the value of the firm

  Average price-earnings ratio

What is the value per share of the company's stock

  Determine the financial consequences

Show by calculation the net present value for the three alternatives (no education, network design certification, mba). Also, according to NPV suggest which alternative you advise your friend to choose

  Prepare a spread sheet model

Prepare a spread sheet model for the client that determines NPV/IRR with and without tax.

  Principles and tools for financial decision-making

Principles and tools for financial decision-making. Analyse the concept of corporate capital structure and compute cost of capital.

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