Preview

case analysis

Satisfactory Essays
Open Document
Open Document
349 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
case analysis
Silo Manufacturing Corporation

1. The cost for Ferguson’s 4 case proposal and Patrachalski’s 32 case proposal is exactly the same with a cost of $1,213,900.80.

2. Based on the lowest total annual cost, the order quantity Martin should recommend should be 170 units or 11.33 cases.

3. If order quantity is decreased to the nearest whole case then the total annual cost would change 2.9%. If order quantity is increased to the nearest whole case the annual cost would change 2.82%.

4. If vice president of Sales Steve Smith achieves his goal to increase sales by 9.6%, the cost to place an order would be $43.95.

5. If vice president of Sales Steve Smith achieves his goal to increase sales by 9.6% and Financial Comptroller Fred Ferguson achieves his goal of reducing the cost to carry inventory from 32% to 29.4% the cost to place an order would be $40.38.

6. If vice president of Sales Steve Smith achieves his goal to increase sales by 9.6% and Financial Comptroller Fred Ferguson achieves his goal of reducing the cost to carry inventory from 32% to 29.4% and purchasing director Peter Patrachalski achieves his goal of reducing the average cost per unit by 5.2%, then the cost to place an order would be $38.28.

7. If Davis implemented a just-in-time approach to ordering 1 unit at a time the cost to place an order would be $48.001667.

8. There first recommendation I would make in order to lower cost to place an order would be to reduce the supply base and narrow our suppliers down. By doing this, we will be able to get better deals on inventory and overall lower the ordering costs. The next recommendation I would make would be to utilize our bulk discounts. By ordering materials in higher quantity it reduces supply costs, overall shipping costs and increases productivity by lowering human interaction. The last recommendation I would make would be to estimate reserves accurately. This way there won’t be any year-end surprises and they won’t be way over or way

You May Also Find These Documents Helpful

  • Satisfactory Essays

    SCM 366 001 HW 1 and HW 2

    • 346 Words
    • 9 Pages

    Ordering Cost Sensitivity $ 500 $ 1000 $ 1500 $ 2000 $ 2500 $ 3000 $ $ 182.00 910.00 455.00 303.33 227.50 182.00 151.67 Holding Cost Sensitivity $ 525.00 500 $ 105.00 1000 $ 210.00 1500 $ 315.00 2000 $ 420.00 2500 $ 525.00 3000 $ 630.00 1,472 Annual Cost of Holding and Ordering = (13,000*x/500) + (500*$0.42/2) $900 = (13,000*x/500) + (500*$0.42/2) $900 = (26 *x) + $105 $900 - $105 = (26 *x) $795 = 26 * x x = $795 / 26 = 30.58 f. Scenario Demand Ratio Scenario 1 Scenario 2 Scenario 3 Scenario 4 Scenario 5 g. 0.25 0.5 1 2 4 Order Quantity 1000 2000 3000 4000 5000 Annual Ordering Costs $ 455 $ 228 $ 152 $ 114 $ 91 Annual Deamd EOQ 3,250 6,500 13,000 26,000 52,000 Annual Holding Costs $ 210.00 $ 420.00 $ 630.00 $ 840.00 $ 1,050.00 735.98 1040.83 1471.96 2081.67 2943.92 Total $ $ $ $ $ 665 648 782 954 1,141…

    • 346 Words
    • 9 Pages
    Satisfactory Essays
  • Powerful Essays

    JCT2 Task 1

    • 1659 Words
    • 8 Pages

    15,000 15,000 15,000 + Shipping 0 27,665 46,811 52,995 + Inventory Holding Costs 0 4,544 20,489 0 + Excess Capacity Cost 0 0 0 0 + Depreciation 0 45,833 91,667 137,500 =…

    • 1659 Words
    • 8 Pages
    Powerful Essays
  • Satisfactory Essays

    Acct 505 Project A

    • 281 Words
    • 2 Pages

    Total cash collections ... $436,000 $695,000 $865,000 $1,996,000 c. Merchandise purchases budget: Budgeted unit sales ..... 65,000 Add desired ending inventory (40% of the next month’s unit sales)................. 40,000 Total needs.................. 105,000 Less beginning inventory .................. 26,000 Required purchases...... 79,000 Cost of purchases at $4 per unit ................ $316,000 100,000 50,000 215,000 20,000 120,000 12,000 62,000 12,000 227,000 40,000 80,000 20,000 42,000 26,000 201,000 $320,000 $168,000 $ 804,000 d. Budgeted cash disbursements for merchandise purchases: Accounts payable .......... $100,000 April purchases ............. 158,000 May purchases .............. June purchases .............…

    • 281 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    A bakery buys sugar in 15-pound bags. The bakery uses 5000 bags of sugar each year. Carrying costs are $20 per bag per year. Ordering costs are estimated at $5 per order. Assume that the bakery is open 250 days a year and its daily demand is estimated at 20 bags. It takes 5 days for each order of sugar to be filled.…

    • 1687 Words
    • 12 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Gilles Laboratory

    • 473 Words
    • 2 Pages

    Inventory turns 12 x per yr or once per mo. Since15,000 cases of product are shipped to Columbus each month, the average inventory must be 15,000 cases @ $18.00/case = $270,000…

    • 473 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    week 3 db smitheford

    • 1165 Words
    • 4 Pages

    For a company the size of Smitheford Pharmaceutical inventory cost can be a large portion of the inventory value on hand. Inventory cost also known as ordering cost or carrying cost can be defined as the cost a company obtain to tore and maintain inventory over a certain time period ("Carrying Cost Of Inventory Definition | Investopedia," 2014).One way to reduce inventory cost is by Smitheford developing a great relationship with their vendor so delivery time can be decreased. Management can farther reduce cost by arranging terms with vendors that will support bringing inventory to a lower level.…

    • 1165 Words
    • 4 Pages
    Better Essays
  • Good Essays

    Flexible Budgets

    • 734 Words
    • 3 Pages

    Smith Wholesale’s budgeted sales price is $40 per unit for a budgeted sales volume of 5,000 units. The actual performance was 5,500 units at an average sales price of $39.75. The dollar amount of sales variance to the difference in actual and budgeted volume is a favorable variance of $.…

    • 734 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Skill Mgt

    • 265 Words
    • 2 Pages

    c. An inventory withdrawal of 10 pairs was just made. Is it time to reorder?…

    • 265 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    * Services related to inventory management are not included properly, since the percentage they gain is the same for all products. Whether they are cheap and efficiently to handle or rather problematic. Hence costs will skyrocket if customers will ask for additional services (while keeping the same price).…

    • 654 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    The accounts receivable and inventory carrying cost for the private-label brand is $175,789.97, $59,386.73 and $116,412.24 respectively. (Appendix 2)…

    • 498 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Supply Chain Management

    • 1921 Words
    • 8 Pages

    4. Assuming a 20% gross margin for each printer, sea transportation costs of $1 per printer and air transportation costs of $10 per printer (air shipment lead-time is three days), evaluate the various alternatives available to Brent Cartier to address the inventory and service problem.…

    • 1921 Words
    • 8 Pages
    Powerful Essays
  • Good Essays

    Eoq, Ppd, L4L, Poq

    • 2768 Words
    • 12 Pages

    Lot sizing problem generally considered in a local level; that is, only in terms of the…

    • 2768 Words
    • 12 Pages
    Good Essays
  • Satisfactory Essays

    Confederated Pulp & Paper

    • 554 Words
    • 3 Pages

    - The $2 stockpiling fee is paid at the same time that the $8 shipping fee and $23 variable cost are incurred.…

    • 554 Words
    • 3 Pages
    Satisfactory Essays