Before using the Subtotal command, you must first sort the data. On the Subtotals worksheet, sort the data by Employee and further sort by Category, both in alphabetical order. 4 3 You want to subtotal the data to calculate expenses by employee. Use the Subtotals feature to insert subtotal rows by Employee to calculate the total expense by employee.

Captain john's yachts, inc., located in fort lauderdale, florida, rents three types of ocean-going boats: sailboats, cabin cruisers, and captain john's favorite, the luxury yachts. captain john advertises his boats with his famous "you rent"we pilot" slogan, which means that the company supplies the captain and crew for each rented boat. each rented boat has one captain, of course, but the crew sizes (deck hands, galley hands, etc.) differ. the crew requirements, in addition to a captain, are one for sailboats, two for cabin cruisers, and three for yachts. ten employees are captains, and an additional 18 employees fill the various crew positions. currently, captain john has rental requests for all his boats: four sailboats, eight cabin cruisers, and three luxury yachts. if captain john's daily profit contribution is $50 for sailboats, $70 for cruisers, and $100 for luxury yachts, how many boats of each type should he rent?

Bridge building company estimates that it will incur $1,200,000 in overhead costs for the year. additionally, the company estimates 50,000 direct labor hours will be spent building custom walking bridges for the year at a total direct labor cost of $600,000. what is the predetermined overhead rate for bridge building company if direct labor costs are to be used as an allocation base?

Aaron corporation, which has only one product, has provided the following data concerning its most recent month of operations: selling price $ 102 units in beginning inventory 0 units produced 4,900 units sold 4,260 units in ending inventory 640 variable costs per unit: direct materials $ 20 direct labor $ 41 variable manufacturing overhead $ 5 variable selling and administrative expense $ 4 fixed costs: fixed manufacturing overhead $ 64,200 fixed selling and administrative expense $ 2,900 the total contribution margin for the month under variable costing is: