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

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?
Manji
It's Still Raining (ISR) manufacturers umbrellas. In order to better budget and manage costs, they are analyzing the purchasing costs behavior. They have the following data from the last six months of last year. Month Total Purchasing Costs Purchase Orders July $19, 670 460 August $20, 940 560 September $19,430 400 October $20, 020 500 November $18,800 470 December $19,340 480 Using the regression analysis function in Excel, what are the expected costs if 520 purchase orders are processed? Please round your answer to the nearest whole dollar.
help me
Below is some comparative data for ABC Company. Management wants us to investigate variances between 2019 and 2018 that are greater than +/- $1,000,000 AND +/- 20% change from last year. Use the appropriate formula to identify instances where both of these criteria are true. Hint: you will need to use absolute value functions to solve this, see example below. The formula should return the answer in a "Yes" or "No. 2019 2018 Salaries 59,484,000 73,556,000 Fringe benefits 15,601,000 19,660,000 Client incidentals and services 2,858,000 7,937,000 Computer operations 3,325,000 2,021,000 Food 2,557,000 2,960,000 Insurance 1,503,000 1,022,000 Interest and bank charges 2,051,000 1,243,000 Miscellaneous 1,166,000 6,844,000 Professional fees and staffing…
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
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?