IF Statements Assessment

This is the file needed to answer this assessment question: IF Module Question 1

In the file above, you are given demand for the next 4 months as well as the first month’s starting inventory, holding cost, production cost, and shortage cost. Shortage and holding costs are based on end of month inventory.

Determine each type of cost and total cost for each month. Your total cost should change if I change quantity produced and/or demand.

This is the file needed to answer this assessment question: IF Module Question 2

In the file above, you are given daily closing prices of the Dow Jones index. Suppose you buy one share on January 2, 2008. Setup the following strategy: Buy if you do not own the Dow and the price at the start of the day >= average of the last 200 closing prices. At the beginning of December 19, 2016, sell if you own a share.

What is your profit?

This is the file needed to answer this assessment question: IF Module Question 3

From the file above, your job is to determine a company’s annual revenues based on information from cells B11:C15.

Unit sales increase annually at the given rate until a competitor enters, then unit sales remain constant. For example, for the given numbers, unit sales increase by 15% per year through the end of year 5 and remain at their level in later years.The price of the product increases annually by the inflation rate.

Enter formulas in the yellow cells that correctly compute unit sales, price, and revenue for years 1-10.

*The formulas should work for any set of input values.

This is the file needed to answer this assessment question: IF Module Question 4

From the file above, suppose the sales of our product depends on the price. The competitors price is given. If my price is at least $3 higher than the competitor’s price, we sell 500 units. If my price is at least $3 lower than the competitor’s price, we sell 1,500 units. Otherwise we sell 1,000 units.

Enter formulas (you must use IF statements) in cells F16:O25 that calculate for each price combination., the total product sales.

This is the file needed to answer this assessment question: IF Module Question 5

From the file above, write a formula in cell D5 that will average monthly sales and will always yield the correct answer as new data is added to the bottom of column H.