See description and attachment.
5/31/2017 Capstone WebApp
http://ww3.capsim.com/WebApp/userinterface/index.cfm?template=incomeStatement.cfm 1/2
Draft saved at May 31, 2017 06:17PM MDT Teamname: Digby | SimID: C88580 | Round: 1 | Year: 2018
Income Statement Revenue Daze Dell Dixie Dot Dune NA NA NA TOTAL 0.0%
Sales $ 73,082 $ 27,994 $ 35,000 $ 12,330 $ 23,595 $ 0 $ 0 $ 0 $ 172,001 100.0% VARIABLE COSTS
Direct Labor $ 22,419 $ 10,415 $ 10,627 $ 3,507 $ 6,548 $ 0 $ 0 $ 0 $ 53,515 31.1% Direct Material $ 27,883 $ 10,167 $ 15,507 $ 5,769 $ 9,299 $ 0 $ 0 $ 0 $ 68,624 39.9% Inventory Carry $ 0 $ 942 $ 871 $ 417 $ 0 $ 0 $ 0 $ 0 $ 2,230 1.3% Total Variable Costs $ 50,302 $ 21,523 $ 27,006 $ 9,693 $ 15,847 $ 0 $ 0 $ 0 $ 124,370 72.3% Contribution Margin $ 22,781 $ 6,471 $ 7,994 $ 2,637 $ 7,748 $ 0 $ 0 $ 0 $ 47,631 27.7%
PERIOD COSTS Depreciation $ 2,880 $ 2,427 $ 1,440 $ 720 $ 720 $ 0 $ 0 $ 0 $ 8,187 4.8% SG&A: R&D $ 306 $ 0 $ 1,000 $ 0 $ 482 $ 0 $ 0 $ 0 $ 1,788 1.0%
:Promotion $ 2,100 $ 900 $ 900 $ 700 $ 1,100 $ 0 $ 0 $ 0 $ 5,700 3.3% :Sales $ 2,000 $ 900 $ 2,000 $ 700 $ 1,100 $ 0 $ 0 $ 0 $ 6,700 3.9% :Admin $ 727 $ 278 $ 348 $ 123 $ 235 $ 0 $ 0 $ 0 $ 1,711 1.0%
Total Period Costs $ 8,013 $ 4,505 $ 5,688 $ 2,243 $ 3,636 $ 0 $ 0 $ 0 $ 24,085 14.0% Net Margin $ 14,768 $ 1,966 $ 2,306 $ 394 $ 4,112 $ 0 $ 0 $ 0 $ 23,546 13.7%
Other (Fees, Write Offs, TQM) $ 450 0.3% EBIT $ 23,096 13.4%
Interest $ 5,930 3.4% Taxes $ 6,008 3.5%
Profit Sharing $ 223 0.1% Net Profit $ 10,935 6.4%
Proforma Income Statement
Coach File Undo Decisions Proformas Reports Help
5/31/2017 Capstone WebApp
http://ww3.capsim.com/WebApp/userinterface/index.cfm?template=incomeStatement.cfm 2/2
Phone: 8774778787 | Email: [email protected] | Address: 55 E Monroe, Suite 3210 Chicago, IL 60603 Capsim Management Simulations, Inc. 2017 All Rights Reserved. Capsim and Capsim.com . Your best source for business simulations.
$73,082.11
$27,993.57 $35,000.00
$12,330.03
$23,595.23
Labor Material Inventory Carrying Costs Depreciation Research & Development Marketing Administrative/Other Net Margin
Daze Dell Dixie Dot Dune $0
$25000
$50000
$75000
$100000
® ® ®