REQUIRED:

Create a spreadsheet with TWO sheets:

Data

Graph

Graph Requirements:

Prepare a visual of overhead costs for Fudge and Cookies, comparing two costing methods (volume-based with Activity-based), on a PER-UNIT basis.

Label your data points, rounded to two decimal places

Your file does not have to exactly match the tutorial. Be creative and do what makes sense to you!

DO:

Communicate clearly and cleanly! KISS principle.

DO NOT:

Confuse your audience. I should be able to interpret accurately what is being presented in the visual.

SCENARIO:

Wellington Chocolate Company uses plantwide overhead rate, based on oven hours.

They are considering changing to activity-based costing (ABC). The controller identified two activities and their budgeted costs: Setting up equipment $432,000 Other overhead $1,440,000

Setting up equipment is based on setup hours, and other overhead is based on oven hours. Wellington produces two products, Fudge and Cookies. Information on each product is as follows: Fudge Cookies Units produced 8,000 445,000 Setup hours 6,400 1,600 Oven hours 1,600 8,000