Lab2.2.2 - Comments _

Info iconThis preview shows pages 1–6. 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
Comments Page 2 DO WE HAVE OT MAKE THE CHNAGES THAT IT TALKS ABOUT
Background image of page 2
Parameters Page 3 Tax Rates GST 8% PST 7% Payroll Tax 7% (of payroll) Franchise Fees Flat Fee $11,000  Franchise% 7% Business Model Advertising% 4% (of total sales) Cost of Goods% 47% (of total sales) DO WE HAVE Labour Costs Sales persons (hourly rate) $9.50 Supervisor (hourly rate) $15.00
Background image of page 3

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

View Full DocumentRight Arrow Icon
Parameters Page 4 E OT MAKE THE CHNAGES THAT IT TALKS ABOUT
Background image of page 4
Q1_Budget Page 5 First Quarter Budget January February March Q1 Total Sales Clothing  $140,000.00   $125,000.00 
Background image of page 5

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

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

This note was uploaded on 02/05/2011 for the course ECON 1000 taught by Professor Paschakis during the Spring '08 term at York University.

Page1 / 7

Lab2.2.2 - Comments _

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

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