C). Given the following data, calculate a level production plan,quarterly ending inventory, and average quarterly inventory. Ifinventory carrying costs are $6 per unit per quarter, what is theannual carrying cost? Opening and ending inventory are zero.Quarter 1 Quarter 2| Quarter 3 Quarter 4TotalsForecast Demand5000700085009500ProductionEnding InventoryAverage InventoryInventory CostIf the company always carries 100 units of safety stock, what is the annualcost of carrying it?D) Perform an ABC analysis on the following set of products.AnnualItemDemandUnit CostA211800$9B390100$90C003450$6D100400$100E70785$2,000F660250$320G473500$75Н921100$75

SOLUTION: NOTE: ACCORDING TO BARTLEBY WE CAN SOLVE AONE QUESTION AT ATIME IF YOU WANT US TO ANSWER…

Answered: C). Given the following data, calculate…

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

In a Q system, the demand rate for strawberry ice cream is normally distributed, with an average of 295 pints per week. The lead time is 6 weeks. The standard deviation of weekly demand is 16 pints. Refer to the standard normal table for z-values. a. The standard deviation of demand during the 6-week lead time is 39 pints. (Enter your response rounded to the nearest whole number.) b. The average demand during the 6-week lead time is 1770 pints. (Enter your response as an integer.) c. The reorder point that results in a cycle-service level of 96 percent is pints. (Enter your response rounded to the nearest whole number.)
Use the information below for the following questions: Knights Corporation also needs to determine the proper reorder point and safety stock level. Annual Demand = 15000 gallons Lead Time = 15 days Standard deviation of lead time = 3 days Standard deviation of demand = 10 gallons Service Level = 96% (Z score of 1.75 or 1.76) Open days per year = 360 days 1. What is the reorder point? (keep two decimal places through your work, round your final answer up to the next highest whole number) 2.What is the safety stock? (keep two decimal places through your work, round your final answer up to the next highest whole number) 3. If the service level increased to 99% (Z score of 2.32 or 2.33), what would be the new safety stock? (keep two decimal places through your work, round your final answer up to the next highest whole number)
Inventory tracking is concerend both ith the quantity and the location of the goods in inventory. Select one: a. True. b. False.
Your company has the following items in inventory: Unit Cost $9 $90 $6 Item A B с D E F G H Annual Demand 1200 100 4500 400 35 250 1000 100 $150 $2000 $120 $90 $75 a) What is the annual dollar volume for all items b) Perform an ABC analysis on the data. Which are the A items, the B items and the C item: c) Why is it desirable to classify items into groups, as the ABC classification scheme does? d) Define and discuss the term "productivity" with help of productivity equation.
Please show work so I can understand it. Given this information: •Expected demand during lead time = 800 units • Standard deviation of lead time demand = 40 units Assuming that lead time demand is distributed normally. The risk of stockout is 5 percent during lead time (a) What amount of safety stock is appropriate? (b) Calculate ROP
Suppose that an organization is engaged in the manufacturing and sales of a seasonal product. Based on a sales forecast of 1000, 500, 500, and 2000 per quarter, calculate a level production plan, quarterly ending inventory, and average quarterly inventory. If inventory carrying costs are $7 per unit per quarter, what is the annual cost of carrying inventory? Assume that the opening and ending inventories are zero. (With steps)
explain the characteristics of inventory situations: 1. lead time 2. sources and level of risk 3. Static versus dynamic problems
The following lots of a particular commodity were available for sale during the year Beginning inventory 9 units at $47 First purchase 15 units at $50 Second purchase 20 units at $21 Third purchase 18 units at $58 The firm uses the periodic system, and there are 27 units of the commodity on hand at the end of the year. What is the ending inventory balance at the end of the year rounded to nearest dollar according to the average cost method? Do not round intermediate calculations. a.$1,269 b.$1,233 c.$1,323 d.$1,148
1. A local producer of vegetables is deciding how much inventory to have to meet the next week's demand. Vegetable products are perishable with a shelf-life of a week. Based on the historical observations, the company expects the weekly demand to follow a normal distribution with mean 4500 pounds and standard deviation of 400 pounds. The price of the product is $14 per pound in the store, and it costs $6 to produce. If there are any leftovers, the company is required to dispose them safely to avoid any pollution. This process costs $0.5 per pound. Answer the following questions. a) What is the cost of overage per pound? b) What is the cost of underage per pound? c) What is the optimal order quantity?
Customers arrive to a local bakery with an average time between arrivals of5 minutes. However, there is quite a lot of variability in the customers’ arrivals, asone would expect in an unscheduled system. The single bakery server requires anamount of time having the exponential distribution with mean 4.5 minutes to servecustomers (in the order in which they arrive). No customers leave without service.b. Calculate how long customers spend on average to complete their transactionsat the bakery (time in queue plus service time). What percentage of that time isspent queueing?
21- Which one of the following represent FIFO method of inventory evaluation? a. Old items remain in inventory b. Old merchandise is sold first c. New merchandise is sold first d. Average number of goods are sold
Ram Roy's firm has developed the following supply, demand, cost, and inventory data. Supply Available Period 1 W N 3 Regular Time 30 35 40 Overtime 15 15 20 Initial inventory Regular-time cost per unit Overtime cost per unit Subcontract 10 10 10 Subcontract cost per unit Carrying cost per unit per month 20 units $100 $160 $250 $2 Demand Forecast 40 55 60 Assume that the initial inventory has no holding cost in the first period and backorders are not permitted. Allocating production capacity to meet demand at a minimum cost using the transportation method, the total cost is $ (enter your response as a whole number).

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