{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

2.2- data view

# 2.2- data view - Comments _

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

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.

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

View Full Document
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
Lab 2 Exercise 2 Raafia Siddiqui 211098936 StaffingModel (data view) Weekly Work Scheudle Monday Tuesday Wednesday Thursday Friday Saturday Sunday Sales Persons Number 5 5 5 5 6 8 3 Hours 8 8 8 10 10 10 4 Amount \$380.00 \$380.00 \$380.00 \$475.00 \$570.00 \$760.00 \$114.00 Supervisor Number 1 1 1 2 2 2 1 Hours 8 8 8 10 10 10 5 Amount \$120.00 \$120.00 \$120.00 \$300.00 \$300.00 \$300.00 \$75.00 total Payroll Costs per Week \$4,394.00

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

View Full Document
Q1_Budget Page 4 First Quarter Budget January February March Q1 Total Sales Clothing  \$140,000.00   \$125,000.00   \$135,000.00
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 4

2.2- data view - Comments _

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

View Full Document
Ask a homework question - tutors are online