Ans) Explanations for the formula stated in the below chart
a)Transport costs: If R denotes unit transport rate and D denotes annual demand, then RD gives an estimate of the annual transport cost.
b)In-transit inventory: Each unit, valued at $C, spends T days in transit. If I is annual holding rate, each item costs ICT/365 in holding charges during transport time. Since D is annual demand, total in-transit inventory cost equals [ICT/365]*D.
c)Letting Q = shipment size, and assuming production occurs instantaneously at the plant, average annual inventory cost at the plant equals ICQ/2.(for rail Q/2=100 both at the plant and at the warehouse)
d) Letting C ’ = C + R, i.e., product value at the field warehouse, then average inventory cost at the field warehouse equals IC’ ‘Q/2, assuming constant lead time (All of these inventory cost estimates assume constant and deterministic demand rate)
Cost types-
i)For transportation; (Formula- R*D)
Rail- (0.1)(700.000) =70.000 Piggyback- (0.15)(700.000) =105.000 Truck- (0.2)(700.000) =140.000 Air- (1.4)(700.000) =980.000
ii)For In-transit Inventory; (Formula- ICDT/365)
Rail- ((0.3)(30) X(700 00)X(21))/365 =363.465 Piggyback- ((0.3)(30) X(700.000) X(14))/365 =241.644 Truck- ((0.3)(30) X(700.000)X(5))/36 5 =86.301 Air- ((0.3)(30) X(700.000)X(2))/3 65 =34.521
iii)For Plant Inventory; (Formula- ICQ/2)
Rail- ((0.3)(30) X(100.000)) =900.000 Piggyback- ((0.3)(30) X(50.000)(0.93) =418.500 Truck- ((0.3)(30) (50.000) (0.84)) =378.000 Air- (0.3)(30) X(25.000) X(0.8) =182.250
iv)For Warehouse Inventory; (Formula-IC’Q/2)
Rail- ((0.3)(30.1) X(100.000)) =903.000 Piggyback- ((0.3)(30.15) X(50.000)(0.93) =420.593 Truck- ((0.3)(30.2) (50.000 X(0.84)) =380.520 Air- ((0.3)(30.4) X(25000) X(0.8)) =190.755
Therefore Total Cost- (adding all cost types for the particular transport)
Rail- 2236.465
Piggyback- 1185.737
Truck- 984.821
Air- 1387.526
Conclusion; Transportation cost trough Truck will cost the lowest for the company.
please help asap! Team work 1 The choice of transportation mode The Carry- All luggage Company...
During the past two months, Thomas Train, vice president of transportation for Specialty Metals Company, a metals servicing company with operations in ten mid-western states, has been soliciting bids for the movement of tool steel - specialty steel used for manufacturing tools and related products. Tom’s goal is to reduce the shipping cost of this high-value steel. The supplier is located in Weirton, West Virginia, 350 miles from Specialty’s Toledo, Ohio, service center. Steel Haulers, Inc., a regional contract motor...
Heavy Metal Transport (HMT), a contract motor carrier, has an excellent reputation for service and reliability. It has submitted an incremental rate, $4.00/cwt. for shipments weighing less than 150 cwt., $3.80 for shipments between 150 and 200 cwt., $3.60 for shipments between 200 and 250 cwt., and $3.40 for shipments over 250 cwt. up to a maximum of 400 cwt. Midland Continental Railway has submitted a piggyback rate of $3.25 per cwt. with a minimum load of 200 cwt. The...
Please help with these case questions. Thank you Balagny Clothing Company Inc. is a major apparel manufacturer in the United States. It makes men's, women's, and children's casual wear such as denim jeans, cotton slacks, skirts, and sweaters. Balagny Clothing has taken the low-cost provider strategy and is constantly trying to find ways to cut costs and maintain its 4 percent profit margin while maintaining a competitive advantage over its major competitors. Because direct labor makes up approximately 65 percent...
Discussion Questions: 1. What is the purpose of a distribution center? 2. Why does Cameron have eight warehouses? Why do you think Kelly believes six warehouses is better than eight? 3. What is the cost of holding inventory at Cameron? 4. Why should the decision to invest in inventory be different from investing in capital? 5. Do you think it is prudent to evaluate the future of the Atlanta warehouse independently from consideration of the other seven warehouses in the...
Instructions: Use of a regular calculator and a formula sheet is allowed. There are 20 multiple choice questions, all questions are compulsory, and carry equal points. 1) The internal rate of return is A) the discount rate that makes the NPV positive. B) the discount rate that equates the present value of the cash inflows with the present value of the cash outflows. C) the discount rate that makes NPV negative and the PI greater than one. D) the rate...
Please show all work. 1. Statement of Cash Flows and Standardized Financial Statements a) Net income for your firm was $10,000 last year. The depreciation expense was $2,500; accounts receivable increased $1,250; accounts payable increased $800; and inventories increased by $2,000. Identify the sources and uses of cash • What was the total cash flow from operations for the period? Operating activities = Net Income + Depreciation + Source (inflow) - Use foutflow) b) i) Prepare the 2018 common-size Income...
Hi,
I am requesting your help. Some of those that I am not sure if I
am right?
Thank you,
Michelle
________________________________
You work at Ford Motor Company and are responsible for determining weekly production capacity for the Juarez, Mexico assembly plant. There are 21 days left in the production month. Your sales manager just informed you that 4,725 vehicles need to be produced in the upcoming days to meet projected sales demand in the United States 21. Your production...
Hi! Can you please help me answer required 1, 2A, and
2B. Thanks and have a wonderful day!
Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on which he had secured patents. Although the company has been fairly profitable, it is now experiencing a severe cash shortage. For this reason, it is requesting a $690,000 long-term loan from Gulfport State Bank, $195,000 of which will be used to bolster the Cash account and...
please help me out experts !
1. The comparative statements of Villa Tool Company are presented below: VILLA TOOL COMPANY INCOME STATEMENT For the year ended on December 31 2018 2017 $1,750,000 Net Sales $1.818,500 Cost of Goods Sold S1.011.500 $996.000 Gross Profit $807.000 $754,500 Selling and Administrative Expenses $516,000 $479.000 $291,000 $275,500 Income from Operations Other Expenses and Losses- Interest expense Income before taxes $18.000 $14,000 $273,000 $261,500 $81.000 $77,000 Income tax expense Net Income $192,000 $184,500 VILLA TOOL...
You are part of an accounting firm Advisory team that has been engaged by a client to assess how they might make their “sales to order” process more “efficient”, perhaps with the introduction of new technologies. The client has provided a written description of their business, and the process under review, as follows: HHH is a small manufacturer of university based sportswear (a highly competitive market where fast response times are prized by customers). Sales span every region of the...