1 A retall has sixteen stores in a region supplied from eight supply sources. Trucks have a capacity of 20,000 units and cost $1,000 per load plus $200 per delivery. Thus, a truck making two deliveries charges $1,400. The cost of holding one unit in inventory at retail store for a year is $1.00. The vice president of supply chain is considering whether to use direct shipping from suppliers to retail stores or setting up milk runs (2 and 4 stores milk run) from suppliers to retail stores. A. What network do you recommend if annual sales for each product at each retail store are 600,000? What is the total transportation and inventory cost of this strategy? B. What network do you recommend if annual sales for each product at each retail store are 300,000? What is the total transportation and inventory cost of this strategy?

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
PLEASE solve part D only
1 A retall has sixteen stores in a region supplied from eight supply sources. Trucks have a capacity of
20,000 units and cost $1,000 per load plus $200 per delivery. Thus, a truck making two deliveries
charges $1,400. The cost of holding one unit in inventory at retail store for a year is $1.00.
The vice president of supply chain is considering whether to use direct shipping from suppliers to retail
stores or setting up milk runs (2 and 4 stores milk run) from suppliers to retail stores.
A. What network do you recommend if annual sales for each product at each retail store are 600,000?
What is the total transportation and inventory cost of this strategy?
B. What network do you recommend if annual sales for each product at each retail store are 300,000?
What is the total transportation and inventory cost of this strategy?
C. What network do you recommend if annual sales for each product at each retail store are 100,000?
What is the total transportation and inventory cost of this strategy?
D. Use Solver to determine the annual quantity level the VP should change their network from a 4 store
milk run and to a 2 store milk run network. (At what quantity doe the total transportation and inventory
costs of the two network strategies equal?)
Transcribed Image Text:1 A retall has sixteen stores in a region supplied from eight supply sources. Trucks have a capacity of 20,000 units and cost $1,000 per load plus $200 per delivery. Thus, a truck making two deliveries charges $1,400. The cost of holding one unit in inventory at retail store for a year is $1.00. The vice president of supply chain is considering whether to use direct shipping from suppliers to retail stores or setting up milk runs (2 and 4 stores milk run) from suppliers to retail stores. A. What network do you recommend if annual sales for each product at each retail store are 600,000? What is the total transportation and inventory cost of this strategy? B. What network do you recommend if annual sales for each product at each retail store are 300,000? What is the total transportation and inventory cost of this strategy? C. What network do you recommend if annual sales for each product at each retail store are 100,000? What is the total transportation and inventory cost of this strategy? D. Use Solver to determine the annual quantity level the VP should change their network from a 4 store milk run and to a 2 store milk run network. (At what quantity doe the total transportation and inventory costs of the two network strategies equal?)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education