Hey! I'm having trouble on this assignment can I tutor help me out?

SCM 406 - ASSIGNMENT #4 (70 points) You've been asked to track supplier performance for three electronic components suppliers. Performance across four criteria for the past quarter is as follows: mmwm WERE$2.50 $2.60 QUALITYWWW W W W 98%0N-TIME mwww Develop a weighted-point supplier scorecard to evaluate these suppliers. Of the four criteria, product quality is the most important to your rm and should be weighted at 40%. Unit price is the second most important criteria but worth ZIS in importance to quality. On time delivery and cycle time, while of equal importance to each other, are not as important as quality and price. Evaluate these suppliers on a scale of 13 where 1 is considered best performance. insert a completed scorecard table or spreadsheet in space below. Highlight the best performing supplier. (25 points) QUANTITY DISCOUNT ANALYSIS Jocelyn Smithy has received the following quote from a supplier of replacement parts for the plastic ovenivrap machines in her factory Number of Units per 1 2 4 10 15 Order Price per unit 22 19 17 '13 '12 (quoted Slunit) Total Price per Order (5) Price Difference between Orders (S) Quantity DifferencefOrder Pricel'UnitIOrder Quantity Difference Assignment Questions 1. Perform a quantity discount analysis for the quote using the data above. Fill in the blocks above (round up to whole numbers) with your answers. Each block is worth 1l2 point. (10 points) 2. How many units should Jocelyn order if she wants to receive the lowest incremental costs between quantities? (2 points) 3. Jocelyn would be willing to purchase 15 parts in this order if she can get the pricefunit for each additional part beyond '1 0 to $6funit. She plans on negotiating with the supplier to reduce his price quotation to: (3 points) $7.45lunit $10.6?!unit $11.22iunit $15.05Iunit Not enough information available EDP-99'9\" UI'UII\\U Inl'ull'u IIl'll'l'll'\" VUI\\'IU Hannah Baxter is a buyer at MERE: a manufacturer of large industrial pumps. She has a requirement for a customized subassembly that a preferred supplier, Mistral, is building for the rst time. She is preparing for negotiations with W. A key issue will be the price of the subassembly. Given the unique nature of this subassembly, Hannah expects to incorporate price reduction targets into the contract based on learning curve estimates. While Hannah does not have specic data for W she has accumulated data for a subassembly similar in design and manufacturing complexity. 4. Calculate average labor per unit given the cumulative total labor hours provided and learning rate by lling out the table below. Each table block is worth U2 point for a total of 8 points. Total Labor Average Labor Learning Units Hours per Unit Rate 5. Overall average improvement rate is approximately = B. Applicable learning curve = 7. Fill out the table below. Each block is worth V2 point for a total 6 points. Total Labor Average Labor Learning Units Hours per Unit Rate (%) ESTIMATING PRICES USING LEARNING RATES A buyer placed an initial order with a supplier for 100 pieces at a per-unit price of $281 and was able to collect the following cost data from the supplier: Direct Material Costs $100iunit Direct Labor Costs $50iunit (5 hourslunit at $1 Oihour labor rate) Overhead Costs $75iunit (calculated at 150% of direct labor) Total Costs of Goods Sold $225iunit Seller's Prot (25% of total) $56 cost markup Total price per unit = $281 The buyer now wants to place an order for an additional 700 pieces. She believes the supplier's workforce will become more efcient as they take on more volume. Assignment Questions 8. Calculate how many labor hours will be required for volumes of 100 and 200 units respectively assuming a learning curve of 80%. (3 points) a. 60 and 80 labor hours b 500 and 800 labor hours c. 100 and 200 labor hours d 500 and 200 labor hours 9. Calculate how many labor hours will be required for volumes of 400 and 800 units respectiver assuming a learning curve of 80%. (3 points) a. 400 and 800 labor hours b. 4000 and 8000 labor hours c. 1280 and 2048 labor hours d. 1545 and 2250 labor hours 10. What are the labor dollars per unit for the next 700 pieces? (3 points) a. $22.1'll'unit b. $13.55l'unit c $17.17l'unit d. $24.501'unit e $32.10l'unit 11. What is the new total price per unit for the next 700 pieces assuming this learning curve is met? (3 points) a. $281funit b. $176.502'unit c $181.77funit d. $194.10funit e $244.2funit