2.2- formula view

2.2- formula view - Comments RetailBudgetModelFirstQuarter

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Comments Page 1 Retail Budget Model - First Quarter In this model the various values that are usually constant are included in a separate worksheet - the Parameters worksheet - and are given names. Notice how much more understandable the formulas in the Q1_Budget worksheet become.  Probably you will now find it very easy to make the changes described in the lab handbook.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Parameters Page 2 Tax Rates GST 2% PST 7% Payroll Tax 6% (of payroll) Franchise Fees Flat Fee $12,000  Franchise% 5% Business Model Advertising% 4% (of total sales) Cost of Goods% 47% (of total sales) Labour Costs hourly pay rate for  $9.50 hourly pay rate for  $15.00
Background image of page 2
Exercise 2 Raafia Siddiqui 211098936 StaffingModel (data view) Weekly Work Scheudle Monday Tues Wedne Thursday Frida Saturd Sunday Sales Persons Numbe 5 5 5 5 6 8 3 Hours 8 8 8 10 10 10 4 Amoun $380.00 ### ### $475.00 ### ### ### Supervisor Numbe 1 1 1 2 2 2 1 Hours
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/15/2010 for the course CSE CSE 1520 taught by Professor Paul during the Spring '09 term at York University.

Page1 / 4

2.2- formula view - Comments RetailBudgetModelFirstQuarter

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online