CSE 2111 Study Guide - Final Guide: Fisher-Price, The Item, Oregon Route 7

• School: Ohio State University
• Department: Computer Science & Engineering
• Course: CSE 2111
• Professor: All

Document Summary

As the new manager of toys america, a retail toy store chain, one of your jobs is to keep track of items sold and returned. You have designed several worksheets to help you keep track of all items in stock and the revenue made from these items. Revenue is defined as retail price times quantity. Expenses are the wholesale price of an item and the shipping costs. Items this worksheet contains information about the name of the item in stock, the company that makes it, the category id of the item, the wholesale cost and the quantity sold in the last month. Wholesale cost is the cost of the goods purchased straight from the manufacturer. You will use this information later to write formulas and perform calculations. Markup this worksheet contains information about the markup percentage for each. Units this table contains information about shipping costs associated with purchasing item you sell.