Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Law and the Legal Environment

Authors: Jeffrey F. Beatty, Susan S. Samuelson, Patricia Sanchez Abril

8th edition

1337404667, 1337404662, 9781337404532, 1337404535, 978-1337736954

Students also viewed these Accounting questions