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

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter18: Pricing And Profitability Analysis

Section: Chapter Questions

Problem 32P: Sulert, Inc., produces and sells gel-filled ice packs. Sulerts performance report for April follows:...

See similar textbooks

Similar questions

1. This year’s total sales of Yui Inc. are P4,600,000. The following variances are determined: · Sales Price Variance – 750,000 favorable · Cost Price Variance – 100,000 unfavorable · Sales Volume Variance – 150,000 unfavorable Using horizontal analysis, determine the percentage change from the prior year's total sales to the current year's total sales. 2. The income statement of Petra Inc. in 2022 reflects a net Income of P2,050,000. The dividend policy of the company is to pay an annual cash dividend of P2 per share to common stock regardless of the market price of the share. If the dividend yield determined for the last day of 2022 is 20%, how much is the fair value of the share? (per share)
Income Statement Prepare an income statement through gross profit for Venneman Company for the month ended March 31. Refer to the lists of Labels and Amount Descriptions for the exact wording of text entries. Enter all amounts as positive numbers except favorable variances. Use a minus sign to indicate favorable variances. A colon (:) will automatically appear for you if it is required. Instructions Venneman Company Venneman Company produces a product that requires 3.5 standard pounds per unit. The standard price is $5.10 per Income Statement Through Gross Profit pound. The company produced 14,000 units that required 48,000 pounds, which were purchased at $5.40 per pound. The (Label) product also requires 4 standard hours per unit at a standard hourly rate of $12 per hour. The 14,000 units required 58,000 hours at an hourly rate of $11.85 per hour. In addition, the standard variable overhead cost per unit is $0.80 per 1 hour and the actual variable factory overhead was $46, 100.…
Assume you have asked your data folks to determine the relationship between customer service scores (i.e. the ratings provided by customers in response to a survey) and profit. The analyst reports the following: "I gathered data for the last 48 months and ran a regression where profit in a given month is the dependent variable and customer service score in that same month is the independent variable. I found an intercept of $10,000 (p-value: 0.31) and the coefficient on customer service score is $1,200 (p-value: 0.22). The R-2 (which is appropriate when there is just one independent variable) is 0.07." What do you infer from the results (two to three sentences, sticking to the information provided) and why?
Sulert, Inc., produces and sells gel-filled ice packs. Sulerts performance report for April follows: Required: 1. Calculate the contribution margin variance and the contribution margin volume variance. 2. Calculate the market share variance and the market size variance. (CMA adapted)
Blake McKenzie Tax Services is a company serving 72 clients (as of the beginning of last month) that is working on reorganizing its balanced scorecard. Currently, the company has the following performance metrics: online client satisfaction rating, client growth percentage (the number of total clients at the beginning of the current month compared to the number of total clients at the beginning of the prior month), market share, and profit margin. The company tracks these metrics from month to month. The companys target client growth percentage is 4% per month. Its target average online client satisfaction rating is 4.8 stars. Last month, the company noted the following data related to these metrics: a. Working together in teams, create strategic objectives that each of the companys four performance metrics might represent. b. Determine whether the company achieved its client growth percentage target last month. c. Suppose that last month, the company received 55 five-star reviews, 10 four-star reviews, 3 three-star reviews, 1 two-star review, and 1 one-star review (some clients did not submit a review). Determine whether the company met its average online client satisfaction rating target. d. Come up with at least one strategic initiative for the strategic objective of any performance metric target that you know the company did not meet last month.
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…
I alrdeady provided the correct answers, please show me the solutions. The income data of Escano Company for the years 200B and 200A are follows: 200B 200A Variance Sales P276,000 P204,000 P72,000 favorable COGS 151,800 122,400 P29,400 unfavorable Gross Profit P124,200 P81,600 P42,600 favorable If the sales price in 200B is approximately 20% higher than the sales price 200A, the P72,000 increase in sales may be analyzed into: P46,000 favorable P26,000 favorable The number of units increased (decreased) by 12.745% The P29,400 increase in cost of sales may be analyzed into:Cost Price Variance Cost Volume Variance P15,600 unfavorable P13,800 favorable The 200B cost price is higher (lower) than the 200A cost price by10%
Dickinsen Company gathered the following data for December: Planned Actual Sales price per unit Number of units of sales $5.80 x 820,000 $4,756,000 $6.00 x 805,000 $4,830,000 Total sales a. Compute the revenue price variance. b. Compute the revenue volume variance. c. Compute the total revenue variance.
This year’s total sales of Bulldogs Inc. is P4,600,000. The following variances are determined:· Sales Price Variance – 750,000 favorable· Cost Price Variance – 100,000 unfavorable· Sales Volume Variance – 150,000 unfavorableUsing horizontal analysis, determine the percentage change from the prior year total sales to the current year total sales.
Woodruff Flowering Plants provides the following information for the month of May: Actual Sales in units Contribution margin per unit For May, Woodruff will report a(n) OA. favorable sales - mix variance B. favorable market share variance OC. unfavorable market share variance D. unfavorable sales - mix variance Fuchsia 21,000 $22 Dogwood 4.500 $19 C Fuchsia Budget 18,000 $23 Dogwood 3,200 $18
The monthly sales for Yazici Batteries, Inc., were asfollows: a) Plot the monthly sales data.b) Forecast January sales using each of the following:i) Naive method.ii) A 3-month moving average.iii) A 6-month weighted average using .1, .1, .1, .2, .2, and .3,with the heaviest weights applied to the most recent months.iv) Exponential smoothing using an a = .3 and a Septemberforecast of 18.v) A trend projection. c) With the data given, which method would allow you to fore-cast next March’s sales?
The Toro Cutlery Company has collected monthly sales information below: MONTH MONTH May January February June March April SALES 15,000 18,000 33,000 115,000 SALES 77,000 30,000 80,000 44,000 MONTH September October November December SALES 34,000 101,000 68,000 84,000 July August The company is examining two forecasting methods, moving average and exponential smoothing for forecasting sales. a. What will the forecast be for January the following year using a three-, four-, and five-month moving averages? Do not round intermediate calculations. Round your answers to the nearest whole number. Forecast (January, 3-month MA): Forecast (January, 4-month MA): Forecast (January, 5-month MA): b. What will the forecast be for January the following year using exponential smoothing with a = 0.4? Assume the forecast for February this year is 15,000. Do not round intermediate calculations. Round your answer to the nearest whole number.