ZuoTi.Pro
Question

4. Target purchases home goods made by a supplier in China. Targets stores in the United States sell 200,000 units of home goods each month. Each unit costs $10 and the com- pany has an annual holding cost of 20 percent. Placing a replenishment order incurs clerical costs of $500/order. The shipping company charges $5,000 as a fixed cost per ship- ment along with a variable cost of $0.10 per unit shipped. What is the optimal order size for Target? What is the annual holding cost of the optimal policy? How many orders per year does Target place? What is the annual fixed transporta- tion cost? What is the annual variable transportation cost? What is the annual clerical cost?

Please solve it in Excel with showing calculation

business   Operations-Management   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)

All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
Please solve it in Excel with showing calculation 4. Target purchases home goods made by a...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Similar Homework Help Questions

  • Demand for the Deskpro computer at Best Buy is 1,000 units per month. Best Buy incurs...

    Demand for the Deskpro computer at Best Buy is 1,000 units per month. Best Buy incurs a fixed order placement, transportation, and receiving cost of $4,000 each time an order is placed. Each computer costs Best Buy $500 and the retailer has a holding cost of 20 percent. The store manager orders in lots of 200 units for each replenishment order. Calculate: 1.         The number of times the manager should place an order (order frequency) to meet the annual demand.   2.         The...

  • Voldemort, an auto parts distributor, has a large warehouse in the Chicago region and is deciding...

    Voldemort, an auto parts distributor, has a large warehouse in the Chicago region and is deciding on a policy for inbound shipping. Three shipping policies avaliable for inbound shipping are LTL, TL, and hybrid. LTL shipping costs $1 per unit. TL shipping costs $800 per truck plus $110 per pickup. Hybrid shipping policy costs $160 as a fixed cost per shipment along with a variable cost for $0.50 per unit shipped. A truck can carry up to 2,000 units. Voldemort...

  • Minions is an online retailer of health supplements. Demand for vitamins is 2,000 bottles per month....

    Minions is an online retailer of health supplements. Demand for vitamins is 2,000 bottles per month. Minions incurs a fixed order placement, transportation, and receiving cost of $200 each time it places an order for vitamins with the manufacturer. Minions incurs a holding cost of 20 percent. The manufacturer charges $3 for each bottle of vitamins purchased. Each time Minions places an order, the manufacturer must process, pack, and ship the order. The manufacturer has a line packing bottles at...

  • Home Entertainment is a small, family-owned business that purchases LCD televisions from a reputable manufacturer and...

    Home Entertainment is a small, family-owned business that purchases LCD televisions from a reputable manufacturer and sells them at the retail level. The televisions sell, on average, for $1,680 each. The average cost of a television from the manufacturer is $1,030. Home Entertainment has always kept careful accounting records, and the costs that it incurs in a typical month are as follows:   Costs      Cost Formula   Selling:      Advertising $ 1,045 per month      Delivery of televisions $ 50 per television sold...

  • A North Face retail store in Chicago sells 120 jackets per week. Each jacket costs the...

    A North Face retail store in Chicago sells 120 jackets per week. Each jacket costs the store $100 and the company has an annual holding cost of 25 percent. The fixed cost of a replenishment order (including transportation) is $100. The store currently places a replenishment order every month for 500 jackets. What is the annual holding cost? What is the annual ordering cost? What is the annual total cost including the purchasing cost? If the retail store wants to...

  • Home Entertainment is a small, family-owned business that purchases LCD televisions from a reputable manufacturer and...

    Home Entertainment is a small, family-owned business that purchases LCD televisions from a reputable manufacturer and sells them at the retail level. The televisions sell, on average, for $1,700 each. The average cost of a television from the manufacturer is $1,260. Home Entertainment has always kept careful accounting records, and the costs that it incurs in a typical month are as follows: Cost Formula Costs Selling: Advertising Delivery of televisions Sales salaries and commissions Utilities Depreciation of sales facilities Administrative:...

  • PLEASE PRINT CLEARLY AND EXPLAIN ALL OF THE QUESTIONS. THANK YOU O Assignment 6 - Question...

    PLEASE PRINT CLEARLY AND EXPLAIN ALL OF THE QUESTIONS. THANK YOU O Assignment 6 - Question 1 Target - Two popular coffee brands sold at Target stores are SB and EO - These coffees are shipped to Target's Dekalb distribution center (DC) from their local warehouses - Cost of 12-oz coffees are $8 for SB coffee and $4 for EO coffee Suppose - Weekly demands at DeKalb DC are 200 packages for SB coffee and 400 packages for EO coffee...

  • Home Entertainment is a small, family-owned business that purchases LCD televisions from a reputable manufacturer and...

    Home Entertainment is a small, family-owned business that purchases LCD televisions from a reputable manufacturer and sells them at the retail level. The televisions sell, on average, for $1,700 each. The average cost of a television from the manufacturer is $1,260. Home Entertainment has always kept careful accounting records, and the costs that it incurs in a typical month are as follows:   Costs      Cost Formula   Selling:      Advertising $ 1,345 per month      Delivery of televisions $ 40 per television sold...

  • Home Entertainment is a small, family-owned business that purchases LCD televisions from a reputable manufacturer and...

    Home Entertainment is a small, family-owned business that purchases LCD televisions from a reputable manufacturer and sells them at the retail level. The televisions sell, on average, for $2,470 each. The average cost of a television from the manufacturer is $1,900. Home Entertainment has always kept careful accounting records, and the costs that it incurs in a typical month are as follows: Cost Formula is it is Costs Selling: Advertising Delivery of televisions Sales salaries and commissions Utilities Depreciation of...

  • Custom Computers, Inc. assembles custom home computer systems. The fan assemblies needed are bought for $24...

    Custom Computers, Inc. assembles custom home computer systems. The fan assemblies needed are bought for $24 each. Annual demand is 7500 fan assemblies, the annual inventory holding cost rate is $4 per unit, and the cost to place an order is estimated to be $60. What is the optimal order quantity (rounded to the nearest integer)? Assuming that the fan assemblies are ordered in quantities equal to the optimal order quanitity, calculate the following: a. Average inventory level b. The...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT