Whoops! Something went wrong.

Click here to refresh the page
60 Downloads

Cost of Sales Project

Cost of Sales Project
Grade Levels
Resource Type
Product Rating
File Type

Spreadsheet (Excel) File

Be sure that you have an application to open this file type before downloading and/or purchasing.

22 KB
Share
Product Description
This project is meant to help students apply knowledge in several areas including spreadsheets, such as Excel and a major business topic, Inventory Control and Cost of Sales.

This is not a full lesson, but an activity meant to stretch the students' understanding and ability to apply skills that are learned in classes dealing with spreadsheets or general business.


Cost of Sales Sheet

The cost of sales is essentially how much it cost for the inventory. A major factor of the sheet was determining how much tax the company needed to pay for each item. You will need to recreate this worksheet. You have been provided with costs of item, prices charged and amount of inventory. You will need to sort the worksheet by category and by product name. You will need to determine how much has been sold during the month, you will need to construct an IF statement to sort the products into the correct tax amount, you will need formulas to determine income, cost of sales, profit and totals for taxes, income, COS, and profit.

Amount Sold: is the total amount of inventory for the month less the amount remaining at the end of the month
IF Statements: will test if the categories match and charge the correct amount of tax, if the categories do not match, the cell will be left blank (HINT: The false part of this formula is accomplished by using empty quotations)
Taxes: taxes are included in the sales price, you will need to determine how much needs to be withheld
Income from sales: is the total amount from sales less the taxes
Cost of Sales: is the cost of the product plus the total inventory during the month
Profit: is the total money received less the cost of the inventory
Total Pages
N/A
Answer Key
Included
Teaching Duration
1 Week
Report this Resource
Loading...
FREE
Digital Download
avatar

Tom Cook

82 Followers
Follow
More products from Tom Cook
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
FREE
Digital Download
Teachers Pay Teachers

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign up