Question

Bruno Fruscalzo decided to start a small production facility in Sydney to sell gelato to the local restaurants. His local milk supplier charges $0.5 per kg of milk plus a $25 delivery fee (that is independent of the amount ordered). Bruno’s holding cost is $0.02 per kg per month. He needs 9750 kgs of milk per month.

a.Suppose Bruno orders 9250 kgs each time. What is his average inventory (kgs)?

b.Suppose Bruno orders 7000 kgs each time. How many orders does he place with his supplier each year? not attempted orders

c.How many kgs should Bruno order from his supplier with each order to minimize the sum of ordering and holding costs?

d.If Bruno’s storage vessel can hold only 2000 kgs of milk, what would be Bruno’s annual ordering and holding costs?not attempted(Do not round intermediate calculations. Round your answer to 2 decimal places.)

e.If Bruno’s storage vessel can hold only 5000 kgs of milk, what would be Bruno’s annual ordering and holding costs?not attempted(Do not round intermediate calculations. Round your answer to 2 decimal places.)

f.Bruno’s supplier’s truck can carry 20,000 kgs of milk. The supplier does not want to deliver to more than 3 customers with each truck. Thus, the supplier requires a minimum order quantity of 6,500 kgs. If Bruno orders the minimum amount, what would be the sum of his annual ordering and holding costs? Assume he has a storage vessel large enough to hold 6,500 kgs.not attempted(Round your answer to 3 decimal places.)

g.Bruno’s supplier offers a 2% discount when a customer orders a full truck, which is 20,000 kgs. Assume Bruno can store that quantity and the product will not spoil. If Bruno orders a full truck, what would be the inventory holding and ordering cost incurred per kg of milk? Assume the discount also applies to the holding cost.not attempted

Answer #1

(c)

The order size should be the economic order quantity which is
computed as:

Q = (2.d.K / h)1/2 = sqrt(2*9750*20 / 0.02) = 4937.10

(d)

If Q = 2000 kg,

Total cost of ordering + carrying = (12d/Q) * K + (Q/2) *12h =
(12*9750/2000)*25 + (2000/2)*0.02*12 = $1702.5

(e)

If Q = EOQ = 4937.10 kg

Total cost of ordering + carrying = (12d/Q) * K + (Q/2) *12h =
(12*9750/4937.10)*25+ (4937.10/2)*0.02*12 = $1184.90

(f)

If Q = 6,500 kg,

Total cost of ordering + carrying = (12d/Q) * K + (Q/2) *12h =
(12*9750/6500)*25 + (6500/2)*0.02*12 = $1230

(g)

If Q = 20,000 kg,

Total cost of ordering + carrying = (12d/Q) * K + (Q/2) *12h =
(12*9750/20,000)*25 + (20,000/2)*0.02*12 = $2546.25

So, per kg cost = 2546.25 / (9750*12) = $0.022

Bruno Fruscalzo decided to start a small production facility in
Sydney to sell gelato to the local restaurants. His local milk
supplier charges $0.50 per kg of milk plus a $21 delivery fee (the
$21 fee is independent of the amount ordered). Bruno’s holding cost
is $0.03 per kg per month. He needs 9000 kg of milk per month.
Round your answer to 3 digits after the decimal point.
Do NOT use comma in your numeric answers.
Suppose Bruno orders...

Bruno Fruscalzo decided to start a small production facility in
Sydney to sell gelato to the local restaurants. His local milk
supplier charges $0.50 per kg of milk plus a $21 delivery fee (the
$21 fee is independent of the amount ordered). Bruno’s holding cost
is $0.03 per kg per month. He needs 9000 kg of milk per month.
Round your answer to 3 digits after the decimal point.
Do NOT use comma in your numeric answers.
If Bruno’s storage...

Sarah’s Organic Soap Company makes organic liquid soap. One of
the raw materials for her soaps is organic palm oil. She needs 500
kgs of palm oil per day on average. The supplier charges a $55
delivery fee per order (which is independent of the order size) and
$5.5 per kg. Sarah’s annual holding cost is 15%. Assume she
operates and sells 5 days per week, 52 weeks per year.
a.If Sarah wants to minimize her annual ordering and inventory...

Question 2 A car engine manufacturer has the
following production goals for the next year:
Engine
Quantity
Machine Req’s
V6
2000
6hrs
V8
1500
10hrs
V12
100
20hrs
If all three engines can be produced by the same machines and
each of the manufacturer’s machines operate for 2400 hours per
year, how many machines are required for the above product mix?
Question 3
A manufacturing operation has three stages:
•Stage 1 Capacity: 400 units/hr
•Stage 2 Capacity: 300 units/hr
•Stage...

Chris Froome is a purchasing agent for a firm that sells
components for high-performance bicycles. One of the most popular
components is the TDF bicycle frame which has an annual demand of
1,750 units. The cost of each frame is $675 and the inventory
carrying cost is estimated to be 18% of the cost of each frame.
Chris has made a study of the costs involved in placing an order
for any of the frames the firm stocks, and he...

Please complete all work in excel. Use excel to make the
calculations (cells can be clicked on to view any formulas used)
and be sure to identify your answer, including units.
A manager needs to buy raw materials for the production process.
For a particular raw material, the manager uses 20,000 units each
year. The supplier has quoted a price of $6.50 per unit for an
order size of 999 units or less, a price of $6 per unit for...

PLEASE SHOW ALL WORK IN EXCEL!!!!!!!
SHOW CALCULATIONS / FORMULAS IN
ANSWER!!!!!!!!
You need to buy raw materials for your production process. You
use 2,000 units of the raw material each year. The supplier quotes
you a price of $9.50 per unit for an order size of 499 units or
less, a price of $9 per unit for orders of 500 to 1499 units, and a
price of $8.50 per unit for an order of 1,500 or more units. You...

1. The use of a production smoothing
strategy creates inventory for products that experience a seasonal
fluctuation in demand. True or False ?
2. Companies belonging to the same
industry segment should have the same inventory
turns. True or False ?
3. Which of the following is a work-in-process inventory for
C&A Bakery?
A. Flour
B. Cupcakes freshly out of the oven
C. Ovens
D. Cupcake mix prepared from scratch
4. C&A has on average $6000 in inventory and its daily...

The owner of the Beachcomber Hair Salon in Galveston, Texas,
orders bottles of professional shampoo from a local beauty care
distributor. Based on the store's popularity, the owner is
considering adding two more chairs to accommodate more customers
each day. To make room for the new chairs, however, the owner must
reduce the size of the storage area used for all of the supplies.
Specically, she estimates that there will only be space to store 20
bottles at a time....

Problem 1 - Better Life Pharmacies
///////////////////////////////////////////
Part 1: Optimal order quantity
Joshua is running a pharmacy in Nigeria (where Naira is the
local currency). His recent experience in the MicroMasters course
motivated him to rethink how to reorder pharmaceuticals to
replenish inventory. He recalls from Module 4, Unit 1, Video 5,
that he should consider the purchase cost, the order cost, and the
holding cost. In the past, Joshua rigorously tracked these cost
items. For Ibuprofen he knows that:...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 17 minutes ago

asked 21 minutes ago

asked 31 minutes ago

asked 34 minutes ago

asked 59 minutes ago

asked 1 hour ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 3 hours ago

asked 3 hours ago