I need the formulas

Case Notes: You work for an accounting firm that has recently been aw arded a new client. This client, RK Installation LLC, is a single member limited liability company which sells and installs windows and doors to retail clients. Windows and doors are not manufactured at RK Installation LLC, they are purchased from an outside vendor. You are tasked to complete a performance report for the year ended December 31, 2019. You will be completing twotabs. The first tab, part B form, will show the original data in a performance report. After the performance report is correct, you will be creating a what-if" scenario tab (named Part B Scenario) that will allow the owner to play with all data numbers to see the impact of potential decisions being made. In addition, at the end, you will analyze the original data andexplain to the owner where the variances came from. Instructions: 1. Complete the "Part BForm" tab, entering formulas into each cell marked with a?. There should be no hand typed numbers in you spreadsheet except the details on the top of Statement can be differenct betweenrevenue and expense accounts but should not change within the expense li ne items 3. Save your worksheet. Then, check your worksheet by changing the revenue in cell D8 to $537.50; the cost of inventory in cell C3 to $476.75. The activity variance for total expenses should now be $136.75 and the revenue and spending variance for net operating income should be $10,162 4. Once your spreadsheet is correct, change your spreadsheet back to the original numbers for D8 ($601.00) and C9 ($536.35). 5. Using the data on "Part BForm tab (original data), write a memo [in Microsoft Word) to the owner of RK Installation Service, outlining thetop 2 spending variances. reasonable explanations for these variances, and suggestions for improvements if unfavorable. Memo must be clear,concise and no more than 1page long 6. Ma rename the new tab "Part B Scenario ke a copy of the "Part B Form" tab, paste it as the last tab of the entire spreadsheet, and f. lhe owner ot the company teels that it he contracts with anew, higher quality vendor, he can increase his selling price by 10%. The vendor will charge 7.5% higher cost of inventory than the old vendor. The owner believes in "sharing the wealth" so he will increase the variable portion of his employees wages by 5%. This plan w as put into place. The increase in revenue, inventory costs, and salary is reflected below. In addition, the new results for the yer are given. tab to reflect the results of the owner's decisions (no calculations needed, use the data given below) Revise the data in your "Part B Scenario" Double check all formulas to make sure they are reasonable and correct. Double check to make sure the formatting has copied correctly Revenme &Revenmue & Cost PerCost Per 33 Data 34 Revenue 35 Cost of invento 36 Wages and salaries 37 Utilities 38 Insurance 39 Rent 40 Miscellaneous 41 42 Actual results: 43 Revenue 44 Cost of invento 45 Wages and salaries 46 Utilities 47 Insurance 48 Rent 49 Miscellaneous Fixed Cost Door $966.63 $576.58 $99.75 $2.05 $3.65 $661.10 $314.98 $70.35 0 30,614 $ $3,194 $3,972 $7,222 1 $1,833$45.00 $380,499 $206,554 $72,225 $2,077 $4,500 $7,944 $20,111 9 Doors Sold Windows Sold 52 Actual unit activi 53 Planning budget unit a 189 180 0 8 5 Reiev Problem: Variance Analysis Using a Flexible Budget Ro LostFer 7 Data 8 Revenue 9 Cost of inventory 10 Wages and salaries 11Utlies 12 Insurance 13 Rent 14 Miscellaneous 15 16 Actual results: 17 Revenue 18 Cost of inventory 19 Wages and salaries 20 Uties Fivad CostCa Drinion $30,614 $3.194 $3,972 $7,222 $1,833 $878.75 $536.35 $95.00 $2.05 $3.65 $601.00 $293.00 $67.00 $130 $1.70 $45.00 $37.00 $299,075 $157,618 $67,588 $2,153 $5,665 $7,222 $17,963 21 Insurance 22 Rent 23 Miscellaneous 24 25 26 Actual unit activity Doors Sold 155 140 Windows Sold 275 298 Planning budget unit activity 29 EAter a formu inta eaeh afthe cells marted rabelgr Herst enter an F Jtatement far the iiF seleetion. can be aifferentbetreen renenje andespenses butsame F 30 statementmest be esed for entne column afespenses 32 Construrct a flesible budgetpeffarmance repart Roranans 35 ta Rosums SRN95 UIF SRN95 UIF 37 Doors Sold 38 Windows Sold 39 40 Revenue 41Expenses: 42 43 ?UIF Cost of inventory Wages and salaries Utilities Insurance Rent Miscellaneous ? UIF ? UIF ?UIF ? UIF ? UIF ? UIF ? UIF ? UIF UIF 45 46 47 48 Total expenses 43 Net operating income UIF Case Notes: You work for an accounting firm that has recently been aw arded a new client. This client, RK Installation LLC, is a single member limited liability company which sells and installs windows and doors to retail clients. Windows and doors are not manufactured at RK Installation LLC, they are purchased from an outside vendor. You are tasked to complete a performance report for the year ended December 31, 2019. You will be completing twotabs. The first tab, part B form, will show the original data in a performance report. After the performance report is correct, you will be creating a what-if" scenario tab (named Part B Scenario) that will allow the owner to play with all data numbers to see the impact of potential decisions being made. In addition, at the end, you will analyze the original data andexplain to the owner where the variances came from. Instructions: 1. Complete the "Part BForm" tab, entering formulas into each cell marked with a?. There should be no hand typed numbers in you spreadsheet except the details on the top of Statement can be differenct betweenrevenue and expense accounts but should not change within the expense li ne items 3. Save your worksheet. Then, check your worksheet by changing the revenue in cell D8 to $537.50; the cost of inventory in cell C3 to $476.75. The activity variance for total expenses should now be $136.75 and the revenue and spending variance for net operating income should be $10,162 4. Once your spreadsheet is correct, change your spreadsheet back to the original numbers for D8 ($601.00) and C9 ($536.35). 5. Using the data on "Part BForm tab (original data), write a memo [in Microsoft Word) to the owner of RK Installation Service, outlining thetop 2 spending variances. reasonable explanations for these variances, and suggestions for improvements if unfavorable. Memo must be clear,concise and no more than 1page long 6. Ma rename the new tab "Part B Scenario ke a copy of the "Part B Form" tab, paste it as the last tab of the entire spreadsheet, and f. lhe owner ot the company teels that it he contracts with anew, higher quality vendor, he can increase his selling price by 10%. The vendor will charge 7.5% higher cost of inventory than the old vendor. The owner believes in "sharing the wealth" so he will increase the variable portion of his employees wages by 5%. This plan w as put into place. The increase in revenue, inventory costs, and salary is reflected below. In addition, the new results for the yer are given. tab to reflect the results of the owner's decisions (no calculations needed, use the data given below) Revise the data in your "Part B Scenario" Double check all formulas to make sure they are reasonable and correct. Double check to make sure the formatting has copied correctly Revenme &Revenmue & Cost PerCost Per 33 Data 34 Revenue 35 Cost of invento 36 Wages and salaries 37 Utilities 38 Insurance 39 Rent 40 Miscellaneous 41 42 Actual results: 43 Revenue 44 Cost of invento 45 Wages and salaries 46 Utilities 47 Insurance 48 Rent 49 Miscellaneous Fixed Cost Door $966.63 $576.58 $99.75 $2.05 $3.65 $661.10 $314.98 $70.35 0 30,614 $ $3,194 $3,972 $7,222 1 $1,833$45.00 $380,499 $206,554 $72,225 $2,077 $4,500 $7,944 $20,111 9 Doors Sold Windows Sold 52 Actual unit activi 53 Planning budget unit a 189 180 0 8 5 Reiev Problem: Variance Analysis Using a Flexible Budget Ro LostFer 7 Data 8 Revenue 9 Cost of inventory 10 Wages and salaries 11Utlies 12 Insurance 13 Rent 14 Miscellaneous 15 16 Actual results: 17 Revenue 18 Cost of inventory 19 Wages and salaries 20 Uties Fivad CostCa Drinion $30,614 $3.194 $3,972 $7,222 $1,833 $878.75 $536.35 $95.00 $2.05 $3.65 $601.00 $293.00 $67.00 $130 $1.70 $45.00 $37.00 $299,075 $157,618 $67,588 $2,153 $5,665 $7,222 $17,963 21 Insurance 22 Rent 23 Miscellaneous 24 25 26 Actual unit activity Doors Sold 155 140 Windows Sold 275 298 Planning budget unit activity 29 EAter a formu inta eaeh afthe cells marted rabelgr Herst enter an F Jtatement far the iiF seleetion. can be aifferentbetreen renenje andespenses butsame F 30 statementmest be esed for entne column afespenses 32 Construrct a flesible budgetpeffarmance repart Roranans 35 ta Rosums SRN95 UIF SRN95 UIF 37 Doors Sold 38 Windows Sold 39 40 Revenue 41Expenses: 42 43 ?UIF Cost of inventory Wages and salaries Utilities Insurance Rent Miscellaneous ? UIF ? UIF ?UIF ? UIF ? UIF ? UIF ? UIF ? UIF UIF 45 46 47 48 Total expenses 43 Net operating income UIF