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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
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

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 Right Arrow Icon
Ask a homework question - tutors are online