Please answer in excel TotalKuantan ATV, Inc. assembles five different models of all-terrain vehicles (ATVs) from various ready-madecomponents to serve the Las Vegas, Nevada, market. The company uses the same engine for all its ATVs. Thepurchasing manager, Ms. Jane Kim, needs to choose a supplier for engines for the coming year. Due to the sizeof the warehouse and other administrative restrictions, she must order the engines in lot sizes of 1,000 each. Theunique characteristics of the standardized engine require special tooling to be used during the manufacturingprocess. Kuantan ATV agrees to reimburse the supplier for the tooling. This is a critical purchase since latedelivery of engines would disrupt production and cause 50 percent lost sales and 50 percent back orders of theATVS. Jane has obtained quotes from two reliable suppliers but needs to know which supplier is more cost-effective. The terms of sale are 4/10 net 30 for Supplier 1 and 2/10 net 30 for Supplier 2. The data related to thecosts of ownership associated with two reliable suppliers has been collected in the Microsoft Excel Online filebelow. Open the spreadsheet and perform the required analysis to answer the questions below.Que onsssibility: Good to go1. What is the total cost of ownership for each of the suppliers? Assume the buyer will take advantage of thelargest discount. Do not round intermediate calculations. Round your answers to the nearest cent.Supplier 1S fill in the blank 22. Which supplier is more cost-effective?SearchDLSupplier 2S fill in the blank 3GFocusBE A1 Total Cost of Ownership Analysis23 Requirements (annual forecast units)4Lot size (Q)SWeight per engine (lbs)Order processing cost (per order)Inventory carrying rate (per year)Cost of working capital (per year)Profit marginPrice of finished ATVBack-order cost (per unit)Back-order lost salesLate delivery lost sales5son800 S.16೯ ರoglerome20212324fx25Tosoft 6dgeOther InformationTruckload (TL=40,000 lbs)Less-than-truckload (LTL)Per ton-mileDays per yearInvoice payment period (days)Discount period (days)B14,0001,00024$165.0024%15%16%$5,000$18.0050%50%Sheet1 +Catculation Mode: Automatic Workbook Statistics$0.70 per ton-mile$1.40 per ton-mile2,000 lbs per mile3653010DItems1 to 999 units per unit1,000 to 2,999 units per unit3,000+ units per unitTooling costTerms (net 30)Distance (miles)Supplier Quality Rating (defects)Supplier Delivery Rating (lateness)Total engine costCash discount (net 30)Cash discount (early payment)Tooling costTransportation costOrdering costCarrying costQuality costBackorder costLost sales costTotal costLowest costESupplier 1$520.00$511.00$501.00$21,0004%1402%2%Supplier 1$7.280,000.00SAMSUNGFSupplier 2$530.00$521.00$516.00$25,000Supplier 22%1103%3%Formu=B3 E3

Answered: Image /qna-images/answer/72535e9a-bf1d-4689-976c-9d87901a5335.jpg

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. Th purchasing manager, Ms. Jane Kim, needs to choose a supplier for engines for the coming year. Due to the siz of the warehouse and other administrative restrictions, she must order the engines in lot sizes of 1,000 each. TEH 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 book:

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. Th purchasing manager, Ms. Jane Kim, needs to choose a supplier for engines for the coming year. Due to the siz of the warehouse and other administrative restrictions, she must order the engines in lot sizes of 1,000 each. TEH 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 book:

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

How long should a record of a default record be kept by an organisation in accordance with legislative requirements?
help
What is the cardinality of the two (Talk about the relationship between the entities being one to many, one to mandator, etc): 1. Property_Service must exist in Owned_Property 2.Property_Service must exist in Service
Bill Lewis, manager of the Thomas Electronics Division, called a meeting with his controller, Brindon Peterson, and his marketing manager, Patty Fritz. The following is a transcript of the conversation that took place during the meeting: Bill: Brindon, the variable costing system that you developed has proved to be a big plus for our division. Our success in winning bids has increased, and as a result our revenues have increased by 25%. However, if we intend to meet this year’s profit targets, we are going to need something extra—am I right, Patty? Patty: Absolutely. While we have been able to win more bids, we still are losing too many, particularly to our major competitor, Kilborn Electronics. If we knew more about their bidding strategy, we could be more successful at competing with them. Brindon: Would knowing their variable costs help? Patty: Certainly. It would give me their minimum price. With that knowledge, I’m sure that we could find a way to beat them on several jobs,…
Pls help ASAP
Incorrect Question 7 After you finish speaking at a business law conference, an eager fan asks you how long is an offer considered open for acceptance by the offeree. Your pithy reply is which of the following? Unless the terms of the offer state otherwise, the offer is open for a reasonable amount of time. Indefinitely, until the offeror revokes or rescinds it. Only 10 days, no exceptions. 30 days unless the parties agree otherwise.
If a payment is between $1 and $10, it is known to be a _______.
five general risks involved in the revenue cycle of any business information processing system?
Pls help ASAP
What are 'accelerated filers,' and how are they selected (i.e., based on revenue, number of employees, and so on)?
The first public disclosure by a public company to the SEC of a non-recurring event is on which form? O A. Form 8K O B. Form 10Q O C. Form 10K O D. Form 20-K O E. Form SG 13G Rocot C
State TWO (2) features of a control system that is used at the tactical level of management in a commercial entity