Below are the monthly sales forcast and actual monthly sales for Company. Company has hired you to conduct a variance analysis for its sales. In addition to the variance analysis, Company would like the entire row highlighted in green for months where the favorable variance is at least 20 percent and the entire row highlighted in red for months where the unfavorable variance is at least 20 percent. Show in Excel Month Sales forecast Actual Sales 1 83.00 $ 83.00 2 78.00 $ 58.50 3 174.00 $ 189.66 4 138.00 $ 149.04 190.00 $ 169.10 $ 153.00 $ 107.10 7 $ 54.00 $ 64.26 113.00 2$ 128.82 9. 135.00 $ 133.65 10 $ 51.00 $ 43.86

Below are the monthly sales forcast and actual monthly sales for Company. Company has hired you to conduct a variance analysis for its sales. In addition to the variance analysis, Company would like the entire row highlighted in green for months where the favorable variance is at least 20 percent and the entire row highlighted in red for months where the unfavorable variance is at least 20 percent. Show in Excel Month Sales forecast Actual Sales 1 83.00 $ 83.00 2 78.00 $ 58.50 3 174.00 $ 189.66 4 138.00 $ 149.04 190.00 $ 169.10 $ 153.00 $ 107.10 7 $ 54.00 $ 64.26 113.00 2$ 128.82 9. 135.00 $ 133.65 10 $ 51.00 $ 43.86

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

vnt.iob
Planned sales are 10,000 units at $7.00 per unit. Actual sales are 11,000 units at $6.50 per unit. Which of the following statements is not true? a. The revenue volume variance is favorable. b. The total revenue variance is unfavorable. c. The revenue volume variance is $7,000. d. The revenue price variance is unfavorable.
The Ferguson Company estimated that October sales would be 100,000 units with an average selling price of $6.00. Actual sales for October were 105,000 units, and average selling price was $5.95. The sales volume variance was: Multiple Choice О $5,250 unfavorable. $5,250 favorable. $5,000 unfavorable. О $5,000 favorable.
Blue Co. sells the following products for 2021 and 2022. The following total sales and total cost of sales details were obtained from the records of the firm per product:What is the Sales volume variance?
The income data of SB Kopi for the years 200B and 200A are as follows: 200B 200A Variance Sales 276,000.00 204,000.00 72,000.00 F Cost of Sales 151,800.00 122,400.00 29,400.00 U Gross Profit 124,200.00 81,600.00 42,600.00 Question: If the sales price in 200B is approximately 20% higher that the sales price in 200A, the P72,000 increase in sales may be analyzed into: Sales Price Variance Sales Volume Variance a 46,000 favorable 26,000 unfavorable b 46,000 unfavorable 26,000 favorable c 26,000 favorable 46,000 favorable d 46,000 favorable 26,000 favorable Group of answer choices B A C D Question: The 29,400 increase in cost of sales may be analyzed into: Cost Volume Variance Cost Price Variance a 15,000 favorable…
By year-end, Oriole Corp. had recognized standard cost variances for all of its production costs, including DM, DL, variable-MOH, and fixed-MOH. The following variances exist per the trial balances; the balance of COGS at this time is $130,390. DM price variance DM efficiency variance DL price variance DL efficiency variance $5,920 Credit 4,080 Debit 1,830 Debit 2,420 Credit Variable-MOH price variance Variable-MOH efficiency variance Fixed-MOH price variance Fixed-MOH volume variance $3,860 Debit 240 Debit 1,860 Debit 870 Credit
You are required to calculate:i. The sales price variance. ii. The sales volume profit variance. iii. The sales mix variance profit. iv. The sales quantity profit volume variance.
Required: present the gross profit variance
ty Variance OF Master Budget (19,200 units) 57,600
Revenue variances Rockport Industries Inc. gathered the following data for March: Sales price per unit Number of units of sales Total sales Planned $150 x 12,500 Actual $144 x 12,900 $1,875,000 $1,857,600 Enter a favorable variance as a negative number using a minus sign and an unfavorable variance as a positive number. a. Compute the revenue price variance. b. Compute the revenue volume variance. $ c. Compute the total revenue variance.
PART B REQUIREMENTS: For the given data below calculate all the variances for Level 1,2, and 3 analysis. Explain the performance of the company. 2015 ACTUAL SALES 2015 INVENTORIES IN UNIS Product Units Ending Inventory Begining Inventory 20,000 Price 58,000 Thingone Thingtwo $167 27,000 46,000 $218 8,000 3,000 Actual 2015 INVENTORIES IN UNITS Direct Unit Unit Begining Ending Materials Price Inventory Inventory Changes A kg 4% 32,000 30,000 increase kg 3% 29,000 25,000 decrease unit No 6,000 5,000 change All other costs increase 8% comparing to the previous year's prices. But the workers are not happy with this new pricing policy and they slowed the work 4%.
[The following information applies to the questions displayed below.] The director of cost management for Odessa Company uses a statistical control chart to help management determine when to investigate variances. The critical value is 1 standard deviation. The company incurred the following direct-labor efficiency variances during the first six months of the current year. January February March. April May June $ 250 F 800 U 700 U 908 U 1,050 U 1,200 U The standard direct-labor cost during each of these months was $19,000. The controller has estimated that the firm's monthly direct-labor variances have a standard deviation of $950. Required: 1-a. Draw a statistical control chart and plot the variance data given above. 1-b. Which variances will be investigated?