Do problem 3 a through c. For problem 3 there 6 #10 cans in a case of green beans they cost $28.10 a case and 12 cases are ordered, for tomato sauce computed the same as green beans. For problem 3 on (c) the discount is .1% not 10%. ""Lead timeSafety levela. How many pounds should be ordered at the order point? How many 10-poundpoly bags should be purchased?1 day1 dayb. The order is placed when there are 390 pounds available. How many purchase unitsshould be ordered?c. What is the usage rate in the four-day order period?d. How many 10-pound poly bags are used daily and during the order period?e.How many purchase units are included in the lead time and safety level factors?f. What is the maximum number of pounds to be available?How many purchase units should be purchased at the order point?8.ItemGround BeefGreen BeansTomato SauceShrimpProblem 3The following information is provided on a delivery invoice. Use this information to answerthe following questions:.lasing and Receiving Controls 225Ordered251266•Pack10 lb6 #10 cs6 #10 cs10 5-lb csWeight (lb)250 lb300 lbUnit Price$2.30$28.10$26.75$8.45a. What is the total amount due?b. The sharp-eyed employee who received the order noticed the following:.AmountOnly 23 10-pound bags of ground beef were received.One case of green beans appeared damaged (the corner of the case was crushed;the cardboard case looked like it had been wet and then had dried).There were 7 cases of tomato sauce.There were only 5 cases (10 5-lb) of shrimp.What is the amount that should be entered on the request-for-credit memo?What is the adjusted amount of the delivery invoice?c. The supplier will give a 10-percent discount if the invoice is paid within 10 days. Whatis the total amount of the invoice to be paid, assuming that this discount is taken?

An invoice is a business document given to a buyer by a seller when dealing in a goods transaction.…

Do problem 3 a through c. For problem 3 there 6 #10 cans in a case of green beans they cost $28.10 a case and 12 cases are ordered, for tomato sauce computed the same as green beans. For problem 3 on (c) the discount is .1% not 10%.

Do problem 3 a through c. For problem 3 there 6 #10 cans in a case of green beans they cost $28.10 a case and 12 cases are ordered, for tomato sauce computed the same as green beans. For problem 3 on (c) the discount is .1% not 10%.

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

Fisk Corporation is trying to improve its inventory control system and has installed an online computer at its retail stores. Fisk anticipates sales of 112, 500 units per year, an ordering cost of $3 per order, and carrying costs of $1.20 per unit. a. What is the economic ordering quantity? b. How many orders will be placed during the year? c. What will the average inventory be? d. What is the total cost of ordering and carrying inventory?
Sunrise Garden Center buys 425 bags of fertilizer per month for feeding and weeding lawns. The ordering cost is $15.00. Holding cost is $0.10 per bag per year. a. How many bags should Sunrise order at a time? Sunrise should order bags 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.)
The following data give monthly Demband >1300 units Ordenng cost Holding lo st to Q - $ 15 pe oder $2/ units peo year 464 Lead time 4 days %3D wha t is the tolal annua / vanable inventory Cost Cie total annus! total aroual ordening) © $968 $ 8 ® $484 D $ I436 14520
Lancelot plc uses a certain material named “LANCE” in manufacturing its products. The materials are sold in sacks and for the quarter Lancelot uses 1200 sacks. The cost per sack is GHC95. It costs GHC150 to place an order whiles the special storage costs are GHC4 per sack. How many orders can the company place in the year using the optimal size? A. 2 B. 4 C. 6 D. 8 Reset Selection
Please explain me in brief about Pros and Cons of Re-Order Point Control and Re-Order Cycle Control Inventory control Systems.
You are the executive chef at a large wedding facility, and a wedding with a confirmed count of 168 is scheduled for tomorrow at noon. Everything has been ordered except the shrimp, which was missing from the last purchase order. It will have to be a last-minute rush order, and only one supplier can get it to you in time. The purchase order will be for frozen raw, U 16-20, shrimp peeled, de-veined, tail-on, in 5-pound boxes (according to your spec for the product). You’ve dealt with this supplier before, and made a note to yourself on the jumbo shrimp spec that this vendor’s product averages 19 to 20 shrimp per pound and has a 96% yield. Catering policy dictates that a 10% buffer be provided for unexpected guests, and the catering menu states that 5 shrimp are to be served per person. If you have 4 pounds of good jumbo shrimp on hand, how much will you order for the wedding? Will there be any leftover product? How much?
Fisk Corporation is trying to improve its inventory control system and has installed an online computer at its retail stores. Fisk anticipates sales of 48,400 units per year, an ordering cost of $3 per order, and carrying costs of $1.50 per unit. a. What is the economic ordering quantity? _____________Units b. How many orders will be placed during the year? _____________Orders c. What will the average inventory be? ____________Units d. What is the total cost of ordering and carrying inventory? $__________
Fisk Corporation is trying to improve its inventory control system and has installed an online computer at its retail stores. Fisk anticipates sales of 97,200 units per year, an ordering cost of $4 per order, and carrying costs of $1.50 per unit. What is the economic ordering quantity? How many orders will be placed during the year? What will the average inventory be? What is the total cost of ordering and carrying inventory?
Question 1: Which of the following best defines " stockout costs"? options: A) They are physical goods used in operations. B) They are costs associated with retrieving inventory items from a workshop C) They are costs associated with interruptions to assembly lines D) They are associated with inventory being unavailable when needed to meet demand. E) None of the above. Question 2 At many LCBO stores in Ontario, Hennessy Cognac is kept in a clear locked case. Based on this information, according to the ABC Inventory Analysis method, is Hennessy most likely to be classified as an A item, a B item, a C item, or none of these? Question 2 options: A) C item B) None C) A item D) B item Question 3 What purpose does Rent the Runway's high-speed reverse logistics system serve? options: A) It allows the customers to return inventory to the fulfillment centre in record time. B) It allows the company to send inventory out to recipients (customers) in record time. C) It allows customers to return…
Exercise on EOQ and TAIC: Data: D = 7000 flyers, Q = 500 flyers S = $100, k = 28%, C = $2, number of days/year = 350 days Calculate the total cost and the total inventory cost to see if the company's ordering policy needs to be changed. If yes, how should it be changed? Question 2: This year's forecast for D is 8000 flyers/year. The following price list is given according to quantity: Quantity Price 599- 999 2,5$ 1000- 1999 2$ > 2000 1,5 $ How should the ordering policy be changed? (Note: questions about ordering policies like this require finding two factors: when to order and how much to order each time.)
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
14 To calculate Economic Order Quantity (EOQ =sqrt(D*k/h)