(Solved): Sales/Expense Summary Sales Increase Expense Increase Sales Expenses: Salaries Travel Advertising ...

Sales/Expense Summary Sales Increase Expense Increase Sales Expenses: Salaries Travel Advertising Dues Postage Utilities Total Expenses Average Expense Maximum Expense Minimum Expense Count of Expenses Gross Profit Jan 7% 10% 600,000 325,000 100,000 56,000 1,500 2,370 3,400 488,270 Feb 642,000 357,500 110,000 61,600 1,650 2,607 3,740 537,097 Mar 686,940 393,250 121,000 67,760 1,815 2,868 4,114 590,807 Apr 735,026 432,575 133,100 74,536 1,997 3,154 4,525 649,887 This assignment deals with understanding Excel spreadsheets, basic statistics as well as Charts and Trend-lines. When you are ready, use the 'Add Attachments' link to choose your file and submit it for grading. Instructions: Marks: 2 1. Add functions to calculate the average, Max, Min and Count on rows 18-21 in columns B-E. 2. In Cell B25 type an answer to the following question: Is the average computed in B18-E18 a good predictor of how much a new expense might cost, should we incur a new expense next year? Why or why not? Save the document on your computer as FirstNameLastNameSalesum.xls. Marks: 8 1. Continuing with your Salesum.xls document, copy the titles in cells B6:E6 and paste them into cells B9:E9. 2. Select cells A9:E15. 3. Press the F11 key at the top of your keyboard to create a bar chart. (2 marks) 4. Rearrange the chart if required so that the months (Jan-Apr) appear on the bottom axis of the chart, and the Legend contains the expenses. (1 mark) 5. Add a trendline to the chart for the 'Salaries' expense. (1 mark) 6. Right click on the trendline to add the option of showing the trendline equation on the chart as well. 7. Copy and paste this equation into cell B27 of Sheet 1. (1 mark) 8. In cell B28, type the predicted value for August for the salaries expense based on this equation to show your understanding of it. (1 mark) 9. Given the following equation: Y = $1,250 +.75x, Calculate the monthly pay for a job with 235 job evaluation points. Type this equation and resulting value into cell E35. (2 marks)