Question: table [ [ Total Cost of Ownership Analysis,,,,, ] , [ , , Items,Supplier 1 , Supplier 2 ] , [ Requirements ( annual

\table[[Total Cost of Ownership Analysis,,,,,],[,,Items,Supplier 1,Supplier 2],[Requirements (annual forecast units),16,000,,1 to 999 units per unit,$520.00,$525.00],[Lot size (Q),1,000,,1,000 to 2,999 units per unit,$513.00,$517.00],[Weight per engine (lbs),30,,3,000+ units per unit,$505.00,$512.00],[Order processing cost (per order),$140.00,,Tooling cost,$23,000,$20,000],[Inventory carrying rate (per year),28%,,Terms (net 30),4%,2%],[Cost of working capital (per year),10%,,Distance (miles),135,110],[Profit margin,16%,,Supplier Quality Rating (defects),2%,3%],[Price of finished ATV,$4,600,,Supplier Delivery Rating (lateness),3%,2%],[Back-order cost (per unit),$17.00,,,,],[Back-order lost sales,50%,,,Supplier 1,Supplier 2],[Late delivery lost sales,50%,,Total engine cost,,],[,,,Cash discount (net 30),,],[Other Information,,,Cash discount (early payment),,],[Truckload (TL>=40,000 lbs),$0.80,per ton-mile,Tooling cost,,],[Less-than-truckload (LTL),$1.50,per ton-mile,Transportation cost,,],[Per ton-mile,2,000,lbs per mile,Ordering cost,,],[Days per year,365,,Carrying cost,,],[Invoice payment period (days),30,,Quality cost,,],[Discount period (days),10,,Backorder cost,,],[,,,Lost sales cost,,],[,,,Total cost,,],[,,,,,],[,,,Lowest cost,,],[,,,,,]]
 \table[[Total Cost of Ownership Analysis,,,,,],[,,Items,Supplier 1,Supplier 2],[Requirements (annual forecast units),16,000,,1 to

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!