can you help me solve this

46 Bronze 48 Silver Direct Labor 53 49 Standard Cost Direct Materials 50 6 17 Per Unit Variable Overhead 12 6 51 12 52 Fixed Overhead 53 Standard Cost Accounting requires that a budget be created in advance of a period. 54 The budget is based on a for reach product. 55 The budgeted volumes permits the establishment of standard cost per unit of expenses that are not fully variable (fixed and semi-fixed). 57 56 For each product and cost component, the standard cost per unit is multiplied by the budgeted volumes to develop the budget 58 You are now half way through the f e the results of the first six months. 9 Let's first use the standard cost accounting framework to analyze the six-months of actual results. 0 We will then apply this fundamental understanding of the half-year actual results to develop a revised budget for the second half and to decide whether to: 61 Adjust the budget for the second half of the year? 62 Increase/decrease factory workers (direct labor) to respond to your full-year outlook 63 Adjust overhead to respond to your full-year outlook. 64 Write formulas in the green boxes below to calculate the budget. 65 Use 'S' in the formula to permit you to write one formula in the upper left box that can be copied down and across. 66 67 6 Month Bronze Silver Gold 68 Budget Sales Volumes Total 100 125 150 375 69 70 Direct Labor 71 Budgeted Direct Materials 72 Volumesat Variable Overhead 73 Standard Cost Fixed Overhead 74 Tota 75 76 On which product did your company anticipate spending the most (all cost components)? 77 78 79 At the end of the period the Actual Volumes produced are known. 80 81 6 Month Bronze Silver Gold 82 Total Actual Sales Volumes 170 100 120 390 83 $4 At this time the 'Actual Volumes at Standard Costs' is calculated. 85 This represents the expenses that hypothetically should have been incurred, based on the Actual Volumes produced and the Standard Costs Per Unit. 86 Write formulas in the green boxes below to calculate the Actual Volumes at Standard Costs. 87 88 Bronze Silver Gold Total 89 Direct Labor 90 Actual Direct Materials 91 Volumesat Variable Overhead 92 Standard Cost Fixed Overhead 93 Total 94 95 On which product did your company actually spend the most (all cost components)? 96 97 98 The Volume Variances' are the difference between the Actual Volumes at Standard Cost less the Budgeted Volumes at Standard Cost. 99 It represents the difference in expenses that would be expected because Actual Volumes were different than Budgeted Volumes 100 Anegative value is favorable as it means that the Actual expense was less than the Budgeted expense. 101 Write formulas in the green boxes below to calculate the Volume Variances. 102 103 Bronze Silver Gold Total 104 Direct Labor 105 Volume Direct Materials 106 Variable Overhead 107 Variances Fixed Overhead 108 Total 109 110 Across all products, which cost component has the most unfavorable Volume Variances? 111 112