San Jose State University Inventory Sales and Beers Excel Project During our first inventory Beer 2 was selling at a much lower rate than Beer 1. Make a su

San Jose State University Inventory Sales and Beers Excel Project During our first inventory Beer 2 was selling at a much lower rate than Beer 1. Make a suggestion for a change in each one of the four Ps that you might try if you wanted to increase the sales of Beer 2. There are no wrong answers, I just want to see your ideas.

Product _______________
Price _________________
Promotion ________________
Place ___________________

Enter Screenshot below or attach Excel file.

____________________________________________________________ Excel Inventory
This lesson covers multiple-worksheet forms.
Students practice skills learned in earlier assignments.
Instructions:
Read through the set of learning objectives. This is what you are supposed to know how to do when you
finish the lesson.
Make sure you understand the terminology in the key terms table. It is there to help you if you get stuck
on an instruction.
Complete every step in the assignment, in the order given. Do not skip steps.
When you have done all of the steps, fill out the Check for Understanding (CFU) form and Quiz. Attach
your Excel work or screenshots to the Canvas submission
Learning Objectives – Key Points:
Simultaneously create the same form in multiple worksheets.
Hide and unhide columns.
In a formula, use references to cells in other worksheets.
Use paste-special to replace formulas with their values.
Create links to other worksheets in the workbook.
Automatically generate a table of range names and locations.
My colleague, Patricia Kwan, has created a video version of this lesson. https://youtu.be/dIzAbg04KW4
Key Terms and Concepts
Inventory
An inventory is a count of products on hand.
Inventories are taken at regular intervals: once a week,
once a month, once a quarter, and so on.
The purpose of an inventory is to determine how many
items were used or sold during the period. A standard
formula is used: Starting Inventory + purchases during
the period – ending inventory.
You can think of this like the gas tank on a car. At the
start of the month you have 7 gallons in the tank.
During the month you buy 35 gallons. At the end of the
month you have 14 gallons left. You know you had 42
gallons in your tank during the month (35+7), and only
14 left over, so you must have burned through 28
gallons (42-14).
The starting inventory for each period is the ending
inventory from the previous period.
The ending inventory is found by counting the stock on
hand at the end of the period.
Margin and Profit
The difference between the cost to buy or produce
each unit of a product and the price that it sells for is
called the margin.
The formula is Price – Cost = Margin.
Multiplying the margin times the number sold during a
period gives the profit on that item for that period.
The formula is Margin * Number Sold = Profit.
References to cells in other worksheets
When you want to refer to a cell in a different
worksheet, include the name of the other worksheet,
followed by the ! symbol, before the cell reference.
Example =Sheet2!C4
Reorder point.
It takes time between when you order more inventory
and when it arrives. You want to order more when you
are running low, not when you are out. The reorder
point is a calculation that tells you how low the
inventory can get before you need to place an order.
When the inventory level reaches the reorder point
you order more.
Each product has a unique value for the reorder
point. The quantity of items ordered would also vary
by product
You can use an IF function to decide when to order
more inventory and how much to order. IF the current
inventory
Purchase answer to see full
attachment