Campbell’s Wholesale Company is preparing monthly cash budgets for the fourth quarter of theyear. Monthly sales revenue in this quarter is estimated as follows: October, $30,000; November,$24,000; and December, $20,000. All sales are made on open credit with 70% collected in themonth of sale and 30% collected in the following month. What is the estimated total cash collectedin November? December?

can you help me with this, show me how to do on excel plz

Kooyman hardware sells 31 different types of drills. They had demand for 25 of the drills and satisfied 78 percent of the demand. What was their fill rate for drills? % ( Do not round intermediate calculations.

How is probability is used in inventory management?

Use the inventory table and the gross profit inventory method to estimate the ending inventory and cost of goods sold if a 40% gross profit is realized on sales and net sales are $115,990. Date of purchase Units Cost per Total Retail price Total retail purchased unit cost per unit value Beginning inventory 41 $830 $34,030 $985 $40,385 February 5 20 $1,750 $35,000 $2,115 $42,300 February 19 15 $975 $14,625 $1,996 $29,940 March 3 28 $470 $13,160 $610 $17,080 Goods available for sale 104 $129,705 Units sold 81 Ending inventory 23 The estimated cost of goods sold is $

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?

As with other products, Fisher-Price faces the decision of how many Weather Teddy units to order for the comingholiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, or28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning themarket potential. The product management team asks you for an analysis of the stock-out probabilities forvarious order quantities, an estimate of the profit potential, and to help make an order quantity recommendation.Fisher-Price expects to sell Weather Teddy for $24 based on a cost of $16 per unit. If inventory remains afterthe holiday season, Fisher-Price will sell all surplus inventory for $5 per unit. After reviewing the sales historyof similar products, Fisher-Price’s senior sales forecaster predicted an expected demand of 20,000 units with a.95 probability that demand would be between 10,000 units and 30,000 units. Question: One of Fisher-Price’s managers felt…

Algro Inc. keeps a wide range of parts and materials on hand for use in its production processes. Management has recently had difficulty managing parts inventory as demand for its finished goods has increased; they frequently run out of some critical parts while having an endless supply of others. They would like to classify their parts inventory according to the ABC approach to better control inventory. The following is a list of parts, along with their annual usage and unit value: Item Annual Unit Item Annual Unit Number Usage Cost Number Usage Cost 1 36 $350 2 510 30 3 50 23 4 300 45 5 18 1900 6 500 8 7 710 4 8 80 26 9 344 28 10 67 440 11 510 2 12 682 35 13 1216 95 50 14 10 3 15 820 1 KARAN2222222222 16 60 $610 17 120 20 18 270 15 19 45 50 20 19 3200 21 910 3 12 4750 23 30 2710 24 24 1800 25 870 105 26 244 30 27 750 15 28 45 110 29 46 160 30 165 25 a. Classify the inventory items according to the ABC approach using the dollar value of annual demand. b. Clearly explain why you…

A firm is faced with the attractive situation in which it can obtain immediate delivery of an itemit stocks for retail sale. The firm has therefore not bothered to order the item in any systematicway. Recently, however, profits have been squeezed due to increasing competitive pressures, andthe firm has retained a management consultant to study its inventory management. The consultanthas determined that the various costs associated with making an order for the item stockedare approximately $30 per order. She has also determined that the costs of carrying the item ininventory amount to approximately $20 per unit per year (primarily direct storage costs and foregoneprofit on investment in inventory). Demand for the item is reasonably constant over time and the forecast is for 19,200 units per year. When an order is placed for the item, the entire orderis immediately delivered to the firm by the supplier. The firm operates 6 days a week plus afew Sundays, or approximately 320 days per…

LPM Corp. produces and sells two types of frozen burgers, Turkey Burgers and Veggie Burgers. In the most recent month, the firm sold 12,000 Turkey Burgers and 8,000 Veggie Burgers. Turkey Burgers sold for $14.00 per box and variable costs were $7.40 per box. The Veggie Burgers sold for $16.00 per box and variable costs were $8.25 per box. The fixed expenses of the entire company were $41,160. If the sales mix were to shift toward the Turkey Burgers product line with total sales volume remaining constant at 20,000, the overall break-even point for the entire company: