excel

profileandra37
Unit2-HWAssignment1-P03_02-updated-1.xlsx

Model

Assembling and testing computers
Cost per labor hour assembling $11
Cost per labor hour testing $15
Inputs for assembling and testing a computer
Basic XP VXP
Labor hours for assembly 5 6
Labor hours for testing 1 2
Cost of component parts $150 $225
Selling price $300 $450
Unit margin $80 $129 $0
Assembling, testing plan (# of computers)
Basic XP VXP
Number to produce 0 0 0
<= <= <=
Maximum sales 600 1200 50
Constraints (hours per month) Hours used Hours available
Labor availability for assembling 0 <= 10000
Labor availability for testing 0 <= 3000
Net profit ($ this month) Basic XP VXP Total
$0 $0 $0 $0

image1.png