Please answer using Microsoft Excel and show formulas. thank you
UR Cougar Inc, sells Shirts. The can make up to 8.000 I-shirts every month but they normally only make and sell 7.000 The following represents the sales and costs in a normal month Capacity of the factory T-shirts per month 8,000 This means that Cougar Inc is able to make UP TO 8,000 T-shirts per month without adding additional costs T-Shirts sold in a normal month 7,000 Selling Price of T-shirts 50.00 Cost to Cougar ine of each shirt material & labor) 25.00 Monthly Sed costs for rent utilities, accountants, etc $ 62500.00 20 Longhorn Lid wants Cougar Inc. to sell them 2,000 T-shirts in December, but they only want to pay $35 per T-shirt T-shirts sold to Longhom Ltd in December 2.000 Longhorn Lid offers to pay (per shirt) 3500 QUESTION: Should Cougar Inc, sell Longhorn Lid the T-shirts? How much would they gain or lose by taking this deal? Remember that if they sell the T 14 shirts to Longhom Ltd. for $35, they cannot sell them to UH fans for $50. 16 Create an income statement for Cougar in doing business as normal. THEN create one for if they werpt Longhom La proposal 17 THEN calculate how much Cougarne would make or lose by accepting the other. BE SURE YOU DO ALL 3 PARTS and Show your Work 18 Partial credit will be awardedican figure out you are on the right vack Cougar Inc. sells I-Shirts. The can make up to 8,000 T-shirts every month but they normally only make and sell 7.000 The following represents the sales and costs in a normal month Capacity of the factory: T-shirts per month 8,000 000 This means that Cougar Inc is able to make UP TO 8.000 T-shirts per month without adding additional costs T-Shirts sold in a normal month 7 000 Selling Price of T-shirts 50.00 Cost to Cougar Inc of each shirt material & labor) 25.00 Monthly fed costs for rent, uilities, accountants, etc 62,500.00 10 Longhom Lid wants Cougar ina, to sell them 2,000 T-shirts in December, but they only want to pay $35 per T-shirt T-shirts sold to Longhorn Lid in December Longhorn Lid offers to pay per shirt 2.000 3500 QUESTION: Should Cougar Incsell Longhorn Lid. the T-shirts? How much would they gain or lose by taking this deal? Remember that they sell the T. 14 shirts to Longhorn Lid. for $35, they cannot sell them to UH fans for $50. 16 Create an income statement for Cougar ne doing business as normal. THEN create one for if they accept Longhorn Lid's proposal 17 THEN calculate how much Cougar Inc. would make or lose by accepting the offer BE SURE YOU DO ALL 3 PARTS and Show your Work 18 Partial credit will be awarded if I can figure out you are on the right track
