Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Montel Enterprises manufactures special tiles. The managing director, David Jones, is concerned that the total number of suppliers that they currently deal with is adding

Montel Enterprises manufactures special tiles. The managing director, David Jones, is concerned that the total number of suppliers that they currently deal with is adding unnecessary cost to the business. Currently they are dealing with 10 suppliers. David has asked you, as the new accounting graduate to investigate this. You have decided to undertake an activity-based analysis of supplier costs and supplier performance, and will focus initially on 2 suppliers of silica sand.

The following cost information has been gathered based on previous dealings with supplier A and B.

Activity

Cost per unit of activity

Order materials

$200

Receive order

$500 per delivery

Inspect order

$150 per delivery

Pay supplies

$70

Dispute invoice amount

$350 per dispute

The two suppliers consumed the following number of activities

Activity

Supplier A

Supplier B

Order materials

20

50

Receive order

20

79

Inspect order

6

26

Pay supplies

14

50

Dispute invoice amount

3

0

Materials purchased information over the past year was as follows:

Supplier A: 12 000 bags @ $5 per bag

Supplier B: 20 000 bags @ $6 per bag

Required:

1. Calculate the total cost of ownership for supplier A and B. (3 marks)

2. Calculate the supplier performance index for supplier A and B. (2 marks)

3. Which supplier do you recommend Montel Enterprises stop dealing with and why. (2 mark)

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_2

Step: 3

blur-text-image_3

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

Safety Health And Environmental Auditing A Practical Guide

Authors: Simon Watson Pain

2nd Edition

1138557153, 9781138557154

More Books

Students also viewed these Accounting questions