Please show in Excel

38. Labor Balancing. The Patriotic Doll Company manufactures two kinds of dolls: the Betsy Ross and the George Washington. The assembly process for each of these dolls requires two neonle. The assemblv times are as follows: The company policy is to balance workloads on all assembly jobs. In fact, management wants to schedule work so that no assembler will have more than thirty minutes more work per day than other assemblers. This means that in a regular eight-hour shift, all assemblers will be assigned at least 71/2 hours of work. If the firm makes a $2 profit for each George Washington doll and a $1 profit for each Betsy Ross doll, how many units of each doll should be produced per day? How much time will each assembler be assigned per day? B = Nmber of Betsy Ross Dolls Produced = G = Number of George Washington Dolls Produced = A Profit =