Hello, I need help creating a Spreadsheet for the Data and Graph. The full scenario information for the data sheet is provided in the first image, and the last 3 images are simply a provided example. Unfortunately I still do not understand, please help? Please tell me the steps to create the Data and Graph. Thank you.

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 doess 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 activities and their budgeted costs: considering changing to activity-based costing (ABC). The controller identified two Setting up equipment $432,000 $1,440,000 Other overhead 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 8,000 Cookies Units produced Setup hours 445,000 1,600 6,400 Oven hours 1,600 8,000 04_ABC_Tutorial Template File Edit View Insert Format Data Tools Add-ons Help O View only I Y - 100% B C D F G A Production Department A Production Department B 4,000 20,000 Machine Hour 16,000 10,000 Direct Labor-Hour Budgeted OH 1,000,000 Regular Operations Units produced and sold Deluxe 200 800 $ $ $ Unit cost of direct materials 100 50 Hourly direct labor wage rate Direct labor-hours in Department A per unit Direct labor-hours in Department B per unit $ 25 2 20 2 1 1 Driver Consumption Deluxe Regular Budgeted OH Activity Material movemen $ Cost Driver Budgeted Quantity 7,000 of production runs 400,000 of setups 350 15 20 Machine setups Inspections Shipments 500 25 50 588,000 of units 19,600 200 800 5,000of shipments 250 50 100 1,000,000 04_ABC_Tutorial Template File Edit View Insert Format Data Tools Add-ons Help View only - 100% Y- C A B C E G H Volume-Based Costing Activity Based Costing Stage 1 Allocation OH Allocation Regular Total OH allocated to Dept. B Total OH allocated to Dept. A Deluxe Materials Movement Machine Setups Inspections Shipment Total OH $ 20000 200,000 800,000 300 400 S 40000 Stage 2 Allocation 6000 24000 1000 2000 66,400 27,300 Per Unit Cost Deluxe Regular OH Dept. A $ OH Dept. B Total 20 20 Vs. 80 80 OH per Unit $ $ 136.50 $ S 100 100 83 Product costs per unit: Product costs per unit: Deluxe Regular Deluxe Regular DM S $ 100 75 DM 100 50 50 $ DL 75 60 DL 60 100 100 136.50 83 Unit Cost 275 210 311.50 193 Unit Costs 9) Your final graph should look like the one shown below Volume-Based versus Activity-Based Deluxe Product $350 $300 $250 $200 oVolume-Based Activity-Based $150 $100 $50 $- DM DL Unit Cost Unit Cost Breakdown (In $) 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 doess 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 activities and their budgeted costs: considering changing to activity-based costing (ABC). The controller identified two Setting up equipment $432,000 $1,440,000 Other overhead 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 8,000 Cookies Units produced Setup hours 445,000 1,600 6,400 Oven hours 1,600 8,000 04_ABC_Tutorial Template File Edit View Insert Format Data Tools Add-ons Help O View only I Y - 100% B C D F G A Production Department A Production Department B 4,000 20,000 Machine Hour 16,000 10,000 Direct Labor-Hour Budgeted OH 1,000,000 Regular Operations Units produced and sold Deluxe 200 800 $ $ $ Unit cost of direct materials 100 50 Hourly direct labor wage rate Direct labor-hours in Department A per unit Direct labor-hours in Department B per unit $ 25 2 20 2 1 1 Driver Consumption Deluxe Regular Budgeted OH Activity Material movemen $ Cost Driver Budgeted Quantity 7,000 of production runs 400,000 of setups 350 15 20 Machine setups Inspections Shipments 500 25 50 588,000 of units 19,600 200 800 5,000of shipments 250 50 100 1,000,000 04_ABC_Tutorial Template File Edit View Insert Format Data Tools Add-ons Help View only - 100% Y- C A B C E G H Volume-Based Costing Activity Based Costing Stage 1 Allocation OH Allocation Regular Total OH allocated to Dept. B Total OH allocated to Dept. A Deluxe Materials Movement Machine Setups Inspections Shipment Total OH $ 20000 200,000 800,000 300 400 S 40000 Stage 2 Allocation 6000 24000 1000 2000 66,400 27,300 Per Unit Cost Deluxe Regular OH Dept. A $ OH Dept. B Total 20 20 Vs. 80 80 OH per Unit $ $ 136.50 $ S 100 100 83 Product costs per unit: Product costs per unit: Deluxe Regular Deluxe Regular DM S $ 100 75 DM 100 50 50 $ DL 75 60 DL 60 100 100 136.50 83 Unit Cost 275 210 311.50 193 Unit Costs 9) Your final graph should look like the one shown below Volume-Based versus Activity-Based Deluxe Product $350 $300 $250 $200 oVolume-Based Activity-Based $150 $100 $50 $- DM DL Unit Cost Unit Cost Breakdown (In $)