whatsapp

Connect on Whatsapp : +1 206 673 2541, Uninterrupted Access 24x7, 100% Confidential. Connect Now

Calculate the minimum and maximum weekly sales units.

A retail company has been reviewing the adequacy of its stock control systems and has identified three products for investigation. The relevant details for the three products are set out below:

EOQStock in the warehouse storeWeekly sales Sh”000”
Product“000” units“000” unitsSh/unitMinimumNormalMaximum
A2532.52.25262830
B500422.70.36130143160
C2501900.876096128

The management accountant has provided you with the following additional information:

i) The gross margin of products A, B and C are 42, 46 and 37. The company policy is to express the gross margin as a percentage of sales.

ii) There are six trading days a week. A trading year has 52 weeks.

iii) All orders are delivered by suppliers into the retailer’s central warehouse. The lead-time

is one week from the placement of order. A further week is required by the retailer in order to transfer stock from the central warehouse to stores. Both of these lead times can be relied on.

iv) The information produced above represents the expected occurrence of demand and costs.

v) An order for item C for 250,000 units was placed 2 days ago.

REQUIRED:

a) Calculate for each product:

i) The minimum and maximum weekly sales units (4 marks)

ii) The stock-re-order level (3 marks)

iii) The maximum stock level (4 marks)

Solution:

Looking for help with your homework?
Grab a 30% Discount and Get your paper done!

30% OFF
Turnitin Report
Formatting
Title Page
Citation
Place an Order

Calculate your paper price
Pages (550 words)
Approximate price: -