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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!