| | | | | (Product Name:) | Bid | Bold | Brat | Bat | Na | Na | Na | Na | 2020 Total | Common Size | | Sales | $29,171 | $29,510 | $48,613 | $51,243 | $0 | $0 | $0 | $0 | $158,536 | 100.0% | | | | | | | | | | | | | | Variable Costs: | | | | | | | | | | | | Direct Labor | $2,963 | $3,073 | $9,666 | $8,842 | $0 | $0 | $0 | $0 | $24,544 | 15.5% | | Direct Material | $12,887 | $13,394 | $19,085 | $19,793 | $0 | $0 | $0 | $0 | $65,159 | 41.1% | | Inventory Carry | $179 | $194 | $402 | $380 | $0 | $0 | $0 | $0 | $1,155 | 0.7% | | Total Variable | $16,029 | $16,661 | $29,153 | $29,015 | $0 | $0 | $0 | $0 | $90,858 | 57.3% | | | | | | | | | | | | | | Contribution Margin | $13,142 | $12,848 | $19,460 | $22,228 | $0 | $0 | $0 | $0 | $67,678 | 42.7% | | | | | | | | | | | | | | | | | | | | | | | | | | Period Costs: | | | | | | | | | | | | Depreciation | $4,753 | $5,367 | $3,167 | $3,800 | $0 | $0 | $0 | $0 | $17,087 | 10.8% | | SG&A: R&D | $446 | $446 | $966 | $966 | $0 | $0 | $0 | $0 | $2,824 | 1.8% | | Promotions | $1,300 | $1,300 | $1,300 | $1,300 | $0 | $0 | $0 | $0 | $5,200 | 3.3% | | Sales | $1,600 | $1,600 | $1,400 | $1,400 | $0 | $0 | $0 | $0 | $6,000 | 3.8% | | Admin | $315 | $319 | $526 | $554 | $0 | $0 | $0 | $0 | $1,714 | 1.1% | | Total Period | $8,414 | $9,031 | $7,358 | $8,020 | $0 | $0 | $0 | $0 | $32,824 | 20.7% | | | | | | | | | | | | | | Net Margin | $4,727 | $3,817 | $12,101 | $14,208 | $0 | $0 | $0 | $0 | $34,854 | 22.0% | | | | | | | | | | | | | | | Definitions: Sales: Unit sales times list price. Direct Labor: Labor costs incurred to produce the product that was sold. Inventory Carry Cost: the cost to carry unsold goods in inventory.Depreciation: Calculated on straight-line 15-year depreciation of plant value. R&D Costs: R&D department expenditures for each product. Admin: Administration overhead is estimated at 1.5% of sales. Promotions: The promotion budget for each product. Sales: The sales force budget for each product. Other: Charges not included in other categories such as Fees, Write Offs, and TQM. The fees include money paid to investment bankers and brokerage firms to issue new stocks or bonds plus consulting fees your instructor might assess. Write-offs include the loss you might experience when you sell capacity or liquidate inventory as the result of eliminating a production line. If the amount appears as a negative amount, then you actually made money on the liquidation of capacity or inventory. EBIT: Earnings Before Interest and Taxes. Short Term Interest: Interest expense based on last year's current debt, including short term debt, long term notes that have become due, and emergency loans. Long Term Interest: Interest paid on outstanding bonds. Taxes: Income tax based upon a 35% tax rate. Profit Sharing: Profits shared with employees under the labor contract. Net Profit: EBIT minus interest, taxes, and profit sharing. | | | | | | Other | $4,702 | 3.0% | | EBIT | $30,152 | 19.0% | | Short Term Interest | $3,632 | 2.3% | | LongTerm Interest | $11,910 | 7.5% | | Taxes | $5,113 | 3.2% | | Profit Sharing | $190 | 0.1% | | Net Profit | $9,306 | 5.9% | | | |
