Baldwin round $1$ practice numbers to make company best

Recalculate

$M$ Marketing

Teamname: Baldwin $|$ Industry ID: C$152268|$ Round: $1|$ Year: $2025$

Draft saved at Sep $04,202401$:$12$PM EDT

$\backslash$table$[[$Name$,$Price $(1),\backslash$table$[[$Promo$],[$Budget $(1)]],\backslash$table$[[$Sales$],[$Budget$]],\backslash$table$[[$Benchmark$],[$Prediction$]],\backslash$table$[[$Your$],[$Forecast$]],\backslash$table$[[$Gross$],[$Revenue$]],\backslash$table$[[$Variable$],[$Costs$]],\backslash$table$[[$Contrib$],[$Margin$]],\backslash$table$[[$Less$],[$Promo$/$Sales$]]],[$Baker$,$$$,28\mathrm{.}00,$$$,1000,$$$,1000,896,0,$$ $25,078,$$ $17,130,$$ $7,948,$$ $5,948],[$Bead$,$$$,21\mathrm{.}00,$$$,900,$$$,900,1,357,0,$$ $28,502,$$ $20,482,$$ $8,020,$$ $6,220],[$Bid$,$$$,38\mathrm{.}00,$$$,800,$$$,800,355,0,$$ $13,507,$$ $8,707,$$ $4,800,$$ $3,200],[$Bold$,$$$,33\mathrm{.}00,$$$,700,$$$,700,366,0,$$ $12,074,$$ $8,936,$$ $3,138,$$ $1,738],[$Buddy$,$$$,33\mathrm{.}00,$$$,700,$$$,700,390,0,$$ $12,873,$$ $8,659,$$ $4,213,$$ $2,813],[$Bald$,,$$$0\mathrm{.}0,,$$ $0,,$$ $0,0,-,$$ $0,$$ $0,$$ $0,$$ $0],[$NA$,,$$$0\mathrm{.}0,,$$ $0,,$$ $0,0,-,$$ $0,$$ $0,$$ $0,$$ $0],[$NA$,,$$$0\mathrm{.}0,,$$ $0,,$$ $0,0,-,$$ $0,$$ $0,$$ $0,$$ $0],[$Total$,,,,$$ $4,100,,$$ $4,100,3,364,0,$$ $92,034,$$ $63,913,$$ $28,121,$$ $19,921]]$

A$/$R Lag $($days$)($i$)$: $30$ Recalculate

$\backslash$table$[[$Production$],[$Schedule$,$Baker,Bead,Bid,Bold,Buddy,Bald,NA$,$NA$,$Total$],[$Unit Sales Forecast,$896,1,357,355,366,390,0,0,0,3,364],[$Inventory On Hand,$189,39,40,78,62,0,0,0,408],[$Production Schedule,$1200,1820,410,440,380,0,,,4,250],[$Production After Adj.,$1,188,1,802,406,436,376,0,0,0,4,209],[$Margins$],[2$nd Shift Production$\%,0\mathrm{.}0\%,30\mathrm{.}0\%,0\mathrm{.}0\%,0\mathrm{.}0\%,0\mathrm{.}0\%,0\mathrm{.}0\%,0,0,],[$Labor Cost$/$Unit$,$$$7\mathrm{.}85,$$$7\mathrm{.}46,$$$8\mathrm{.}97,$$$8\mathrm{.}97,$$$8\mathrm{.}97,$$$0\mathrm{.}00,0,0,],[$Material Cost$/$Unit $($i$),$$$11\mathrm{.}28,$$$7\mathrm{.}63,$$$15\mathrm{.}53,$$$15\mathrm{.}45,$$$13\mathrm{.}23,$$$16\mathrm{.}04,0,0,],[$Total Unit Cost $($i$),$$$19\mathrm{.}13,$$$15\mathrm{.}09,$$$24\mathrm{.}50,$$$24\mathrm{.}42,$$$22\mathrm{.}20,$$$16\mathrm{.}04,0,0,],[$Contribution Margin $($i$),31\mathrm{.}7\%,28\mathrm{.}1\%,35\mathrm{.}5\%,26\mathrm{.}0\%,32\mathrm{.}7\%,0\mathrm{.}0\%,0,0,],[$Physical Plant,,,,,,,,,Total$],[1$st Shift Capacity,$1,800,1,400,900,600,600,0,0,0,5,300],[$Buy$/$Sell Capacity,$0,0,0,0,0,0,,,0],[$Automation Rating $($i$),4\mathrm{.}0,5\mathrm{.}0,3\mathrm{.}0,3\mathrm{.}0,3\mathrm{.}0,0\mathrm{.}0,0\mathrm{.}0,0\mathrm{.}0,],[$New Autom. Rating,$4\mathrm{.}0,5\mathrm{.}0,3\mathrm{.}0,3\mathrm{.}0,3\mathrm{.}0,0\mathrm{.}0,,,],[$Investment $($$$000),$$ $0,$$ $0,$$ $0,$$ $0,$$ $0,$$ $0,$$ $0,$$ $0,$$ $0],[$Workforce$,$Last Year $($i$),$Needed $($i$),$This Year $\%($i$),$This Year $($i$),1$st Shift $($i$),2$nd Shift $($i$),$Overtime $($i$),$Max Invest $($i$),$$ $32,694]]$ Liabilities & Owner's Equity