Can you assist me with Chapter 12 Question 9 it has two parts, Please show the steps it's easier to follow along instead of an excel spreadsheet. Thank you Chris Sandvig Irrigation, Inc., has summarized the price list from four potential suppliers of an underground control valve. See the table below. Annual usage is 700 valves; order cost is $10 per order; and annual inventory holdingcosts are $5.25 per unit.Vendor APrice$35.00Vendor BQuantityVendor CPrice$34.50Vendor DPrice$34.2533.0031.00Quantity1-14Quantity1-149PriceQuantity1-491-24$34.7525-99100-19915-2434.7534.0050-14933.75150-29925-99150-29933.5532.3531.1530.7532.8031.6030.5032.50300+100-199200-399300+31.10200-399400+400+Which vendor should be selected and what order quantity is best if Sandvig Irrigation wants to minimize total cost?Chris Sandvig Irrigation should order units at a time from(enter your response as a whole number). Based on available information, lead time demand for PC jump drives averages 51 units (normally distributed), with a standard deviation of 4 drives. Management wants a 90% service level. Refer to the standard normal table forz-values.a) What value of Z should be applied?b) How many drives should be carried as safety stock? units (round your response to the nearest whole number).c) What is the appropriate reorder point? units (round your response to the nearest whole number).

Which vendor should be selected and what order quantity is best if Sandvig Irrigation wants to minimize total cost? Chris Sandvig Irrigation should order O units at a time from |(enter your response as a whole number).

Which vendor should be selected and what order quantity is best if Sandvig Irrigation wants to minimize total cost? Chris Sandvig Irrigation should order O units at a time from |(enter your response as a whole number).

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

What is a rollup/summary?
how do I do a V look up, in a spreadsheet to search for one item Computer applications class
1 Wendy is unsure how she can find new customers through online selling. You explain to her that there are already facilities available online to help her find new customers. 2 Finally Wendy asks you about the business of doing transactions on the Internet and how she will deal with getting the product to the customer and finalizing the sale. No hand written and fast answer
Paragraph Styles Editing If the annual demand is reduced to 9,000 units, the set-up costs increased to $110, inventory carrying cost increased to $0.60 per unit per year and the demand during the production period is maintained at 60 units per day and 80 units can be manufactured daily, calculate: A) ) The optimum production quantity (Q*) per production run (or per production lot). B) The length of each production run. C) The number of production runs per year. ictions: On acer % &
18
INSTRUCTIONS: Make a summary report of each table. Make it in a paragraph format and include learning experience each table. Specific Task Performed Ma'am Joy teaches me how to use the system they are using in the company. Arrange for a copy of the request forms for the months of April and May. Assisted ma'am Juliet in purchasing a soft broom. Check, verify, and count the supplies that were delivered yesterday. Prepare the request of the Billing department and medical records Do a physical count of the supplies that are lacking in number. Assist in the preparation of supply requests for other departments and assist in the distribution of supplies. Problems Encountered WEEK 11 Some of the supplies requested by the laundry department are not yet accounted for in the system. They are asking for items that are now unavailable in the supply. There are certain goods for which we are unfamiliar with the account name. As a result of the existence of an error, we are unable to fulfill the…
A portfolio can be organized in which of these ways? (Choose all that apply.) Random ☐ Chronological order ☐ Reverse Chronological order Best-First order
Data Analytics Assignment #2 Customer Categorization: The concept began in B2B marketing long ago, and, like Relationship Marketing, has also been adopted by B2C marketing. This idea is simple and closely related to inventory management control. Customers come in three types, A, B and C. ‘A’ customers are your most profitable. According to the Pareto Principle, 20% of your customers account for 80% of your profit. These customers deserve your attention and priority. Keep them coming back. ‘C’ customers may not be profitable at all or account for very little profit. They’re probably not worth the effort put into them and can be dropped or dissuaded from returning. At the very least, ignore them. ‘B’ customers are somewhere in the middle. The aggregate of their sales is large but their profitability is nowhere near ‘A’ customers. Can they be turned into ‘A’ customers? Are they worth that effort? If you’re interested in learning more about customer categorization and profit…
A comprehensive portfolio includes which of the following All of the above Letter of recommendation Proof of the skills achieved Certificates of awards Example of work completed in each courses
accounting Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Do not provide Excel Screet shot rather use tool table Answer completely. The Lowlands publishing company has decided to launch a new magazine for financial special-ists with the brand new title The Daily Financial Times. The problem is that this has not been done before. The Lowlands management does not have a clue how many copies will be sold and they think it will be somewhere between 60 000 and 120 000 copies. The magazine sells for €4 and the variable cost to print is €1.20. Unsold magazines are destroyed. Required: 1. Prepare a results matrix (or pay-off table) for different levels of demand: 60 000, 80 000, 100 000 and 120 000. 2. Suppose Lowlands management wants to avoid being blamed afterwards for having selected the wrong production plan, what production level should they then choose? 3. What strategy should be chosen if management wants to…
Need help with Case D. Thank You