Mike and Kelly Kyson were two small city teachers who happen to fall in love and get married. Soon after they were married, children were on the way. Kelly was always involved in crafts and wanted to spend time with her children, so she figured that she could stay home and make leather handbags and purses to earn extra money. After doing this for a while, she grew tired of dealing with the large leather suppliers and jobbers-who were giving heavy discounts to large customers, but were charging near retail prices to mid and small business. She decided to directly source the leather herself. To get the volumes necessary to buy directly from the leather tanners and processors, Kelly needed to buy in higher volumes. Initially, she would order large leather shipments and sell-off the excess on EBay. It did not take long for her to realize that she was making more money selling leather than making and selling handbags and purses. Within a couple of years Kelly and Mike became the largest leather suppliers on EBay. They decided to expand their operations and start-up a website and call their new company the Leather Hide Store After getting the Leather Hide Store up and running, the Kysons expect to sell around 7280 hides per year. On top of the web business, the Kysons plan to keep selling on EBay, but they plan to reserve their EBay business to use it to get rid of overstocks or sell special orders. Leather is a natural product and is sold typically as full or half hides. The average hide covers 50 square feet; however, hides can range from 35-to-75 square feet. On average the Kysons pay $125 for the hides, including materials overhead and labor. The inbound freight cost is $8.00; labor to receive each hide and maintain it in inventory cost $5, plus $1 per month. Storage space cost $0.05/sq. ft. per month. The Kysons have decent credit and are able to borrow at and APR of 6%. The Kyson's figure that insurance per hide runs about $0.25 per hide; taxes run about $2 per $100 value with a 30% tax rate; loss and damage runs about 4% per year; obsolescence runs 2% per year.

Elements Of Electromagnetics
7th Edition
ISBN:9780190698614
Author:Sadiku, Matthew N. O.
Publisher:Sadiku, Matthew N. O.
ChapterMA: Math Assessment
Section: Chapter Questions
Problem 1.1MA
icon
Related questions
Question
Mike and Kelly Kyson were two small city teachers who happen to fall in love and get married. Soon
after they were married, children were on the way. Kelly was always involved in crafts and wanted to
spend time with her children, so she figured that she could stay home and make leather handbags and
purses to earn extra money. After doing this for a while, she grew tired of dealing with the large leather
suppliers and jobbers-who were giving heavy discounts to large customers, but were charging near
retail prices to mid and small business. She decided to directly source the leather herself. To get the
volumes necessary to buy directly from the leather tanners and processors, Kelly needed to buy in
higher volumes. Initially, she would order large leather shipments and sell-off the excess on EBay. It did
not take long for her to realize that she was making more money selling leather than making and selling
handbags and purses. Within a couple of years Kelly and Mike became the largest leather suppliers on
EBay. They decided to expand their operations and start-up a website and call their new company the
Leather Hide Store
After getting the Leather Hide Store up and running, the Kysons expect to sell around 7280 hides per
year. On top of the web business, the Kysons plan to keep selling on EBay, but they plan to reserve their
EBay business to use it to get rid of overstocks or sell special orders.
Leather Hide Store¹
Leather is a natural product and is sold typically as full or half hides. The average hide covers 50 square
feet; however, hides can range from 35-to-75 square feet. On average the Kysons pay $125 for the
hides, including materials overhead and labor. The inbound freight cost is $8.00; labor to receive each
hide and maintain it in inventory cost $5, plus $1 per month. Storage space cost $0.05/sq. ft. per
month. The Kysons have decent credit and are able to borrow at and APR of 6%. The Kyson's figure that
insurance per hide runs about $0.25 per hide; taxes run about $2 per $100 value with a 30% tax rate;
loss and damage runs about 4% per year; obsolescence runs 2% per year.
While Mike and Kelly decide on the colors and quantity of hides, the actual ordering is Janet's
responsibility. Janet is their office manager. Janet earns around $700 per week (including salary and
fringes) and spends half of her time processing orders and processes an average 4 orders per week. The
Kysons would like the ordering process to take less of Kelly's time, so that she could spend more time
doing other tasks.
After operating their website for two months the Kysons hired you as a consultant to stream-line their
ordering and inventory process. Over the most recent 4 week period, the Leather Hide Store had the
following daily demand for hides:
Monday
Tuesday
Wednesday
Thursday
Friday
Week-1 Week-2 Week-3
32
32
33
27
21
26
29
30
20
33
31
30
24
29
21
Week-4
18
35
28
34
27
Over the same 4 week period, they had 16 orders with the following order cycle times: 5, 3, 2, 7, 3, 3, 4,
3, 7, 6, 5, 4, 3, 3, 3, 2, and 5 days.
Transcribed Image Text:Mike and Kelly Kyson were two small city teachers who happen to fall in love and get married. Soon after they were married, children were on the way. Kelly was always involved in crafts and wanted to spend time with her children, so she figured that she could stay home and make leather handbags and purses to earn extra money. After doing this for a while, she grew tired of dealing with the large leather suppliers and jobbers-who were giving heavy discounts to large customers, but were charging near retail prices to mid and small business. She decided to directly source the leather herself. To get the volumes necessary to buy directly from the leather tanners and processors, Kelly needed to buy in higher volumes. Initially, she would order large leather shipments and sell-off the excess on EBay. It did not take long for her to realize that she was making more money selling leather than making and selling handbags and purses. Within a couple of years Kelly and Mike became the largest leather suppliers on EBay. They decided to expand their operations and start-up a website and call their new company the Leather Hide Store After getting the Leather Hide Store up and running, the Kysons expect to sell around 7280 hides per year. On top of the web business, the Kysons plan to keep selling on EBay, but they plan to reserve their EBay business to use it to get rid of overstocks or sell special orders. Leather Hide Store¹ Leather is a natural product and is sold typically as full or half hides. The average hide covers 50 square feet; however, hides can range from 35-to-75 square feet. On average the Kysons pay $125 for the hides, including materials overhead and labor. The inbound freight cost is $8.00; labor to receive each hide and maintain it in inventory cost $5, plus $1 per month. Storage space cost $0.05/sq. ft. per month. The Kysons have decent credit and are able to borrow at and APR of 6%. The Kyson's figure that insurance per hide runs about $0.25 per hide; taxes run about $2 per $100 value with a 30% tax rate; loss and damage runs about 4% per year; obsolescence runs 2% per year. While Mike and Kelly decide on the colors and quantity of hides, the actual ordering is Janet's responsibility. Janet is their office manager. Janet earns around $700 per week (including salary and fringes) and spends half of her time processing orders and processes an average 4 orders per week. The Kysons would like the ordering process to take less of Kelly's time, so that she could spend more time doing other tasks. After operating their website for two months the Kysons hired you as a consultant to stream-line their ordering and inventory process. Over the most recent 4 week period, the Leather Hide Store had the following daily demand for hides: Monday Tuesday Wednesday Thursday Friday Week-1 Week-2 Week-3 32 32 33 27 21 26 29 30 20 33 31 30 24 29 21 Week-4 18 35 28 34 27 Over the same 4 week period, they had 16 orders with the following order cycle times: 5, 3, 2, 7, 3, 3, 4, 3, 7, 6, 5, 4, 3, 3, 3, 2, and 5 days.
Besides needing help with their inventory, the Kysons want to know how to plan and prioritize their
inventory requirements. Unfortunately, the Leather Hide Store does not have demand data per day
according to product number or name; however, they do have the following demand information over
the first year.
Product
Number
ES1
ES2
ES3
ES6
ES7
ES10
ES13
ES14
ES18
ES19
ES20
ES26
ES31
Product Name
Indigo
Black Cat
Black Magic
Black Pebble
True Red
Roasted Red Pepper
True Burgundy
Pure Sand
Polo Brown
Cheyenne
Harvest
Soft White
Soft Cream
Case Questions
Units
Sold
624
260
Price
per
Unit
$245.70
$167.40
1282 $206.70
312 $167.40
520 $245.70
312 $152.00
468
$171.60
104 $175.50
1560
$198.00
412
$247.00
936 $222.30
208 $202.80
282 $179.40
Net
revenues
per Unit
$67.76
$23.16
$35.50
$16.42
$54.28
$19.90
$15.23
$16.44
$20.06
$79.85
$55.15
$34.30
$23.03
1. Determine how many hides the Leather Hide Store should order and how many orders per year
they should place, and compare this to their current method. To do this, you will need to
address
a. What is the inventory-carrying rate?
b. What is the current number of orders per year if Janet is making 4 orders per week?
C. What is the economic order quantity
d. What will be the number of orders per year based upon the economic order quantity
e. What is the reorder point
2. Using Pareto's Law, develop an inventory classification system that would allow for the planning
and prioritizing of inventory requirements. Make sure to explain your reasoning and support
your solutions.
Transcribed Image Text:Besides needing help with their inventory, the Kysons want to know how to plan and prioritize their inventory requirements. Unfortunately, the Leather Hide Store does not have demand data per day according to product number or name; however, they do have the following demand information over the first year. Product Number ES1 ES2 ES3 ES6 ES7 ES10 ES13 ES14 ES18 ES19 ES20 ES26 ES31 Product Name Indigo Black Cat Black Magic Black Pebble True Red Roasted Red Pepper True Burgundy Pure Sand Polo Brown Cheyenne Harvest Soft White Soft Cream Case Questions Units Sold 624 260 Price per Unit $245.70 $167.40 1282 $206.70 312 $167.40 520 $245.70 312 $152.00 468 $171.60 104 $175.50 1560 $198.00 412 $247.00 936 $222.30 208 $202.80 282 $179.40 Net revenues per Unit $67.76 $23.16 $35.50 $16.42 $54.28 $19.90 $15.23 $16.44 $20.06 $79.85 $55.15 $34.30 $23.03 1. Determine how many hides the Leather Hide Store should order and how many orders per year they should place, and compare this to their current method. To do this, you will need to address a. What is the inventory-carrying rate? b. What is the current number of orders per year if Janet is making 4 orders per week? C. What is the economic order quantity d. What will be the number of orders per year based upon the economic order quantity e. What is the reorder point 2. Using Pareto's Law, develop an inventory classification system that would allow for the planning and prioritizing of inventory requirements. Make sure to explain your reasoning and support your solutions.
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Work and Heat
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, mechanical-engineering and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Elements Of Electromagnetics
Elements Of Electromagnetics
Mechanical Engineering
ISBN:
9780190698614
Author:
Sadiku, Matthew N. O.
Publisher:
Oxford University Press
Mechanics of Materials (10th Edition)
Mechanics of Materials (10th Edition)
Mechanical Engineering
ISBN:
9780134319650
Author:
Russell C. Hibbeler
Publisher:
PEARSON
Thermodynamics: An Engineering Approach
Thermodynamics: An Engineering Approach
Mechanical Engineering
ISBN:
9781259822674
Author:
Yunus A. Cengel Dr., Michael A. Boles
Publisher:
McGraw-Hill Education
Control Systems Engineering
Control Systems Engineering
Mechanical Engineering
ISBN:
9781118170519
Author:
Norman S. Nise
Publisher:
WILEY
Mechanics of Materials (MindTap Course List)
Mechanics of Materials (MindTap Course List)
Mechanical Engineering
ISBN:
9781337093347
Author:
Barry J. Goodno, James M. Gere
Publisher:
Cengage Learning
Engineering Mechanics: Statics
Engineering Mechanics: Statics
Mechanical Engineering
ISBN:
9781118807330
Author:
James L. Meriam, L. G. Kraige, J. N. Bolton
Publisher:
WILEY