To monitor Smart Accessibility Pty Ltd's budgets using the information data above, construct a quarterly budget for your department using Excel. Equation functions must be used for all calculations.

You are the Sales Manager for the Wholesale Department at Smart Accessories Pty Ltd. You have a team of 7 salespeople and one supervisor who assists in the filling of orders. You have been given the following departmental budget to follow for the 2020/21 financial year.

Wholesale Department Budget 2020/21

Credit Sales Revenue	$6,000,000
Cost of Sales	($3,100,000)
Wages	($800,000)
Telephone	($50,000)
Travel	($35,000)
Office Supplies	($7,000)
Bad Debts	($150,000)
Other Operating Expenses	($125,000)
Departmental Profit	$1,733,000

Due to the seasonality nature of this business, the Sales Revenue, the Cost of Sales, wages, bad debts, and other operating expenses are expected to fluctuate throughout the year.

In the first quarter, you expect a 20% drop and in the fourth quarter, you expect a 25% drop from the average.

In the second quarter, heading towards Christmas, you expect an increase of 30%, and in the third quarter an increase of 15% from the average.

Answer rating: 100% (QA)

Quarterly Budget for Wholesale Department at Smart Accessories Pty Ltd This Excel spre... View the full answer