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

A company has the following alternatives for investment. Using the incremental B/C method, determine which alternative should be selected. Assumei = 10%. А В C Cost new $20,000 $24,000 $16,000 Annual O&M Cost $1,000/yr $800/yr $2,200/yr Annual income $5,600/yr $5,700/yr $5,400/yr Estimated life (yr) 7 9. Note: Incremental B/C method should be used in the solution. Solutions by using other methods will not be graded.
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
Quarterly sales of PnP (in hundred million Rands) from 2000 to 2004 are given in the table below: Q1 Q2 Q3 Q4 2000 5 6 8 9 2001 6 8 9 11 2002 10 9 12 10 2003 13 10 15 10 2004 14 16 15 14 What is the five period moving average for 2002_Q2 (round off to one decimals). A. 10.8 B. 10.4 C. 10.2 D. 10.0
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.
XYZ work in a small electric business in Basrah city. He had a sunshine controller device. He had to decide how to market his idea, and in the short term, his options could be summarised as selling the device locally, selling nationally through a website, entering a partnership with an existing company or selling the patent. His returns depended on demand, which he described as high, medium, or low. Using this simple model, he developed the matrix of potential annual gains shown below: Options Demand High Medium Low Market locally 60 90 45 Use website 23 90 78 Partnership 12 25 89 Sell patent 30 30 30 Identify the decision taken under the following approaches: (1) Equal probability (2) Regret (3) Hurwicz criterion. Note: The decision maker's degree of Pessimistic (a) is 0.3.
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.

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