70.2K
Verified Solution
Link Copied!
Use the chart above to determine the following for product "Able"
Any inventory left over, or still on hand and not sold, has what percent of a carry cost?
Production Vs. Capacity C99915 Andrews Baldwin Chester Digby Ferris 1.000 2.000 4,000 6.000 7,000 8,000 3,000 Capacity 5,000 Production 2nd Shift & Over- time Primary Segment Trad Low Units Sold 822 2,096 Unit Inven Revision Age tory Date Dec.31 MTBF 1,146 11/8/2022 4.2 17500 85 3/12/2022 4.6 15000 04/19/2017 4.7 23000 06/29/2016 5.5 25000 418 9/30/2022 3.4 19000 Pfmn Coord 6.4 3.2 8.0 9.4 5.7 Name Able Acre Adam Aft Agape Size Coord 13.6 16.7 12.0 15.5 14.3 0% Contr. Marg. 31% 35% Price $29.00 $21.00 $34.00 $31.00 $29.00 Material Labor Cost Cost $9.85 $5.97 $6.31 $6.91 $0.00 $0.00 $0.00 $0.00 $9.68 $8.85 Auto mation Next Round 6.0 6.0 3.0 3.0 Capacity Next Round 1,800 1,400 Plant Utiliz. 66% 149% 0% 50% 0% 0% 100% 0% 0 Trad 0% 31% 1,019 10% 600 198% 5.0 Baker Bead Bid Bold Buddy Bid2 Trad Low High Pfmn Size 2.267 2,691 193 970 538 8.5 5.5 3 4/1/2020 107 5/25/2014 264 11/18/2021 79 8/28/2021 07/16/2021 06/5/2023 3.0 7.6 1.4 1.4 1.5 0.0 17500 14000 23000 27000 19000 6.2 3.0 10.0 12.1 5.7 0.0 13.9 17.0 10.0 13.8 8.4 0.0 $26.99 $20.99 $38.99 $33.49 $32.49 $0.00 $9.63 $5.79 $14.69 $15.60 $12.79 $0.00 $6.72 $5.29 $7.33 $8.82 $7.94 $0.00 36% 46% 35% 27% 36% 0% 0% 100% 0% 75% 0% 0% 1,800 1,400 900 600 600 200 83% 200% 39% 175% 58% 0% ba OUR Cake Cedar Cid Coat Cure Cape Trad Low High Pimn Size High 1,301 825 553 472 247 399 07/29/2021 652 10/23/2020 292 1/31/2021 10 12/2/2020 538 4/15/2021 21 7/27/2021 2.2 3.1 2.1 2.4 2.2 0.4 17500 13000 25000 27000 17000 25000 7.2 3.0 10.2 11.8 4.4 11.0 12.5 17.0 9.8 14.2 9.1 9.0 $27.00 $22.00 $38.00 $34.00 $35.00 $38.50 $10.69 $5.49 $15.46 $15.33 $11.49 $16.17 $7.76 $6.69 $6.78 $12.19 $9.44 $8.38 30% 35% 37% 24% 23% 35% 45% 22% 0% 100% 25% 100% 3.0 700 900 800 100 600 600 143% 121% 93% 198% 124% 84% 4.5 6.0 4.0 Daze Dell Dixie Dot Dune Dakota Trad Low High Pimn Size 1,086 2,037 596 403 630 399 3/15/2020 383 2/27/2019 98 9/12/2021 271 11/27/2021 08/31/2021 03/21/2022 3.1 7.6 1.3 1.8 1.5 0.0 18000 18000 23050 26000 19000 5.7 3.0 10.7 11.4 5.4 0.0 14.1 17.0 9.3 14.6 8.6 0.0 $29.00 $24.00 $38.50 $34.00 $34.00 $0.00 $9.47 $6.99 $15.32 $14.70 $12.60 $0.00 $9.95 $8.15 $9.31 $9.31 $9.31 $0.00 29% 34% 35% 25% 36% 0% 67% 41% 0% 0% 0% 0% 5.0 4.0 4.0 900 1,400 1,000 600 700 600 165% 139% 56% 81% 64% 0% 4.0 3.0 Eat Ebb Echo Edge Egg Echo2 Trad Low High Pimn Size High 2,028 3,066 551 792 984 494 0 12/4/2021 662 3/14/2023 463 11/8/2021 151 12/14/2021 0 12/14/2021 0 12/21/2021 1.5 17500 7.6 14000 1.2 23000 1.4 27000 1.3 19000 0.7 26550 7.6 3.0 11.0 12.5 6.1 11.2 12.4 17.0 9.0 13.9 7.4 8.7 $27.19 $20.00 $38.50 $33.50 $33.50 $38.50 $10.91 $6.77 $5.79 $2.89 $15.57 $9.51 $15.81 $11.27 $13.46 $11.39 $16.86 $9.84 36% 53% 29% 19% 28% 32% 37% 76% 14% 59% 66% 25% 8.0 10.0 5.0 5.0 5.0 1,400 2,000 900 600 600 400 136% 175% 113% 157% 164% 124% 4.0 4.0 6.0 Fast Feat Fist Foam Fume Fox Trad Low High Pimn Size High 1,493 1,386 526 657 881 690 04/21/2020 07/27/2023 198 12/14/2021 135 9/19/2021 12 12/12/2021 53 12/12/2021 3.1 14000 7.6 13000 1.1 25000 1.4 27000 1.3 16000 0.5 25000 5.5 3.0 11.3 12.8 6.1 12.0 14.5 17.0 8.6 13.5 7.2 8.0 $21.50 $21.50 $38.50 $33.40 $33.50 $38.50 $8.00 $5.49 $16.48 $16.08 $12.68 $17.05 $10.66 $7.61 $11.18 $9.64 $9.82 $7.84 3.0 12% 38% 27% 22% 32% 36% 100% 100% 40% 33% 42% 50% 600 1,100 650 650 750 500 198% 198% 139% 132% 140% 149% 4.5 4.0 5.5 Production Vs. Capacity C99915 Andrews Baldwin Chester Digby Ferris 1.000 2.000 4,000 6.000 7,000 8,000 3,000 Capacity 5,000 Production 2nd Shift & Over- time Primary Segment Trad Low Units Sold 822 2,096 Unit Inven Revision Age tory Date Dec.31 MTBF 1,146 11/8/2022 4.2 17500 85 3/12/2022 4.6 15000 04/19/2017 4.7 23000 06/29/2016 5.5 25000 418 9/30/2022 3.4 19000 Pfmn Coord 6.4 3.2 8.0 9.4 5.7 Name Able Acre Adam Aft Agape Size Coord 13.6 16.7 12.0 15.5 14.3 0% Contr. Marg. 31% 35% Price $29.00 $21.00 $34.00 $31.00 $29.00 Material Labor Cost Cost $9.85 $5.97 $6.31 $6.91 $0.00 $0.00 $0.00 $0.00 $9.68 $8.85 Auto mation Next Round 6.0 6.0 3.0 3.0 Capacity Next Round 1,800 1,400 Plant Utiliz. 66% 149% 0% 50% 0% 0% 100% 0% 0 Trad 0% 31% 1,019 10% 600 198% 5.0 Baker Bead Bid Bold Buddy Bid2 Trad Low High Pfmn Size 2.267 2,691 193 970 538 8.5 5.5 3 4/1/2020 107 5/25/2014 264 11/18/2021 79 8/28/2021 07/16/2021 06/5/2023 3.0 7.6 1.4 1.4 1.5 0.0 17500 14000 23000 27000 19000 6.2 3.0 10.0 12.1 5.7 0.0 13.9 17.0 10.0 13.8 8.4 0.0 $26.99 $20.99 $38.99 $33.49 $32.49 $0.00 $9.63 $5.79 $14.69 $15.60 $12.79 $0.00 $6.72 $5.29 $7.33 $8.82 $7.94 $0.00 36% 46% 35% 27% 36% 0% 0% 100% 0% 75% 0% 0% 1,800 1,400 900 600 600 200 83% 200% 39% 175% 58% 0% ba OUR Cake Cedar Cid Coat Cure Cape Trad Low High Pimn Size High 1,301 825 553 472 247 399 07/29/2021 652 10/23/2020 292 1/31/2021 10 12/2/2020 538 4/15/2021 21 7/27/2021 2.2 3.1 2.1 2.4 2.2 0.4 17500 13000 25000 27000 17000 25000 7.2 3.0 10.2 11.8 4.4 11.0 12.5 17.0 9.8 14.2 9.1 9.0 $27.00 $22.00 $38.00 $34.00 $35.00 $38.50 $10.69 $5.49 $15.46 $15.33 $11.49 $16.17 $7.76 $6.69 $6.78 $12.19 $9.44 $8.38 30% 35% 37% 24% 23% 35% 45% 22% 0% 100% 25% 100% 3.0 700 900 800 100 600 600 143% 121% 93% 198% 124% 84% 4.5 6.0 4.0 Daze Dell Dixie Dot Dune Dakota Trad Low High Pimn Size 1,086 2,037 596 403 630 399 3/15/2020 383 2/27/2019 98 9/12/2021 271 11/27/2021 08/31/2021 03/21/2022 3.1 7.6 1.3 1.8 1.5 0.0 18000 18000 23050 26000 19000 5.7 3.0 10.7 11.4 5.4 0.0 14.1 17.0 9.3 14.6 8.6 0.0 $29.00 $24.00 $38.50 $34.00 $34.00 $0.00 $9.47 $6.99 $15.32 $14.70 $12.60 $0.00 $9.95 $8.15 $9.31 $9.31 $9.31 $0.00 29% 34% 35% 25% 36% 0% 67% 41% 0% 0% 0% 0% 5.0 4.0 4.0 900 1,400 1,000 600 700 600 165% 139% 56% 81% 64% 0% 4.0 3.0 Eat Ebb Echo Edge Egg Echo2 Trad Low High Pimn Size High 2,028 3,066 551 792 984 494 0 12/4/2021 662 3/14/2023 463 11/8/2021 151 12/14/2021 0 12/14/2021 0 12/21/2021 1.5 17500 7.6 14000 1.2 23000 1.4 27000 1.3 19000 0.7 26550 7.6 3.0 11.0 12.5 6.1 11.2 12.4 17.0 9.0 13.9 7.4 8.7 $27.19 $20.00 $38.50 $33.50 $33.50 $38.50 $10.91 $6.77 $5.79 $2.89 $15.57 $9.51 $15.81 $11.27 $13.46 $11.39 $16.86 $9.84 36% 53% 29% 19% 28% 32% 37% 76% 14% 59% 66% 25% 8.0 10.0 5.0 5.0 5.0 1,400 2,000 900 600 600 400 136% 175% 113% 157% 164% 124% 4.0 4.0 6.0 Fast Feat Fist Foam Fume Fox Trad Low High Pimn Size High 1,493 1,386 526 657 881 690 04/21/2020 07/27/2023 198 12/14/2021 135 9/19/2021 12 12/12/2021 53 12/12/2021 3.1 14000 7.6 13000 1.1 25000 1.4 27000 1.3 16000 0.5 25000 5.5 3.0 11.3 12.8 6.1 12.0 14.5 17.0 8.6 13.5 7.2 8.0 $21.50 $21.50 $38.50 $33.40 $33.50 $38.50 $8.00 $5.49 $16.48 $16.08 $12.68 $17.05 $10.66 $7.61 $11.18 $9.64 $9.82 $7.84 3.0 12% 38% 27% 22% 32% 36% 100% 100% 40% 33% 42% 50% 600 1,100 650 650 750 500 198% 198% 139% 132% 140% 149% 4.5 4.0 5.5
Answer & Explanation
Solved by verified expert
