Question

In: Accounting

Joe oversee the distribution of Little Debbie products from the plant warehouse to its two distribution...

Joe oversee the distribution of Little Debbie products from the plant warehouse to its two distribution centers in the U.S. The plant warehouse currently has 42,000 units of the company's most popular product, Nutty Bars. However, Joe retains 7,000 units of the products at the warehouse as a buffer (safety stock). The Cincinnati's Distribution Center has an inventory of 12,500 units and a daily requirement of 2,500 units. The Phoenix Distribution Center has an inventory of 6,000 units and a daily requirement of 2,000 units.   (a) Why is this a problem for the distribution centers . (b) How can Fair Share help this problem.   (c) Compute the common day's supply of Nutty Bar to each distribution center. (d) Use answer c to determine the number of Nutty Bars to allocate to each Cincinnati and Phoenix distribution center ....

Solutions

Expert Solution

Solution:

a) The above Situation demands for inventory planning in a careful manner. If planning doesnot occurs properly, then there are chances to the DC that will get less than the required and the Other more than required resulting in the Shortages in one and excess inventory because the exisiting inventory level and the demand at the DC are different.

b) The common tools for allocating inventory with fair share logic is to employ -

  • The concept of a common day's supply, individual day's requirement, and individual inventories of the DCs at different locations.
  • The concept of Distribution Requirement Planning (DRP) which is similar to the concept of MRP.

c) Common day's supply (DS) = [(42,000 - 7,000)+(12,500+6,000)] / (2,500 + 2,000) = 11.89 days.

d) Allocation=(Days’ Supply x Daily Requirements) - Inventory

Allocation at Cincinnati = (11.89 * 2,500) - 12,500 = 17,225 units

Allocation at Phoenix = (11.89 * 2,000) - 6,000 = 17,780 units.


Related Solutions

Frank’s Foods has a warehouse that supplies products to its store locations. The warehouse has two...
Frank’s Foods has a warehouse that supplies products to its store locations. The warehouse has two service departments, Information Services (S1) and Operation Support (S2), and two operating departments, Order Processing (P1) and Delivery (P2). As an internal auditor, you are checking the company’s procedures for cost allocation. You find the following cost allocation results for September:    Costs allocated to P1 $ 41,000 from S1 ? from S2 Costs allocated to P2 ? from S1 $ 26,700 from S2...
A business maintains a centralized warehouse for the distribution of products ordered via the internet.  Management is...
A business maintains a centralized warehouse for the distribution of products ordered via the internet.  Management is examining the relation between distribution costs and the number of orders processed in a month.  The goal is to estimate monthly cost from the number of orders.  Here is the data for the past twelve months, with Cost given in thousands of dollars and Orders given in the thousands.  Orders are the explanatory variable and Cost is the dependent variable. Cost 52.9 71.7 85.6 63.7 72.8 68.4...
A​ mail-order catalog business maintains a centralized warehouse for the distribution of products ordered. Management is...
A​ mail-order catalog business maintains a centralized warehouse for the distribution of products ordered. Management is currently examining the process of distribution from the warehouse and has the business objective of determining the factors that affect warehouse distribution costs. Data that indicate the warehouse distribution costs and the number of orders received over the past 15 months are in the accompanying table. Month Cost_($thousands) Month Cost_($thousands) Orders 1 74.18 4628 2 89.42 5460 3 70.78 4416 4 93.46 5737 5...
Sunland Manufacturing produces two products in its Saratoga plant, balzene and galvene. Since it opened its...
Sunland Manufacturing produces two products in its Saratoga plant, balzene and galvene. Since it opened its doors in 1965, Sunland has been using a single manufacturing overhead pool to accumulate overhead costs. Overhead has been allocated to products based on direct labor hours. Until recently, Sunland was the sole producer of galvene in the country and was therefore able to dictate the selling price. However, last year Marcella Products began marketing a comparable product at $53 per unit—a price that...
A distribution company is considering two locations for the construction of a new automated warehouse: Chicago...
A distribution company is considering two locations for the construction of a new automated warehouse: Chicago and Dallas. Two types of automation are also being considered: bar coding and RF/ID (radio-frequency identification). The annual operating costs for each type of automation at the two locations are: Bar Coding RF/ID Location Fixed Cost Variable Cost per 1,000 units Fixed Cost Variable Cost per 1,000 units Chicago $1,800,000 $12.30 $2,700,00 $9.70 Dallas 1,500,000 13.10 2,300,000 9.40 For what range of annual product...
A company makes two products in a single plant. It runs this plant for 100 hours...
A company makes two products in a single plant. It runs this plant for 100 hours each week. Each unit of product A that the company produces consumes two hours of plant capacity, earns the company a contribution of $1000, and causes, as undesirable side effects, the emission of 4 ounces of particulates. Each unit of product B that the company produces consumes one hour of capacity earns the company a contribution of $2000, and causes, as undesirable side effects,...
Upriver Parts manufactures two products, V-1 and V-2, at its River Plant. Selected data for an...
Upriver Parts manufactures two products, V-1 and V-2, at its River Plant. Selected data for an average month for the two products follow. V-1 V-2 Units produced 10,000 1,000 Direct materials cost per unit $ 2 $ 4 Machine hours per unit 1 2 Production runs per month 80 40 Production at the plant is automated and any labor cost is included in overhead. Data on manufacturing overhead at the plant follow. Machine depreciation $ 36,000 Setup labor 18,000 Material...
Upriver Parts manufactures two products, V-1 and V-2, at its River Plant. Selected data for an...
Upriver Parts manufactures two products, V-1 and V-2, at its River Plant. Selected data for an average month for the two products follow. V-1 V-2 Units produced 10,000 1,000 Direct materials cost per unit $ 2 $ 4 Machine hours per unit 1 2 Production runs per month 80 40 Production at the plant is automated and any labor cost is included in overhead. Data on manufacturing overhead at the plant follow. Machine depreciation $ 51,000 Setup labor 24,000 Material...
Upriver Parts manufactures two products, V-1 and V-2, at its River Plant. Selected data for an...
Upriver Parts manufactures two products, V-1 and V-2, at its River Plant. Selected data for an average month for the two products follow. V-1 V-2 Units produced 10,000 1,000 Direct materials cost per unit $ 2 $ 4 Machine hours per unit 1 2 Production runs per month 80 40 Production at the plant is automated and any labor cost is included in overhead. Data on manufacturing overhead at the plant follow. Machine depreciation $ 39,000 Setup labor 19,200 Material...
juhania runs a manufacturing plant for the production of one of its products – the Fizzberry....
juhania runs a manufacturing plant for the production of one of its products – the Fizzberry. The budget expects production and sales of 8,000 units per month . Direct materials standard costs per unit; •Fizz 0.2kg at £10 per kg •Berries 4kg at £1.10 per kg The following data has been collected for April 2020:Actual materials used ;•1,440kg of Fizz at a total cost of £13,824 •24,000kg of berries at a total cost of £21,600• The output was 7,000 units...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT