Gorecki Construction Stefan Gorecki is the owner of Gorecki Construction, a small construction rm in Chester, Pennsylvania. He wants to use Excel to track his company’s monthly income and...
Gorecki Construction Stefan Gorecki is the owner of GoreckiConstruction, a small construction rm in Chester, Pennsylvania. He wants touse Excel to track his company’s monthly income and expenses and then use thatinformation to create a monthly budget. Stefan has already entered the raw datavalues but has asked to you to complete the workbook by adding the formulas andfunctions to perform the calculations. Complete the following:
1. Open the Gorecki workbook located in the Excel3 >Case1 folder, and then save the workbook as Gorecki Budget in the locationspecied by your instructor.
2. In the Documentation worksheet, enter your name in cellB3 and the date in cell‑B4.
3. The budget values are entered based on the end-of-monthvalues. In the Monthly Budget worksheet, enter the date 31-Jan-18 in cell E4and 28-Feb-18 in cell F4. Use AutoFill to ll in the remaining end-of-monthdate in the range G4:P4.
4. Calculate the company’s total monthly income by selectingthe range E6:P7 and using the Quick Analysis tool to insert the SUM functionautomatically into the range E8:P8.
5. Calculate the company’s total cost of goods sold byselecting values in range E10:P11 and using the Quick Analysis tool to insertthe SUM function automatically into the range‑E12:P12.
6. In the range E14:P14, calculate the company’s monthlygross prot, which is equal to the difference between the monthly income andthe monthly cost of goods sold.
7. Select the expenses entered in the range E17:P26, and usethe Quick Analysis tool to insert the sum of the monthly expenses into therange E27:P27.
8. In the range E29:P29, calculate the company’s net incomeequal to the difference between its gross prot and its total expenses.
9. Select the values in the range E29:P29, and then use theQuick Analysis tool to insert a running total of the company’s net income intothe range E30:P30.
10. Calculate the year-end totals for all nancialcategories by selecting the range E6:P29 and using the Quick Analysis tool to insert the sum of each row into the range