{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

lab2_ex2b

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

This preview shows pages 1–3. 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 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)
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
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

{[ snackBarMessage ]}