1. Spreadsheet to show: Fixed Overhead $500,000.00, Variable Overhead Rate $6 Your allocation base is 125,000 and is a trucking company. Your spreadsheet needs to calculate the rate and in the answer box PRESENT the answer correctly.

2. Create your Inventory Balance Calculator and calculate Inventory Used using the following variables: Beginning Balance $12,500.00, Ending Balance $11,500.00 and Purchases of $50,000.00

3. Copy your Weighted Average Calculator for determining spreading out of Over/Under applied Overhead to WIP,FG and COGS. Calculate the amounts moved to WIP,FG and COGS using the following variables:

WIP $3500.00 MOVHD has a $10,000 in Actual and $12,000 in Applied OVHD

FG $5200.00

COGS $7000.00

Your answer must include the calculation and the journal entry.

4. Equivalent Unit Speadsheet to Tab 4. Calculate the journal entry to transfer the costs from Department A to Department B using the following variables:

BB WIP 0

Processed into WIP 200

Completed and gone 500

EB WIP 200

Production reports DM is 50% and CONV is 60 % Complete respectively DM and CONV each had a BB of $2500.00 and Costs for the period are DM $12,000, CONV $13,000 Answer must include the journal entry

5. CVP Analysis Spreadsheet to Tab 5. Solve for Break Even in both Units and Sales Dollars as well as Target Profit in both Units and Sales Dollars using the following variables:

# of Units 2000

Revenue $100,000

Variable Expenses $50,000

Fixed Expenses $25,000

Target Profit $30,000