question archive The Inventory scenario is based on a ?ctitious custom bike builder
The Inventory scenario is based on a ?ctitious custom bike builder
Subject:MathPrice: Bought3
The Inventory scenario is based on a ?ctitious custom bike builder. Of course, the data given for the scenario is a small sampling of what a shop's inventory would be. The data represents an end of month quantity and is being used to determine, the balance on hand and which items need to be reorder, if any. The Payroll scenario is, of course, also just a snapshot of the calculations needed for a company's payroll. In an Excel ?le named Inventory create three sheets named Inventory, Bikes_Made, and Items_Used. Input the data given here. (You should use the previous year for the date.) In addition to the columns given in the inventory data table, add three more columns on your sheet named Balance on Hand. Create a complex formula to calculate the Value of Inventory using the data from the three separate sheets to determine whether the balance on hand is enough, or it is time to reorder the item. If it is time to reorder the item, the cell should contain the word REORDER and the cell should be ?lled with the color red.
