CHAPTER3THECONCEPTUALPAPERWORKSHEETTosolvetheBreak-EvenModelThrough a table of relevant data, findingtheanswerwhere PROFITis exactlyzeroThrough a graphical representation of therelevant data,finding the answer from thegraph.Througha system of linear simultaneousequations,finding the answer by solvingthesystem of linear equations
CHAPTER 3 THE CONCEPTUAL PAPER WORKSHEET To solve the Break-Even Model ⚫ Through a table of relevant data, finding the answer where PROFIT is exactly zero. ⚫ Through a graphical representation of the relevant data, finding the answer from the graph. ⚫ Through a system of linear simultaneous equations, finding the answer by solving the system of linear equations
CONCEPTUALPAPERWORKSHEET(CPW)Tohighlight the important modelling andpackagehandling issuesThe construction ofa CPW is useful inthree ways:Toclarifyany academicmodellingissuesTodetermine the size of theworksheet andtherange of cells that will be used.Toidentifies the range of package facilities thatwill need to be activated in constructing themodel througha worksheet
CONCEPTUAL PAPER WORKSHEET (CPW) ⚫ To highlight the important modelling and package handling issues ⚫ The construction of a CPW is useful in three ways : ⚫ To clarify any academic modelling issues. ⚫ To determine the size of the worksheet and the range of cells that will be used. ⚫ To identifies the range of package facilities that will need to be activated in constructing the model through a worksheet
WHATISAWORKSHEET?Alarge twodimensional pieceof paperCOLUMNS---LETTERLABELSROWS---NUMBERLABELSCELL/BOX---combinationofCOLUMNandROWExampleTable3.1OnWORKSHEET.theuserentersinstructionsthatenablethepackage toperformrelevant datamanipulations.Two software packagesTheSPREADSHEETpackageEXCELTobecontrolled throughMENUSTheSTATISTICALpackageMNITABTobecontrolled throughCOMMANDS
WHAT IS A WORKSHEET ? ⚫ A large two dimensional piece of paper ⚫ COLUMNS-LETTER LABELS ⚫ ROWS- NUMBER LABELS ⚫ CELL/BOX-combination of COLUMN and ROW ⚫ Example Table 3.1 ⚫ On WORKSHEET, the user enters instructions that enable the package to perform relevant data manipulations. ⚫ Two software packages ⚫ The SPREADSHEET package EXCEL ⚫ To be controlled through MENUS ⚫ The STATISTICAL package MNITAB ⚫ To be controlled through COMMANDS
UserinputsofCPWAclearspecificationoftheacademicisSUeS（THETHEORETICALMODEL）ls theproblem properly defined?Isthemodel properly structured?·Areall thevariables requiredspecified?Are thevariables of interest properly defined?Explicit recognition of thepackagehandlingfacilities(BUILDINGAWORKSHEET)
User inputs of CPW ⚫ A clear specification of the academic issues (THE THEORETICAL MODEL ) ⚫ Is the problem properly defined? ⚫ Is the model properly structured? ⚫ Are all the variables required specified? ⚫ Are the variables of interest properly defined? ⚫ Explicit recognition of the package handling facilities(BUILDING A WORKSHEET )
SECTIONI:CREATINGATABLEOFDATAFourinputsintotheBreak-EvenmodelSELLINGPRICEperunit(p)FIXEDCOSTS(FC)VARIABLECOSTperunitVC)andRANGEofOUTPUTSq---quantitytoproduceTo determine SizE of the worksheet to becreated
SECTION I: CREATING A TABLE OF DATA Four inputs into the Break-Even model ⚫ SELLING PRICE per unit (p) , ⚫ FIXED COSTS (FC) , ⚫ VARIABLE COST per unit (VC) , and ⚫ RANGE of OUTPUTS ⚫ q-quantity to produce ⚫ To determine SIZE of the worksheet to be created