Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Kuantan ATV, Inc. assembles five different models of all-terrain vehicles (ATVs) from various ready-made components to serve the Las Vegas, Nevada, market. The company uses

Kuantan ATV, Inc. assembles five different models of all-terrain vehicles (ATVs) from various ready-made components to serve the Las Vegas, Nevada, market. The company uses the same engine for all its ATVs. The purchasing manager, Ms. Jane Kim, needs to choose a supplier for engines for the coming year. Due to the size of the warehouse and other administrative restrictions, she must order the engines in lot sizes of 1,000 each. The unique characteristics of the standardized engine require special tooling to be used during the manufacturing process. Kuantan ATV agrees to reimburse the supplier for the tooling. This is a critical purchase since late delivery of engines would disrupt production and cause 50 percent lost sales and 50 percent back orders of the ATVs. Jane has obtained quotes from two reliable suppliers but needs to know which supplier is more cost-effective. The terms of sale are 5/10 net 30 for Supplier 1 and 3/10 net 30 for Supplier 2. The data related to the costs of ownership associated with two reliable suppliers has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.

Total Cost of Ownership Analysis
Items Supplier 1 Supplier 2
Requirements (annual forecast units) 13,000 1 to 999 units per unit $510.00 $505.00
Lot size (Q) 1,000 1,000 to 2,999 units per unit $502.00 $497.00
Weight per engine (lbs) 28 3,000+ units per unit $493.00 $492.00
Order processing cost (per order) $155.00 Tooling cost $24,000 $21,000
Inventory carrying rate (per year) 28% Terms (net 30) 5% 3%
Cost of working capital (per year) 5% Distance (miles) 130 115
Profit margin 22% Supplier Quality Rating (defects) 2% 3%
Price of finished ATV $4,000 Supplier Delivery Rating (lateness) 3% 1%
Back-order cost (per unit) $20.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.10 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

Questions

1. What is the total cost of ownership for each of the suppliers? Assume the buyer will take advantage of the largest discount. Do not round intermediate calculations. Round your answers to the nearest cent.

Supplier 1 Supplier 2
Total $ fill in the blank $ fill in the blank

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Basic Accounting Auditing Concepts Internal Auditing And Guiding

Authors: Bertram Bessette

1st Edition

B09PMFWVSJ, 979-8796265253

More Books

Students also viewed these Accounting questions

Question

5. Describe how contexts affect listening

Answered: 1 week ago