As a buyer that is sourcing a new item you have been given the following quotation information from the supplier. As you can see the supplier is offering you price breaks at various ranges of order quantities. Although other considerations will come into play when determining the quantity you may ultimately order, as a first step you want to verify that the quantity discounts being offered are reasonable.
|
Quantity Range |
1 – 9 units |
10 - 25 units |
26 – 75 units |
76 – 200 units |
201 – 500 units |
501 & above |
|
Price per Unit in Range |
$27.80 each |
$26.48 each |
$26.15 each |
$25.75 each |
$25.30 each |
$24.70 each |
A. Calculate the incremental, or marginal unit cost for each quantity range.
Show all work in a step-by-step fashion to identify how you calculated your numbers
In order to receive partial or full credit. (15 points)
B. Based on your analysis above, briefly describe the questions or discussion you might have with the supplier. (5 points)
A. Here, Incremental cost has been calculated as you start to decrease the quantity of goods being bought. Because the quantity discount will decrease with decrease in number of quantity bought.
| Quantity Range | 501 & above | 201 – 500 units | 76 – 200 units | 26 – 75 units | 10 - 25 units | 1 – 9 units |
| Price per Unit in Range | $24.70each | $25.30each | $25.75each | $26.15each | $26.48each | $27.80each |
| Marginal (Incremental Unit Cost) | NA |
$0.60 each (25.30-24.7) |
$0.45 each (25.75-25.30) |
$0.40 each (26.15-25.75) |
$0.33 each (26.48-26.15) |
$1.32 each (27.80-26.48) |
B. Expected set of questions would be:
1. Will there be any difference in quality of items among all price range.
2. Additional discount for goods purchased above 500 units.
3. Time required between order placement by buyer and fulfillment by seller.
4. What will be the Transportation cost and who will bear it.
As a buyer that is sourcing a new item you have been given the following quotation...
please help with 3 question in detail on excel. thank
you
CASE STUDY The Sourcing Decision at Forever Young Forever Young is a retailer of trendy and low-cost apparel in the United States. The company divides the year into four sales seasons of about three months each supplier costs 55 yuan/unit (inclusive of all delivery and brings in new merchandise for each season. The company has historically outsourced production to China given the lower costs. Sourcing from the Chinese costs),...
You have been given the following list of variances for the Pennadi Company: Direct materials price variance $ 16,800 U Direct materials quantity variance 12,000 U Direct labour rate variance 16,270 F Direct labour efficiency variance 27,000 U Variable overhead spending variance 3,120 U Variable overhead efficiency variance 6,000 U Fixed overhead budget variance 5,000 U Fixed overhead volume variance 53,250 F You have also been given the following information: Actual units produced 25,000 Budgeted units...
If possible please just send the SQL statement. Thank you
Each question within deliverable 3 must begin on a new page and be sure to document the question as the title of each item at the top of each page. Also, using a 12-point font, include the SQL statement and then provide a screen shot of each query. The screen shots must include both the SQL statement and the results for each item below based on the data entered in...
1. Establish a buyer's negotiating position and plan using the information in the case (It is suggested you answer questions 2 to 5 before preparing your plan), and include: a. Negotiation objectives. b. Identify two (2) or three (3) key issues to be negotiated and define the minimum, maximum and target positions for each. c. Identify important facts from buyer's point of view. d. Identify buyer's and seller's strengths and weaknesses. e. Identify buyer's and seller's needs. f. List other...
resentation, Neatness, and Organization points (5 points) The recitation instructors will be giving yo score (out of 5 points) that reflect how well your presentation, neatness, and organization of your lutions are 1. When Jack started his job working for an industrial manufacturing company, he contributed $220 at the end of each month into a savings account that earned 2.5 % interest compounded monthly for 8 years. At the end of the 8th year, Jack was laid off. To help...
OPS Practice quiz 2. The benefits of risk pooling depend on the behavior of demand from one market relative to demand from another. True False 3. What is Supply Chain Management? A set of approaches utilized to efficiently integrate suppliers, manufacturers, warehouses and stores so that merchandize is produced, distributed at the right quantities, to the right locations and at the right time in order to minimize system wide costs while satisfying service level requirements. The management of the flow...
Just solved (Task 2)
Just solved (Task 2)
Just solved (Task 2)
You work as a technical engineer in a company that designs and installs sound systeins, such as speakers for large halls and open spaces. The company manager has assigned you to design a new sound system for a stadiun, and asked you to make a technical report explaining some preliminary studies on the behaviour of sound waves. Task 1: A When we are designing the sound levels to...
Hello! Could you please write a 6 paragraph summary (5-6
sentences each paragraph) of the below? In the overview, if you
could please describe the information in detail. Please have
completed in 6 days if possible. Thank you!
In 50 Words Or LesS .6TOC combines lean Six Sigma (LSS) and the theory of constraints (TOC) for bottom-line benefits . The method's metrics pyramids and communi- cations allow organiza- tions to retain gains and monitor benefits. · 6TOC goes beyond fac-...
How can we assess whether a project is a success or a
failure?
This case presents two phases of a large business transformation project involving the implementation of an ERP system with the aim of creating an integrated company. The case illustrates some of the challenges associated with integration. It also presents the obstacles facing companies that undertake projects involving large information technology projects. Bombardier and Its Environment Joseph-Armand Bombardier was 15 years old when he built his first snowmobile...