Preview

A Report on Inventory Management

Satisfactory Essays
Open Document
Open Document
864 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
A Report on Inventory Management
“Scientific Glass - Inventory Management” study case

1. How much funding will have to be raised in 2010 in order to finance the increase in inventory?
Generally, the budget of inventory has positive correlation with the forecast of the turnover. As the case concerns, the finance department forecast 20% growth in sales in 2010 due to a forecast cast increase in the number of orders. Consequently, the cost of finished goods inventory in 2010 should get 20% increase on the basis of inventory cost in 2009. Moreover, the increase rate of raw material inventory should be more than 20%, thus, we assume it at 25%.
Furthermore, the cost of adding one distributor is $750,000, so the total cost of three distributors is $2.25MM. All in all, the inventory budget in 2010 should be:
2.18*(1+25%)+6.54*(1+20%)+2.25=$12.82MM

2. Analyze the inventory value and cost impact of the different options proposed by Eric, Melissa, and Ava:
The results of our calculations applicable for this question are included in the Exhibit of the report.
a) Implementation of the Policy Changes (reducing inventory of overstocked products, eliminating trunk stock, and reducing inventory write-offs)
For the calculation of the effect of implementing the policy changes, we assumed that the enforcement of the 99% service level through reduction of inventory of overstocked products would affect inventory of all finished goods and subsequently the inventory of raw materials needed to produce finished goods by the given 5%. The inventory needed for the three new distributors would not be affected, however, as it is stated in the case, this amount is needed to ensure distributors effectively push product sales. Furthermore, we assumed that the 32 sales employees made use of the highest possible amount of trunk stock ($10,000 each) to realize as many sales as possible.
For the implementation of the policy changes in total the reduction of inventory value amounts to $372,320, the reduction in inventory costs

You May Also Find These Documents Helpful

  • Good Essays

    Baseball Card Emporium (BBE) of Lewistown, Pennsylvania, is a distributor of baseball cards to sports card retailers. Its market area encompasses most of Pennsylvania, eastern Ohio, and New Jersey. The cards are printed in Neenah, Wisconsin, and currently shipped to Lewistown via motor carrier transportation. Kenny Craig, vice president of logistics, has asked his staff to evaluate using air carrier service to ship the cards.…

    • 408 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Acc 422 E9-1 & E9-12

    • 383 Words
    • 2 Pages

    (b) Determine the inventory by the lower-of-cost-or-market method, applying the method to the total of the inventory. $340,500…

    • 383 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Jack Jones, the materials manager at Precision Enterprises, is beginning to look for ways to reduce inventories. A recent accounting statement shows the following inventory investment by category: raw materials, $3,129,500; work-in-process, $6,237,000; and finished goods, $2,686,500. This year’s cost of goods sold will be about $32.5 million. Assuming 52 business weeks per year, express total inventory as…

    • 1629 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    Business Memo-Accounting

    • 459 Words
    • 2 Pages

    I created three scenarios to the original data case. In scenario 1, I make sales volume increased by 10%, compared with making sales volume fell by 10%, and it turns out that 10% increase in sales units also increase the production cost, direct-labor cost and manufacturing over-head. As well, 10% decrease in sales will cause decreases in the company’s cost. In scenario2, the company changes the policy of the end-of-month inventory. It is obvious that it almost make no changes in all of the three kinds of costs. So a new inventory policy can be carried out to not increasing the costs and at the same time meet the market needs. In scenario3, I assume that employee medical insurance increases 5 times and not install the new equipment. From the budget schedules, it shows us that the direct-labor cost increases fiercely, but the manufacturing cost remains the same level. It indicated that new equipment helps a lot decrease…

    • 459 Words
    • 2 Pages
    Good Essays
  • Good Essays

    QAT1 Task 3 309

    • 611 Words
    • 3 Pages

    *Holding cost is the per unit cost of inventory multiplied by the holding cost rate…

    • 611 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Finally, alternative 3 and 4 are recommended. In addition, there are some aspects to be noticed during the short-term and long-term implementation. It is recommended for the company to bring down the age of inventory to near to the industry average by improve the inventory control system. Paul should pay attention to his personal financial condition. It is necessary for him to save some money and reduce the withdraw from Lawsons.…

    • 2224 Words
    • 15 Pages
    Powerful Essays
  • Satisfactory Essays

    During the year, Summit produces 50,000 snow shovels and sells 45,000 snow shovels. What is the value of ending inventory using full costing?…

    • 715 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    Loblaw Chapter 8

    • 4097 Words
    • 17 Pages

    In the report, we can find the cost of sales (24 185 million) that we add to the ending inventory (2 007 million) and then we have to subtract the beginning inventory (2025 million).…

    • 4097 Words
    • 17 Pages
    Good Essays
  • Good Essays

    4. What would be the impact on TCI’s external funding needs as of the end of 1996 if inventory were not reduced by the end of 1996?…

    • 1046 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Budget Outlook Report

    • 1047 Words
    • 3 Pages

    Mr. Chester thinks that “stock outs” occur too frequently and wants to understand the impact of increasing inventory levels of 30 and 40 percent of next quarter’s sales on their full investment. High inventory levels negatively affect cash flow as well as warehousing. Demand planning ensures available inventory as sales grow. Critical to meet customers’ need and expectations, Mr. Chester’s concern is well intended here. The ability to project such demands for products to meet and to ensure the availability as sales grow vital in keeping up with customers' needs. Nordmeyer, also suggest that a risk exist in term of cash flow, sales prices and warehousing capacity in the event that manufacturing capacity is…

    • 1047 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    3. Compute the total costs (order and inventory-holding costs) for a fixed quantity system (FQS) and compare to the current order Q’s (see exhibit 12.16 for order Q). Can you save money by adopting an FQS? ( 3 points)…

    • 379 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Inventory Management

    • 333 Words
    • 2 Pages

    1. Locate a firm that incorporates inventory management. Identify the type of inventory system (fixed order quantity system, fixed order period system, or a hybrid system) it uses.…

    • 333 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    To decrease the current inventory level and set up a more efficient inventory management system, two main alternatives should be considered. Firstly, related policies could be revised to alleviate this inventory problem; secondly, the warehouses could be rearranged and restructured to address the inventory issue. However, the first proposal of revising polices were found to be undesirable among sales managers as they believed it would undermine their influences on the…

    • 1251 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    Compute the accounts receivable balance before and after the change in the cash discount policy. Use the net sales (total sales2cash discounts) to determine the…

    • 494 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Case 2

    • 504 Words
    • 3 Pages

    1.What is the total annual cost of maintaining the components inventory under the present system?…

    • 504 Words
    • 3 Pages
    Good Essays

Related Topics