2 pg case study - in Excel

!Please&read&and&understand&the&following&important&instructions:&&1.#All#work#for#case#studies#will#be#submitted#as#Excel#workbooks.#Please#create#different#worksheets#for#each#part.#Label#these#sheets#“Part#a”,#“Part#b”,#etc.#If#an#answer#requires#other#sheets#(e.g.,#“Sensitivity#Report”),#rename#them#referring#to#the#part#of#the#problem#to#which#it#corresponds.#Always#include#an#“Introduction”#sheet#as#the#first#worksheet#(see#below).###2.Make#ample#use#of#colors,geometricshapesandobjects,framedcellsandranges,TextBoxes,#Comments,#Word#Art,ClipArt,backgrounds,#etc.,#to#enhance#the#presentation#and#appearO#ance#of#your#sheet.#Don’t#go#overboard#and#risk#losing#clarity#and#legibility#or#having#the#sheet#look#gaudy##"Grading.#Points#are#allotted#according#to#the#following#scale:##Model.##################################Maximum#of#70#points.##Presentation#########################Maximum#of#20#points.##Use#of#Excel#Features##########Maximum#of#10#points.###Model:The#model#is#the#conceptual#part#of#the#problem.#If#it#is#a#linear#programming#formulation,#for#example,#the#model#criterion#is#applied#to#check#whether#the#formulation#is#correct#and#whether#it#was#entered#and#solved#correctly#in#the#Solver.#Here,#what#matters#is#the#right#answer#in#all#the#parts#of#the#case#study.###Presentation:&This#measures#how#well#the#problem#is#presented#for#the#reader#to#unO#derstand.#All#variables#should#be#defined#using#words.#The#formulation#should#be#clear#by#just#looking#at#the#sheet#where#the#data#appears#including#aspects#such#as#the#constraints,#objective#function,#sense#of#optimization,#sense#of#inequalities,#etc.#This#should#be#in#addiO#tion#to#having#the#algebraic#formulation#explicitly#stated#in#a#separate#TextBox.#The#case#studies#usually#involve#interesting#applications#requiring#ingenuity#in#the#way#the#problem#is#formulated.#Therefore,#the#formulation#should#be#discussed#in#words#in#a#separate#TextBox.#Feel#free#to#make#use#of#TextBoxes#to#discuss#other#issues#that#arise.#Range#names#should##be#clear#and#should#be#such#that#they#appear#in#the#Solver#Window.#Special#cell#comments#should#further#elucidate#more#specific#aspects#of#the#problem.#The#optimal#solution#should#be#presented#and#described#in#words#in#its#own#TextBox.###Excel&Features:&This#is#the#“cosmetic”#part#of#the#evaluation.#The#criterion#is#how#well#Excel#features#such#as#those#described#above#enhance#the#appearance#and#utility#of#the#presentation.##!