BicycleBro is a retailer that sells bicycles. The company had been operating for 30 days (1 month). By the end of 1 month it wants to measure its performance in terms of Inventory turnover and Days of inventory. Below is the information that the company has collected from its warehouse and accounting departmentStock Count SheetItem codeStock on handStock count week (week number when employees counted the stock on hand)10030week120010week110010week320020week3Inventory valuationItem codeValue per unit (in $)10010002002000Bicycles sold by end of monthItem codeUnits sold100520010 Given the information above findWhat is the total inventory turnover rate for given period?What is the total Inventory Days of Sales for given period?

Name: BicycleBro is a retailer that sells bicycles. The company had been ope
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: BicycleBro is a retailer that sells bicycles. The company had been operating for 30 days (1 month). By the end of 1 month it wants to measure its performance in terms of Inventory turnover and Days of inventory. Below is the information that the comp

Inventory turnover rate = sales/ inventory cost Days of sales = average inventory/average COGS…

Answered: What is the total inventory turnover…

Business

Operations Management

What is the total inventory turnover rate for given period? What is the total Inventory Days of Sales for given period?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
A food manufacturing company orders raw material A, 1200 kg annually. The company estimates its annual storage and handling cost to be RM0.50 per kg per month. The administrative cost for placing and receiving an order is RM250.00. The company operates 310 days per year. The ordering lead time is 5 working days. Currently every two months the company will order 200 kg. The management wants to reduce the total inventory cost. Suggest how this can be achieved and determine when the order should be made. Show all calculations to one decimal point to support your suggestion
You were asked to assist with optimising the stock ordering and holding process for a company that sells car batteries. As part of the process, you need to decide the optimal order size to minimise associated costs. You are given the following information: • The batteries cost R400 each. • Sales volumes are constant at 600 batteries per month. • The lead time from order to delivery is 14 days. • It costs R360 for every order to be processed. It is calculated that it costs R5 to store a battery per month. 4) Calculate the optimal total costs.
You manage a production line that operates using a monthly production cycle. There are five different products that could be made this month. However, you only have 500 hours of line capacity, so you must be careful which products you select to make in the production cycle. Making a product incurs two types of setup costs: (1) a material “tear down” cost (measured in dollars) and (2) downtime for line preparation (measured in hours). Any quantity up to the forecasted monthly demand can be sold. Additional production details are given in the table below: Product 1 Product 2 Product 3 Product 4 Product 5 Monthly Demand 1000 units 1100 units 1700 units 1600 units 1500 units Revenue (per unit) $150 $175 $155 $200 $225 Production Cost (per unit) $60 $70 $60 $100 $110 Set Up Cost $10000 $15000 $25000 $10000 $5000 Set Up Time 25 hrs 15 hrs 0 hrs 10 hrs 30 hrs Production Time (per unit) .1 hrs .12…
The materials manager of a tire manfacturer must predict periodically place order for a key chemical one of the raw materials used in manufacturing uses the chemical at a rate of 300lbs each week and the lead time of delivery is 4 days. Assume that the manufacturing operation runs 5 days a week. At what point should the chemical be reorderedd a. when 1200lbs are remaining b. where 0lbs are remaining c. where 375lbs are remaining d. when 240lbs are rem
A restaurant uses 100 per week or 5,000 quart bottles of ketchup each year. The ketchup costs $3.00 per bottle and is served only in whole bottles because its taste quickly deteriorates. The restaurant figures that it costs $10.00 each time an order is placed, and holding costs are 20 percent of the purchase price. It takes 3 weeks for an order to arrive. The restaurant operates 50 weeks per year. The restaurant would like to use an inventory system that minimizes inventory cost. The restaurant has figured that the most economical order size or EOQ is approx. 409 (rounding up the decimals). Approximately, what is the time between two orders (in terms of weeks) 08 06 04 02 None of the above
World’s Greatest Coffee EOQ Problem A natural food store carries a brand of coffee called World’s Greatest Coffee. The following data shouldbe used in your calculations.Demand/Sales = 10 cases of coffee per week (you will need to convert this to an annual amount)Ordering Cost = $12 per orderCarrying Charge = 18% per yearUnit Cost = $75 per case Answer the following questions and be sure to show your computations. You can use whatever symbolyou need for square root, if typing in Word.1. How many cases should be ordered at a time? (This number will be the EOQ)2. How often should the coffee be ordered?3. What is the annual cost or ordering the coffee? What is the annual cost of carrying the coffee?And what is the total cost (ordering and carrying costs added together)?4. Name three reasons or factors that might cause the firm to order a larger or smaller amountthan the EOQ. Scoring – 20 possible pointsSection Possible PointsQuestion 1 – EOQ computation 4Question 2 – Frequency of…
Aboloway Company stocks a part that has a daily demand represented by the empirical distribution (shown in the table below). When restocking this part, the average lead time from the supplier is 3 days with a standard deviation of 0.5 days. The plant manager wants to determine how much safety stock to maintain for this part to ensure that stock-outs will not be incurred in more than 5.5% of the order cycles. Daily demand (d) in units Frequency 5 10 10 35 15 65 20 32 25 8 Total Observations = 150 3a. Find the mean and standard deviation for demand. 3b. Based on the information in problems 3 and 3a, what is the mean and standard deviation of demand during the lead time? 3c. Based on the information in problems 3, 3a, and 3b, how much safety stock should the plant manager maintain to ensure that stock-out will not be incurred in more than 5.5% of the order cycles?
Muscle Bound is a chain of fitness stores located in many largeshopping centers. Recently, an internal memo from the CEOto all operations personnel complained about the budget over-runs at Muscle Bound’s central warehouse. In particular, shesaid that inventories were too high and that the budget will becut dramatically and proportionately equal for all items in stock.Consequently, warehouse management set up a pilot study tosee what effect the budget cuts would have on customer service.They chose 5-pound barbells, which are a high volume SKU andconsume considerable warehouse space. Daily demand for thebarbells is 1,000 units, with a standard deviation of 150 units.Ordering costs are $40 per order. Holding costs are $2/unit/year.The supplier is located in the Philippines; consequently, thelead time is 35 days with a standard deviation of 5 days. MuscleBound stores operate 313 days a year (no Sundays).Suppose that the barbells are allocated a budget of $16,000 fortotal annual costs. If…
Suppose that an organization is engaged in 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. (without using Excel)
The following table contains figures on the monthly volume and unit costs for a random sample of 16 items from a list of 2,000 inventory items at a health care facility: Item Unit Cost Usage Item Unit Cost Usage K34 $10 200 F99 20 60 K35 25 600 D45 10 550 K36 36 150 D48 12 110 M10 16 25 D52 15 110 M20 20 80 D57 40 120 Z45 80 200 N08 30 40 F14 20 300 P05 16 500 F95 30 800 P09 10 30 Determine the percentage of items in each category and the annual dollar value for each category for part b
Muscle Bound is a chain of fitness stores located in many large shopping centers. Recently, an internal memo from the CEO to all operations personnel complained about the budget overruns at Muscle Bound’s central warehouse. In particular, she said that inventories were too high and that the budget will be cut dramatically and proportionately equal for all items in stock. Consequently, warehouse management set up a pilot study to see what effect the budget cuts would have on customer service.They chose 5-pound barbells, which are a high volume SKU and consume considerable warehouse space. Daily demand for the barbells is 1,000 units, with a standard deviation of 150 units. Ordering costs are $40 per order. Holding costs are $2/unit/year. The supplier is located in the Philippines; consequently, the lead time is 35 days with a standard deviation of 5 days. Muscle Bound stores operate 313 days a year (no Sundays). Suppose that the barbells are allocated a budget of $16,000 fortotal annual…