be sure to design your formulas in a way that will incorporate changes in the batch 617765

Texas Bar Supply manufactures equipment for bars and lounges. While the company manufactures several different products, one is a blender that bartenders use to make certain kinds of drinks.Using information in the spreadsheet template, complete the requisition form to calculate the quantity and cost of the parts needed to manufacture a batch of 500 bar blenders. To look up the cost from the price list sheet, you will use a spreadsheet function called VLOOKUP. Be sure to design your formulas in a way that will incorporate changes in the batch size or changes to costs of individual parts.