Vallie Enterprise sells a product that cost $200 per unit and has a monthly demand of 500 units. The annual holding cost per unit is calculated as 2% of the unit purchase price. It costs the business $30 to place a single order. The maximum number of units sold for any one week is 150 and minimum sales 80 units. The vendor takes anywhere from 2 to 4 weeks to deliver the merchandise after the order is placed. The EOQ model is appropriate. i) What is the cost minimizing solution for this product each year? ii) Determine the re-order level, minimum inventory level and maximum inventory level for the product.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
icon
Concept explainers
Topic Video
Question

Vallie Enterprise sells a product that cost $200 per unit and has a monthly demand of 500 units. The annual holding cost per unit is calculated as 2% of the unit purchase price. It costs the business $30 to place a single order.

The maximum number of units sold for any one week is 150 and minimum sales 80 units. The vendor takes anywhere from 2 to 4 weeks to deliver the merchandise after the order is placed. The EOQ model is appropriate.

  1. i) What is the cost minimizing solution for this product each year?
  2. ii) Determine the re-order level, minimum inventory level and maximum inventory level for the

product.

October 5
Purchased 15 batteries at a cost of $17,020 each.
October 14
Sold 18 batteries at $22,250 per battery
October 22
Purchased 24 batteries at a cost of $18,175 each but the supplier gave a 4% quantity discount.
Sold 15 batteries to Orion Auto Ltd and 10 batteries to Brown's Auto Detailing at a price of
$23,990 each.
November 10
November 12 Owing to an increased demand for this brand of batteries, 30 batteries were purchased on
account at a cost of $17,612 each. In addition, All Things Auto paid $288 in cash on each
battery to have the inventory shipped from the vendor's warehouse to their location.
November 27 Sold 23 batteries which yielded total sales revenue of $576,840. (8 of these batteries were
sold on account to Middletown Fuel & Auto Accessories a longstanding customer)
November 30A customer, to whom 5 batteries were sold at the end of the business day on November 27,
returned 2 units, as they were of the "Duralast" brand.
In preparation for the festive season, All Things purchased 25 batteries at a total cost of
$474,500.
December 2
December 15
5 of the batteries purchased on December 2 were returned to the supplier, as the poles were
either corroded or otherwise badly damaged.
December 3O
Sold 22 batteries to two customers (Omega Traders & Middleton Auto Accessories) at a
selling price of $26,950 each.
December 31
An actual count of inventory was carried out which revealed that there were 9 units of the
"DieHard" brand in the warehouse.
All purchases were on account and received on the dates stated.
Transcribed Image Text:October 5 Purchased 15 batteries at a cost of $17,020 each. October 14 Sold 18 batteries at $22,250 per battery October 22 Purchased 24 batteries at a cost of $18,175 each but the supplier gave a 4% quantity discount. Sold 15 batteries to Orion Auto Ltd and 10 batteries to Brown's Auto Detailing at a price of $23,990 each. November 10 November 12 Owing to an increased demand for this brand of batteries, 30 batteries were purchased on account at a cost of $17,612 each. In addition, All Things Auto paid $288 in cash on each battery to have the inventory shipped from the vendor's warehouse to their location. November 27 Sold 23 batteries which yielded total sales revenue of $576,840. (8 of these batteries were sold on account to Middletown Fuel & Auto Accessories a longstanding customer) November 30A customer, to whom 5 batteries were sold at the end of the business day on November 27, returned 2 units, as they were of the "Duralast" brand. In preparation for the festive season, All Things purchased 25 batteries at a total cost of $474,500. December 2 December 15 5 of the batteries purchased on December 2 were returned to the supplier, as the poles were either corroded or otherwise badly damaged. December 3O Sold 22 batteries to two customers (Omega Traders & Middleton Auto Accessories) at a selling price of $26,950 each. December 31 An actual count of inventory was carried out which revealed that there were 9 units of the "DieHard" brand in the warehouse. All purchases were on account and received on the dates stated.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Inventory management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.