Dirt Bike Manufacturing produces two types of dirt bikes (motocross and trail) Motocross passes through four process: cutting, welding, polishing, and painting. Trail uses three of the same processes: cutting, welding, and painting. Each of the four processes employs 9 workers who work eight hours each day. Motocross sells for $9,000 and trail sells for $8,000 per unit. Materials is the only unit-level variable expense. The materials cost for motocross is $4,600 per unit and the materials cost for trail is $3,900 per unit. Dirt Bike's accounting system has provided the following additional information about its operations and products Cutting Labor Welding Labor Polishing Labor Painting Labor Market Demand 3,100 minutes 3.100 minutes 3.100 minutes 3.100 minutes Usage Per Unit 50 minutes 50 minutes 50 minutes 35 minutes Usage Per Unit 40 minutes 45 minutes 40 minutes Motocross Trail 80 per day 63 per da unit 1 unit Dirt Bike's management has determined that any corrected within two davs production interruptions can be PARTA Using the solver function in Excel, set this up in a table format and find the combination of both products that maximizes income. What is the combination of the two products that should be produced and what is the maximum income using this combination? (8 points) Dirt Bike Manufacturing produces two types of dirt bikes (motocross and trail) Motocross passes through four process: cutting, welding, polishing, and painting. Trail uses three of the same processes: cutting, welding, and painting. Each of the four processes employs 9 workers who work eight hours each day. Motocross sells for $9,000 and trail sells for $8,000 per unit. Materials is the only unit-level variable expense. The materials cost for motocross is $4,600 per unit and the materials cost for trail is $3,900 per unit. Dirt Bike's accounting system has provided the following additional information about its operations and products Cutting Labor Welding Labor Polishing Labor Painting Labor Market Demand 3,100 minutes 3.100 minutes 3.100 minutes 3.100 minutes Usage Per Unit 50 minutes 50 minutes 50 minutes 35 minutes Usage Per Unit 40 minutes 45 minutes 40 minutes Motocross Trail 80 per day 63 per da unit 1 unit Dirt Bike's management has determined that any corrected within two davs production interruptions can be PARTA Using the solver function in Excel, set this up in a table format and find the combination of both products that maximizes income. What is the combination of the two products that should be produced and what is the maximum income using this combination? (8 points)
