Preview

Qat 4

Satisfactory Essays
Open Document
Open Document
373 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Qat 4
Jason Walthour Student ID 305059
QAT Task 3

Order size for Company A.

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.

B. Lot size for Company B.

To find the lot size for Company B you need to use the economic production lot size model. 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 4% and the unit cost is $250 (Ch=4%X$250 or Ch=$10). Now that you have the holding cost you can find the optimal lot size To find the optimal lot size you take the square root of 2 times the demand times the set up cost divide by the holding cost times 1 minus demand over the production. Q* = the square root of 2(D)(Cs)/Ch(1-D/p) or Q*= the square root of 2(5,200,000)($500)/$10(1-5,200,000/88,400,000). When you complete this equation you get 23,505.318547065042. Because you can not create a partial lot you need to round up. This gives you 23,506 as the optimal lot

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

    SCM 366 HW1

    • 517 Words
    • 1 Page

    d. What should the order size be if your friend wants to minimize the annual sum of ordering and holding costs?…

    • 517 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    MgtOp 340 Final Exam Notes

    • 5984 Words
    • 33 Pages

    Suppose that JJ Inc. has a production rate of 250,000 units per year and a demand of 800 per day. JJ has a setup cost of $40, and a holding cost percentage of 25%. JJ sells their product for $50 and it costs them $30 to produce it. If JJ works for 250 days per year, what is the optimal batch size?…

    • 5984 Words
    • 33 Pages
    Good 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
  • Good Essays

    Hamptonshire Express Case

    • 632 Words
    • 3 Pages

    b. The optimal stocking quantity differs from problem #2 because Ralph is incurring the cost of overstocking, which changes the critical ratio from .8 in problem #2 to .2. Because of the critical ratio change, Anna’s profit decreases as Ralph’s increases. This is consistent with the Newsvendor Model, which gives Cu=.2, Co=.8, for a critical ratio of .2. Using the formula in the spreadsheet, Q*=NORM.INV(.2,600,100)=515.837, gives the optimal stocking quantity of 516.…

    • 632 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Ise 513 Homework2

    • 549 Words
    • 3 Pages

    d. Assuming that we get replenishment of 8000 pounds of flour on Monday and Tuesday respectively, the bakery will consume the first 8000 pounds from Monday till Thursday, and next 8000 pounds from Friday. However, the flour would be expired after 7 days, in this case on next Tuesday; while we only consume 4000 pounds before next Tuesday. Therefore, the maximum economic lot size under this scenario would be 8000+4000=12000 pounds.…

    • 549 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    QRC193 Assessment

    • 605 Words
    • 3 Pages

    Good evening Professor and class. As tasked by this week’s forum below you will find my assessment of QRC193 and how that relates to a given paradigm as well as identification of an associated risk with the case study and how I would mitigate it. First, let’s start with the background concerning Simmons and Sutter’s (2007) research paper.…

    • 605 Words
    • 3 Pages
    Good Essays
  • 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

    Sample Test2 Fall 2014

    • 1199 Words
    • 8 Pages

    ____ 2. For product M, a firm has an annual holding cost percentage of 20%, an ordering cost of $80 per order, and annual demand of 10,000 units. If they order less than 1,100 units at a time, the purchase price is $10.00. If they order 1,100 or more, then the purchase price for all units is $8.00. What are the possible optimal solutions?…

    • 1199 Words
    • 8 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Consumer Surplus

    • 310 Words
    • 2 Pages

    Price Quantity Demanded Quantity Supplied$100 70 30$200 60 40$300 50 50$400 40 60$500 30 70$600 20 80…

    • 310 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Brunswick Plastics

    • 1020 Words
    • 4 Pages

    Brunswick Plastics, located in Canada, is an injection molding company. Brunswick Plastics produces 50 different products; however, they are not reaching capacity. Production required multiple labor hours, and since they weren’t at capacity, they were finishing a little above breakeven. The Division Manager of Brunswick Plastics, Michael Smith was informed of an opportunity for his company and must make a decision on whether or not to venture into this opportunity. Mr. Smith was informed of a project of producing 150,000 milk crates. He can place a bid for the project. However, Mr. Smith isn’t confident in the information that he has, and needs answers to best estimate the costs of producing the additional units. The costs that he knows are as follows:…

    • 1020 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Khalideoq

    • 815 Words
    • 4 Pages

    As the production manager, you need to minimize both ordering and inventory costs. You need to provide a recommendation of the optimal order quantity of raw materials to your plant manager. Your objective is to determine the economic order quantity (EOQ). If the annual demand for Ultamyacin at Smitheford is 400,000 units, then the annual carrying cost rate is 15% of the cost of the unit. The product costs $48/unit to purchase, and the product ordering cost is $28.00".…

    • 815 Words
    • 4 Pages
    Powerful Essays
  • Powerful Essays

    To correct the inventory policy, we want to find the optimal ordering quantity based on the calculation EOQ=. Demand was calculated by taking the average number of customer orders per day over the first 50 days. We came up with a figure near 12.24 orders per day which we multiplied by 268 days for the entire simulation. Setup cost was provided for us at $1,000 per order and holding cost was generated by multiplying the cost per unit by the interest rate which gave us a yield of 60. Based on this information, EOQ was 331 units after rounding. From the history, this was the second change we made to the inventory policy, up from 299. This was a result of a discussion in demand, where we had calculated demand based on 218 days for the simulation instead of the 268 days of the actual simulation. Next we wanted to fix the reorder point so we could eliminate inventory shortages and determined we would like to do so while maintaining a 95% service level. Since R=mean DDLT+z*std. dev. of DDLT, we needed to calculate Mean DDLT, z & std. deviation of demand. For mean DDLT, we used the 12.24 * 4 day lead time which gave us a rounded value of 49. Excel was utilized to figure z=1.64 for the service level of 95%. We found the std. dev. of DDLT by multiply…

    • 1206 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    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.…

    • 736 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Homework Es

    • 272 Words
    • 2 Pages

    3. (TCO 7) The production budget shows planned sales of 43,000. Beginning inventory is 6,400. Units to be produced are 44,400. What is the desired ending inventory? (Points : 4)…

    • 272 Words
    • 2 Pages
    Satisfactory Essays