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

    BUS 475 Sample Final Exam

    • 4935 Words
    • 20 Pages

    Jaime Inc. manufactures 2 products, sweaters and jackets. The company has estimated its overhead in the order-processing department to be $180,000. The company produces 50,000 sweaters and 80,000 jackets each year. Sweater production requires 25,000 machine hours, jacket production requires 50,000 machine hours. The company places raw materials orders 10 times per month, 2 times for raw materials for sweaters and the remainder for raw materials for jackets. How much of the order-processing overhead should be allocated to jackets?…

    • 4935 Words
    • 20 Pages
    Good Essays
  • Good Essays

    Micoeconomics

    • 649 Words
    • 3 Pages

    The quantity supplied for prices P(a), P(b), P(c), P(d) were calculated based on the MC’s of each type – if the price is below the MC of the firm, the firm would stop its production. The quantities to be supplied for each price level is like below:…

    • 649 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Executive Shirt Company (ESC) is currently following a certain process that it had been using for a long time to produce regular shirts. The company’s manager has recently decided to add a new product to his company which is custom shirts believing that this will attract more profits to the company. To achieve this, the manager ordered a new cutting machine, asked two of his assistants to come up with different plans to implement the new product line and set only two constraints: 1. The Company should produce 16,000 regular shirts and 2,000 custom shirts per month and 2. The lead time for the custom shirt should not exceed 5 working days.…

    • 1811 Words
    • 8 Pages
    Powerful Essays
  • Good Essays

    Economic Order Quantity

    • 2415 Words
    • 10 Pages

    (b) Suppose the true annual cost of capital tied up in Computronics’ inventory actually is 10 percent of the value of the inventory. Then what should the order quantity be? What is…

    • 2415 Words
    • 10 Pages
    Good Essays
  • Better Essays

    Qat Work

    • 2446 Words
    • 10 Pages

    In the given scenario, an engineer was hired two years ago at a mid-sized manufacturing plant. The engineer is a bright, detail-oriented person and a hard worker who has suggested changes at the plant that resulted in considerable savings on manufacturing energy costs and eliminated a significant safety hazard that had been overlooked by the previous engineer. Even with all of this, some co-workers resent the engineer because of clashing personalities, and they often play practical jokes on the engineer.…

    • 2446 Words
    • 10 Pages
    Better Essays
  • Good Essays

    This is clearly a challenge for Lisa. If Lisa decides to take the order she will have the opportunity to run the factory to capacity over the next three months and fulfill a Company Value by keeping employees working, in addition, she will have a bonus check on her pocket. This will be the optimal decision if the factory had excess capacity of 100,000 and Big Box asking price remains $20 per unit. Let’s say Lisa decides to use the Beta Model Line to make the additional 30,000 units, since we are short on information let’s assume that because of the production line change the factory will be 30,000 short on Beta Models. Based on table 1 (Unit Profitability Report) and if units are sold accordingly then San Juan Cell Phones will generate a profit of $90,000 by manufacturing and selling the Alpha model vs. $240,000 profit generated by manufacturing and selling the Beta model. San Juan Cell Phones will risk $150,000 in profit with the production line change alternative. If the company decides to honor the asking price then San Juan Cell Phones will generate losses. If phones are sold at $15 each and variable cost per unit remains same based on table 1 (Unit Profitability Report) then the company will lose $2 per unit making it a $200,000 or a $140,000 deficit. Variable cost will have to decrease $2+ in order to gain some profit. Another alternative will be to hire the OEM to manufacture the entire order. This alternative will be the most profitable one with a $100,000 profit gain without literary doing anything.…

    • 602 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Q Basic

    • 627 Words
    • 3 Pages

    1) WAP to print the Fibonacci series CLS a = 1 b = 1 PRINT a, b, FOR i = 1 TO 8 c = a + b PRINT c, a = b b = c NEXT i END ………………………………………………………………………………. 2) WAP to print the factors of a given number REM Program to print the factors of a given number CLS INPUT “Enter any number”; n FOR i = 1 TO n IF n MOD i = 0 THEN PRINT i, NEXT i END ………………………………

    • 627 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Purchasing Assignment

    • 417 Words
    • 2 Pages

    A company wants to develop a level production plan for a family of products. The opening inventory is 500 units, and a decrease to 200 units is expected by the end of the plan. The demand for each of the periods is given in what follows. All periods have the same number of working days. How much should the company each period? What will be the ending inventories in each period? Do you see any problems with the plan?…

    • 417 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Most prevalent Planned quantity of one product Many different products made on same equipment Economic situation determines an optimal batch size Products are run in a logical sequence to optimize process Lead time includes waiting in queue and processing time…

    • 2789 Words
    • 12 Pages
    Powerful Essays
  • Good Essays

    Tesco

    • 557 Words
    • 3 Pages

     Order placing after taking into account of all the constraints. The constraint includes customers, distributors, distributing facilities and centers, suppliers and facilities of manufacturing.…

    • 557 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Quát

    • 2149 Words
    • 9 Pages

    Right from ancient times, when the State was not formed, people have taken to the production and exchange of commodities by various simple methods. Or to put it another way, the life history and economic development of the State long before appeared and given nx regulatory to adjust the socio-economic relations with the advent and development of socio-economic relations, disputes arise and set needs to be addressed so that a fair and reasonable in the context of socio-economic and political.…

    • 2149 Words
    • 9 Pages
    Powerful Essays