lab2_ex2b - Sales taxes $30,521.74 $28,956.52 $33,260.87...

Info iconThis preview shows pages 1–3. 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 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)
Background image of page 2
Q1_Budget Page 3 First Quarter Budget January February March Q1 Total Sales Clothing  $140,000.00   $125,000.00   $135,000.00   $400,000.00  Hard Goods  $94,000.00   $97,000.00   $120,000.00   $311,000.00  Total Sales  $234,000.00   $222,000.00   $255,000.00   $711,000.00 
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Sales taxes $30,521.74 $28,956.52 $33,260.87 $92,739.13 Payroll taxes $2,170.00 $2,030.00 $2,240.00 $6,440.00 Total Remittances $32,691.74 $30,986.52 $35,500.87 $99,179.13 Expenses Advertising $9,360.00 $8,880.00 $10,200.00 $28,440.00 Cost of goods $109,980.00 $104,340.00 $119,850.00 $334,170.00 Payroll $31,000.00 $29,000.00 $32,000.00 $92,000.00 Lease $19,000.00 $19,000.00 $19,000.00 $57,000.00 Miscellaneous $6,000.00 $6,000.00 $6,000.00 $18,000.00 Franchise cost $25,243.48 $24,513.04 $26,521.74 $76,278.26 Total Expenses $200,583.48 $191,733.04 $213,571.74 $605,888.26 Surplus(Deficit) $724.78 $(719.57) $5,927.39 $5,932.61 Government Remittances...
View Full Document

This note was uploaded on 02/13/2012 for the course CSE 1520 taught by Professor Kemeny during the Fall '08 term at York University.

Page1 / 3

lab2_ex2b - Sales taxes $30,521.74 $28,956.52 $33,260.87...

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

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