Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

DATA : ' Questions : please fill out according to the above File Home Insert Page Layout Formulas Data Review View Help Share Comments *

DATA : image text in transcribed 'image text in transcribed

Questions :

image text in transcribed

please fill out according to the above

File Home Insert Page Layout Formulas Data Review View Help Share Comments * Insert > X Calibri 11 ' ' > General 2 9X Delete Paste B I U A $ - % -20 Conditional Format as Cell Formatting Table Styles Sort & Find & Filter v Select Sensitivity Format Analyze Data Clipboard Font Alignment F Number Styles Cells Editing Analysis Sensitivity L11 : G H K L M N 0 P Q B Wakeup Juice (WUJU) Standard Unit costs (STD_UC) Amount in recipe Unit price of ingrdient 0.1 Standard costs 0.92 0.375 9 0.45 0.1 0.05 0.5 2 2.75 A DL hours/month Rate ($/hr) 352 Labour cost per month 20 7040.000 4.32 ol 1 Product name Report type 3 4 Direct Cost of 1 liter WUJU 5 6 Direct materials 7 Avocado flesh (kg) 8 Banana flesh (kg) 9 Baby Spinach (kg) 10 Coconut water 11 Total DM 12 13 Direct labour 14 2 staff 15 Total DL per 1000ml 16 17 Direct cost per 1000ml 18 19 Manufacturing overhead 20 Utilities (electricity+gas+water) 21 Depreciation of blender 22 Rent 23 Insurance 24 MOH per 100ml 25 26 27 Production costs 28 Paper Cup 29 Standard cost each product 30 Budgeted selling price 31 7.07 Per month Allocation 300 output 21.65 output 3000 output 14 output Qty of allocation Cost per 1000ml 1630 0.18 1630 0.01 1630 1.84 1630 0.01 2.05 Per 1000 ml Medium (340ml) 9.11 3.10 0.0951 3.19 Source: https://www.castawayfoodpackaging.com.au/product/ca-dc08d-paper-cold-cups/ 8.00 Data Group Assign_Analysing variance + : Ready . a + 70% File Home Insert Page Layout Formulas Data Review View Help Share Comments Fa: Insert v Calibri = = A 11 > General DX Delete Paste BI U v A Sensitivity O- $ - % Conditional Format as Cell Formatting Table Styles Format Sort & Find & Filter Select Analyze Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity Q31 fic G . J K L M N O Q 2.05 Medium (340ml) 9.11 Source: 3.10 0.095 3.19 8.00 https://www.castawayfoodpackaging.com.au/product/ca-dc08d-paper-cold-cups/ 100 Per day/blender (0) Per month per blender Number of blender Total capacity 50 1100 2 2200 Maximum capacity B 24 MOH per 100ml 25 26 Per 1000 ml 27 Production costs 28 Paper Cup 29 Standard cost each product 30 Budgeted selling price 31 32 Budgeted sales and production per month 33 Estimated event sale (liters) 34 Estimated retail sales (units) 35 Total estimated sales (liters) 36 Estimated output per month (litres) 37 Blender cost ($) 38 Fridge 39 Expected useful life (years) 40 per month depreciation 41 Rent 42 Insurance per year 43 Total fixed MOH per month 44 Variable MOH per month 45 MOH per liter 46 47 Assumptions 48 Avocado 49 % of flesh/whole fruit 50 51 Avocado flesh/skin/seed ratio 52 http://ucavo.ucr.edu/General/Ratios.html 53 54 4500 1630 1630 998 1600 10 21.65 3000 168 3035.65 300 2.05 Banana 65% 80% Data Group Assign_Analysing variance + Ready 70% File Home Insert Page Layout Formulas Data Review View Help Share Comments #Insert IN Calibri 11 = ' ' > General IM 9X Delete Paste B IU A $ % HD Sensitivity 00 20 Conditional Format as Cell Formatting Table Styles v Styles Sort & Find & Filter Select Analyze Data in Format Clipboard Font Alignment Number Cells Editing Analysis Sensitivity Q31 E fr . L M N R S T V X Y Z Siginificant level of significant level of Total budget var Price Efficience var Significant level of Volumn var D F G 1 HEALTHY DRINK BAR - VARIANCE ANALYSIS REPORT - 1ST QUARTER 2021 2 Step 1: Overall variance analysis STATIC P&L FLEXIBLE P&L Price/efficiency Total budget 3 P&L items BUDGET Volume variance BUDGET variances ACTUAL P&L variances 4 Sales 5 less Variable costs DM-Avocado 7 DM-Banana DM-Spinach DM-Coconut water 10 DM-Paper cup 11 DL 09 12 Variable overhead 13 Total variable costs 14 Contribution margin 15 less Fixed costs 16 Gross margin 17 less selling and admin costs 18 Net profit 0 19 20 21 Step 2: Detail variance investigation for variable overheads 28 Formula 23 24 Variable overhead cost is allocated to products using variable overhead rate and the quantity of allocation base, in this case the output. 25 So the variance of variable overhead is caused by either the actual variable overhead rate is different or the quantity of allocation base is different 26 27 VOH spending variance The difference between actual VOH and standard VoH for actual quantity Actual VOH - SVR Actual quantity of allocation base (in which SVR is standard variable overhead rate) 29 Calculation 30 SU 31 VOH efficiency variance The variance caused by the difference between actual quantity of allocation base and standard quantity of allocation base for actual output) 32 Formula SVR (AQ - SQa) 33 Calculation Total VOH variance Comment on the overall performance 38 Data Group Assign_Analysing variance + Select destination and press ENTER or choose Paste PI + + 55% File Home Insert Page Layout Formulas Data Review View Help Share Comments * Insert > X Calibri 11 ' ' > General 2 9X Delete Paste B I U A $ - % -20 Conditional Format as Cell Formatting Table Styles Sort & Find & Filter v Select Sensitivity Format Analyze Data Clipboard Font Alignment F Number Styles Cells Editing Analysis Sensitivity L11 : G H K L M N 0 P Q B Wakeup Juice (WUJU) Standard Unit costs (STD_UC) Amount in recipe Unit price of ingrdient 0.1 Standard costs 0.92 0.375 9 0.45 0.1 0.05 0.5 2 2.75 A DL hours/month Rate ($/hr) 352 Labour cost per month 20 7040.000 4.32 ol 1 Product name Report type 3 4 Direct Cost of 1 liter WUJU 5 6 Direct materials 7 Avocado flesh (kg) 8 Banana flesh (kg) 9 Baby Spinach (kg) 10 Coconut water 11 Total DM 12 13 Direct labour 14 2 staff 15 Total DL per 1000ml 16 17 Direct cost per 1000ml 18 19 Manufacturing overhead 20 Utilities (electricity+gas+water) 21 Depreciation of blender 22 Rent 23 Insurance 24 MOH per 100ml 25 26 27 Production costs 28 Paper Cup 29 Standard cost each product 30 Budgeted selling price 31 7.07 Per month Allocation 300 output 21.65 output 3000 output 14 output Qty of allocation Cost per 1000ml 1630 0.18 1630 0.01 1630 1.84 1630 0.01 2.05 Per 1000 ml Medium (340ml) 9.11 3.10 0.0951 3.19 Source: https://www.castawayfoodpackaging.com.au/product/ca-dc08d-paper-cold-cups/ 8.00 Data Group Assign_Analysing variance + : Ready . a + 70% File Home Insert Page Layout Formulas Data Review View Help Share Comments Fa: Insert v Calibri = = A 11 > General DX Delete Paste BI U v A Sensitivity O- $ - % Conditional Format as Cell Formatting Table Styles Format Sort & Find & Filter Select Analyze Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity Q31 fic G . J K L M N O Q 2.05 Medium (340ml) 9.11 Source: 3.10 0.095 3.19 8.00 https://www.castawayfoodpackaging.com.au/product/ca-dc08d-paper-cold-cups/ 100 Per day/blender (0) Per month per blender Number of blender Total capacity 50 1100 2 2200 Maximum capacity B 24 MOH per 100ml 25 26 Per 1000 ml 27 Production costs 28 Paper Cup 29 Standard cost each product 30 Budgeted selling price 31 32 Budgeted sales and production per month 33 Estimated event sale (liters) 34 Estimated retail sales (units) 35 Total estimated sales (liters) 36 Estimated output per month (litres) 37 Blender cost ($) 38 Fridge 39 Expected useful life (years) 40 per month depreciation 41 Rent 42 Insurance per year 43 Total fixed MOH per month 44 Variable MOH per month 45 MOH per liter 46 47 Assumptions 48 Avocado 49 % of flesh/whole fruit 50 51 Avocado flesh/skin/seed ratio 52 http://ucavo.ucr.edu/General/Ratios.html 53 54 4500 1630 1630 998 1600 10 21.65 3000 168 3035.65 300 2.05 Banana 65% 80% Data Group Assign_Analysing variance + Ready 70% File Home Insert Page Layout Formulas Data Review View Help Share Comments #Insert IN Calibri 11 = ' ' > General IM 9X Delete Paste B IU A $ % HD Sensitivity 00 20 Conditional Format as Cell Formatting Table Styles v Styles Sort & Find & Filter Select Analyze Data in Format Clipboard Font Alignment Number Cells Editing Analysis Sensitivity Q31 E fr . L M N R S T V X Y Z Siginificant level of significant level of Total budget var Price Efficience var Significant level of Volumn var D F G 1 HEALTHY DRINK BAR - VARIANCE ANALYSIS REPORT - 1ST QUARTER 2021 2 Step 1: Overall variance analysis STATIC P&L FLEXIBLE P&L Price/efficiency Total budget 3 P&L items BUDGET Volume variance BUDGET variances ACTUAL P&L variances 4 Sales 5 less Variable costs DM-Avocado 7 DM-Banana DM-Spinach DM-Coconut water 10 DM-Paper cup 11 DL 09 12 Variable overhead 13 Total variable costs 14 Contribution margin 15 less Fixed costs 16 Gross margin 17 less selling and admin costs 18 Net profit 0 19 20 21 Step 2: Detail variance investigation for variable overheads 28 Formula 23 24 Variable overhead cost is allocated to products using variable overhead rate and the quantity of allocation base, in this case the output. 25 So the variance of variable overhead is caused by either the actual variable overhead rate is different or the quantity of allocation base is different 26 27 VOH spending variance The difference between actual VOH and standard VoH for actual quantity Actual VOH - SVR Actual quantity of allocation base (in which SVR is standard variable overhead rate) 29 Calculation 30 SU 31 VOH efficiency variance The variance caused by the difference between actual quantity of allocation base and standard quantity of allocation base for actual output) 32 Formula SVR (AQ - SQa) 33 Calculation Total VOH variance Comment on the overall performance 38 Data Group Assign_Analysing variance + Select destination and press ENTER or choose Paste PI + + 55%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A One-Year Accounting Course Part 2

Authors: Trevor Gambling

1st Edition

0080130267, 9780080130262

More Books

Students also viewed these Accounting questions