Question
Hi
HA1-R12 (Home assignment #1 based on theRIchärdsbookOhipterawmarehouseoostn Calculate answers to all the questions below. Then go to Assessments Quizzes on Western Online and enter the answers into HA1-R12. Each answer is worth 2 points. You will have two attempts. Exercise 1. RO A warehouse manager is considering purchasin g an electric forklift for loading/unloading and handling of pallets on the dock, the operations that are currently performed with a hand pallet truck. The cost of a forklift is $20,000 and a one-time charging station set-up cost is $5,000. The useful life of the forkift is 5 years. The labor productivity improvement will save the warehouse $16,000 per year in labor costs. Additionally, faster loading and unloading of trucks will translate into better truck utilization and bring $4,000 per year in savings 1. What is the payback period in months? 2. What is the ROl over the 5-year life of this equipment in percent? Exercise 2. Overhead A 3PL warehouse provides contract services to 3 customers: A, B and C. The direct annual costs of the whole warehouse are as follows Space- $2,000,000; Labor-$800,000; MHE (material handling equipment)-$200,000 Total overhead is $600,000. There is space for 10,000 pallet locations split between The total labor hours per year are 50,000; they are split between the customers as follows: A- and C-10%. MHE is used to serve the customers in the same proportions as labor 3. What is the rate of overhead in percent? the customers as follows: A-50%-25% and C 25% 50%:8-40%, 4. What is the average warehouse labor rate per hour with overhead in dollars and cents? 5. What is the share of customer B in total overhead contribution as a percentage? 6. What is the amount in total overhead contribution of customer A in whole dollars? much overhead in dollars will remain undistributed if customer C reduces its storage needs by 20% and 7. How handling (ie, labor and MHE use) by 10%. Exercise 3. Activity-based vs. traditional costing Please use table 12.4 on page 355 of the Richards book for this exercise. Assume that it represents an accurate picture of costs in the warehouse by customer based on activities. Now lets compare it to traditional costing. 8. If under tradition pallets) and not to handling cost drivers (labor and MHE), which customer would be getting the most (the highest number of free, unpaid management hours)? al costing all management overhead A were allocated only to storage space (number of
(Home assignment #1 based on Calculate answers to all the questions below. Then go to Assessments >Quizzes on Western Online and enter the answers into HA1-R12. Each answer is worth 2 points. You will have two attempts Exercise 1. RO A warehouse manager is considering purchasing an electrie forkift for loading/unloading and handling of pallets $20,000 and a one-time charging station set-up cost is $5,000. The useful life of the forklift is 5 years. The labor on the dock, the operations that are currently performed with a hand pallet truck. The cost of a forklit s will save the warehouse $16,000 per year in labor costs. Additionally, faster loading and unloading of trucks will translate into better truck utilization and bring $4,000 per year in savings. 1. What is the payback period in months? 2. What is the ROl over the 5-year life of this equipment in percent? Exercise 2. Overhead A 3PL warehouse provides contract services to 3 customers: A, B and C. The direct annual costs of the whole warehouse are as follows: Space- $2,000,000 Labor-$800,000; MHE (material handling equipment)- $200,000 Total overhead is $600,000. There is space for 10,000 pallet locations split between the customers as follows: A-SO%, B-25%, and C-25% The total labor hours per year are 50,000; they are split between the customers as follows: A-50%8 40% and C-10%, MHE is used to serve the customers in the same proportions as labor. 3. What is the rate of overhead in percent? 4. What is the average warehouse labor rate per hour with overhead in dollars and cents? 5. What is the share of customer B in total overhead contribution as a percentage? 6. What is the amount in total overhead contribution of customer A in whole dollars? 7, How much overhead in dollars will remain undistributed if customer C reduces its storage needs by 20% and handling (ie, labor and MHE use) by 10%. Exercise 3. Activity-based vs. traditional costing Please use table 12.4 on page 355 of the Richards book for this exercise. Assume that it represents an accurate picture of costs in the warehouse by customer based on activities. Now lets compare it to traditional costing. 8. If under traditional costing all management overhead A were allocated only to storage space (number of pallets) and not to handling cost drivers (labor and MHE), which customer would be getting the most tree ride (the highest number of free, unpaid management hours)?
9. How many free management hours would that customer get? 10. Which customer would be the most disadvantaged (the highest number of paid unused management hours)? 11. How many management hours would that customer pay for and not use? Exercise 4. Charging for storage Please use table 12.5 on page 288 of the Richards book for this exercise. Assume that Monday stock was 205 pallets and that the warehouse switched to 7 days a week operation and the intake on Sunday was 60 pallets and dispatch was 45. Nothing else changed 12. For how many pallets will the 3PL charge the customer under scenario 1 (the highest number of pallets per week)? 13. For how many pallets will the 3PL charge the customer under scenario 2 (the average number of pallets in stock per week)? 14. For how many pallets will the 3PL charge the customer under scenario 3 (opening stock plus intake)? 15. For how many pallets will the 3PL charge the customer under scenario 4 (opening stock plus intake minus dispatches)i? Exercise 5. Charging for storage and handling Please use table 12.5 on p. 288 of the Richards book for this exercise without any changes given in exercise 4. Assume that the cost of one pallet storage is $10 per week, inbound (intake) handling is $2.50 per pallet and the cost of outbound handling (dispatch) is $4.00 per pallet. All overhead is applied at a rate of 20% to both storage and handling. Assume the week consists of seven days, Monday through Sunday. In a closed-book contract where charges are billed on a weekly basis and indude 15% profit applied to all costs, the 3PL uses minimum daily average pallet storage requirement of 100 pallets and minimum weekly inbound and outbound handling requirements of 350 pallets each to base the charges on if the actual daily average usage numbers are below the minima. The charges on the bill are itemized as storage, inbound handling, and outbound handling 16. What will the customer be billed for storage for that week if the parties use the average daily pallet method (scenario 2)? 17. What is the agreed contract charge per storage of one pallet per week? 18. What will the customer be billed for inbound handling for that week? 19. What is the total charge for that week? 20. In an open book or cost-plus contract, a total profit may be the last item on the bill after the cost subtotal What will this profit line item be under these conditions for that week? 21. Bonus (extra credit) question. Answer question 16 under the modified terms of exercise 4. 22. Bonus (extra credit) question. Answer question 19 under the modified terms of exercise 4
HA1- R12 (Home assignment #1 based on the Richards book, Chapter 12, Warehouse Costs) Calculate answers to all the questions below. Then go to AssessmentsQuizzes on Western Online and enter the answers into HA1-R12. Each answer is worth 2 points. You will have two attempts Exercise 1. ROI A warehouse manager is considering purchasing an electric forklift for loading/unloading and handling of pallets on the dock, the operations that are currently performed with a hand pallet truck. The cost of a forklift is $20,000 and a one-time charging station set-up cost is $5,000. The useful life of the forklift is 5 years The labor productivity improvement will save the warehouse $16,000 per year in labor costs. Additionally, faster loading and unloading of trucks will translate into better truck ubilization and bring $4,000 per year in savings. 1. What is the payback period in months? 2. What is the ROI over the 5-year life of this equipment in percent? Exercise 2. Overhead A 3PL warehouse provides contract services to 3 customers: A, B and C. The direct annual costs of the whole warehouse are as follows: Space $2,000,000; Labor $800,000; MHE (material handling equipment)-$200,000. Total overhead is $600,000. There is space for 10,000 pallet locations split between the customers as follows: A-50%; B-25%, and C-25%. The total labor hours per year are 50,000; they are split between the customers as follows: A-50%; B-40 and C-10%, MHE is used to serve the customers in the same proportions as labor 3. What is the rate of overhead in percent? 4. What is the average warehouse labor rate per hour with overhead in dollars and cents? 5. What is the share of customer B in total overhead contribution as a percentage? 6. What is the amount in total overhead contribution of customer A in dollars? 7. How much overhead in dollars will remain undistributed if customer C reduces its storage needs by 20% and handling (i.e. labor and MHE use) by 10%. Exercise 3. Activity-based vs. traditional costing Please use table 12.4 on page 286 of the Richards book for this exercise. Assume that it represents an accurate picture of costs in the warehouse by customer based on activities. Now lets compare it to traditional costing 8. If under traditional costing all management overhead A were allocated only to storage space (number of pallets) and not to handling cost drivers (labor and MHE), which customer would be getting the most free ride (the highest number of free, unpaid management hours)?
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Initial Investment:
Forklif $20,000
Charging Station $5,000
Total initial investment $25,000
Annual saving from labor productivity $16,000
Annual saving from truck utilization $4,000
Total Annual savings $20,000
Payback Period in years 1.25 (25000/20000)
Payback Period in Months 15 (1.25*12)
ROI (Return on investment) 0.8 (20000/25000)
ROI (Return on investment in percent) 80%
AsHOMEWORKLIB Guideline, in order tooptimize resources, experts are required to answer one question
Kindly upload balance questions again
Add a comment
Know the answer?
Add Answer to:
Hi HA1-R12 (Home assignment #1 based on theRIchärdsbookOhipterawmarehouseoostn Calculate answers to all the questions below. Then...
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
  • HA1- chapter12 (Home assignment #1 based on the Richards book, Chapter 12, warehouse costs") Exercise 2....

    HA1- chapter12 (Home assignment #1 based on the Richards book, Chapter 12, warehouse costs") Exercise 2. Overhead A 3PL warehouse provides contract services to 3 customers: A, B and C. The direct annual costs of the whole warehouse are as follows: Space $2,000,000 Labor $800,000; [MHE (material handling equipment)-$200,000. Total overhead is $600,000. There is space for 10,000 pallet locations split between the customers as follows: A- 50%iB-25%, and C-2596. The total labor hours per year are 50,000; they are...

  • HA1 – R12

    Exercise 2. OverheadA 3PL warehouse provides contract services to 3 customers: A, B and C. The direct annual costs of the whole warehouse are as follows:Space - $2,000,000;Labor - $800,000;MHE (material handling equipment) - $200,000.Total overhead is $600,000.There is space for 10,000 pallet locations split between the customers as follows: A – 50%; B – 25%, and C – 25%. The total labor hours per year are 50,000; they are split between the customers as follows: A – 50%; B – 40%, and C – 10%. MHE is used to serve the...

  • HA1 – R12

    Exercise 3. Activity-based vs. traditional costingPlease use table 12.4 on page 286 of the Richards book for this exercise. Assume that it represents an accurate picture of costs in the warehouse by customer based on activities. Now let’s compare it to traditional costing.8. If under traditional costing all management overhead A were allocated only to storage space (number of pallets) and not to handling cost drivers (labor and MHE), which customer would be getting the most “free ride” (the highest number of free,...

  • Table 12.4 page 355 is below Subtitie 2 5 HA1-chapter12 (Home assignment #1 based on the...

    Table 12.4 page 355 is below Subtitie 2 5 HA1-chapter12 (Home assignment #1 based on the Richards book, Chapter 12, warehouse costs") Exercise 3. Activity-based vs. traditional costing Please use table 12.4 on page 355 of the Richards book for this exercise. Assume that it represents an accurate picture of costs in the warehouse by customer based on activities. Now let's compare it to traditional costing. 8. If under traditional costing all management overhead A were allocated only to storage...

  • HA1 – R12

    Exercise 5. Charging for storage and handlingPlease use table 12.5 on p. 288 of the Richards book for this exercise without any changes given in exercise 4. Assume that the cost of one pallet storage is $10 per week, inbound (intake) handling is $2.50 per pallet and the cost of outbound handling (dispatch) is $4.00 per pallet. All overhead is applied at a rate of 20% to both storage and handling. Assume the week consists of seven days, Monday through...

  • Table 12.4 (Home assignment #1 based on the Richards book, Chapter 12, "Warehouse Costs.) Exercise 3....

    Table 12.4 (Home assignment #1 based on the Richards book, Chapter 12, "Warehouse Costs.) Exercise 3. Activity-based vs. traditional costing Please use table 12.4 on page 355 of the Richards book for this exercise. Assume that it represents an accurate picture of costs in the warehouse by customer based on activities. Now let's compare it to traditional costing. 8. If under traditional costing all management overhead A were allocated only to storage space (number of pallets) and not to handling...

  • Check my work Required information The following information applies to the questions displayed below.) Part 1...

    Check my work Required information The following information applies to the questions displayed below.) Part 1 of 5 128 Kitchen King's Toledo plant manufactures three product lines, all multi-burner, ceramic cook tops. The plant's three product models are the Regular (REG), the Advanced (ADV), and the Gourmet (GMT). Until recently, the plant used a job-order product-costing system, with manufacturing overhead applied on the basis of direct-labor hours. The following table displays the basic data upon which the traditional costing system...

  • cách). 1. Activity-based costing differs from a traditional costing system in all of the following aspects...

    cách). 1. Activity-based costing differs from a traditional costing system in all of the following aspects EXEPT: A) Direct materials, direct labor, and shipping costs are directly assigned to cost objects. B) Numerous overhead cost pools are used in ABC system. C) Most but not all manufacturing costs are assigned to products. D) Non-manufacturing as well as manufacturing costs may be assigned to products. 2. In activity-based costing, the activity rate for an activity cost pool is computed by dividing...

  • Hello, I am doing homework questions and was hoping to compare answers. Thanks, 1) Ernsting Printers...

    Hello, I am doing homework questions and was hoping to compare answers. Thanks, 1) Ernsting Printers has contracts to complete weekly supplements required by forty-six customers. For the year 2015, manufacturing overhead cost estimates total $420,000 for an annual production capacity of 12 million pages. For 2015 Ernsting Printers has decided to evaluate the use of additional cost pools. After analyzing manufacturing overhead costs, it was determined that number of design changes, setups, and inspections are the primary manufacturing overhead...

  • (The following information applies to the questions displayed below.) Fields Company has two manufacturing departments, forming...

    (The following information applies to the questions displayed below.) Fields Company has two manufacturing departments, forming and painting. The company uses the weighted-average method of process costing. At the beginning of the month, the forming department has 36,000 units in inventory, 65% complete as to materials and 35% complete as to conversion costs. The beginning inventory cost of $81,100 consisted of $57,400 of direct materials costs and $23,700 of conversion costs. During the month, the forming department started 510,000 units....

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