Author: Anonymous

EXHIBIT 2 A small business wants to find out which social media ads it should buy in order to maximize its exposure in its local market. It has a monthly advertising budget of $10,000. The company is considering three possible websites: Facebook, Instagram and LinkedIn. Information regarding cost and exposure of the different media is given in the table below. In addition, each social media website allows only a limited number of ads from the same company (see in table below). The decision variables are defined as: x1 = Number of Facebook ads per month x2 = Number of Instagram ads per month x3 = Number of LinkedIn ads per month     Facebook (x1) Instagram (x2) LinkedIn (x3) Exposure (audience reached per ad) 8,500 7,000 2,500 Cost per ad $1,000 $800 $500 Maximum ads per month 7 10 5   Please solve the problem described in this Exhibit using the Excel Solver. You will find the template for this problem in the file Final_Exam_Exhibit 2_DATA.xlsm   Important: When clicking on the link, if the file does not open you will find it in the “download” section of your browser (bottom left of the page) and you can open it from there. If it still does not open, make sure that you are not editing a formula in another Excel file (this sometimes prevents you from opening a new file). Please note that this file is protected against saving. Do not close this file until you submit the exam, otherwise you may loose its content. In case you inadvertently closed the file, please download it again.

Energy is stored long-term in the bonds of ____ and used short-term to perform work from a(n) ____ ATP: glucose an anabolic molecule; catabolic molecule Glucose; ATP a catabolic molecule; anabolic molecule

What is the energy of a photon first used to do in photosynthesis?  

A promoter is ________.  

Please write the correct formula you should type in Excel to calculate the level for Week 17 using an exponential smoothing with trend forecast method, based on the data and parameters cells in the Excel file (the formula needs to be entered in a way that allows to calculate the forecasts for the other weeks as well). All references must refer to the exact cells in the file you downloaded for this exhibit.

ACADEMIC INTEGRITY By taking this exam, you understand that you are not allowed to access any resources other than the Midterm Exam 1 on Canvas and the Excel files provided within the exam. You understand that your actions on this computer are being recorded during the whole exam, and accessing any unauthorized resource (online, offline or outside of your computer) during the exam will lead to an unforgivable F for this course. Before continuing with the exam, please close all other applications and files on your computer.

Please forecast the demand for 2020 using a weighted moving average forecast method, based on the data indicated in the Excel file and the weights provided below. Round your answer to the closest whole number. Most recent period’s weight (W1) = 0.8 Second most recent period’s weight (W2) = 0.15 Third most recent period’s weight (W3) = 0.05

Please forecast the demand for 2018 using a weighted moving average forecast method, based on the data indicated in the Excel file and the weights provided below. Round your answer to the closest whole number. Most recent period’s weight (W1) = 0.6 Second most recent period’s weight (W2) = 0.3 Third most recent period’s weight (W3) = 0.1

Please write the correct formula you should type in Excel to calculate the forecast for 2019 using a simple moving average forecast method with five periods (the formula needs to be entered in a way that allows to calculate the forecasts for the other years as well). All references must refer to the exact cells in the file you downloaded for this exhibit.

Please forecast the demand for Day 28 using a weighted moving average forecast with the weights listed below and the data indicated in the Excel file. Round your answer to the closest whole number. Weight of the most recent period: 0.6 Weight of the other periods: 0.2