Question

In: Accounting

A community hospital in Southeast Ohio consumes 1,000 boxes of bandages per week. The price of...

A community hospital in Southeast Ohio consumes 1,000 boxes of bandages per week. The price of bandages is $35 per box, and the hospital operates 52 weeks per year. The ordering cost is $15, and the cost of holding one box is 15% of the price of the material. The lead time to receive materials is 2 weeks.

f) If the hospital uses a periodic review system, with the review period (P) equal to 2 weeks and cycle-service level of 97%:

i. What would be the target inventory level, T? (Use the original information from part e)

ii. What is the cost of using the periodic review system? iii. Compare/Contrast the continuous review system and periodic review system in terms of safety stock and costs. What are the managerial implications of each?

Solutions

Expert Solution

I have taken the screen shot to attach since the functions are not getting copied from excel.

iii)The continuous review system requires knowing physical inventory all the times, like using a barcode scanner every time cashier scans product purchased by the customer to update inventory. This method is more expensive to administer because inventory needs to update each time something goes out of shelf or comes into the shelf. It requires a lower level of safety since there is only uncertainty during the delivery period is the magnitude of demand. Therefore, during that time, the only safety stock required is for potential stock outs.

The advantage of the continuous review system:

  • Provide real-time updates of inventory counts
  • Make easier to know when to order
  • Provide accurate accounting

The disadvantage of the continuous system:

  • Involves additional cost

The periodic review system, evaluate inventory at specific times like counting inventory at the end of each month. It is inexpensive to administer since counting takes place at a particular time, but a higher level of safety is required to buffer against uncertainty in demand over longer planning horizon.

The advantage of the periodic review system:

  • Reduce time for business owner to analyze inventory counts
  • Allows the business owner having more time to run another aspect of the business
  • Simple to administer
  • Save labor cost for counting

The disadvantage of the periodic review system:

  • It may not provide an accurate inventory count when there is a high volume of sale
  • It may also make accounting inaccurate
  • There is little control over inventory movement

Related Solutions

A community hospital in Southeast Ohio consumes 1,000 boxes of bandages per week. The price of...
A community hospital in Southeast Ohio consumes 1,000 boxes of bandages per week. The price of bandages is $35 per box, and the hospital operates 52 weeks per year. The ordering cost is $15, and the cost of holding one box is 15% of the price of the material. The lead time to receive materials is 2 weeks. CERTAIN DEMAND (SET STANDARD DEVIATION TO 0) a) Currently, the hospital orders bandages in lot sizes of 900 boxes for total costs...
Eliza consumes 12 cappuccinos and 8 apple turnovers per week. The price of a cappuccino is...
Eliza consumes 12 cappuccinos and 8 apple turnovers per week. The price of a cappuccino is $4 each and apple turnovers are $1 each. 2.1 What is the amount of income allocated to cappuccino and apple turnover consumption? 2.2 What is the price ratio (the price of cappuccinos relative to the price of apple turnovers)? 2.3 Explain the meaning of the price ratio you computed. 2.4 If Eliza maximizes utility, what is the ratio of the marginal utility of cappuccinos...
Horatio consumes 20 fries and 12 shakes per week. The price of fries is $3 each...
Horatio consumes 20 fries and 12 shakes per week. The price of fries is $3 each and shakes are $5 each. 2.1 What is the amount of income allocated to shakes and fries consumption? 2.2 What is the price ratio (the price of shakes relative to the price of fries)? 2.3 If Horatio maximizes utility, what is the ratio of the marginal utility of shakes to the marginal utility of fries? (Hint: Start with the rule that you know and...
Assume the following equation represents the demand for unskilled labor (in thousands of hours per week) in Ohio:
Assume the following equation represents the demand for unskilled labor (in thousands of hours per week) in Ohio:P = (-1/3)Q + 20     And the following equation represents the supply of unskilled labor (in thousands of hours per week) in Ohio:P = (1/2)Q.What follows is a numeric fill in the blank question with 3 blanks.Now, assume the state government decides it wants to place a $1 tax on labor, with the workers (supply-side) facing the statutory burden of paying the tax.Calculate the...
Rob consumes two goods, x and y. He has an allowance of $50 per week and...
Rob consumes two goods, x and y. He has an allowance of $50 per week and is not endowed with either of the goods. If the price of good x increases and his substitution and income effects change demand in opposite directions, a. good x must be a Giffen good. b. good x must be an inferior good. c. WARP is violated. d. good x must be a normal good. e. There is not enough information to judge whether good...
A medical investigator claims that the average number of infections per week at a hospital in...
A medical investigator claims that the average number of infections per week at a hospital in Southwestern Pennsylvania is 16.3. A random sample of 12 weeks had a mean number of 17.7 infections per week with a standard deviation of 1.8 infections per week. Use a 1% significance level to test the investigator’s claim that the mean number of infections per week is 16.3. Students will need to utilize the excel functions: t.dist(), t.dist.2t(), and t.dist.rt() in this activity. Fill...
A medical investigation claims that the average number of infections per week at a hospital in...
A medical investigation claims that the average number of infections per week at a hospital in Pennsylvania is at least 19.1. A random sample of 40 weeks had a mean number of 17.7 infections, and a sample standard deviation is 3.8. Is there enough evidence to reject the investigator’s claim? Use a 8 % level of significance to test this claim.
Price (dollars per firework) Quantity demanded (fireworks per week) Quantity supplied (fireworks per week) 4 220...
Price (dollars per firework) Quantity demanded (fireworks per week) Quantity supplied (fireworks per week) 4 220 40 5 200 80 6 180 120 7 160 160 8 140 200 9 120 240 10 100 280 11 80 320 12 60 360 13 40 400 14 20 440 1. The table gives the demand and supply schedules for fireworks on the Island of Big Bang. In the past, because many deaths have resulted from accidents involving fireworks, the government has banned...
Count how many food boxes "Classic - 3 meals per week for 2 people" we sold...
Count how many food boxes "Classic - 3 meals per week for 2 people" we sold via marketing channel "TV / Radio Advertising" (Solve with 1 formula and show the formula you used) Please Tell me the steps on how this would be solved using Excel. Note that this is not the full excel data but just a small sample. date_sign_up customer_id product_name marketing_channel City 4/17/2015 13:11 71041 Classic - 3 meals per week for 2 people Search Engine Marketing...
Tastee Mart sells Frostee Flakes. Demand for Frostee Flakes is 500 boxes per week. Tastee Mart...
Tastee Mart sells Frostee Flakes. Demand for Frostee Flakes is 500 boxes per week. Tastee Mart has a holding cost of 30 percent and incurs a fixed cost of $100 for each replenishment order it places for Frostee Flakes. Given that cost is $2 per box of Frostee Flakes, i) how much should Tastee Mart order in each replenishment lot? ii) If a trade promotion lowers the price of Frostee Flakes to $1.80 (d=$0.2) for one month, how much should...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT