Purchase Solution

Spreadsheets in Excel for my Information Technology class

Not what you're looking for?

Ask Custom Question

You are the owner of a small business specializing in the restoration of oil paintings. You are trying to save enough money to lease a larger working space and thereby increase the amount of business that you can handle. You have enough orders to keep you busy for the next six months: July $ 5,500; August $9,450; September $8,300; October $4,600; November $7,700; December $6,300. Each month your overhead includes $1,000 for leasing your present workspace, 35% of each job for materials, 15% of each job for tools. The money remaining is your profit.

Present 3 spreadsheets:

#1 - Current financial situation for the next six months.
#2 - Financial situation if you decrease material expenditures to 25%
of each job
#3 - Financial situation if you decrease tool expenditures
to 10% of each job

Purchase this Solution
Solution Summary

The expert examines the spreadsheets in Excel for my information technology class.

Solution Preview

Take a look at the attached spreadsheet. I've set it up for you with each month being a separate column and the items as rows.

I've ...

Purchase this Solution
Free BrainMass Quizzes
C++ Operators

This quiz tests a student's knowledge about C++ operators.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Javscript Basics

Quiz on basics of javascript programming language.

C# variables and classes

This quiz contains questions about C# classes and variables.

View More Free Quizzes
Related BrainMass Solutions

  • Use of technology in early education

    You are welcome to use information related to the element that came up in discussion (such as ideas from class members, the reading, and specific tools provided by classmates or your own research) in your response if you wish but you do not have to do

  • Sunsweet Growers and Information Technology

    Sunsweet company was only using Excel in their information system and there are inherent problems with it. These limitations are: - As business complexities increase, so did the spreadsheets.

  • Excel Grade Book Project

    I can use this to help me to keep track of my progress in the class and know at all times my current course grade even though the course is not over yet. o How might you use Excel in the future?

  • Use of MS Excel as a Management Tool

    From this information, he was able to download to another excel spreadsheet - information for the buyers, and then compile a report in another excel spreadsheet for the owner.

  • databases

    (In fact, my students are also taught to create and make use of their own non-electronic databases for my class, including a portfolio, class notebook, checklists, missing work binder, etc.)

  • Normalization of an Excel Spreadsheet

    NO references required for this task :-) How do you convert excel spreadsheets into an RDBMS? along with an erd diagram? i am stumped! I NEED examples using the supplied excel spreadsheets!

  • Technology in business, changes and challenges

    Before I was using Quickbooks and Excel to do the tracking. These are not programs that can be integrated. While my documents and database information can integrate with Excel, QB did not accept such changes or integration into its program.

  • Importance of professional worksheets

    This usually happens more when there is a lot of information in the spreadsheet and there are multiple spreadsheets present.

  • Excel Gradebook Project

    I can use this to help me to keep track of my progress in the class and know at all times my current course grade even though the course is not over yet. I might use Excel to keep track of my grades in all my courses.

View More Related Solutions