7. The following were taken from the records of Sauyo Company:YearCost ofBeginningEndingGood SoldInventoryInventory(In Pesos)(In Pesos)340,50025,30030,2002.435,04030,20035,400520,40035,40036,4004547,50036,40038,300600,70038,30039,000Required: Compute the inventory turn-over for year 5. Round off answer to whole number.

The given data is as follows Cost of goods sold 600700 Average Inventory…

Answered: 7. The following were taken from the…

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

A Figure 16.19 B (1) C(2) LT = 1 LT = 2 TABLE 16.1 D (1) INVENTORY RECORD DATA ITEM LT = 3 DATA CATEGORY Lat sizing rule Lead time Scheduled rece pts FOQ = S00 units 3 weeks POQ (P=3) L4L 1 week 2 weeks Nane 200 (week 1) None Beginning (on hand) inventory 20 425 POQ tum: 8 Lat sie: POQP - 3) Description. Lead time: 1wek Week 10 Gross 100 200 120 180 60 requirements Scheduled Projected on hand inventory Hanned receipti Hanned order reteases L4L tam: C Lat sue: LAL Description Lead time 2 weks Week 10 Gross 200 400 240 120 requirements Scheduled cepts Projected on hand imventory Hanned recets Manned ordur releases
Problem 3. Lexberheights Company has the following information: 10.000 units per year 2,000 units Sales Order Quantity Safety stock Lead time 1,300 units 4 weeks The company uses a 50-week year in all calculations. Requirements: 8. Reorder point
2.7 Which of the following help explain how the Reorder Point (ROP) works in conjunction with the Economic Order Quantity (Q), the number of orders (N) and the time between orders (T)? a) The Economic Order Quantity (Q) and the Annual Demand (D) are used to determine the number of Order (N) b) The number of orders (N) and the number of days that a firm works (W) are used to determine the time span between orders (T) c) Orders are placed every T days unless the inventory on hand fall to or below the Reorder Point d) Only a and b e) f) Only b and c All of a, b and c 2.8 The objective of Inventory Management is to balance inventory investment (cost) and customer service. a) TRUE b) False 2.9 The Economic Order Quantity (EOQ), the number of orders, the Reorder Point (ROP), the time between orders are important analytics in Inventory Management. a) TRUE b) FALSE 2.10 The number of working days for a firm is an important input in calculating the components of the Economic Order Quantity…
16. Cheryl Hunter is responsible for maintaining adequate hospital supplies atfictional St. Thomas Hospital. The demand and lead times for syringes are assumedto be constant. During the past year, the daily demand for syringes was 80 units, andthe lead time from the supplier was 4 days. What is the reorder point?
Inventory turns ProofSmart Inc., a supplier of home insulation materials, was burned down in a recent fire. From the remains of what used to be the accounting ledger, the following information was recovered: Inventory Gross Margin Inventory Turns Multiple Choice 2011 $2,367321 16% 13 Prior to the fire, ProofSmart saw a sales growth of 15% in 2012, a record performance for the 18 year-old company. What was the sales for 2012? NOTE: Gross margin is defined as 1-(COGS /Sales). 30772573 36492036 67369882 2012 $2,418,257 45% (unreadable) 42106226
Q1/ Alpha Company estimates its product cost at 8000 $, the estimated annual requirement is 25000 units at holding cost 15% of product cost. a. What is the most economical number of units to order?(EOQ). b. How many orders should be placed in a year?(optimal number of orders).
question #2 Same problem statement: Weekly demand for DVD-Rs at a retailer is normally distributed with a mean of 1,000 boxes and a standard deviation of 150. Currently, the store places orders to the supplier, with a reorder point of 4,200 boxes. The order quantity to the supplier is fixed at 5,000 boxes. Replenishment lead time is 4 weeks, fixed order cost per order is $100, each box costs the retailer $10, and the inventory holding cost is 25% per year. If the retailer wants to achieve a 99% service level (use the z-value with one decimal, as in Table 13.4 on page 400 of the textbook), what should be the safety stock value? Numeric Response 772.8 SHARE f5 f6 4- f7 ♫+ fg fil W f12. insert prt sc delete home @ 0 end 1:23 PM 11/15/2022 pg L
Q2) Clancy's Motors has the following demand to meet for custom manufactured fuel injector parts. The holding cost for that item is $2 per month and each setup costs $80. Lead time is 0 months. Calculate the planned order releases using: (a) the EOQ technique, and (b) the POQ technique. And What are the costs of each plan, including the holding cost of any inventory left over after month 7? What technique performance is better. Month 1 2 3 4 5 6 7 Requirement 400 150 200 150 100 150 250 Answer: (a) The monthly holding cost = $2/month Average monthly demand = ??? units The EOQ = ??? units Total inventory held = ??? units Setup costs = $??? Holding cost = $???? Total cost = $???? (b) POQ Interval = ?.??, round to # month. Total inventory held = ? units Setup costs = $??? Holding cost = $? Total cost = $???
question #5 Same problem statement: Weekly demand for DVD-Rs at a retailer is normally distributed with a mean of 1,000 boxes and a standard deviation of 150. Currently, the store places orders to the supplier, with a reorder point of 4,200 boxes. The order quantity to the supplier is fixed at 5,000 boxes. Replenishment lead time is 4 weeks, fixed order cost per order is $100, each box costs the retailer $10, and the inventory holding cost is 25% per year. Under the current order quantity of 5,000 boxes and current reorder point of 4,200 boxes, what would be the order-up-to level S that the retailer should use as a baseline to calculate how much inventory to order when conducting a periodic review? Numeric Response 1500 f4 ***** LA f5 40 % f6 4- 0 C + & 7 < Prev. 門 fg KAA * 8 5 of 5 DII hp f10 DDI 9 Next fi W f12. insert prt sc + 11 ( ← delete backspace home num lock end 1:24 PM 11/15/2022 pg up
Problem 11-11 (Algo) Famous Albert prldes himself on being the Cookle King of the West. Small, freshly baked cookles are the specialty of his shop. Famous Albert has asked for help to determine the number of cookles he should make each day. From an analysis of past demand, he estimates demand for cookles as VROBARTLITY OF DENAND 0.04 DEEAND 1,800 dosen 2,000 2,200 0.10 0.20 2,400 2,600 2,000 3,000 0.26 0.15 0.03 0.14 ces Each dozen sells for $0.65 and costs $0.49, which includes handling and transportation. Cookles that are not sold at the end of the day are reduced to $0.30 and sold the following day as day-old merchandise. a. Compute the expected profit or loss for each cookie making decislon quantity. (Round your answer to the nearest whole number. Enter expected losses with a negative sign.) Cookles Baked (Dozen) Probability of Demand Expected Profit/Loss 1,800 0.04 2,000 0.10 2,200 0.28 2,400 0.26 2,600 0.15
Problem 13-16 The McDonald's fast-food restaurant on campus sells an average of 4,800 quarter-pound hamburgers each week. Hamburger patties are resupplied twice a week, and on average the store has 465 pounds of hamburger in stock. Assume that the hamburger patties cost $3 a pound and there are 52 weeks in a year. a. What is the inventory turnover for the hamburger patties? (Round your answer to 2 decimal places.) Inventory turnover per year b. On average, how many days of supply are on hand? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Average days of supply
1

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS