Please find the formula for cell B27, C27, D27, E 27. If I changed the formula in these cells to type "California" or "Everywhre" it is still giving me error. Incorrect answers are $5,635 and $83,293. The whole row 27 and 28 is giving me errors. I event multiple the rent expenses by 12 but it didnt work. I think I have to add something else in the cells for Rent Expense, but I cant figurative out. If you check the website for California, it says that apportionment factor is 100% sales, so 0.80% in cellE32 is correct. All the cells in green are correct. the cells in red are incorrect. I asked these questions several times and none of the tutors can not give me the right formula.

B C E F G's Kitchen, Incorporated ("GK, Incorporated") has been crafting fine chocolates for over shity years. GK, Incorporated 3 is a well-established local brand, but baniness really took off when GK, Incorporated hired a social media firm to develop a greater online presence. Sales have expanded from a retail storefront in a small Michigan retort town to being sold online and shipped throughout the contiguous United States. Recently, GK, Incorporated signed a retail agreement with a prominent national retail chain. In order to meet the B demands of the national retail chain while maintaining a high quality product, CK, Incorporated began leasing refrigerated warehouse space from Penguin Network Storage, LLC to store Just-In-Time inventory of its top products. GK, Incorporated has hired you to determine the income tax apportionment percentage in states where it has a 11 phraical pre-vence using the data provided in Column G through Column L. The apportionment weightings have been provided bylove 13 14 Required: 1. Complete the client-provided data with SUM formulas for the Everywhere amounts. 16 2. Complete the apportionment calculations wing VUG OKUP formulas to the client provided data in G1:151 17 18 (HINT: Use the FALSE logical value for act match VLOOKUP formulas Use absolute referencing for the table array.)\f\f\f\f