Motorcross of Wisconsin produces two models of snowmobiles, the XJ6 and the XJ8. In any given production planning week, Motorcross has over has 40 hours available in its final testing bay. Each XJ6 requires 1 hour to test and each XJ8 takes 2 hours. The revenue (in $1,000s) for the firm is stated as (Number of XJ6s)(4 – 0.1 Number of XJ6s) + (Number of XJ8s)(5 – 0.2 Number of XJ8s).
a) Formulate this problem.
b) Solve in Excel. (Show set-up in Excel)