Preview

Paul's Pasta Pinwheels Essay

Good Essays
Open Document
Open Document
736 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Paul's Pasta Pinwheels Essay
1. The current order quantity for Paul’s Pasta Pinwheels is 200 boxes. The order cost is $4 per order, the holding cost is $.40 per box per year, and the annual demand is 500 boxes per year.

Current order quantity 200 boxes Ordering cost $ 4.00 per order holding costs $ 0.40 per box Annual demand 500 boxes

a. Calculate the annual holding cost plus the annual ordering cost to get the total costs when using an order quantity of 200 boxes. Order quantity 200 Boxes Annual ordering Costs =500 boxes /200 boxes* cost per order Annual ordering Costs =2.5 orders *$4 per order Annual ordering Costs $ 10.00 Annual holding costs = average inventory level* holding cost per unit per year Annual holding costs
…show more content…
Office Express sells office suppliers to businesses on a membership basis--i.e., walk-in customers without a membership are not allowed. The company delivers supplies directly to the purchaser as long as minimum purchase of $100 is made. In order to encourage bulk orders, Office Express offers the following discount schedule on purchase quantities of boxes of paper. Larry's lumber has an annual demand of 5,000 boxes of paper, a setup cost of $10 per order, and a holding cost of 22 percent of the purchase price. Calculate the optimal order quantity.
1-100 boxes $5 per box
100-249 boxes $4.75 per box
250-499 boxes $4.50 per box
500 or more $4.25 per box D 5000 S 10 slide price holding % h q*=(2D*s/h)^.5
1-100 5 0.22 1.1 150.76
100-249 4.75 0.22 1.045 154.67
250-499 4.5 0.22 0.99 158.91
500 or ovr 4.25 0.22 0.935 163.52 it is optimal as it locate in slide 100-249

6. A watch repair shop buys batteries for a variety of products. The most frequent battery purchase is for a Y300, with demand of 3,000 per year. the order cost is $15 per order, and the holding cost is $0.50 per battery. Given the following price schedule, calculate the optimal order.

Number of Batteries Price
1-250 $6.00
250-499 $5.50
500-999 $5.00
1,000 or more $4.75 D 300 S 15 slide price h q*=(2D*s/h)^.5
1-250 6 0.5 67.08
250-499 5.5 0.5

You May Also Find These Documents Helpful

  • Good Essays

    Operations Managements

    • 2532 Words
    • 11 Pages

    Consider a firm with a daily demand of 100 units, a production rate per day of 500 units, a setup cost of $200, and an annual holding cost per unit of $10. Suppose that the firm operates 300 days per year. How many units of inventory must their storage area be able to hold?…

    • 2532 Words
    • 11 Pages
    Good Essays
  • Satisfactory Essays

    SCM 366 001 HW 1 and HW 2

    • 346 Words
    • 9 Pages

    Annual EOQ Cost $ 309.11 $ 437.15 $ 618.22 $ 874.30 $ 1,236.45 Annual Purchase Percentage Cost $ 3,900 7.93% $ 7,800 5.60% $ 15,600 3.96% $ 31,200 2.80% $ 62,400 1.98% h. Without Discount Total Cost AHC AOC Purchase Cost $ $ $ $ Since total cost with discount option is more than the total cost without discount 1.14 option, he should not order enough malt 0.4 to receive this discount. With Discount Production Cost Holding Cost Total Cost AHC AOC Purchase Cost i. 16,218.22 309 309 15,600 $ $ $ $ 16,472.88 56.875 1,596 14,820 16218.22 =…

    • 346 Words
    • 9 Pages
    Satisfactory Essays
  • Good Essays

    QAT 3

    • 553 Words
    • 3 Pages

    In order to minimize total cost, the order size should be 337 when company A orders new inventory.…

    • 553 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Qat 4

    • 373 Words
    • 1 Page

    To find the order size for Company A you need to use the economic order quantity model. This will give the smallest total cost to the company. First you need to find the holding cost. To find the holding cost you multiply the annual holding cost rate by the unit cost of the item (Ch=IC). In this example the annual holding cost rate is 3% and the unit cost is $500 (Ch=3%X$500 or Ch=$15). Now that you have the holding cost you can find the optimal order size. To find the optimal order size you take the square root of 2 times the demand times the ordering cost divided by the holding cost. Q*= the square root of 2(D)(Co)/Ch or Q*= the square root of 2(400,000)(42)/15. When you complete this equation you get 1,496.66. Because you can not create a partial laptop you need to round up. Thus giving you 1,497 laptops as the optimal ordering size.…

    • 373 Words
    • 1 Page
    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

    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
  • Good Essays

    Hamptonshire Express Case

    • 632 Words
    • 3 Pages

    3. a. Using the spreadsheet, Ralph’s optimal stocking quantity to maximize his profit is 516.…

    • 632 Words
    • 3 Pages
    Good Essays
  • Good Essays

    I have assumed the quantities demanded and supplied are a function of price and applied the following conditions: Pw = $6.00, Y = $1,600.00, PL = $9.00, and R = 25.…

    • 767 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Final Exam Study Guide

    • 1559 Words
    • 7 Pages

    (c) Currently the owner orders 4000 quarts of ice cream when they have 1680 quarts on hand. Compute the total annual inventory cost including the cost of holding the safety stock.…

    • 1559 Words
    • 7 Pages
    Good Essays
  • Good Essays

    QAT1 Task 3 309

    • 611 Words
    • 3 Pages

    Step 5: Round up to the nearest Unit to get you final answer. In order to minimize total cost, the order size should be 4560 when company A orders new inventory.…

    • 611 Words
    • 3 Pages
    Good Essays
  • Good Essays

    CHAPTER 10

    • 2716 Words
    • 54 Pages

    540 253 274 4) Cost of ending inventory Materials (240 x 2.110227) Conversion ( 120 x 1.305202) Problem 4 1) FIFO Units in process, beg Units started Units Completed ( 17,000) IP beg. Started & completed Units in process, end 30,000 3,000 33,000 1,067 4,782 5,849 507 156 663 8,000 14,000 22,000 8,000 9,000 5,000 22,000 70% 5,600 100% 9,000 80% 4,000 18,600 70%…

    • 2716 Words
    • 54 Pages
    Good Essays
  • Satisfactory Essays

    1. What are good estimates of order cost and inventory holding cost? ( State all…

    • 436 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    B. Verify that the value derived in part (a) is consistent with the optimal stocking quantity in the…

    • 850 Words
    • 5 Pages
    Good Essays
  • Good Essays

    JGT Task 2

    • 1850 Words
    • 6 Pages

    Alistair Wu has requested that I look at what the lowest shipping schedule and cost can be based on data that he has provided. He wants to know what the lowest possible cost of shipping will can be. Mr. Wu is also considering increasing production at the Shanghai factory from 1,300 to 2,800 units, and wants to ensure that this growth will be an affordable choice. The first chart that was given lists the factory capacity and what each warehouse demand is. The second chart lists the price of shipping from each factory to each warehouse. The chart looks at the demand in the warehouses as well as the cost to ship there from each factory. It then generates a cost effective shipping plan to ship products to the warehouse with least shipping expense and fills those warehouses first. It then allocates additional products to other warehouses that have higher shipping prices. This is evident with Shuzworld H and Shuzworld F, the program ships the most products to the lower priced warehouses 1 and 3. Warehouse 1 need 2,500 units but Shuzworld F only produces 2,200 units. That means Warehouse 1 will take all off the units from Shuzworld F and still have a demand of 300 units. Warehouse needs 1,800 units and Shuzworld H produces 2,300 units. This means Warehouse 3 will receive all of its units from Shuzworld H and Shuzworld H will still have an excess of 500 units.…

    • 1850 Words
    • 6 Pages
    Good Essays
  • Satisfactory Essays

    Hamsptonshire Express

    • 2112 Words
    • 9 Pages

    a. Sheen should stock the optimal stocking quantity in this situation, which is 584 newspapers. The expected profit at this stocking quantity is…

    • 2112 Words
    • 9 Pages
    Satisfactory Essays