{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Lab2.2.2

This preview shows pages 1–7. 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
Comments Page 2 DO WE HAVE OT MAKE THE CHNAGES THAT IT TALKS ABOUT
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

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

View Full Document
Parameters Page 4 E OT MAKE THE CHNAGES THAT IT TALKS ABOUT
Q1_Budget Page 5 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  Sales taxes  \$30,521.74   \$28,956.52   \$33,260.87   \$92,739.13  Payroll taxes  \$-     \$-     \$-     \$-

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern