Question

Current service level =80% Orders per year = 500 Units per order = 25 Price per unit = $125 Net cost per unit = $75 Re-handli
requirement:
1) what is the total loss of cash flow under the current service level?
2) improbements are made and the order completion rate increases to 95%. what is the percent change in cash flow improvement from this increased service level versus the previous service level?
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Total sales revenue (500×25×125) =1562500

Net cost (500×25×75) = (937500)

Handling cost (80×500) =(40000)

Administration cost (500×40) =(20000)

Reshipping cost (500×130) =(65000)

Invoice deduction (500×200) =(100000)

Imventory carrying cost( 937500×30%)=(281250)

Cost of capital (1162500 ×16%) =(186000)

Loss =67250

Add a comment
Know the answer?
Add Answer to:
requirement: 1) what is the total loss of cash flow under the current service level? 2)...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • How might the cost of a stockou Deu 12. Assume an organizations me an organization's current service level on order fil...

    How might the cost of a stockou Deu 12. Assume an organizations me an organization's current service level on order fill is as follo Current order fill = 80% Number of orders per year = 5,000 Percentage of unfilled orders back-ordered = 70% Percentage of unfilled orders cancelled = 30% Back order costs per order = $150 Lost pretax profit per cancelled order = $12,500 a. What is the lost cash flow to the seller at this 80 percent service...

  • 1.   What is Webb Corporation’s total net cash flow available from the current lockbox system to...

    1.   What is Webb Corporation’s total net cash flow available from the current lockbox system to meet payroll? 2.   Under the terms outlined by Third National Bank, should the company proceed with the concentration banking system? 3.   What cost of ACH transfers would make the company indifferent between the two systems? yielding 4 percent per year, and there are 365 days per year. MINICASE Cash Management at Webb Corporation Webb Corporation was founded 20 years ago by its president, Bryan...

  • Bob’s apple store utilizes a continuous review system. Current on had inventory is 295 bags of...

    Bob’s apple store utilizes a continuous review system. Current on had inventory is 295 bags of apples, with no open orders or backorders. He buys apples year round, 52 weeks a year, 5 days a week. He buys apples for $10.20 a bag. The following information is available about these bags of apples: Demand = 80 bags/week Order cost = $48/order Annual Holding cost = 32 percent of the cost of a bag Desired cycle-service level = 87 percent Lead...

  • A construction equipment dealer is facing a difficult inventory problem. Low inventory turnover is squeezing profit...

    A construction equipment dealer is facing a difficult inventory problem. Low inventory turnover is squeezing profit margins and causing cash-flow problems. One of the top-selling SKUs in the storage is a special small appliance. Sales are 18 units per week, and the supplier charges $60 per unit. The cost of placing an order with the supplier is $45. Annual holding cost is 25 percent of a product’s value, and the shop operates 52 weeks per year. Management chose a 390-unit...

  • 1: What is the operating cash flow for this project for the first five years of the 10-year period?? 2: for the last...

    1: What is the operating cash flow for this project for the first five years of the 10-year period?? 2: for the last five years of the 10-year period? 3: What is the book value? 4: Calculate the gain or loss at disposal of the manufacturing equipment. 5: What is the after-tax cash flow at disposal? 6: What is the net present value? NPV, Migliotti Restaurants is looking at a project with the following forecasted sales: first-year sales quantity of...

  • 1. Develop a monthly cash budget for Bluffton Pharmacy for the upcoming year. 2. If you...

    1. Develop a monthly cash budget for Bluffton Pharmacy for the upcoming year. 2. If you were Bluffton Pharmacy's banker, would you be comfortable extending a line of credit to the pharmacy? dors grant "net 30" ays for the goods month. Crawford the upcoming year November and The interest rate e repaid the follow- Case 7 Bluffton Pharmacy, Part 2 of goods sold is 77.4 percent, and vendors grant How should the owners of a small credit terms, which means...

  • Discussion Questions: 1. What is the purpose of a distribution center? 2. Why does Cameron have...

    Discussion Questions: 1. What is the purpose of a distribution center? 2. Why does Cameron have eight warehouses? Why do you think Kelly believes six warehouses is better than eight? 3. What is the cost of holding inventory at Cameron? 4. Why should the decision to invest in inventory be different from investing in capital? 5. Do you think it is prudent to evaluate the future of the Atlanta warehouse independently from consideration of the other seven warehouses in the...

  • Security Manufacturing, Inc. is a producer of surveillance systems. Its current line of surveillance systems...

    Security Manufacturing, Inc. is a producer of surveillance systems. Its current line of surveillance systems are selling excellently. However, in order to cope with the foreseeable competition from other similar products, SM spent $6,400,000 to develop a new line of HD surveillance systems (new model development cost). The comprehensive 1440p HD surveillance system model can be used very well for any small home or business. As a result of the advanced HD analog technology made up of a 4-channel 4K...

  • Security Manufacturing, Inc. is a producer of surveillance systems. Its current line of surveillance systems are selling...

    Security Manufacturing, Inc. is a producer of surveillance systems. Its current line of surveillance systems are selling excellently. However, in order to cope with the foreseeable competition from other similar products, SM spent $6,400,000 to develop a new line of HD surveillance systems (new model development cost). The comprehensive 1440p HD surveillance system model can be used very well for any small home or business. As a result of the advanced HD analog technology made up of a 4-channel 4K...

  • Fleda's Beauty Company has $200,000 of total assets and earns 20 percent interest and taxes on...

    Fleda's Beauty Company has $200,000 of total assets and earns 20 percent interest and taxes on these assets. The ratio of total debts to total assets (or DR been set at 50 percent. The interest rate on short-term debt is 7 percent, while the interest rate on long-term debt is 10 percent. A conservative policy calls for only long-term debt with no short-term debt; an intermediate policy calls for 50 percent short-term debt and 50 percent long-term debt; and an...

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