 # SCM 366 HW1

Satisfactory Essays
517 Words Grammar Plagiarism  Writing  Score SCM 366 HW1 SCM 366
Supply Chain Modeling
Spring, 2015

Assignment 1

Your friend needs to purchase malt for his micro-brewery. His supplier charges \$35 per delivery, for each delivery, regardless of the size of the order. The product cost your friend \$1.20 per gallon. The annual holding cost per unit is assumed to be 35% of the item’s cost of \$1.20. Assume that your friend’s weekly usage of malt is 250 gallons and the brewery is open 52 weeks per year.

a. Suppose your friend orders 2,500 gallons of malt each time an order is made. What is the total annual holding and ordering costs using this order quantity?
b. Suppose each order is for 500 gallons of malt, what is the total annual holding and ordering costs using this order quantity?
c. Use a data table to show how annual holding costs and annual ordering costs change as the order quantity Q changes. Start with a Q equal to 500 and increase Q in 500 unit increments up to 3000 (e.g., 500, 1000, 1500, 2000, 2500, and 3000). Produce a graph that shows the costs (ordering, holding, and total) by order quantity. Be sure to label your graph.
d. What should the order size be if your friend wants to minimize the annual sum of ordering and holding costs?
e. What would the cost per order (the ordering cost) need to be in order for a 500 gallon order to have annual holding and ordering costs of \$900.00?
f. Consider 5 different demand scenarios where the demand rate is as follows: Scenario 1, demand = 0.25 of the original demand; Scenario2, demand = 0.5 of the original demand, Scenario 3, demand = original demand, Scenario 4, demand = 2 times the original demand; and Scenario 5, demand = 4 times the original demand. For each demand scenario find the EOQ and express the Annual EOQ costs as a % of the Annual Purchase Cost. Use the original ordering and holding costs inputs.
g. Suppose your friend’s supplier only accepts orders that are an integer multiple of 1,000 gallons. In other

## You May Also Find These Documents Helpful

• Satisfactory Essays

## EOQ

• 378 Words
• 2 Pages

Pam runs a mail-order business for gym equipment. Annual demand for the TricoFlexers is 16,000. The annual holding cost per unit is \$2.50 and the cost to place an order is \$50. What is the economic order quantity?…

• 378 Words
• 2 Pages
Satisfactory Essays
• Satisfactory Essays

2) BB currently uses 3,000 ingots of aluminum each year to manufacure bracelet blanks. The order cost (including shipping) is \$5,000 per order, and carrying costs are \$75 per unit per year. Determine the economic order quantity, the amount of safety stock, and the reorder point for aluminum ingots assuming there is a 1-week lead time and the firm would like a safety stock of 3%.…

• 884 Words
• 4 Pages
Satisfactory Essays
• Good Essays

a. How many orders should be placed each year if Narragansett buys from Supplier A? If the firm buys from Supplier B?…

• 1780 Words
• 8 Pages
Good Essays
• Satisfactory Essays

the investment in the inventory will be 68% of \$12.99 that is \$8.83. The cost of carrying this will be 21 percent that is \$1,85. If we multiply this by 204 units found above we get a yearly cost of \$337.4. Now if the ordering is done once every two weeks then the ordering cost will be 26 X \$20 = \$520. if this is added to the above cost we get a total of \$857.4.…

• 293 Words
• 2 Pages
Satisfactory Essays
• Powerful Essays

(c) The problem could be where to store all the items. If we were to order 1.24 years worth of…

• 1845 Words
• 16 Pages
Powerful Essays
• Good Essays

c) State which method should be chosen for sales and production of 100,000 units per period.…

• 1966 Words
• 8 Pages
Good Essays
• Satisfactory Essays

Expected annual usage of a particular raw material is 1,200,000 units, and standard order size is 10,000 units. The invoice cost of each unit is \$145, and the cost to place one purchase order is \$105. The estimated annual order cost is:…

• 5088 Words
• 43 Pages
Satisfactory Essays
• Satisfactory Essays

Q6. Using the information in Exhibit 4, calculate the cost of the five orders (A - E) under the “new” costing system.…

• 1088 Words
• 7 Pages
Satisfactory Essays
• Satisfactory Essays

The required parameters to the solution are the total demand for the year, the purchase cost for each item, the fixed cost to place the order and the storage cost for each item per year. Note that the number of times an order is placed will also affect the total cost, though this number can be determined from the other parameter.…

• 260 Words
• 2 Pages
Satisfactory Essays
• Good Essays

Q.1 A company has four manufacturing plants and five warehouses. Each plant manufactures the same product which is sold at different prices in each warehouse area. The cost of manufacturing and cost of raw material are different in each plant to various factors. The capacities of the plants are also different. The data are given in the following table: PLANT ITEM Manufacturing cost (RS) per unit Raw material cost (RS)per unit Capacity per unit time 1 12 08 100 2 10 07 200 3 08 07 120 4 08 05 80…

• 2805 Words
• 12 Pages
Good Essays
• Good Essays

A company manufactures a single product in its factory utilizing 600% of its capacity. The selling price and cost details are given below:…

• 3970 Words
• 16 Pages
Good Essays
• Satisfactory Essays

A. What is Doyles Candy Company’s break-even point in boxes of candy for the current year?  Fixed Costs  Selling \$384,000  Administrative \$672,000  Total \$1,056,000   BEP (boxes) = Fixed Costs / Unit Contribution  = \$1,056,000 / (\$9.60 - \$5.76)  = \$1,056,000 / \$3.84  = 275,000 boxes  B. What selling price per box must Doyle’s Candy Company change to cover the 15 percent increase in variable production costs of candy And still maintain the current contribution margin %?  Existing Contribution Margin Percentage (CMP) = \$3.84 / \$9.60 = 40% Revised Variable Cost (RVC) after 15% increase in candy production cost = (\$4.80x1.15) + \$0.96 = \$6.48  Revised Sales(RS) - Revised Variable Cost(RVC) = 40% of Revised Sales RS - RVC = 0.4RS 0.6RS = \$6.48 Or RS = \$6.48 / 0.6 = \$10.80 per box…

• 303 Words
• 2 Pages
Satisfactory Essays
• Good Essays

As shown in the Table 1, it is a part of question1. In the textbook, it has illustrated the 10 month income statement, containing variable cost per machine per hour and cost per thousand passes, which are used for the calculations. For the question 1, it requires to compute two order quantity ranges- 5000- 9999 and 100000- 249999, using the median of the order sizes for simplification. Setup time for a job is a factor of variable cost, so in the table, it has setup time, and uses it to get hours per thousand bottles. The formula is demonstrated below the Table 1. The setup time and run time per thousand adding together can get the total time of working per thousand, which means that when the company operates machines, it will spend cost, and should be included in variable. As a result, total time increases variable cost per machine per hour.…

• 722 Words
• 3 Pages
Good Essays
• Satisfactory Essays

3. What is the opportunity cost of increasing the annual output of corn from 800 to 1000 pounds?…

• 428 Words
• 2 Pages
Satisfactory Essays
• Satisfactory Essays

## Final

• 1485 Words
• 19 Pages

1. Given the following information about purchases and sales during the year, compute the cost to be assigned to ending inventory under each of three methods: (a) average-cost, (b) FIFO, and (c) LIFO. (Show your work.)…

• 1485 Words
• 19 Pages
Satisfactory Essays