Excel project

profiley73t20851
IS312Project1_ExcelProjectTemplate022020182.xlsm

Unit Forecast

Last Name:
First Name:
Year 1 Forecast Year 2 Forecast
Units Q1FY17 Q2FY17 Q3FY17 Q4FY17 Q1FY18 Q2FY18 Q3FY18 Q4FY18
Product A Basic Edition
Product A Premium Edition
Product B
Staffing
Executive 3 4 5 6 7 8 9 10
Staff
Multipliers
Base Unit Price
Average Executive Monthy Salary
Average Staff Monthy Salary
Note:
1. Always put this worksheet on top before saving; especially when you turn it in
2. Use Save and not Save As, i.e. do NOT change the file type/extension
3. If you did not Enable Content when you open the workbook, exit immediately without saving any of your changes,
then reopen the workbook and Enable Content of the embedded Macro to avoid major point deductions!
4. Do NOT GIVE your file to another student NOR TAKE another student's file as your starting point

Income Statement

Last Name:
First Name:
Year 1 Forecast Year 2 Forecast Quarterly
Revenue Q1FY17 Q2FY17 Q3FY17 Q4FY17 Q1FY18 Q2FY18 Q3FY18 Q4FY18 Average
Product A Basic Edition
Product A Premium Edition
Product B
Total Revenue
Expense
Rent $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000
Payroll
Commission
COGS
Misc. $500,000
Total Expense
Quarterly Profit (Loss)
Remarks
One Method for Calc. for 'Made It'
A. Count the # of profitable quater(s) to date
B. Is the current quarter a profitable?
C. If A=1 and B=True, then this is the quarter
D. Collapse the A-C into one but textual substitution
Hyperlink to your resume:

Sheet3

Sheet Cell Change To User Date & Time