Question: Can you help me, this is capsim practice round 7. thank you Name Pfmn Size MTBF Revision Date Age at Revision R&D Cost Able ?
Can you help me, this is capsim practice round 7. thank you
| Name | Pfmn | Size | MTBF | Revision Date | Age at Revision | R&D Cost |
|---|---|---|---|---|---|---|
| Able | ? | ? | ? | 09-Mar-28 | 1.2 | $189 |
| Adam | 5.5 | 15.1 | 14000 | 20-Apr-28 | 1.5 | $306 |
| Afirt | 15.1 | 5.5 | 23000 | 27-Sep-28 | 1.8 | $751 |
| Ahen | 16.4 | 11.4 | 27000 | 29-Aug-28 | 1.8 | $673 |
| Ave | 9.2 | 4.2 | 20000 | 08-Nov-28 | 1.6 | $871 |
| Name | Price | Promo Budget | Sales Budget | Benchmark Prediction | Your Forecast | Gross Revenue | Variable Costs | Contrib Margin | Less Promo/Sales |
|---|---|---|---|---|---|---|---|---|---|
| Able | $ | $ | $ | 2,761 |
| $ 94,500 | $ 72,145 | $ 22,355 | $ 17,655 |
| Adam | $ | $ | $ | 0 |
| $ 43,200 | $ 29,604 | $ 13,596 | $ 8,596 |
| Afirt | $ | $ | $ | 0 |
| $ 170,000 | $ 158,268 | $ 11,732 | $ 6,732 |
| Ahen | $ | $ | $ | 3,481 |
| $ 198,766 | $ 199,178 | $- 412 | ($ 3,012) |
| Ave | $ | $ | $ | 0 |
| $ 105,600 | $ 101,650 | $ 3,950 | $ 350 |
| Total | $ 11,500 | $ 9,400 | 6,243 | 19,404 | $ 612,066 | $ 560,844 | $ 51,222 | $ 30,322 |
A/R Lag (days) : A/P Lag (days) :
Schedule
| Able | Adam | Afirt | Ahen | Ave | Total | |
|---|---|---|---|---|---|---|
| Unit Sales Forecast | 3,000 | 1,350 | 5,000 | 6,854 | 3,200 | 19,404 |
| Inventory On Hand | 434 | 0 | 114 | 0 | 136 | 684 |
| Production Schedule | 1,685 | |||||
| Production After Adj. | 1,193 | 55 | 98 | 123 | 138 | 1,609 |
Margins
| Able | Adam | Afirt | Ahen | Ave | ||
|---|---|---|---|---|---|---|
| 2nd Shift Production% | 41.9% | 93.6% | 98.3% | 24.1% | 88.4% | |
| Labor Cost/Unit | $13.59 | $16.30 | $16.37 | $14.46 | $16.21 | |
| Material Cost/Unit | $10.46 | $5.63 | $15.28 | $14.60 | $15.56 | |
| Total Unit Cost | $24.05 | $21.93 | $31.65 | $29.06 | $31.77 | |
| Contribution Margin | 23.7% | 31.5% | 6.9% | ($ 0)% | 3.7% |
Physical Plant
| Able | Adam | Afirt | Ahen | Ave | Total | |
|---|---|---|---|---|---|---|
| 1st Shift Capacity | 881 | 30 | 52 | 104 | 77 | 1,144 |
| Buy/Sell Capacity | 284 | |||||
| Automation Rating | 2.0 | 1.0 | 1.0 | 1.0 | 1.0 | |
| New Autom. Rating | ||||||
| Investment ($000) | $ 3,500 | $ 100 | $ 0 | $ 240 | $ 0 | $ 3,840 |
| Max Invest | $ 4,202 |
|---|---|
| A/P Lag (days) ? |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
