# answer - \$0.00 Incomes taxes Nets Income \$0.00 Nets Income...

This preview shows pages 1–4. Sign up to view the full content.

Microsoft Excel 12.2.0 Answer Report Worksheet: [sctc.xlsx]Sheet1 Report Created: 4:42:00 PM Target Cell(Value Of) Cell Name Original Value Final Value \$H\$25 Nets Income \$1,582,278.48 -812500 55000 Adjustable Cells Cell Name Original Value Final Value \$H\$4 Number of Units Sold \$100.0 0 16893.87 Constraints Cell Name Cell Value Formula Status Slack \$H\$25 Nets Income \$1,582,278.48 \$55,000.00 \$H\$25=55000 Binding 0

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Sales Price \$100.00 Sales Price Number of Units Sold 15,822.78 Number of Units Sold Total Sales \$1,582,278.48 Total Sales Variable Costs/Unit Labor Variable Costs/Unit Advertising \$15.00 \$1.00 Total Variable Costs/Unit \$5.00 Total Variable Costs \$21.00 332278.48 Contirbution Margin \$1,250,000.00 Contirbution Margin Fixed Costs Category Fixed Costs Land Amount Buildings \$42,500.00 Manufacturing Machinery \$332,500.00 Office Equipment \$532,000.00 Utilities \$212,800.00 Insurance \$30,500.00 Total Fixed Costs \$99,700.00 ### Operating Income \$0.00 Operating Income Incomes taxes

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: \$0.00 Incomes taxes Nets Income \$0.00 Nets Income SCTC Income Statement \$100.00 d 16,893.87 ### Labor \$15.00 Advertising \$1.00 Shipping&Receiving \$5.00 Total Variable Costs/Unit \$21.00 Total Variable Costs \$354,771.18 ### Category Amount Land \$42,500.00 Buildings \$332,500.00 Manufacturing Machinery \$532,000.00 Office Equipment \$212,800.00 Utilities \$30,500.00 Insurance \$99,700.00 Total Fixed Costs ###-\$22,492.70-\$7,872.44 \$55,000.00 SCTC Income Statement Sales Price \$100.00 Number of Units Sold Total Sales Variable Costs/Unit Labor \$15.00 Advertising \$1.00 Shipping&Receiving \$5.00 Total Variable Costs/Unit Total Variable Costs Contirbution Margin Fixed Costs Category Amount Land \$42,500.00 Buildings ### Manufacturing Machinery ### Office Equipment ### Utilities \$30,500.00 Insurance \$99,700.00 Total Fixed Costs Operating Income Incomes taxes Nets Income...
View Full Document

## This note was uploaded on 09/23/2010 for the course BMGT 381 taught by Professor Dawson during the Spring '10 term at University of Maryland Baltimore.

### Page1 / 4

answer - \$0.00 Incomes taxes Nets Income \$0.00 Nets Income...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online