QUESTION 3 (INVENTORY MANAGEMENT: ABC ANALYSIS) Booker's Book Bindery divides SKUs into three classes according to their dollar usage. Calculate the usage values of the following SKUs and determine which is most likely to be classified as class A. SKU Number 1 2 3 4 5 6 7 SKU- STOCK-KEEPING UNIT Description Boxes Cardboard (square feet) Cover stock Glue (gallons) Inside covers Reinforcing tape (meters) Signatures Quantity Used per Year 500 18,000 10,000 75 20,000 3,000 150,000 Unit Value $3.00 $0.02 $0.75 $40.00 $0.05 $0.15 $0.45

QUESTION 3 (INVENTORY MANAGEMENT: ABC ANALYSIS) Booker's Book Bindery divides SKUs into three classes according to their dollar usage. Calculate the usage values of the following SKUs and determine which is most likely to be classified as class A. SKU Number 1 2 3 4 5 6 7 SKU- STOCK-KEEPING UNIT Description Boxes Cardboard (square feet) Cover stock Glue (gallons) Inside covers Reinforcing tape (meters) Signatures Quantity Used per Year 500 18,000 10,000 75 20,000 3,000 150,000 Unit Value $3.00 $0.02 $0.75 $40.00 $0.05 $0.15 $0.45

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

question 5 At Dot Com, a large retailer of popular books, demand is constant at 20,400 books per year. The cost of placing an order to replenish stock is $75, and the annual cost of holding is $6.00 per book. Stock is received 12 working days after an order has been placed. No backordering is allowed. Assume 325 working days a year. a. Dot Com's optimal order quantity is______ books. (Enter your response rounded to the nearest whole number.) b. The optimal number of orders per year is_____ orders. (Enter your response rounded to the nearest whole number.) c. The optimal interval (in working days) between orders is____ days. (Enter your response rounded to one decimal place.) d. The demand during lead time is ______ books. (Enter your response rounded to the nearest whole number.) e. The reorder point is _____ books. (Enter your response rounded to the nearest whole number.) f. The inventory position immediately after an order has been placed is _______ books.…
question 6 In a Q system, the demand rate for strawberry ice cream is normally distributed, with an average of 295pints per week.The lead time is 8 weeks. The standard deviation of weekly demand is 10 pints. Refer to the standard normal table1 for z-values. a. The standard deviation of demand during the 8-weeklead time is ______pints. (Enter your response rounded to the nearest whole number.) b. The average demand during the 8-week lead time is_____ pints. (Enter your response as an integer.) c. The reorder point that results in a cycle-service level of 92percent is _______ pints. (Enter your response rounded to the nearest whole number.) 1: Data Table The table below shows the total area under the normal curve for a point that is Z standard deviations to the right of the mean. Z 0.00 0.01 0.02 0.03 0.04 0.05 0.06 0.07 0.08 0.09 0.0 0.5000 0.5040 0.5080 0.5120 0.5160 0.5199 0.5239 0.5279 0.5319 0.5359 0.1 0.5398…
question 4 Babble, Inc., buys 375 blank cassette tapes per month for use in producing foreign language courseware. The ordering cost is $11.75.Holding cost is $0.10 per cassette per year. a. How many tapes should Babble order at a time? Babble should order_______ tapes at a time. (Enter your response rounded to the nearest whole number.) b. What is the time between orders? The time between orders is_______ months. (Enter your response rounded to one decimal place.)
Question 27 C&A sells 600 bottles of a dietary supplement per week at $100 per bottle. The supplement is ordered from a supplier who charges C&A $30 per order and $50 per bottle. C&A's annual holding cost percentage is 40%. Assume C&A operates 50 weeks in a year. What is C&A's total ordering and holding cost per year if C&A orders 600 bottles at a time? Group of answer choices $13,500 $7,500 $6,800 $5,036
Question 9 QuickBooks Online uses machine learning in its reconciliation tool to help find any hidden transactions. How does QuickBooks Online use machine learning in its reconciliation tool to help find any hidden transactions? A. It can identify transactions that were posted to the wrong account B. It can identify transactions where the transaction date is in a future period and the cleared date is in the statement period C. It will recognize if transactions have been excluded erroneously from bank feeds D. It will automatically record bank fees and interest earned
Question 1 B Groovy Juice Mixers produces juices, Tropical breeze and Guava Jive. These Juices are both made by blending three ingredients, Grape, guava and Papaya. A certain level of flexibility is permitted in the formulae for these products. The allowable percentages, along with revenue and cost data, aregiven in the following table. Up to 60 gallons of Grape, 80 gallons of Guava and 60 gallons of papaya could be purchased. Groovy can sell as much of these juices as it produces. a) Formulate an LP whose objective is to maximise the net profit from the sale of the juices.
Required information Skip to question George Caloz & Frères, located in Grenchen, Switzerland, makes luxury custom watches in small lots. One of the company’s products, a platinum diving watch, goes through an etching process. The company has recorded etching costs as follows over the last six weeks: Week Units Total Etching Cost 1 9 $ 21 2 12 25 3 13 30 4 9 20 5 11 25 6 18 34 72 $ 155 For planning purposes, management would like to know the variable etching cost per unit and the total fixed etching cost per week. 2-a. Using the least-squares regression method, estimate the variable etching cost per unit and the total fixed etching cost per week. 2-b. Express these estimates in the form Y = a + bX.
Question 3 Dr. Peter Kraljic claims that there is no single best way existed for managing purchasing in allcircumstances. He proposed “Kraljic Purchasing Portfolio model”. Elaburate the FOUR (4)Purchasing Portfolio with suitable examples answer should be elaborated with proper examples.
QUESTION TWO Musa's Cashmere Sweaters has authorized the following MPS for her exclusive line of cashmere sweaters. She wants to use the MPS record for promising future orders. Current order promises are included. The MPS order quantity is 60 units. Beginning Inventory is 0. Complete the following MPS record. Period 1 2 3 4 5 6 7 8 9 10 11 12 Forecast 15 15 15 15 20 20 20 20 25 25 25 25 Customer orders 12 10 8 25 40 0 15 30 30 0 0 40 Projected available Available-to-promise MPS 60
Question: The Cover-Up Drapery Company Carries Four Types Of Fabric With The Following Characteristics: Type Annual Demand (Yards) Item Cost Per Yard 1 300 $20 2250 $18 3 100 $12 4 200 $8 The Cover-up Drapery Company carries four types of fabric with the following characteristics: Type Annual Demand(yards) Item Costper Yard 1 300 $20 2 250 $18 3 100 $12 4 200 $8 Assume that the items are to be ordered together from the same supplier at an ordering cost of $20 per order and an annual carrying cost of 20 percent. Also assume 300 working days in a year. Suppose you are the supplier of the Cover-up Drapery Company. It costs $2000 each time you change over your fabric-producing machine from one type to another (1, 2, 3, or 4). Assume that your carrying cost is 30 percent. a. What lot sizes would the supplier of fabric prefer to make for items 1, 2, 3, and 4? Type Lot Size 1. ? 2. ? 3. ? 4. ? b. How would you reconcile the lot sizes that the supplier would like to…
Question-1 Read the below scenario and answer. (Marks – 12) Cisco’s model of building a seamless supply chain is one that many companies can follow. It proves that you do not have to own or control most of the elements in your supply chain, yet have complete visibility of the chain. The Internet allows companies to coordinate more closely with their suppliers and also enables just-in-time delivery that lets businesses greatly reduce inventories. Cisco’s suppliers build and ship while Cisco handles all of the financial transactions. This is an excellent instance of control/demand uncertainty fix. Discuss your understanding about Supply Chain Visibility. What is your inference about technology in the context? Implement the SCOR model and mention the demand and supply uncertainty with the help of a diagram. Identify if Cisco is following a push strategy or pull strategy and explain how?
7. Question content area left Part 1 Leah Johnson, director of Urgent Care of Brookline, wants to increase capacity to provide low-cost flu shots but must decide whether to do so by hiring another full-time nurse or by using part-time nurses. The table below shows the expected costs of the two options for three possible demand levels: States of Nature (demand) Alternatives Low Medium High Hire full−time $300 $480 $680 Hire part−time $0 $340 $1,200 Probabilities 0.20 0.55 0.25 Part 2 a) The alternative with the least expected cost is ▼ a. Hire full-time b. Hire part-time The expected cost of this alternative is $ ______ (enter your answer as a whole number). .