Please use Excel Solver and show formula. Please also provide the Decision Variable, Objective Function and Constraints. Thank you! $6\mathrm{.}8$ Allocating Components to Assemblies: Biking.com is a web$-$based compary that sells bicycles on the Internet. Its distinctive feature is that it allows cus. tomers to customize the design when they order and then to receive quick delivery. Biking.com gives customers choices for frame size $(34,36,38),$ suspension $($standard or heavy$-$duty$),$ and gear speeds $(5,10,15).$ As a result, customers can order one of $18$ possible combinations $(3\backslash$times $2\backslash$times $3).$ The company shorthand refers to frame size as Option A $($A$1$ is the $34-$in$.$ model, A$2$ is the $36-$in$.$ model, and A $3$ is the $38-$in$.$ model$).$ Similarly, the standard suspension is option B $1,$ and the heavy$-$duty suspension is B $2.$ The gear speeds are C $1(5),$ C$2(10),$ and C$3(15).$ Rather than stock $18$ different types of bicycles, the company holds inventories of the major components and then assembles the bikes once a customer order comes in$.$ Orders are taken Mondays through Wednesdays, assemblies are done on Thursdays, and shipments go out on Fridays. Thus, at the close of business on Wednesday, the company has an inventory of components and a list of orders, and its task is to match components with orders to meet as much demand as possible. The tables below describe customer orders for this week and the inventory status at the end of Wednesday. $225($a$)$ What is the maximum number of customer orders that can be satisfied this week? $($b$)$ Suppose that the prolitability varies by model type, as shown in the table below. What is the maximum profit that can be achieved from this week's orders?