Sales in units: Actual Rata Varianta Ex Vacanca Ratonics Sales Revenue 26,300 Budest 26.300 Budu Variable Expenses 5605,000 25,000 5562,500 Sales Commissions $78,000 Travel expenses in milles $210.000 Total variable expenses $288,000 Fixed Expenses Rent $36,500 Sales Salaries 548,600 Depreciation Sales Staff Autos $32,000 Total Fixed Costs: $117.100 $405.100 $75,000 $200,000 $275,000 $36,000 $48.000 $32,000 $116.000 $391.000 $171.500 Total Expenses $199,900 Net Income Variance Analysis and Standard Costs: Show Calculations Dalia Industries produces a cleaning product that works for the peskiest stains. It's pricey, but less expensive than hiring a professional cleaning service. The managers at Dalias are conducting variance analysis at the end of January, the first month of the new fiscal year. The company's standards for one gallon of cleaning solution are as follows, along with actual information for the month. DM DL Standard Quantity per Unit 5 gallons of solution Actual results for January: . 3 DL hours 22,000 gallons were produced Cost of DM purchased was $226,800 DM used in production was 10,800 Standard Price $20.00 per gallon $18.00 per DL hour Cost of DL was $122,500 for 7,000 DL hours worked Required: Flex Budget: 1. As sales manager, Joe Batista was given the following static budget report for selling expenses in the Clothing Department of Soria Company for the month of October 2. The static budget below consists of the following data: Sales in units: Selling Price and Units Unit 25,000 Expenses per $22.50 $562,500 5605,000 Budgeted Actual Variable expenses Sales Commissions 25,000 $3.00 per unit 5 75.000 $ 78,000) Travel expenses in miles 200,000 $1.00 per mile $200,000 $210.000 Total variable expenses $275,000 $288,000 Fixed Expenses: Rent 36,000 $36,500 Sales Salaries Autos Depreciation Sales Staff Total Fixed Costs: Total Expenses Net Income 48.000 $ 46.600 32.000 32.000 $116,000 $117.300 $391.000 5405 300 $171.500 $199,900 As a result of this budget report, Joe was called into the president's office and congrand on his fine sales performance. He was reprimanded, however, for allowing his costs to get out of control. Joe knew something was wrong with the performance report that he had been given. However, he was not sure what to do, and comes to you for advice. Prepare a budget report based on flexible budget data to help Joe Flex Budget Units Fixed Costs Sales in units 26,300 units Variable expenses Sales Commissions 26,300 units Travel expenses in miles 205,000 miles Fixed Expenses Rent $ 36,000 Sales Salaries 5 48.000 Depreciation-Sales Staff Autos $ 32,000 Total Fixed Costs: $ 116,000 Sales in units: Actual Rata Varianta Ex Vacanca Ratonics Sales Revenue 26,300 Budest 26.300 Budu Variable Expenses 5605,000 25,000 5562,500 Sales Commissions $78,000 Travel expenses in milles $210.000 Total variable expenses $288,000 Fixed Expenses Rent $36,500 Sales Salaries 548,600 Depreciation Sales Staff Autos $32,000 Total Fixed Costs: $117.100 $405.100 $75,000 $200,000 $275,000 $36,000 $48.000 $32,000 $116.000 $391.000 $171.500 Total Expenses $199,900 Net Income Variance Analysis and Standard Costs: Show Calculations Dalia Industries produces a cleaning product that works for the peskiest stains. It's pricey, but less expensive than hiring a professional cleaning service. The managers at Dalias are conducting variance analysis at the end of January, the first month of the new fiscal year. The company's standards for one gallon of cleaning solution are as follows, along with actual information for the month. DM DL Standard Quantity per Unit 5 gallons of solution Actual results for January: . 3 DL hours 22,000 gallons were produced Cost of DM purchased was $226,800 DM used in production was 10,800 Standard Price $20.00 per gallon $18.00 per DL hour Cost of DL was $122,500 for 7,000 DL hours worked Required: no Labor Rate variance Compute the following variances: Figues your answers below and record your final in the space provided. Materials price variance Materials quantity variance: Total materials variance: Favorable or Unfavorable Favorable or Unfavorable Favorable or Unfavorable Favorable or Unfavorable Labor Efficiency variance: Favorable or Unfavorable Total spending variance: Favorable or Unfavorable Overhead total spending Variance: Favorable or Unfavorable