Question: Part 3 1. Open the customer-service-operating-expenditure spreadsheet from part 2. Edit the spreadsheet data as below: . Electricity $257 Gas $105 2. Copy the information

 Part 3 1. Open the customer-service-operating-expenditure spreadsheet from part 2. Edit
the spreadsheet data as below: . Electricity $257 Gas $105 2. Copy

Part 3 1. Open the customer-service-operating-expenditure spreadsheet from part 2. Edit the spreadsheet data as below: . Electricity $257 Gas $105 2. Copy the information in this table to a new worksheet and create a summary table of expenses, including formulas and functions. The question marks indicate where calculations are needed. Proofread and check your worksheet for accuracy and test your calculations. Use manuals, user documentation and online help to overcomes problems with your project. Or consult with your manager (your assessor) if you need help. Monthly resources and power costs Item April May June Electricity $257 $202 $210 Gas $105 $98 $105 Office paper $1,098 $876 $998 Envelopes $309 $204 $206 Computer supplies $2,098 $1,409 $1,309 Stationery $1,092 $785 $1,087 Total cost ? ? ? Budget cost $2,800 $2,500 $4,000 Average cost ? ? ? Maximum cost ? ? ? % over/ under . " ? budget To calculate the last row, follow these steps: Divide the total cost by the budgeted cost Multiply this answer by 100. Subtract 100 from what you now have

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!