The Baldwin company wants to decrease its plant utilization for Beetle by 15%. How many units would need to be produced next year to meet this production goal? Ignore impact of accounts payable on plant utilization.

Transcribed Image Text:

Units Produced Andrews 5,285 Baldwin 9,159 Chester 9,684 Digby 6,981 Production Information Name Primary Segment Units Sold Unit Inventory Revision Date Age Dec.31 MTBF Pfmn Coord Size Coord Price Material Cost Labor Cost Contr. Marg. 2nd Shift & Overtime Automation Next Round Capacity Next Round Plant Utiliz. Abby Nano 2,386 1,921 5/25/2024 3.0 24000 12.5 6.3 $28.00 $11.68 $6.74 31% 100% 7.0 1,250 198% Alan Elite 2,315 101 7/24/2024 1.6 26000 14.6 8.0 $30.00 $12.40 $8.43 30% 100% 6.0 1,220 198% Apple 0 1,380 7/4/2024 2.0 20000 6.0 13.5 $49.00 $5.97 $8.16 0% 0% 5.0 848 40% Ate 0 839 7/24/2024 2.0 22000 9.3 10.9 $50.00 $8.48 $6.80 NA% 0% 6.0 834 40% Bat Thrift 2,420 185 4/29/2024 2.7 17000 8.5 11.5 $15.00 $6.69 $1.52 43% 48% 10.0 1,650 147% Beetle Thrift 2,426 190 4/29/2024 2.7 17000 8.7 11.3 $15.00 $6.82 $1.42 42% 21% 10.0 1,900 120% Bid Core 2,265 320 12/13/2024 1.6 18000 11.2 8.1 $23.00 $9.03 $4.76 39% 77% 8.0 1,300 175% Boat Core 2,196 307 12/13/2024 1.6 20000 11.9 8.6 $25.00 $9.64 $4.49 42% 42% 8.0 1,550 141% Camp Thrift 1,624 156 12/20/2023 3.2 14000 8.2 11.8 $15.00 $5.93 $1.33 49% 20% 10.0 1,250 119% Cent Thrift 1,809 266 12/7/2021 4.1 16000 9.1 10.9 $17.00 $7.14 $1.30 45% 13% 10.0 1,600 111% Clack Nano 1,459 235 12/20/2024 1.0 18000 13.3 3.7 $28.00 $11.83 $5.71 36% 50% 7.0 1,000 149% Cone Elite 932 274 12/20/2024 1.0 20000 16.7 6.5 $34.00 $12.62 $5.15 46% 11% 7.0 950 109% Creak Core 1,728 217 12/13/2024 1.0 16000 11.1 8.7 $19.00 $8.63 $4.41 31% 68% 8.0 1,100 167% Cat Core 1,965 95 12/13/2024 1.0 16000 10.8 9.1 $20.00 $8.38 $4.58 36% 100% 8.0 1,040 198% Dart Nano 2,003 419 9/12/2024 1.3 23000 14.0 3.5 $34.00 $13.04 $6.51 41% 83% 7.0 1,200 182% Deft Elite 1,513 311 8/20/2024 1.6 25000 17.1 6.0 $34.00 $13.82 $6.63 38% 100% 7.0 850 198% Dim Nano 1,495 346 8/12/2024 1.4 23000 14.4 3.2 $37.00 $13.28 $5.84 46% 24% 7.0 1,250 123% Don Elite 1,468 380 8/20/2024 1.3 25000 16.9 5.7 $37.00 $13.83 $5.66 45% 14% 7.0 1,400 113% Units Produced Andrews 5,285 Baldwin 9,159 Chester 9,684 Digby 6,981 Production Information Name Primary Segment Units Sold Unit Inventory Revision Date Age Dec.31 MTBF Pfmn Coord Size Coord Price Material Cost Labor Cost Contr. Marg. 2nd Shift & Overtime Automation Next Round Capacity Next Round Plant Utiliz. Abby Nano 2,386 1,921 5/25/2024 3.0 24000 12.5 6.3 $28.00 $11.68 $6.74 31% 100% 7.0 1,250 198% Alan Elite 2,315 101 7/24/2024 1.6 26000 14.6 8.0 $30.00 $12.40 $8.43 30% 100% 6.0 1,220 198% Apple 0 1,380 7/4/2024 2.0 20000 6.0 13.5 $49.00 $5.97 $8.16 0% 0% 5.0 848 40% Ate 0 839 7/24/2024 2.0 22000 9.3 10.9 $50.00 $8.48 $6.80 NA% 0% 6.0 834 40% Bat Thrift 2,420 185 4/29/2024 2.7 17000 8.5 11.5 $15.00 $6.69 $1.52 43% 48% 10.0 1,650 147% Beetle Thrift 2,426 190 4/29/2024 2.7 17000 8.7 11.3 $15.00 $6.82 $1.42 42% 21% 10.0 1,900 120% Bid Core 2,265 320 12/13/2024 1.6 18000 11.2 8.1 $23.00 $9.03 $4.76 39% 77% 8.0 1,300 175% Boat Core 2,196 307 12/13/2024 1.6 20000 11.9 8.6 $25.00 $9.64 $4.49 42% 42% 8.0 1,550 141% Camp Thrift 1,624 156 12/20/2023 3.2 14000 8.2 11.8 $15.00 $5.93 $1.33 49% 20% 10.0 1,250 119% Cent Thrift 1,809 266 12/7/2021 4.1 16000 9.1 10.9 $17.00 $7.14 $1.30 45% 13% 10.0 1,600 111% Clack Nano 1,459 235 12/20/2024 1.0 18000 13.3 3.7 $28.00 $11.83 $5.71 36% 50% 7.0 1,000 149% Cone Elite 932 274 12/20/2024 1.0 20000 16.7 6.5 $34.00 $12.62 $5.15 46% 11% 7.0 950 109% Creak Core 1,728 217 12/13/2024 1.0 16000 11.1 8.7 $19.00 $8.63 $4.41 31% 68% 8.0 1,100 167% Cat Core 1,965 95 12/13/2024 1.0 16000 10.8 9.1 $20.00 $8.38 $4.58 36% 100% 8.0 1,040 198% Dart Nano 2,003 419 9/12/2024 1.3 23000 14.0 3.5 $34.00 $13.04 $6.51 41% 83% 7.0 1,200 182% Deft Elite 1,513 311 8/20/2024 1.6 25000 17.1 6.0 $34.00 $13.82 $6.63 38% 100% 7.0 850 198% Dim Nano 1,495 346 8/12/2024 1.4 23000 14.4 3.2 $37.00 $13.28 $5.84 46% 24% 7.0 1,250 123% Don Elite 1,468 380 8/20/2024 1.3 25000 16.9 5.7 $37.00 $13.83 $5.66 45% 14% 7.0 1,400 113%