5. Quantity Discount Model Suntech Manufacturing Company uses 5,300 scroll wheels for the mouse devices they produce per year. The price of the scroll wheels are given below. It costs approximately P475 to prepare an order and receive it, and carrying costs are 25 percent of purchase price per unit on an annual basis. Detemine the optimal order quantity and the total annual cost. Range Unit Price H 1 to 399 25 .25(25) = 6.25 400 to 699 23 .25(23) = 5.75 700 to 999 20 .25(20) = 5 1000 or more 17 .25(17) 4.25

5. Quantity Discount Model Suntech Manufacturing Company uses 5,300 scroll wheels for the mouse devices they produce per year. The price of the scroll wheels are given below. It costs approximately P475 to prepare an order and receive it, and carrying costs are 25 percent of purchase price per unit on an annual basis. Detemine the optimal order quantity and the total annual cost. Range Unit Price H 1 to 399 25 .25(25) = 6.25 400 to 699 23 .25(23) = 5.75 700 to 999 20 .25(20) = 5 1000 or more 17 .25(17) 4.25

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

Formulate the situation in matrix form. Be sure to indicate the meaning of your rows and columns. Find the requested quantities using the appropriate matrix arithmetic. A car dealer sells sedans, station wagons, vans, and pickup trucks at sales lots in Oakdale and Roanoke. The "dealer markup" is the difference between the sticker price and the dealer invoice price. The dealer invoice prices at both locations are the same: $15,000 per sedan, $19,000 per wagon, $24,000 per van, and $26,000 per pickup. The sticker prices at the Oakdale lot are $18,900 per sedan, $23,900 per wagon, $28,900 per van, and $28,900 per pickup, while at the Roanoke lot the sticker prices are $17,900 per sedan, $22,900 per wagon, $26,900 per van, and $30,900 per pickup. Represent these prices as a dealer invoice matrix D and a sticker price matrix S. Use these matrices to find the dealer markup matrix M for these vehicles at these sales lots. (Let row 1 represent the dealer in Oakdale and row 2 represent the…
Company C
Only solve the first part in black not red. Use excel spreadsheets.
A precedes the identifying customer needs phase. Mission statement Vision statement Budget statement Financial statement 31 (3 points)
Pol Industries uses a job order cost system and applies manufacturing overhead costs to jobs using a predetermined overhead rate based on direct labour-hours. The following data were extracted from the company's accounting records for Year 6 Estimated Actual Manufacturing overhead costs 50,000 54,000 direct labour-hours 20,000 hours 24,000 hoursJob #461 was completed during the year and the following costs had been incurred on that job:direct materials 4000 direct labour 1500(at $5.00 per direct labour hour) Suppose Job #461 contained 100 units. What unit cost would appear on the job cost sheet for job #461? Show ALL calculations.
Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Hi, Pls assist on steps and answers, Thank you.
Problem 13-3 Determining the Time Value of Money [LO13-1] Complete the following table. Use Exhibit 1-A, Exhibit 1-B, Exhibit 1-C, Exhibit 1-D. Note: Use appropriate factor(s) from the tables provided. Round time value factors to 3 decimal pla nearest whole number. Annual Deposit Rate of Number of Return Years Investment Value at the End of Time Period Total Amount of Investment $ 3,000 4 % 9 $ 3,000 8% 9 $ 3,000 4 % 18 $ 3,000 8% 18 Total Amount of Interest or Earnings