Answered: Calculate the sales variance in dollars… | bartleby

Practical Management Science

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

Calculate the sales variance in dollars and the sales variance as a percentage given the following information: last year's sales
$2,825,000; this year's sales $3,000,500.
$5,825,500 and 9.41%
$175,500 and 6.21%
$5,825,500 and 10.62%
$175,500 and 9.41%

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Blurred answer

Similar questions

Mary Williams, owner of Williams Products, is evaluating whether to introduce a new product line. After thinking through the production process and the costs of raw materials and new equipment, Williams estimates the variable costs of each unit produced and sold at $8 and the fixed costs per year at $70,000. Williams forecasts sales of 12,000 units for the first year if the selling price is set at $15 each. What would be the total contribution to profits from this new product during the first year?
Rochor & Co has the following sales forecast for the next quarter: April, 20,000 units; May, 24,000 units; June, 28,000 units. Sales totalled 16,000 units in March. The March finished goods inventory was 4,000 units. End-of- month finished goods inventory levels are planned to be equal to 20 percent of the next month's planned sales. How many units would be produced in April? Group of answer choices 20,000 units 20,800 units 5,600 units 4,800 units
Mary Williams, owner of Williams Products, is evaluating whether to introduce a new product line. After thinking through the production process and the costs of raw materials and new equipment, Williams estimates the variable costs of each unit produced and sold at $8 and the fixed costs per year at $70,000. If the selling price is set at $13.50, Williams forecasts that first-year sales would increase to 17,000 units. Which pricing strategy ($15.00 or $13.50) would result in the greater total contribution to profits?
Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: Year -1 2 Registrations (000) 5.0 5.0 Year Forecast 4 4.3 This exercise contains only parts a and b. a) Using a 3-year moving average, the forecasted registrations (in thousands) for years 4 through 12 are (round your responses to one decimal place): 5 4.6 4 3 3.0 5 6 6.6 7 8 4 5 6 9 10 6.0 11.0 9.0 7.0 9.0 13.0 16.0 6 7 8.7 8 9 7 9 8.3 b) Using a 3-year weighted moving average in which the registrations in the most recent year are given a weight of 2, and registrations in the other 2 years are each given a weight of 1, the forecasted registrations (in thousands) for years 4 through 12 are (round your responses to one decimal place): Year Forecast 8 10 9.6 9 11 12.6 10 12 15.3 11 11 17.0 12
Given the following forecast and steady regular output of 550 every month, what total cost would result if overtime is limited to a maximum of 40 units a month, and subcontracting is limited to a maximum of 10 units a month? Unit costs are: Regular output $20 Overtime $30 Subcontract $25 Average Inventory $10 Backlog $18 Month 1 2 3 4 5 6 Forecast 540 540 570 590 650 680
Congratulations, the design options for the two mobile phone lines have been specified. You will now have to predict the total demand for each product line. Your forecasting team members have come up with a consensus for what they believe demand will be for the mobile phone lines. However, the board of your company is interested in your personal estimates as well. The numbers you will forecast after entering the forecasting room will not affect your production schedule, but they will help you later as you determine where and how to source your products. Model A: Monthly Estimated Demand May–December in thousands per month Average:59Standard Dev:2 AndreiAyaLorenzoClaireByronRuthConsensus020406080 Model B: Monthly Estimated Demand May–December in thousands per month Average:29Standard Dev:6 AndreiAyaLorenzoClaireByronRuthConsensus020406080 Unit Data with Options as Chosen costs are an estimate from the lowest-cost contract manufacturer Model A Model B Unit Price…
As part of their application for a loan to buy Lakeside Farm, a property they hope to develop as a bed-and-breakfast operation, the prospective owners have projected: Monthly fixed cost (loan payment, taxes, insurance, maintenance) $6000 Variable cost per occupied room per night $ 20 Revenue per occupied room per night $ 75 A. Write the expression for total cost per month. Assume 30 days per month. B. Write the expression for total revenue per month. C. How many rooms do they need to sell per night in order to break even?
Explain two approaches a seller can use to estimate variable consideration, and when each approach is likely to be more appropriate.
Consider the following financial data from the past year for Midwest Outdoor Equipment Corporation. Annual sales $24,324,000 Net income 2,975,000 Cost of goods sold 12,600,000 Total assets 10,550,000 Inventory 2,875,000 Receivables 3,445,000 The Midwest Outdoor Equipment Corporation has entered into a new contract with a major supplier of raw materials used in the manufacturing process. Under the new arrangement, called vendor managed inventory, the supplier manages its raw material inventory inside the manufacturer’s plant and bills only the manufacturer when the manufacturer consumes the raw material. This is expected to reduce total assets by $2 million. What is the expected change in return on assets? Note: Round your answer to 2 decimal places.
A manager uses a trend equation plus quarterly relatives to predict demand. Quarter relatives are SR₁ = 0.9, SR₂ = 0.95, SR3 = 1.05, and SR₁ =1.1, The trend equation is: Fr=9+ 41. Over the past nine quarters, demand has been as follows: Period, t: Demand: Click here for the Excel Data File Compute the MAD and tracking signal for each period. (Negative values should be indicated by a minus sign. Round your intermediate calculations and final answers to 3 decimal places.) Period, t 1 2 3 4 5 6 7 1 2 3 4 5 6 7 В 9 14 18 20 22 28 30 36 42 45 89 Demand 14 18 20 22 28 30 36 42 45 MAD Tracking signal
Da
What would be the best way to estimate whether a piece of land could be used to manage an existing (at a profit) in the relatively short- and long-run? Explain what information you would need to make the decision what would be a “Second best” alternative to the criteria you picked first?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

Operations Management

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

Operations Management

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS