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.)
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
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).
Suppose that we would like to determine Reorder Point for the product. From the historical data the manager determined demand during lead-time for that product fits Normal distribution with a mean of 200 and standard deviation of 10 products. The maximum stock out risk is 10%. Answer the following questions according to the (Q, R) system. a) Find the safety stock if the lead time is 2 weeks. b) Find the reorder point. c) Find the reorder point if the stock out risk decreases to 1%. Comment on the result.
1. Demand for walnut fudge ice cream at the Sweet Cream Dairy can be approximated by a normal distribution with a mean of 21 gallons per week and a standard deviation of 5 gallons per week. The new manager desires a service level of 90 percent. Lead time is 8 days, and the dairy is open seven days a week. (Hint: Work in terms of weeks.) If the ROP model is used, what is the appropriate  safety stock level  to achieve the desired service level? Round to two decimal places. Answer: _________
Items purchased from a vendor cost $250 each, and the forecast for next year’s demand is 2,000 units. The optimal order size is 100. The firm operates 52 weeks next year and lead time is 3 weeks. It costs $5 every time an order is placed for more units, and the storage cost is $2 per unit per year. What is the number of orders per year? a.35 b.20 c.22 d.25 e.5

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