Question: This is for my data analytics class, and I really need help! This is for my data analytics class and I really need help. It

This is for my data analytics class, and I really need help!  This is for my data analytics class, and I really need
help! This is for my data analytics class and I really need
This is for my data analytics class and I really need help. It needs to be done in excel help. It needs to be done in excel The motorcyde manutacturing company
CU-Rider produces two popular motorcydes (Ducati750F and 780R). in the coming month,

The motorcyde manutacturing company CU-Rider produces two popular motorcydes (Ducati750F and 780R). in the coming month, the manutacturer plans to produce up Constraint 2 or 'Car] Each 'Ducati 750F produced and sold results in a profit of 51180 , while each 'Ducati 7808 ' results in a profit of $670, The bikes are mechanically similar but differ in the appearance of the polymer-based trim around the fuel tank and seat. Fach Ducati 750 f's trim requires 2.4 pounds of polymer and 4.2 hours of production time, while each 'Ducati 7808' requires 2 pounds of polymer and 5.3 hours of production time. Assume that 1300 pounds of polymer and 2500 labor hours are available for production. Assume that motorcydes can be produced in fractions. Pleaue note, unless stated otherwise, each question is independent of one another. construinto) Does this production dedulon violate "Constralnt tr? total profit 5 violetion of Cil? quantity grodaction total prifies 3) What happena to your ostinat wolution if cu-nider increases the max preduction taget (C) by 100?). quontiry production totar profirs. What happens to your optimal solution if cU-Rider can decrease the production time of the 'Ducati 780R' by 23% ? The motorcycle manufacturing company Cu-tider produces two popular motorcycles foucath 750 and 7 soef. In the coming month, the manufacturer plans to preduce up to 930 fo Fach 'Ducaul 750F' preduced and sold resulis in a proft of 51180 , while each 'Ducati 7 mon' reiults in a proft of $670. The bikes are mechanically siniar but differ in the appearance of the polymer-based trim around the huel tank and seat. Cach Ducati 750P5 trim requires 2.4 peunds of golymer and 4.2 hours of proifuctisn time, while each 'Ducati 7ios' requires 2 pounds of polymer and 5.3 hours of production time. Assume that 1300 pounds of polymer and 2500 labor hours are available for production. Assume that motorcycles can ber produced in fractions. Fhase note, unless stated otherwile, nach question ia independent of ane another. Doss thli productlon declaian vlolate 'Constraint in? 2) Determine the number of 'Ducati 750F and 'Ducati 7oh' cu-hider needs to produce to mavimite its total proft (helude all conatrainti). 3) What bappens to vour optimal solution if cu-nider increases the max production tareet (0) by 100 ? 4) What happens to your optimal solution if CU-Rider can decrease the production time of the 'Ducati 780R' by 23\%? \begin{tabular}{lrr|} quantity production & Ducati 75OF & Ducati 780R \\ \hline & \\ \hline \end{tabular} total profit \$

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!